Microsoft Exam PL-300 Topic 4 Question 39 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 39
Topic #: 4

You need to create a relationship between the Weekly_Returns table and the Date table to meet the reporting requirements of the regional managers. What should you do?

AIn the Weekly.Returns table, create a new calculated column named date-id in a format of yyyymmdd and use the calculated column to create a relationship to the Date table.

BAdd the Weekly_Returns data to the Sales table by using related DAX functions.

CCreate a new table based on the Date table where date-id is unique, and then create a many-to-many relationship to Weekly_Return.

Show Suggested Answer

Suggested Answer: A

by Fatima at Mar 18, 2024, 01:11 AM

Limited Time Offer

25%

Off

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Blair

2 days ago

I'm not sure, but I think option B could also work if we use the DAX functions correctly.

upvoted 0 times

...

Hoa

13 days ago

I disagree, I believe option C is better because it allows for more flexibility in the relationship.

upvoted 0 times

...

Carri

15 days ago

I think option A is the best choice because it creates a direct relationship between the two tables.

upvoted 0 times

...