Microsoft · DP-600
Star schema and relationships
DP-600 · Lesson 11 of 15 · 1:10:45
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the DP-600 exam (Microsoft Certified: Fabric Analytics Engineer Associate). In this lesson: the star schema, relationship cardinality and cross-filter direction, bridge tables, and many-to-many cardinality. Includes three original practice questions.
Preview the topics
- Sales has an order date and a ship date, both related to the Date table, and one relationship is a dashed line. A measure must count the orders by ship date. What should it use?
- Customer and Account are related through a bridge table. A filter on one customer shows the same total for every account. What should you change?
- Monthly targets exist per category, and the Product table has one row per product. There is no Category dimension, and the team wants a direct relationship on Category. Which cardinality fits?