ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 2 question 121 discussion

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

You have a Power BI semantic model that contains the following tables.





You need to define a relationship from FactSales to DimProduct. The solution must ensure the fastest DAX query performance.

Which cardinality should you use?

  • A. one-to-many
  • B. one-to-one
  • C. many-to-many
  • D. many-to-one
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by a2c7cd3 at June 13, 2025, noon

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
Submit Cancel
kay000001
1 week, 1 day ago
Selected Answer: A
You’re defining a relationship from FactSales to DimProduct. In a star schema: FactSales is a fact table — it contains many transactional records. DimProduct is a dimension table — it contains one row per unique product. You're setting up a relationship from Fact → Dim, which is many → one in data terms. But in Power BI, the relationship direction is defined from the dimension table to the fact table (i.e., one-to-many), even though you're technically connecting Fact to Dim.
upvoted 1 times
...
a2c7cd3
1 week, 5 days ago
Selected Answer: D
D is correct
upvoted 2 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