PL-300 - Model the Data - Section 2.1
Design and implement a data model including relationships and star schema best practices.
Design a star schema by separating fact and dimension tables, and define relationships with appropriate cardinality to enable correct aggregations. Choose cross-filter direction carefully, recognising that bidirectional filtering can cause ambiguous results in complex models.
star schemafact and dimension tablesrelationshipscardinalitycross-filter direction
More in this domain
Back to all Model the Data objectives, or the PL-300 cert hub.
Examworthy is not affiliated with or endorsed by Microsoft. Original, blueprint-aligned practice material only.