Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft PL-300 Exam - Topic 12 Question 7 Discussion

You need to design the data model to meet the report requirements. What should you do m Power Bl Desktop?
D) From 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
A) From Power Query, add columns to the Orders table to calculate the calendar quarter and the calendar month of the OrderDate column.
B) From Power Bi Desktop, use the Auto date/time option when creating the reports.
C) From 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.

Microsoft PL-300 Exam - Topic 12 Question 7 Discussion

Actual exam question for Microsoft's PL-300 exam
Question #: 7
Topic #: 12
[All PL-300 Questions]

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

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
Gayla
7 months ago
Totally agree with C, it’s the standard approach!
upvoted 0 times
...
Anissa
7 months ago
Wait, can you really use inactive relationships effectively?
upvoted 0 times
...
Queenie
8 months ago
A is too basic, we need a proper date table!
upvoted 0 times
...
Aliza
8 months ago
I disagree, D seems more comprehensive with DAX.
upvoted 0 times
...
Bernardine
8 months ago
Option C is the best choice for accurate date handling.
upvoted 0 times
...
Willow
8 months 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.
upvoted 0 times
...
Ronnie
8 months 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.
upvoted 0 times
...
Willow
8 months 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.
upvoted 0 times
...
Terrilyn
8 months 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.
upvoted 0 times
...
Francoise
8 months 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.
upvoted 0 times
...
Gerald
8 months 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.
upvoted 0 times
...
Karan
8 months ago
Hmm, this seems straightforward. Lowering the TPC Power Threshold should increase the cell size, so I'll go with option A.
upvoted 0 times
...
Pilar
8 months 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.
upvoted 0 times
...
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.
upvoted 1 times
koorosh
4 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
...
...

Save Cancel