OLAP operations (e.g., slice, dice, roll-up, drill-down) MCQs January 8, 2026November 19, 2024 by u930973931_answers 10 min Score: 0 Attempted: 0/10 Subscribe 1. What does the “slice” operation in OLAP do? (A) Selects a single dimension from a multidimensional cube (B) Rotates data to view from different angles (C) Aggregates data along a hierarchy (D) Divides the data cube into smaller cubes 2. Which of the following is an example of a “dice” operation in OLAP? (A) Selecting a single dimension of data (B) Aggregating data to a higher level of hierarchy (C) Selecting multiple dimensions and filtering data based on certain criteria (D) Drilling down to a more detailed level 3. The “roll-up” operation in OLAP involves: (A) Rotating the cube for different perspectives (B) Breaking data into more granular levels (C) Aggregating data to a higher level of a hierarchy (D) Filtering data based on specific conditions 4. What does the “drill-down” operation do in an OLAP cube? (A) Moves from a summarized view to a more detailed view (B) Aggregates data to a summary level (C) Filters data to focus on a specific slice (D) Combines data from multiple sources 5. Which operation allows users to view data from different perspectives by rotating the data cube? (A) Slice (B) Dice (C) Roll-up (D) Pivot 6. What happens when you perform a “slice” operation on a data cube? (A) You filter the cube to show data for a specific value of one dimension (B) You rotate the cube to view data differently (C) You reduce the cube to a single dimension (D) You split the cube into multiple smaller cubes 7. Which OLAP operation involves selecting multiple dimensions and applying filters on them? (A) Slice (B) Dice (C) Roll-up (D) Drill-down 8. Moving from monthly data to quarterly data in an OLAP cube is an example of: (A) Drill-down (B) Roll-up (C) Slice (D) Dice 9. In the context of OLAP, “drill-through” means: (A) Aggregating data at a higher level (B) Moving from a data cube to transactional data (C) Viewing data from a different perspective (D) Applying filters on multiple dimensions 10. Which of the following operations would you use to examine more detailed data for a specific year? (A) Roll-up (B) Drill-down (C) Dice (D) Pivot