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

Evangelina

29 days ago

Option A is the clear winner here. Ain't nobody got time for all that extra table creating and DAX function nonsense. Keep it simple, stupid!

upvoted 0 times

Azalee

2 days ago

I think we can all agree that option A is the best choice here. Let's keep it simple.

upvoted 0 times

...

Ronnie

4 days ago

Yeah, creating a new table seems like overkill. Option A is much more straightforward.

upvoted 0 times

...

Yvonne

21 days ago

I agree, option A is definitely the way to go. Simple and effective.

upvoted 0 times

...

Shaunna

1 months ago

I like the simplicity of option A. No need to reinvent the wheel here. Sometimes the obvious solution is the best one.

upvoted 0 times

...

Stephaine

1 months 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

Chana

22 days ago

A) In 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.

upvoted 0 times

...

Lorean

1 months 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

1 months 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

Cassie

15 hours ago

A) In 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.

upvoted 0 times

...

Dan

10 days ago

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

upvoted 0 times

...

Paris

21 days ago

A) In 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.

upvoted 0 times

...