OLAP uses measures, dimensions and associations.
A. True
B. False
Answer: Option A
Solution (By Examveda Team)
OLAP (Online Analytical Processing) is a category of database processing that supports multidimensional analysis of data for business intelligence purposes.Measures refer to the numeric data values that users want to analyze, such as sales, profit, or revenue.
Dimensions are perspectives or entities with respect to which an organization wants to keep records, like time, geography, or product.
Associations refer to the relationships between dimensions and measures, allowing users to perform complex queries and drill-down analysis.
Therefore, OLAP uses measures, dimensions, and associations to help in effective data analysis and decision-making.
This Question Belongs to Database >> Database Processing For BIS
Join The Discussion
Comments (1)
A BI reporting system does not ________ .
A. create meaningful information
B. deliver information to users on a timely basis
C. use statistical procedures to predict future events
D. use disparate data sources
Which of the following are not done by Business Intelligence (BI) systems?
A. Analyze past and current activities only
B. Process and record transactions only
C. Both of the above are correct.
D. Neither of the above is correct.
Business Intelligence (BI) systems do not obtain their data by which of the following means?
A. Read and process data from an operational database
B. Process transactions
C. Process extracts from operational databases
D. Process data purchased from data vendors
The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
A. Dirty data
B. Inconsistent data
C. Too much data
D. Non-integrated data
The answer should be A)True