PL-300 practice questions 231–240

1. Question 231 · 358 in bank

   You have a table that contains sales data and approximately 1,000 rows. You need to identify outliers in the table. Which type of visualization should you use?

   • Aarea chart
   • Bscatter plot
   • Cpie chart
   • Ddonut chart

   Show answer

   Answer: B

   Next question

2. Question 232 · 358 in bank

   You need to create a visualization that compares revenue and cost over time. Which type of visualization should you use?

   • Awaterfall chart
   • Bstacked area chart
   • Cline chart
   • Ddonut chart

   Show answer

   Answer: C

   Explanation

   Once they are stacked, it will be hard to compare via visuals. With line chart, you can see the lines crossing each other and moving up and down giving you a relative view.

   Source: Adapted from community discussion — MasterZucchini

   Next question

3. Question 233 · 358 in bank

   Select 2

   You have a report that contains three pages. One of the pages contains a KPI visualization. You need to filter all the visualizations in the report except for the KPI visualization. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AEdit the interactions of the KPI visualization.
   • BAdd the same slicer to each page and configure Sync slicers.
   • CEdit the interactions of the slicer that is on the same page as the KPI visualization.
   • DConfigure a page-level filter.
   • EConfigure a report-level filter.

   Show answer

   Answer: BC

   Explanation

   B and C are the right ones. First we add slicers to sync all of them between pages and later we change the interactions between the KPI visual and the slicer of the same page report.

   Source: Adapted from community discussion — Fer079

   Next question

4. Question 234 · 358 in bank

   HOTSPOT - You have a Power BI visual that uses indicators to show values that are out of range as shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: a line - Incorrect: * not line and clustered column The Line and Clustered Column Chart is a combo charts that combines the Line chart and Column chart together in one visual. By combining these two visuals together, you can make a very quick comparison between two sets of measures. Box 2: anomaly detection - Anomaly detection helps you enhance your line charts by automatically detecting anomalies in your time series data. It also provides explanations for the anomalies to help with root cause analysis. With just a couple of clicks, you can easily find insights without slicing and dicing the data. Example: Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

   

   Next question

5. Question 235 · 358 in bank

   You are creating a Power BI report to analyze consumer purchasing patterns from a table named Transactions. The Transactions table contains a numeric field named Spend. You need to include a visual that identifies which fields have the greatest impact on Spend. Which type of visual should you use?

   • AQ&A
   • Bsmart narrative
   • Cdecomposition tree
   • Dkey influencers

   Show answer

   Answer: D

   References

   • Microsoft Learn

   Next question

6. Question 236 · 358 in bank

   HOTSPOT - You are creating a line chart in a Power BI report as shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: an average reference line With the Analytics pane in Power BI Desktop, you can add dynamic reference lines to visuals, and provide focus for important trends or insights. Box 2: Values - Add a measure to drillthrough - You can add a measure or a summarized numeric column to the drillthrough area. Drag the drillthrough field to the Drillthrough card on the drillthrough target page to apply it. When you add a measure or summarized numeric column, you can drill through to the page when the field is used in the Value area of a visual. Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane

   Source: Adapted from community discussion — AzureJobsTillRetire

   References

   • Microsoft Learn

   

   Next question

7. Question 237 · 358 in bank

   You have a dashboard that contains tiles pinned from a single report as shown in the Original Dashboard exhibit. (Click the Original Dashboard tab.)

   

   You need to modify the dashboard to appear as shown in the Modified Dashboard exhibit. (Click the Modified Dashboard tab.)

   

   What should you do?

   • AChange the report theme.
   • BChange the dashboard theme.
   • CEdit the details of each tile.
   • DCreate a custom CSS file.

   Show answer

   Answer: B

   Explanation

   We are updating the Dashboard not the report, therefore is option B not option A. Even editing details of each tile, this would still not change the background of the dashboard but just background of tiles (and font color).

   Source: Adapted from community discussion — jaume

   Next question

8. Question 238 · 358 in bank

   You have a Power BI report. The report contains a visual that shows gross sales by date. The visual has anomaly detection enabled. No anomalies are detected. You need to increase the likelihood that anomaly detection will identify anomalies in the report. What should you do?

   • AIncrease the Expected range transparency setting.
   • BAdd a data field to the Legend field well.
   • CIncrease the Sensitivity setting.
   • DAdd a data field to the Secondary values field well.

   Show answer

   Answer: C

   Explanation

   C. Increase the sensitivity If you increase the sensitivity, the algorithm is more sensitive to changes in your data. In that case, even a slight deviation is marked as an anomaly. If you decrease the sensitivity, the algorithm is more selective on what it considers an anomaly. reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-anomaly-detection

   Source: Adapted from community discussion — simplex06

   References

   • Microsoft Learn

   Next question

9. Question 239 · 358 in bank

   You maintain a Power BI workspace that contains a supplier quality dashboard. The dashboard contains 10 card visuals, two map visuals and five bar chart visuals. The dashboard mobile layout is shown in the exhibit. (Click the Exhibit tab.)

   

   You need to modify the dashboard mobile layout to meet the following requirements: ✑ Only show single-value visuals. ✑ Minimize scrolling. What should you do?

   • ADecrease the size of the card visuals. Remove the map and bar chart visuals.
   • BDecrease the size of the map and bar chart visuals. Move all the card visuals to the top of the layout.
   • CRemove the card visuals. Increase the size of the map and bar chart visuals.
   • DMove the bar chart visuals to the top of the layout. Remove the map visuals. Decrease the size of the card visuals.

   Show answer

   Answer: A

   Explanation

   Decreasing the size of card visuals will minimize the scrolling. Removing maps and chart visuals is a requirement as they are non single-vlaue visuals

   Source: Adapted from community discussion — jaume

   Next question

10. Question 240 · 358 in bank

    You have a Power BI report. You have a table named Data1 that contains 10 million rows. Data1 is used in the following visuals: ✑ A card that shows the number of records ✑ A bar chart that shows total transaction amount by territory ✑ A scatter plot that shows transaction amount and profit amount on the axes and points colored by territory You need to modify the scatter plot to make it easier for users to identify meaningful patterns. The solution must not affect the accuracy of the other visuals. What should you do?

    • AAdd a count field of the transaction amount to the size bucket of the scatter plot.
    • BAdd a trend line to the scatter plot.
    • CEnable high-density sampling on the scatter plot.
    • DApply a row filter to the Data1 query in Power Query Editor.

    Show answer

    Answer: C

    Explanation

    This question requires "modification" of the scatter plot and what high-density sampling essentially does is to employ methods that capture and represent the underlying data more effectively and eliminates overlapping points. Remember that the table named Data1 contains 10 million rows. How do you represent all that data in a scatter plot in a meaningful pattern for easy understanding and analysis? by use of high density sampling. "By definition, high-density data is sampled to create visualizations reasonably quickly that are responsive to interactivity. Too many data points on a visual can bog it down, and can detract from the visibility of trends". This link explains it more: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-high-density-scatter-charts#how-high-density-scatter-charts-work

    Source: Adapted from community discussion — shakes103

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

PL-300 practice, question 231. 358 questions available.