Explanation: The slice operation selects one particular dimension from a given cube and provides a new sub-cube. Dice selects two or more dimensions from a given cube and provides a new sub-cube. 5. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
A. Rollup
B. Drill down
C. Dicing
D. Pivoting
Answer:A
Explanation: The slice operation selects one particular dimension from a given cube and provides a new sub-cube. Dice selects two or more dimensions from a given cube and provides a new sub-cube. 5. The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
A. Rollup B. Drill down C. Dicing D. Pivoting
Explanation:The opposite operation—that of moving fromcoarser-granularity data to finer-granularity data—is called a drill down. 6. In SQL the cross-tabs are created using