Which statement about data storage in a cube is true?

Which statement about data storage in a cube is true?

• A. Data in a cube is stored using references for rows and columns in tables.
• B. Data is stored alphabetically
• C. Data is stored by load time
• D. Data is stored in a single flat table

Answer: (A)

In a cube, data is kept in a multidimensional grid where each cell’s value is determined by a combination of dimension members (such as time, product, or region). The storage uses references to the rows and columns in the dimension and fact tables, so the value at a given intersection is retrieved by following those references rather than placing data in a single flat structure. This design supports fast slicing and dicing across different dimensions. The other options don’t fit because data isn’t stored alphabetically, nor strictly by load time, and it isn’t housed in one flat table—the cube relies on related dimension tables and a fact table connected through references.

In a cube, data is kept in a multidimensional grid where each cell’s value is determined by a combination of dimension members (such as time, product, or region). The storage uses references to the rows and columns in the dimension and fact tables, so the value at a given intersection is retrieved by following those references rather than placing data in a single flat structure. This design supports fast slicing and dicing across different dimensions. The other options don’t fit because data isn’t stored alphabetically, nor strictly by load time, and it isn’t housed in one flat table—the cube relies on related dimension tables and a fact table connected through references.