Exam PL-300 topic 2 question 109 discussion

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.

Suggested Answer: