In data warehousing, which data structure is used for multi-dimensional analysis and supports drill-down capabilities?

• A. Dimension
• B. Measure
• C. Cube
• D. Cluster

Answer: (C)

Focus on the ability to analyze data across multiple dimensions and to explore details by moving from summarized to finer levels. An OLAP cube is designed for this kind of multi-dimensional analysis. It stores numeric measures (like sales, profit) across several dimensions (such as time, location, product), and its structure supports drill-down by traversing hierarchies within those dimensions (for example, year → quarter → month). A dimension defines the viewpoints, a measure is the numeric data being analyzed, and a cluster is not the data structure used for this purpose. So the data cube is the structure that enables multi-dimensional analysis with drill-down capabilities.