1. What does the “slice” operation in OLAP do?
A. Aggregates data along a hierarchy
B. Rotates data to view from different angles
C. Selects a single dimension from a multidimensional cube
D. Divides the data cube into smaller cubes
Answer: C
2. Which of the following is an example of a “dice” operation in OLAP?
A. Selecting a single dimension of data
B. Selecting multiple dimensions and filtering data based on certain criteria
C. Aggregating data to a higher level of hierarchy
D. Drilling down to a more detailed level
Answer: B
3. The “roll-up” operation in OLAP involves:
A. Aggregating data to a higher level of a hierarchy
B. Breaking data into more granular levels
C. Rotating the cube for different perspectives
D. Filtering data based on specific conditions
Answer: A
4. What does the “drill-down” operation do in an OLAP cube?
A. Aggregates data to a summary level
B. Moves from a summarized view to a more detailed view
C. Filters data to focus on a specific slice
D. Combines data from multiple sources
Answer: B
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
Answer: D
6. What happens when you perform a “slice” operation on a data cube?
A. You reduce the cube to a single dimension
B. You rotate the cube to view data differently
C. You filter the cube to show data for a specific value of one dimension
D. You split the cube into multiple smaller cubes
Answer: C
7. Which OLAP operation involves selecting multiple dimensions and applying filters on them?
A. Slice
B. Dice
C. Roll-up
D. Drill-down
Answer: B
8. Moving from monthly data to quarterly data in an OLAP cube is an example of:
A. Drill-down
B. Slice
C. Roll-up
D. Dice
Answer: C
9. In the context of OLAP, “drill-through” means:
A. Moving from a data cube to transactional data
B. Aggregating data at a higher level
C. Viewing data from a different perspective
D. Applying filters on multiple dimensions
Answer: A
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
Answer: B