nerdexam
Microsoft

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.

Submitted by carlos_mx· Mar 30, 2026Describe an analytics workload on Azure

Question

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?

Options

  • Abridge
  • Bdimension
  • Cfact

How the community answered

(44 responses)
  • A
    18% (8)
  • B
    75% (33)
  • C
    7% (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.

Abridge

A bridge table is a junction table used to resolve many-to-many relationships between dimensions, not a primary container for descriptive entities.

BdimensionCorrect

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.

Cfact

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

#dimensional modeling#dimension tables#star schema#data warehouse

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice