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

Question

Quizplus · Accepted Answer

The attribute hierarchy is used to organize data in a top-down manner for the purpose of aggregation and drill-down/roll-up data analysis. Aggregation involves combining data at higher levels of the hierarchy, while drill-down/roll-up analysis involves navigating through the hierarchy to view data at different levels of detail. Therefore, option D, which refers to aggregation, is the correct answer. Option A, decomposition, may be a possible use of the attribute hierarchy, but it is not mentioned in the context of the question. Option B, denormalization, and option C, normalization, are not related to the attribute hierarchy.

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