Discuss Microsoft PL-300 Exam Topic 12 Question 7

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

Suggested Answer: D

Get Premium PL-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

15 comments · newest first

Gayla 12 months ago

Totally agree with C, it’s the standard approach!

Anissa 1 year ago

Wait, can you really use inactive relationships effectively?

Queenie 1 year ago

A is too basic, we need a proper date table!

Aliza 1 year ago

I disagree, D seems more comprehensive with DAX.

Bernardine 1 year ago

Option C is the best choice for accurate date handling.

Willow 1 year ago

I feel like option D could be overkill since it involves adding multiple columns, but I guess it could work if we need those specific calculations.

Ronnie 1 year ago

I practiced a similar question where adding calculated columns in Power Query was emphasized, but I can't recall if it was specifically about the calendar quarter and month.

Willow 1 year ago

I'm not entirely sure, but I think using the Auto date/time option in option B could simplify things, though it might not be as flexible as a custom date table.

Terrilyn 1 year ago

I remember we discussed the importance of having a dedicated date table for time-based analysis, so I think option C might be the right choice.

Francoise 1 year ago

I'm a little confused by this question. The incident response team seems to have done a lot of the right things, so I'm not sure what the missing step could be. I'll need to re-read the NIST guidelines carefully to figure this out.

Gerald 1 year ago

This question seems straightforward, but I want to make sure I understand the key points. The prompt is asking for an exception to the general rule that audit standards should be followed. I'll need to carefully consider each option and determine which one does not fit that criteria.

Karan 1 year ago

Hmm, this seems straightforward. Lowering the TPC Power Threshold should increase the cell size, so I'll go with option A.

Pilar 1 year ago

Okay, I've got this. The key is to focus on the fact that the information is coming from a database owned by another department. That means the stakeholder who can approve access is likely someone in a governance or oversight role for that department's systems. I'll go with option D, Governance Approach.

Callum F 4 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.

koorosh 4 years ago

↳ replying to Callum F

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

Microsoft PL-300 Exam - Topic 12 Question 7 Discussion