Exam PL-300 topic 2 question 85 discussion

Actual exam question from Microsoft's PL-300

Question #: 85
Topic #: 2

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have a Power BI report that imports a date table and a sales table from an Azure SQL database data source. The sales table has the following date foreign keys:

• Due Date
• Order Date
• Delivery Date

You need to support the analysis of sales over time based on all the date foreign keys.

Solution: From the Fields pane, you rename the date table as Due Date. You use a DAX expression to create Order Date and Delivery Date as calculated tables. You create active relationships between the sales table and each date table.

Does this meet the goal?

A. Yes
B. No

Show Suggested Answer

Suggested Answer: A 🗳️

by Endeetheanalyst at Sept. 5, 2024, 1:09 p.m.

Comments

Submit Cancel

7eb1fdb

Highly Voted 11 months ago

Deja vu

upvoted 5 times

...

Lulu_2022

Most Recent 1 month, 1 week ago

Selected Answer: B

Power BI allows only one active relationship between a fact table (like Sales) and a given dimension table (like Date). Creating calculated tables using DAX for Order Date and Delivery Date based on the original Date table does not create independent role-playing dimensions — they are still tied to the same underlying data and metadata. Attempting to create active relationships from all three date columns in the Sales table to these calculated tables will likely result in ambiguity or errors, and it increases model complexity unnecessarily.

upvoted 1 times

...

jaume

8 months, 2 weeks ago

Selected Answer: A

Same question as Q77 but also same answer :-)

upvoted 1 times

...

amiruladliroslibin

9 months, 2 weeks ago

Selected Answer: B

In Power BI, only one active relationship can exist between two tables at a time. By renaming the date table as "Due Date" and creating calculated tables for "Order Date" and "Delivery Date", you are essentially creating multiple date tables and attempting to establish multiple active relationships with the sales table.

upvoted 2 times

...