The GATE Grind

GATE Database Management and Warehousing: Data warehouse modelling and OLAP – Previous Year Questions

3 GATE previous year questions on Data warehouse modelling and OLAP (Database Management and Warehousing, Data Science and Artificial Intelligence) with answers and explanations, from every paper.

3 questions worth 5 marks in all (1 1-mark, 2 2-mark). Asked between 2025 and 2026, so you can see how the topic has been tested over time.

  1. GATE 2025 DA Q46 (2 marks, Multiple choice) – Consider a fact table in an OLAP application: Facts(D1, D2, val), where D1 and D2 are its dimension attributes and val is a dependent attribute.…
  2. GATE 2026 DA Q18 (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…
  3. GATE 2026 DA Q43 (2 marks, Multiple choice) – Consider the concept hierarchies as shown in the figure. Which of the following options denotes the total number of possible data cuboids from these…