DP-900 · Question #276
In an analytical data model, which type of table contains entities that are used to aggregate numeric values, where each entity is represented by a row with a unique key value?
The correct answer is B. dimension. In dimensional modeling, dimension tables describe the 'who, what, where, when' context for measurements, with each row identified by a unique surrogate or natural key.
Question
Options
- Abridge
- Bdimension
- Cfact
How the community answered
(44 responses)- A18% (8)
- B75% (33)
- C7% (3)
Why each option
In dimensional modeling, dimension tables describe the 'who, what, where, when' context for measurements, with each row identified by a unique surrogate or natural key.
A bridge table is a junction table used to resolve many-to-many relationships between dimensions, not a primary container for descriptive entities.
Dimension tables hold descriptive attributes (e.g., product name, customer city, date) used to filter and group aggregations; each entity gets exactly one row identified by a unique key value, making them the correct answer.
Fact tables store the numeric measures (e.g., sales amount, quantity) that are aggregated, referencing dimension tables via foreign keys rather than representing the entities themselves.
Concept tested: Dimensional modeling: dimension vs. fact tables
Source: https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Topics
Community Discussion
No community discussion yet for this question.