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

3 months 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 months ago

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

upvoted 0 times

...

Ronnie

2 months ago

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

upvoted 0 times

...

Yvonne

2 months ago

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

upvoted 0 times

...

Shaunna

3 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

3 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

Dwight

1 months ago

Yeah, a many-to-many relationship might be too complex for this scenario. Let's keep it simple.

upvoted 0 times

...

Tyisha

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

...

Chana

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

3 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

3 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

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

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

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

...