Computer Science · Data Warehousing and OLAP
Which of the following statements correctly describe the various OLAP operations performed on a multidimensional data cube? I. Roll-Up involves aggregation by climbing up a concept hierarchy, such as moving from a daily sales view to a monthly or annual view. II. Slice creates a sub-cube by selecting a subset on two or more dimensions of the multidimensional data. III. Drill-Down allows users to navigate from summary data to more detailed data, moving from higher levels to lower levels in a hierarchy. IV. Pivot rotates the data axes in the view to provide an alternative orientation or presentation of the multidimensional data. Choose the most appropriate answer from the options given below:
- 1I, II and III Only
- 2II, III and IV Only
- 3I, II and IV Only
- 4I, III and IV Only✓
Correct answer
I, III and IV Only
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Want more practice questions on Data Warehousing and OLAP?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Data Warehousing and OLAP