Free sampleDescribe an Analytics Workload on Azureeasy
In a data warehouse that uses a star schema, what is the role of the central fact table relative to the surrounding dimension tables?
- AIt holds the numeric values that can be aggregated by the related dimensions Correct
- BIt holds the descriptive entities used to group and slice the numeric values
- CIt stores the raw files exactly as received before any schema is applied
- DIt records the read-time formula language used to compute query measures
Fact tables hold numbers; dimension tables hold the entities to aggregate by. In a star schema the central fact table contains the numeric values, related to dimension tables that represent the entities by which the data can be aggregated.
Why A is correct: Correct. In a star schema the central fact table contains the numeric values, related to dimension tables that represent the entities by which the data can be aggregated.
Why B is wrong: Describing entities such as customer, product and store is the role of the dimension tables.
Why C is wrong: Storing raw files with no schema describes a data lake, not a fact table in a star schema.
Why D is wrong: Formula-language measures belong to a semantic model, not to a warehouse fact table.