Microsoft Exam PL-300 Topic 12 Question 7 Discussion

Actual exam question for Microsoft's PL-300 exam

Question #: 7
Topic #: 12

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?

AFrom Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.

BFrom Power Bi Desktop, use the Auto date/time option when creating the reports.

CFrom Power Query, add a date table. Create an active relationship to the OrderDate column in the Orders table and an inactive relationship to the ShippedDate column in the Orders table.

DFrom Power Query, use a DAX expression to add columns to the Orders table to calculate the calendar quarter of the OrderDate column, the calendar month of the OrderDate column, the calendar quarter of the ShippedDate column, and the calendar month of the ShippedDate column

Show Suggested Answer

Suggested Answer: D

by Kati at May 04, 2022, 06:01 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Callum F

2 years ago

C is the correct answer. D is wrong for two reasons: 1) it says to use DAX in Power Query. In Power Query you use M 2) it suggests adding additional dates columns into a fact table rather than creating a calendar table. This is poor data modelling.

upvoted 1 times

koorosh

2 years ago

Hi, If D is wrong, how to calculate late orders, when we have no quarter and month of shipped date?

upvoted 1 times

...