⟩ Aggregations are built from the _________________ by changing the granularity on specific dimensions. a) Both c and d below b) schema c) Dimension table d) Fact table
d) Fact table
d) Fact table
Can the user perform data-entry or editing tasks on OLAP data? a) Yes b) No
Following are three steps in random order for creating a data cube. 1. Chose a data source. Create the query that extracts data from the database. Create the cube from the extracted data. a) 1,2,3 b) 2,1,3 c) 3,2,1 d) 3,1,2
Dice operation is also known as rotate. a) True b) False
The output of an OLAP query is displayed as a a) Matrix b) Pivot c) Both a and b d) excel
Which type of data models are used by databases configured for OLAP? a) Multidimensional b) Single dimensional c) Two dimensional d) Three dimensional
MOLAP databases generally give better performance. a) True b) False
__________operation of OLAP involves computing all of the data relationships for one or more dimensions. a) Slice b) Roll up c) Dice d) Pivot
What are the applications of OLAP? a) business reporting for sales, marketing b) Budgeting c) Forecasting d) All of the above
What are models and meta models?
What do u meant by SBI of an object?