The GATE Grind

GATE 2026 DA – Question 18

Database Management and Warehousing · Data warehouse modelling and OLAP · 1 mark · Multiple choice

Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country.

From this, if we want to further visualize the Sales Quantity for each combination of Product Type, Month and State, which of the following OLAP operations should be performed?

  1. Slicing
  2. Dicing
  3. Roll-up
  4. Drill-down

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (D) Drill-down

Explanation

Going from country to state moves down the location hierarchy to a finer level of detail. That operation is a drill-down. Roll-up goes the other way, from state to country, while slicing and dicing select part of the cube without changing the level of detail.