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

Stephaine

1 hours ago

Ooh, a many-to-many relationship, fancy! But I'm not sure it's necessary for this use case. Seems a bit overkill.

upvoted 0 times

...

Lorean

5 days ago

Ugh, option B is just adding more complexity. Why bring in the Sales table when we can handle this with the Date table directly?

upvoted 0 times

...

Chanel

8 days ago

Creating a calculated column in the Weekly_Returns table is the way to go. It's a simple and straightforward solution that should get the job done.

upvoted 0 times

...

Blair

16 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

27 days ago

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

upvoted 0 times

...

Carri

29 days ago

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

upvoted 0 times

...