Microsoft PL-300 Practice Test 39
Question 380
The original scenario was: A business user wants a report measure that adapts to slicers, not a refresh-time snapshot stored on rows. The initial solution is already in place. Now this new requirement arises: A separate attribute must be used as a relationship or slicer column. Which ADDITIONAL action BEST meets the changed condition?
- The metric changes correctly when slicers change without a model refresh
- Create a materialized calculated column for that row-level attribute
- Create a calculated column that tries to capture the viewer's current slicer value at refresh
- Create a DAX measure rather than a calculated column
Explanation
Correct Answer
B:The changed requirement is 'A separate attribute must be used as a relationship or slicer column'. The additional response is 'Create a materialized calculated column for that row-level attribute'.
Incorrect Answers
A:This observes the original approach but is not an additional action: The metric changes correctly when slicers change without a model refresh.
C:This remains unsuitable for the original situation: Calculated columns do not dynamically recalculate for every report selection. It also does not meet the changed need.
D:This is the already implemented original solution: Create a DAX measure rather than a calculated column. Measures recompute in filter context at query time. It does not itself solve the new requirement.
Question 381
An analyst needs a quick year-over-year percentage calculation for a standard date field. Which TWO entries together identify the most appropriate initial action and direct observed evidence of its success? (Select TWO.)
- Use the Power BI quick-measure feature then inspect and test the generated DAX
- Assume any generated DAX formula is automatically accurate for all business calendars
- Create a DAX measure rather than a calculated column
- The formula produces expected prior-year comparisons on test periods
- Review and adjust the DAX to the approved fiscal definitions
Explanation
Correct Answers
A:Quick measures can generate common DAX patterns that must still be validated. For the stated case, Use the Power BI quick-measure feature then inspect and test the generated DAX.
D:Correct direct operational evidence. The formula produces expected prior-year comparisons on test periods. This is a check of the original requirement, not an unperformed plan.
Incorrect Answers
B:Generated patterns can require a compatible date table and correct requirements. The proposed shortcut 'Assume any generated DAX formula is automatically accurate for all business calendars' fails the documented need.
C:This addresses a separate source situation: A business user wants a report measure that adapts to slicers, not a refresh-time snapshot stored on rows. It does not directly satisfy this case's priority. In the current question, this comparison is made against: An analyst needs a quick year-over-year percentage calculation for a standard date field. Which TWO entries together identify the most appropriate initial action and direct observed evidence of its success? (Select TWO.)
E:This might be appropriate after a different requirement arises: The company adopts a nonstandard fiscal calendar. It is not the best initial response to the stated case.
Question 382
An analyst needs a quick year-over-year percentage calculation for a standard date field. A colleague proposes: Assume any generated DAX formula is automatically accurate for all business calendars. Which explanation BEST identifies the defect in that proposal?
- Generated patterns can require a compatible date table and correct requirements
- Quick measures can generate common DAX patterns that must still be validated
- The suggested approach is safe merely because its product name is familiar.
- Calculated columns do not dynamically recalculate for every report selection
Explanation
Correct Answer
A:Generated patterns can require a compatible date table and correct requirements. This directly explains why the proposal 'Assume any generated DAX formula is automatically accurate for all business calendars' should not be used.
Incorrect Answers
B:This is reasoning supporting the preferred solution 'Use the Power BI quick-measure feature then inspect and test the generated DAX', but it does not directly name the defect in the proposed shortcut.
C:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Generated patterns can require a compatible date table and correct requirements.
D:This addresses a different case: A business user wants a report measure that adapts to slicers, not a refresh-time snapshot stored on rows. It is not the specific defect in 'Assume any generated DAX formula is automatically accurate for all business calendars'.
Question 383
An analyst needs a quick year-over-year percentage calculation for a standard date field. After implementing Use the Power BI quick-measure feature then inspect and test the generated DAX, which observation BEST demonstrates that the intended result is actually working?
- The team schedules a future check of whether The formula produces expected prior-year comparisons on test periods, but has not observed a result.
- The formula produces expected prior-year comparisons on test periods
- The metric changes correctly when slicers change without a model refresh
- The report owner approves Use the Power BI quick-measure feature then inspect and test the generated DAX without testing the resulting behavior.
Explanation
Correct Answer
B:The observation 'The formula produces expected prior-year comparisons on test periods' directly tests the intended result. Quick measures can generate common DAX patterns that must still be validated.
Incorrect Answers
A:A future test is not yet observed operational evidence. The verification must establish: The formula produces expected prior-year comparisons on test periods.
C:This belongs to a different case: A business user wants a report measure that adapts to slicers, not a refresh-time snapshot stored on rows. It does not validate the current change. In the current question, this comparison is made against: An analyst needs a quick year-over-year percentage calculation for a standard date field. After implementing Use the Power BI quick-measure feature then inspect and test the generated DAX, which observation BEST demonstrates that the intended result is actually working?
D:Approval of a proposed design is not evidence of working behavior. The required observation is: The formula produces expected prior-year comparisons on test periods.
Question 384
The original scenario was: An analyst needs a quick year-over-year percentage calculation for a standard date field. The initial solution is already in place. Now this new requirement arises: The company adopts a nonstandard fiscal calendar. Which ADDITIONAL action BEST meets the changed condition?
- Review and adjust the DAX to the approved fiscal definitions
- Use the Power BI quick-measure feature then inspect and test the generated DAX
- The formula produces expected prior-year comparisons on test periods
- Assume any generated DAX formula is automatically accurate for all business calendars
Explanation
Correct Answer
A:The changed requirement is 'The company adopts a nonstandard fiscal calendar'. The additional response is 'Review and adjust the DAX to the approved fiscal definitions'.
Incorrect Answers
B:This is the already implemented original solution: Use the Power BI quick-measure feature then inspect and test the generated DAX. Quick measures can generate common DAX patterns that must still be validated. It does not itself solve the new requirement.
C:This observes the original approach but is not an additional action: The formula produces expected prior-year comparisons on test periods.
D:This remains unsuitable for the original situation: Generated patterns can require a compatible date table and correct requirements. It also does not meet the changed need.
Question 385
A model repeats selected-measure time transformations such as YTD and Prior Year across dozens of base measures. Which approach BEST meets the stated Microsoft Power BI requirement?
- Design calculation-group exceptions or targeted alternate items explicitly
- Copy and paste separate YTD formulas into every measure without governance
- Use a calculation group to centralize reusable calculation items
- Use a measure such as Total Sales = SUM(Sales[SalesAmount])
Explanation
Correct Answer
C:Calculation groups can apply shared calculation logic to different base measures. For the stated case, Use a calculation group to centralize reusable calculation items.
Incorrect Answers
A:This might be appropriate after a different requirement arises: A subset of measures needs a different fiscal calendar rule. It is not the best initial response to the stated case.
B:Duplicated logic increases maintenance and inconsistency risk. The proposed shortcut 'Copy and paste separate YTD formulas into every measure without governance' fails the documented need.
D:This addresses a separate source situation: A report must display total SalesAmount across current customer and date filters. It does not directly satisfy this case's priority.
Question 386
A model repeats selected-measure time transformations such as YTD and Prior Year across dozens of base measures. A colleague proposes: Copy and paste separate YTD formulas into every measure without governance. Which explanation BEST identifies the defect in that proposal?
- Duplicated logic increases maintenance and inconsistency risk
- The suggested approach is safe merely because its product name is familiar.
- COUNT counts nonblank rows rather than adding currency amounts
- Calculation groups can apply shared calculation logic to different base measures
Explanation
Correct Answer
A:Duplicated logic increases maintenance and inconsistency risk. This directly explains why the proposal 'Copy and paste separate YTD formulas into every measure without governance' should not be used.
Incorrect Answers
B:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Duplicated logic increases maintenance and inconsistency risk.
C:This addresses a different case: A report must display total SalesAmount across current customer and date filters. It is not the specific defect in 'Copy and paste separate YTD formulas into every measure without governance'.
D:This is reasoning supporting the preferred solution 'Use a calculation group to centralize reusable calculation items', but it does not directly name the defect in the proposed shortcut.
Question 387
A model repeats selected-measure time transformations such as YTD and Prior Year across dozens of base measures. After implementing Use a calculation group to centralize reusable calculation items, which observation BEST demonstrates that the intended result is actually working?
- The team schedules a future check of whether Multiple base measures use one tested YTD item with consistent results, but has not observed a result.
- Multiple base measures use one tested YTD item with consistent results
- The measure equals source total in an unrestricted view and changes under slicers
- The report owner approves Use a calculation group to centralize reusable calculation items without testing the resulting behavior.
Explanation
Correct Answer
B:The observation 'Multiple base measures use one tested YTD item with consistent results' directly tests the intended result. Calculation groups can apply shared calculation logic to different base measures.
Incorrect Answers
A:A future test is not yet observed operational evidence. The verification must establish: Multiple base measures use one tested YTD item with consistent results.
C:This belongs to a different case: A report must display total SalesAmount across current customer and date filters. It does not validate the current change.
D:Approval of a proposed design is not evidence of working behavior. The required observation is: Multiple base measures use one tested YTD item with consistent results.
Question 388
The original scenario was: A model repeats selected-measure time transformations such as YTD and Prior Year across dozens of base measures. The initial solution is already in place. Now this new requirement arises: A subset of measures needs a different fiscal calendar rule. Which ADDITIONAL action BEST meets the changed condition?
- Multiple base measures use one tested YTD item with consistent results
- Use a calculation group to centralize reusable calculation items
- Copy and paste separate YTD formulas into every measure without governance
- Design calculation-group exceptions or targeted alternate items explicitly
Explanation
Correct Answer
D:The changed requirement is 'A subset of measures needs a different fiscal calendar rule'. The additional response is 'Design calculation-group exceptions or targeted alternate items explicitly'.
Incorrect Answers
A:This observes the original approach but is not an additional action: Multiple base measures use one tested YTD item with consistent results.
B:This is the already implemented original solution: Use a calculation group to centralize reusable calculation items. Calculation groups can apply shared calculation logic to different base measures. It does not itself solve the new requirement.
C:This remains unsuitable for the original situation: Duplicated logic increases maintenance and inconsistency risk. It also does not meet the changed need.
Question 389
A long complex DAX measure repeats the same filtered sales subexpression three times. Which approach BEST meets the stated Microsoft Power BI requirement?
- Use RELATED(Product[StandardCost]) inside an iterator with a valid many-to-one relationship
- Use DAX query view or temporary test measures for the intermediate expression
- Copy the same filter calculation into every nested branch without explanation
- Use VAR definitions and RETURN to reuse intermediate scalar or table expressions
Explanation
Correct Answer
D:DAX variables improve readability and can avoid repeated expression evaluation. For the stated case, Use VAR definitions and RETURN to reuse intermediate scalar or table expressions.
Incorrect Answers
A:This addresses a separate source situation: A measure in Sales needs each row's related Product StandardCost for a row-level extended-cost calculation. It does not directly satisfy this case's priority. In the current question, this comparison is made against: A long complex DAX measure repeats the same filtered sales subexpression three times. Which approach BEST meets the stated Microsoft Power BI requirement?
B:This might be appropriate after a different requirement arises: The metric must expose an intermediate calculation for debugging. It is not the best initial response to the stated case.
C:Repeated subexpressions make troubleshooting and maintenance harder. The proposed shortcut 'Copy the same filter calculation into every nested branch without explanation' fails the documented need.
Question 390
A long complex DAX measure repeats the same filtered sales subexpression three times. A colleague proposes: Copy the same filter calculation into every nested branch without explanation. Which explanation BEST identifies the defect in that proposal?
- Lookup without a reliable key can return wrong or ambiguous values
- The suggested approach is safe merely because its product name is familiar.
- DAX variables improve readability and can avoid repeated expression evaluation
- Repeated subexpressions make troubleshooting and maintenance harder
Explanation
Correct Answer
D:Repeated subexpressions make troubleshooting and maintenance harder. This directly explains why the proposal 'Copy the same filter calculation into every nested branch without explanation' should not be used.
Incorrect Answers
A:This addresses a different case: A measure in Sales needs each row's related Product StandardCost for a row-level extended-cost calculation. It is not the specific defect in 'Copy the same filter calculation into every nested branch without explanation'.
B:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Repeated subexpressions make troubleshooting and maintenance harder.
C:This is reasoning supporting the preferred solution 'Use VAR definitions and RETURN to reuse intermediate scalar or table expressions', but it does not directly name the defect in the proposed shortcut.