Microsoft PL-300 Practice Test 48
Question 470
Finance wants Region rows, Product columns, and subtotal drilldown in the same report. A colleague proposes: Use a card visual and expect it to display row/column intersections. Which explanation BEST identifies the defect in that proposal?
- Static text will not update with user filters
- The suggested approach is safe merely because its product name is familiar.
- Cards are single-metric displays rather than pivot-style matrices
- Matrix supports tabular intersections, hierarchy levels, and subtotals
Explanation
Correct Answer
C:Cards are single-metric displays rather than pivot-style matrices. This directly explains why the proposal 'Use a card visual and expect it to display row/column intersections' should not be used.
Incorrect Answers
A:This addresses a different case: A report's header should display the currently filtered total revenue as one large number. It is not the specific defect in 'Use a card visual and expect it to display row/column intersections'.
B:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Cards are single-metric displays rather than pivot-style matrices.
D:This is reasoning supporting the preferred solution 'Use a Matrix visual with Region and Product hierarchies', but it does not directly name the defect in the proposed shortcut.
Question 471
Finance wants Region rows, Product columns, and subtotal drilldown in the same report. After implementing Use a Matrix visual with Region and Product hierarchies, which observation BEST demonstrates that the intended result is actually working?
- The matrix subtotals reconcile to the overall sales total
- The report owner approves Use a Matrix visual with Region and Product hierarchies without testing the resulting behavior.
- The team schedules a future check of whether The matrix subtotals reconcile to the overall sales total, but has not observed a result.
- The displayed card updates when the report's date slicer changes
Explanation
Correct Answer
A:The observation 'The matrix subtotals reconcile to the overall sales total' directly tests the intended result. Matrix supports tabular intersections, hierarchy levels, and subtotals.
Incorrect Answers
B:Approval of a proposed design is not evidence of working behavior. The required observation is: The matrix subtotals reconcile to the overall sales total.
C:A future test is not yet observed operational evidence. The verification must establish: The matrix subtotals reconcile to the overall sales total.
D:This belongs to a different case: A report's header should display the currently filtered total revenue as one large number. It does not validate the current change.
Question 472
The original scenario was: Finance wants Region rows, Product columns, and subtotal drilldown in the same report. The initial solution is already in place. Now this new requirement arises: Finance asks for a print-perfect multi-page financial statement. Which ADDITIONAL action BEST meets the changed condition?
- The matrix subtotals reconcile to the overall sales total
- Use a card visual and expect it to display row/column intersections
- Use a Matrix visual with Region and Product hierarchies
- Use a paginated report for controlled page layout
Explanation
Correct Answer
D:The changed requirement is 'Finance asks for a print-perfect multi-page financial statement'. The additional response is 'Use a paginated report for controlled page layout'.
Incorrect Answers
A:This observes the original approach but is not an additional action: The matrix subtotals reconcile to the overall sales total.
B:This remains unsuitable for the original situation: Cards are single-metric displays rather than pivot-style matrices. It also does not meet the changed need.
C:This is the already implemented original solution: Use a Matrix visual with Region and Product hierarchies. Matrix supports tabular intersections, hierarchy levels, and subtotals. It does not itself solve the new requirement.
Question 473
An inventory report should highlight StockOnHand below reorder level in red. Which approach BEST meets the stated Microsoft Power BI requirement?
- Apply conditional formatting driven by a low-stock rule or measure
- Change the entire report background to red for all inventory records
- Use a sorted horizontal bar chart for category comparisons
- Implement a graded conditional-format rule with documented cutoffs
Explanation
Correct Answer
A:Conditional formatting communicates threshold exceptions directly. For the stated case, Apply conditional formatting driven by a low-stock rule or measure.
Incorrect Answers
B:A universal color cannot distinguish individual low-stock items. The proposed shortcut 'Change the entire report background to red for all inventory records' fails the documented need.
C:This addresses a separate source situation: A retailer must compare total revenue across 15 product categories and read their ranks. It does not directly satisfy this case's priority.
D:This might be appropriate after a different requirement arises: Supply chain adds multiple severity bands. It is not the best initial response to the stated case.
Question 474
An inventory report should highlight StockOnHand below reorder level in red. A colleague proposes: Change the entire report background to red for all inventory records. Which explanation BEST identifies the defect in that proposal?
- A universal color cannot distinguish individual low-stock items
- Pie slice comparisons make precise category ranking difficult
- Conditional formatting communicates threshold exceptions directly
- The suggested approach is safe merely because its product name is familiar.
Explanation
Correct Answer
A:A universal color cannot distinguish individual low-stock items. This directly explains why the proposal 'Change the entire report background to red for all inventory records' should not be used.
Incorrect Answers
B:This addresses a different case: A retailer must compare total revenue across 15 product categories and read their ranks. It is not the specific defect in 'Change the entire report background to red for all inventory records'.
C:This is reasoning supporting the preferred solution 'Apply conditional formatting driven by a low-stock rule or measure', but it does not directly name the defect in the proposed shortcut.
D:Product familiarity is not evidence of suitability. The actual defect in this proposal is: A universal color cannot distinguish individual low-stock items.
Question 475
An inventory report should highlight StockOnHand below reorder level in red. After implementing Apply conditional formatting driven by a low-stock rule or measure, which observation BEST demonstrates that the intended result is actually working?
- Only below-threshold products receive the warning format
- The report owner approves Apply conditional formatting driven by a low-stock rule or measure without testing the resulting behavior.
- The largest category appears first with comparable bars and readable labels
- The team schedules a future check of whether Only below-threshold products receive the warning format, but has not observed a result.
Explanation
Correct Answer
A:The observation 'Only below-threshold products receive the warning format' directly tests the intended result. Conditional formatting communicates threshold exceptions directly.
Incorrect Answers
B:Approval of a proposed design is not evidence of working behavior. The required observation is: Only below-threshold products receive the warning format.
C:This belongs to a different case: A retailer must compare total revenue across 15 product categories and read their ranks. It does not validate the current change.
D:A future test is not yet observed operational evidence. The verification must establish: Only below-threshold products receive the warning format.
Question 476
The original scenario was: An inventory report should highlight StockOnHand below reorder level in red. The initial solution is already in place. Now this new requirement arises: Supply chain adds multiple severity bands. Which ADDITIONAL action BEST meets the changed condition?
- Apply conditional formatting driven by a low-stock rule or measure
- Implement a graded conditional-format rule with documented cutoffs
- Change the entire report background to red for all inventory records
- Only below-threshold products receive the warning format
Explanation
Correct Answer
B:The changed requirement is 'Supply chain adds multiple severity bands'. The additional response is 'Implement a graded conditional-format rule with documented cutoffs'.
Incorrect Answers
A:This is the already implemented original solution: Apply conditional formatting driven by a low-stock rule or measure. Conditional formatting communicates threshold exceptions directly. It does not itself solve the new requirement.
C:This remains unsuitable for the original situation: A universal color cannot distinguish individual low-stock items. It also does not meet the changed need.
D:This observes the original approach but is not an additional action: Only below-threshold products receive the warning format.
Question 477
An analyst wants extra product attributes visible when hovering over a sales chart without cluttering bars. Which TWO entries together identify the most appropriate initial action and direct observed evidence of its success? (Select TWO.)
- Add configured drillthrough navigation for the product
- Hovering over a bar shows the intended custom tooltip with the correct product
- Add every product attribute as a new bar category in the main chart
- Use a Waterfall chart to display sequential increases and decreases
- Configure a report-page tooltip containing relevant product metrics
Explanation
Correct Answers
B:Correct direct operational evidence. Hovering over a bar shows the intended custom tooltip with the correct product. This is a check of the original requirement, not an unperformed plan.
E:Tooltips reveal context on demand while preserving the primary visual. For the stated case, Configure a report-page tooltip containing relevant product metrics.
Incorrect Answers
A:This might be appropriate after a different requirement arises: The executive wants to open a detailed product page after selection. It is not the best initial response to the stated case.
C:Excess categorical bars impair the report's main comparison. The proposed shortcut 'Add every product attribute as a new bar category in the main chart' fails the documented need.
D:This addresses a separate source situation: A finance report needs to show how revenue, cost, discounts, and returns contribute to operating profit. It does not directly satisfy this case's priority.
Question 478
An analyst wants extra product attributes visible when hovering over a sales chart without cluttering bars. A colleague proposes: Add every product attribute as a new bar category in the main chart. Which explanation BEST identifies the defect in that proposal?
- Excess categorical bars impair the report's main comparison
- Spatial encoding does not show the financial bridge
- The suggested approach is safe merely because its product name is familiar.
- Tooltips reveal context on demand while preserving the primary visual
Explanation
Correct Answer
A:Excess categorical bars impair the report's main comparison. This directly explains why the proposal 'Add every product attribute as a new bar category in the main chart' should not be used.
Incorrect Answers
B:This addresses a different case: A finance report needs to show how revenue, cost, discounts, and returns contribute to operating profit. It is not the specific defect in 'Add every product attribute as a new bar category in the main chart'.
C:Product familiarity is not evidence of suitability. The actual defect in this proposal is: Excess categorical bars impair the report's main comparison.
D:This is reasoning supporting the preferred solution 'Configure a report-page tooltip containing relevant product metrics', but it does not directly name the defect in the proposed shortcut.
Question 479
An analyst wants extra product attributes visible when hovering over a sales chart without cluttering bars. After implementing Configure a report-page tooltip containing relevant product metrics, which observation BEST demonstrates that the intended result is actually working?
- The team schedules a future check of whether Hovering over a bar shows the intended custom tooltip with the correct product, but has not observed a result.
- The report owner approves Configure a report-page tooltip containing relevant product metrics without testing the resulting behavior.
- The final waterfall total reconciles to the stated operating profit
- Hovering over a bar shows the intended custom tooltip with the correct product
Explanation
Correct Answer
D:The observation 'Hovering over a bar shows the intended custom tooltip with the correct product' directly tests the intended result. Tooltips reveal context on demand while preserving the primary visual.
Incorrect Answers
A:A future test is not yet observed operational evidence. The verification must establish: Hovering over a bar shows the intended custom tooltip with the correct product.
B:Approval of a proposed design is not evidence of working behavior. The required observation is: Hovering over a bar shows the intended custom tooltip with the correct product.
C:This belongs to a different case: A finance report needs to show how revenue, cost, discounts, and returns contribute to operating profit. It does not validate the current change.
Question 480
The original scenario was: An analyst wants extra product attributes visible when hovering over a sales chart without cluttering bars. The initial solution is already in place. Now this new requirement arises: The executive wants to open a detailed product page after selection. Which ADDITIONAL action BEST meets the changed condition?
- Configure a report-page tooltip containing relevant product metrics
- Hovering over a bar shows the intended custom tooltip with the correct product
- Add every product attribute as a new bar category in the main chart
- Add configured drillthrough navigation for the product
Explanation
Correct Answer
D:The changed requirement is 'The executive wants to open a detailed product page after selection'. The additional response is 'Add configured drillthrough navigation for the product'.
Incorrect Answers
A:This is the already implemented original solution: Configure a report-page tooltip containing relevant product metrics. Tooltips reveal context on demand while preserving the primary visual. It does not itself solve the new requirement.
B:This observes the original approach but is not an additional action: Hovering over a bar shows the intended custom tooltip with the correct product.
C:This remains unsuitable for the original situation: Excess categorical bars impair the report's main comparison. It also does not meet the changed need.