exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 109 discussion

Actual exam question from Microsoft's PL-300
Question #: 109
Topic #: 2
[All PL-300 Questions]

HOTSPOT
-

You have a Power BI semantic model that contains three tables named Products, OrderHistory, and Date.

The Products table is a dimension table that contains the following columns:

• ProductID
• ProductName

The OrderHistory table is a fact table that contains the following columns:

• OrderID
• ProductID
• OrderDate

The Date table is a dimension table that contains the following columns:

• Year
• Date
• Week
• Month

You need to define a relationship from Products to OrderHistory and from OrderHistory to Date.

Which cardinality should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct answer is worth one point.

Show Suggested Answer Hide Answer
Suggested Answer:

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
kai_data
Highly Voted 4 months, 1 week ago
the second should be many-to-one
upvoted 13 times
...
Lulu_2022
Most Recent 1 month, 1 week ago
From Products to OrderHistory: Cardinality: One-to-Many Why: Each product in the Products table has a unique ProductID, and that ID appears multiple times in the OrderHistory table (one row per order). This is a classic dimension-to-fact relationship. ✅ From Date to OrderHistory: Cardinality: One-to-Many Why: The Date table contains a unique list of dates, and OrderHistory[OrderDate] contains many rows per date. Again, this is a standard date dimension to fact relationship.
upvoted 1 times
...
Jasm_74
1 month, 3 weeks ago
Guessing the second answer is 1-1. Just because the title of the fact table is order history.
upvoted 1 times
...
cambolambo
2 months ago
Is the second one really many-to-one? I don't get how they don't even have the correct answer choice as an option.
upvoted 1 times
...
a530d13
4 months, 1 week ago
Nothing in the question indicates that there is at most one order per day. If there is more than one order per day then "one" date in the Date table would map to "many" dates in the OrderHistory table
upvoted 3 times
...
dkilkelly
4 months, 1 week ago
The given answer is incorrect. It should be one-to-many, and then many-to-one. Without additional information provided, it would be rational to assume that the fact table has many dates which would relate to a single date in the date dimension table.
upvoted 2 times
...
889efe8
4 months, 3 weeks ago
correct
upvoted 1 times
...
4b88f2d
5 months ago
ye, but second option tells on-to-one, and the same like first option is relationing dim table with fact table, so must be one-to-many too. Am I wrong?
upvoted 1 times
...
Anloindian123
5 months, 1 week ago
Given answer is correct. Dimension table is always the "one side", and fact table is always the "many side"
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...