ExamVeda
Login
Home

OLAP uses measures dimensions and associations

This question belongs to Database Database Processing For BIS
Database Processing for BIS
?

OLAP uses measures, dimensions and associations.

Answer & Solution
Correct Answer: Option A
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.
Examveda
Question posted by Examveda
Community

Join the Discussion

1 Comment
Dr KD
Dr KD 1 year ago
The answer should be A)True
Keep Learning

Related Questions on Database Processing for BIS

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
More Related Questions on Database Processing for BIS