Microsoft Certified: Power BI Data Analyst Associate PL-300 Question # 4 Topic 1 Discussion
PL-300 Exam Topic 1 Question 4 Discussion:
Question #: 4
Topic #: 1
You need to create relationships to meet the reporting requirements of the customer service department.
What should you create?
A.
an additional date table named ShipDate, a one-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a one-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]
B.
an additional date table named ShipDate, a many-to-many relationship from
Sales[sales_date_id] to Date[date_id], and a many-to-many relationship from
Sales[sales_ship_date_id] to ShipDate[date_id]
C.
a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Weekly_Returns[week_id]
D.
a one-to-many relationship from Sales[sales_date_id] to Date[date_id] and a one-to-many
relationship from Sales[sales_ship_date_id] to Date[date_id]
E.
a one-to-many relationship from Date[date_id] to Sales[sales_date_id] and another one-to-many relationship from Date[date_id] to Sales[sales_ship_date_id]
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit