Multiple choice technology architecture

Which of the following defines the level of detail stored in the datawarehouse

  1. Fact

  2. Dimension

  3. Granularity

  4. Summary

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Granularity refers to the level of detail stored in the data warehouse - how fine or coarse the data is. For example, sales data stored by day versus by month represents different granularity levels. Facts are measurements, dimensions provide context, and summary is an aggregation.