The attribute hierarchy provides a top-down data organization that is used for two main purposes: ____ and drill-down/roll-up data analysis.
A) hierarchy
B) de-normalization
C) normalization
D) aggregation

Question

Quizplus · Accepted Answer

The attribute hierarchy is primarily used for aggregation, where data is summarized to a higher level, and drill-down/roll-up analysis, where data is analyzed at different levels of granularity. De-normalization and normalization are data modeling techniques, and although they may be related to the organization of data in a hierarchy, they are not the primary purposes of the hierarchy.

The Attribute Hierarchy Provides a Top-Down Data Organization That Is