PL-300 Model the data Practice Question
You are building a Power BI model that includes a table 'Orders' with columns: OrderID, CustomerID, OrderDate, and TotalAmount. You also have a table 'Customers' with columns: CustomerID, CustomerName, and Segment. You need to create a relationship between Orders and Customers on CustomerID. Which relationship configuration should you choose to ensure that filtering Customers by Segment correctly filters Orders?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
One-to-many relationship from Customers to Orders
A one-to-many relationship from Customers (one side) to Orders (many side) with single-direction cross-filtering ensures that filtering Customers by Segment correctly filters Orders. Option B (many-to-one) would reverse the cardinality and, by default, would not allow filtering from Customers to Orders. Option C is unnecessary and can cause ambiguity. Option D is inappropriate as one customer can have many orders.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
One-to-many relationship from Customers to Orders
Why this is correct
This is the canonical star-schema relationship. A single customer can appear in many orders, so Customers is the 'one' side and Orders is the 'many' side. By placing the relationship from Customers to Orders, customer attributes (region, segment, etc.) automatically filter and slice all related order rows, enabling correct aggregations in measures. This relationship uses the dimension table as the lookup table and the fact table as the data table, which is the preferred pattern for performance and intuitive filtering.
- ✗
Many-to-one relationship from Orders to Customers
Why it's wrong here
This relationship declaration is wrong because it describes the source as the Orders table, implying filters would flow from the many-side fact table to the one-side dimension table. While a many-to-one relationship in Power BI has the same cardinality as a one-to-many, the requested star-schema design must start at Customers (the dimension) and end at Orders (the fact). Starting at the fact side obscures filter direction and breaks the convention of having the lookup table on the one side drive all downstream measures.
- ✗
Many-to-many relationship with a bridge table
Why it's wrong here
A many-to-many relationship requires a bridge table to resolve the cardinality when both tables lack unique keys. In this scenario, each order has exactly one customer and each customer can have many orders, so there is no many-to-many association between Customers and Orders. Introducing a bridge table would needlessly fragment the model, add extra joins, and risk double-counting customer metrics unless special handling such as CALCULATE with USERELATIONSHIP is added.
- ✗
One-to-one relationship
Why it's wrong here
A one-to-one relationship would force every customer to have at most one order and every order to belong to a distinct customer. This is impossible in an order management system because a customer can place multiple orders over time, and multiple order rows share the same customer key. Enforcing one-to-one cardinality would require denormalizing order details into the customer row, which violates the normalized design of a fact table containing multiple transactions per dimension member.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-300 question from scratch — 217 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.