Online analytical processing (OLAP) Question:
Download Questions 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

Answer:

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

Download OLAP Interview Questions And Answers PDF

Previous QuestionNext 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