PL-300 practice questions 201–210

1. Question 201 · 358 in bank

   DRAG DROP - You have a Power BI dashboard named DashboardA that contains a tile named TileA. TileA contains a treemap visual from a report named ReportA. You need to provide the users of DashboardA with additional tiles that relate to the contents of TileA. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

   

   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

   Step 1: From ReportA, select Get Insights Then select 'Get Insights'ג€¦ From the Datasets + dataflows tab, select More options (...) next to the dataset, and then choose Get insights. Power BI Quick Insights will now scan the data related to the tile and display a list of potential insights you may want to explore further. To drill into a specific data point, you can even select data in the visual and Quick Insights will focus on that data point when searching for insights. Power BI uses various algorithms to search for trends in your dataset. Within seconds, your insights are ready. Select View insights to display visualizations. The visualizations display in a special Quick Insights canvas with up to 32 separate insight cards. Each card has a chart or graph plus a short description. Step 2: From DashboardA, select the TileA options, and then select View Insights The insight screen opens in Focus mode. Step 3: From Focus mode, pin the relevant visuals to DashboardA Go to 'in focus mode' on a dashboard tile for data loaded into Power BI. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-insights

   Source: Adapted from community discussion — PinkZebra

   References

   • Microsoft Learn

   

   Next question

2. Question 202 · 358 in bank

   You are creating a dashboard by using the Power BI service. You have an existing report page that contains three charts. You need to add the charts to the dashboard while maintaining the interactivity between the charts. What should you do?

   • AEdit interactions in the report and set all interactions to Filter.
   • BPin each chart as a tile.
   • CEdit the dashboard theme and pin each chart as a tile.
   • DPin the report page as a live tile.

   Show answer

   Answer: D

   Explanation

   I tested options B and D with a real PBI report. I pinned three charts one by one (as single items) into the Dashboard, and I cannot interact with the charts and when I clicked any of them, I moved to the source report. Pinning the entire page containing the three visuals into the Dashboard, provided me the entire functionality I had in my report (I was able to click in any visual to get the other two visuals filtered by the selected value)

   Source: Adapted from community discussion — jaume

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 203 · 358 in bank

   HOTSPOT - You need to create a visual as shown in the following exhibit.

   

   The indicator color for Total Sales will be based on % Growth to Last Year. The solution must use the existing calculations only. How should you configure the visual? To answer, select the appropriate options in the answer area. 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: Background color - To apply conditional formatting, select a Table or Matrix visualization in Power BI Desktop. In the Visualizations pane, right-click or select the down-arrow next to the field in the Values well that you want to format. Select Conditional formatting, and then select the type of formatting to apply. Box 2: Rules - To format cell background or font color by rules, in the Format by field of the Background color or Font color dialog box, select Rules. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting

   Source: Adapted from community discussion — Fer079

   References

   • Microsoft Learn

   

   Next question

4. Question 204 · 358 in bank

   DRAG DROP - You are using existing reports to build a dashboard that will be viewed frequently in portrait mode on mobile phones. You need to build the dashboard. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select and Place:

   

   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

   Step 1: Edit the dashboard mobile view Open a report in Editing view. Step 2: Pin items from the reports to the dashboard Step 3: Open the dashboard. Open the dashboard to see the pinned live tile, From the nav pane, select the dashboard with the new live tile. There, you can do things like rename, resize, link, and move the pinned report page. Step 4: Rearrange, resize, or remove items from the mobile layout Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report

   Source: Adapted from community discussion — RickyAnd

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 205 · 358 in bank

   You plan to create the chart shown in the following exhibit.

   

   How should you create the dashed horizontal line denoting the 40th percentile of daily sales for the period shown?

   • AAdd a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.INC (Sales,sales[Total Sales],0.40)
   • BAdd a measure to the visual that uses the following DAX expression. Measure1 = PERCENTILEX.EXC (Sales,sales[Total Sales],0.40)
   • CAdd a new percentile line that uses Total Sales as the measure and 40% as the percentile.
   • DCreate a horizontal line that has a fixed value of 24,000.

   Show answer

   Answer: C

   Explanation

   Actually I do not know the difference between "Percentile line" and "Percentile.INC()" , but I know "percentileX.inc()" has row filter and it will not be horizontal.

   Source: Adapted from community discussion — Shalaleh

   Next question

6. Question 206 · 358 in bank

   Select 2

   You are building a Power BI report. Users will view the report by using their mobile device. You need to configure the report to display data based on each user's location. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AFrom Power Query Editor, detect the data types of the relevant columns.
   • BIn Data Category, set the geographic data category for the relevant columns.
   • CCreate a hierarchy for columns of the geography data type.
   • DUse the columns of the geography data type in all visuals.
   • EFor the relevant columns, set synonyms to match common geographical terms.

   Show answer

   Answer: BD

   Explanation

   I passed the exam today (948/1000). My answer was: - In Data Category, set the geographic data category for the relevant columns. - Use the columns of the geography data type in all visuals

   Source: Adapted from community discussion — SamuComqi

   References

   • Microsoft Learn

   Next question

7. Question 207 · 358 in bank

   You have a report that contains a donut chart and a clustered column chart. Interactions between the visuals use the default settings. You need to modify the report so that when you select a column in the column chart, the donut chart redraws by using the data from the selected column. What should you do?

   • ASelect the donut chart and set the column chart interaction to Filter.
   • BSelect the column chart and set the donut chart interaction to Filter.
   • CSelect the donut chart and set the column chart interaction to None.
   • DSelect the column chart and set the donut chart interaction to None.

   Show answer

   Answer: B

   Explanation

   you are setting the interactions FROM the selected visual (the column chart) for the rest of the visuals (second, "TO", select the donut visual and set the appropriat einteraction). Filter will redraw the visual with only the selected data from the other visual. Highlight will not redraw entirely the donut but just would "grey" the unselected data

   Source: Adapted from community discussion — jaume

   Next question

8. Question 208 · 358 in bank

   HOTSPOT - You have a report page that contains the visuals 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: cross-filter - The Cluster column chart has the filter icon active. Box 2: cross-highlight - The map has the cross-highlight icon active. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

   Source: Adapted from community discussion — 0ca027f

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

9. Question 209 · 358 in bank

   You are creating a Power BI report by using Power BI Desktop. You need to include a visual that shows trends and other useful information automatically. The visual must update based on selections in other visuals. Which type of visual should you use?

   • AQ&A
   • Bsmart narrative
   • Ckey influencers
   • Ddecomposition tree

   Show answer

   Answer: B

   Explanation

   If you watch the video in this link (https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-smart-narrative), you'll see that smart narrative is being described in the question.

   Source: Adapted from community discussion — MoxieTT

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

10. Question 210 · 358 in bank

    You have a report that contains a bar chart and a column chart. The bar chart shows customer count by customer segment. The column chart shows sales by month. You need to ensure that when a segment is selected in the bar chart, you see which portion of the total sales for the month belongs to the customer segment. How should the visual interactions be set on the column chart when the bar chart is selected?

    • Ahighlight
    • Bfilter
    • Cno impact

    Show answer

    Answer: A

    Explanation

    might be wise to explain the how to; in your report, you will have two visuals, master and slave. Select FORMAT then slect you Master visual (the one who will send the reaction to the second one) In Format, first button on the left --> Edit Interactions In your slave visual you will see 3 grey icons appearing on the right: filter, highlight, no impact choose appropriate Note that by DEFAULT, interaction is highlight so basically you should do nothing

    Source: Adapted from community discussion — Dani_eL

    References

    • Microsoft Learn
    • Microsoft Learn

    Next question

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

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