Online analytical processing (OLAP) Question: Download OLAP PDF

The operation of moving from finer-granularity data to a coarser granularity (by means of aggregation) is called a ________.
a) Roll-up
b) Drill down
c) Dicing
d) Pivoting

a) Roll-up
Explanation:
The opposite operation-that of moving from coarser-granularity data to finer-granularity data-is called a drill down.

Previous Question	Next Question
The process of viewing the cross-tab (Single dimensional) with a fixed value of one attribute is. a) Slicing b) Dicing c) Pivoting d) Both a and b	In SQL the cross-tabs are created using: a) Slice b) Dice c) Pivot d) All of the mentioned