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.

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.…
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…
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…