You need to create a relationship between the Weekly_Returns table and the Date table to...

Vendor: Microsoft
Product: PL-300
Update on: Jul 31, 2025
Questions: 450

Microsoft PL-300 Question Answer

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?

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.

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

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.