What is true of hierarchies in a data cube?
A) Without them, the dimension must contain the most detailed level of data
B) They make it easier to compute aggregates across the dimension
C) Dimensions can have multiple hierarchies
D) All of the above

Question

Quizplus · Accepted Answer

All three options are true of hierarchies in a data cube. Hierarchies allow for more organized and efficient aggregation of data, and dimensions can have multiple hierarchies with varying levels of granularity. Without hierarchies, dimensions would have to contain only the most detailed level of data, which would make computing aggregates across the dimension more difficult.

What Is True of Hierarchies in a Data Cube