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.
Select one answer.
Purchase Full Access to view answer options & explanation
The first 134 questions in this bank are completely free. Unlock Full Access on the exam page to view all answer choices, verified answers, explanations, and community discussions for all 444 questions.