Free Microsoft Power BI PL-300 Actual Exam Questions - Question 12 Discussion
HOTSPOT You need to design the data model and the relationships for the Customer Details worksheet and the Orders table by using Power BI. The solution must meet the report requirements. For each of the following statement, select Yes if the statement is true, Otherwise, select No. NOTE: Each correct selection is worth one point. 
If CustomerID isn't unique in Customer Details, then any statement claiming a one-to-many relationship from Customers to Orders should be No. Uniqueness is key for that link to work properly.
If CustomerID isn't unique in Customer Details, then the one-to-many relationship might not hold, so any statements assuming uniqueness should be No. Otherwise, the typical setup is one-to-many from Customers to Orders.
I’d say some of the Yes/No answers also depend on whether CustomerID in Customer Details is marked as a primary key or just a regular column. If it’s not guaranteed unique, then the relationship might not be strictly one-to-many. Also, if the Orders table has any duplicate CustomerIDs that don’t match the Customer Details keys exactly, that could mess up the expected relationship type. So checking uniqueness and data integrity first helps make sense of these statements, not just assuming one-to-many automatically.
Yes, one customer can have many orders, so one-to-many fits here.
Statements saying each order relates to one customer should be Yes, since orders typically have a single customer. Anything implying customers link to multiple orders is also correct, but many-to-many is unlikely here.
I’d say statements that suggest a single customer can have multiple orders should be Yes, since that’s the typical case. Any claim that orders link to multiple customers at once doesn’t fit, so those get a No.
The one-to-many relationship from Customer Details to Orders makes sense since each order should link to a single customer. So, any statement suggesting many-to-many would be off for this case.
Yes, usually Customer to Orders is one-to-many, so those statements check out.
Without seeing the image, I think some statements about one-to-many relationships between Customer Details and Orders should be yes, since orders usually link back to one customer. Others might be no if they suggest many-to-many or incorrect keys.
There’s not enough detail in the question itself to decide on those yes/no answers confidently. The image probably has some model or rule details that are crucial, but since it’s just the question text here, can anyone share a clearer explanation of how the Customer and Orders tables relate? Especially looking at the key columns for relationship types needed in Power BI. Without that context, it’s hard to say what should be yes or no for these statements.