PL-300 practice questions 221–230

1. Question 221 · 358 in bank

   Select 2

   A user creates a Power BI report named ReportA that uses a custom theme. You create a dashboard named DashboardA. You need to ensure that DashboardA uses the custom theme. The solution must minimize development effort. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • APublish ReportA to Power BI.
   • BFrom ReportA save the current theme.
   • CPublish ReportA to the Microsoft Power BI Community theme gallery.
   • DFrom DashboardA, create a custom theme.
   • EFrom DashboardA, upload a JSON theme.

   Show answer

   Answer: BE

   Explanation

   "Here's an explanation of why these two actions are appropriate: A: When you publish a report to Power BI, any custom themes you have applied to it will also be published to your tenant. This makes them available to other reports and dashboards within your organization. E: Uploading a JSON theme from DashboardA allows you to apply the custom theme from ReportA to DashboardA without the need for additional development effort. This solution minimizes development effort and leverages work that has already been done in ReportA." ChatGPT

   Source: Adapted from community discussion — alojt

   References

   • Microsoft Learn

   Next question

2. Question 222 · 358 in bank

   You have the visual shown in the Original exhibit. (Click the Original tab.)

   

   You need to configure the visual as shown in the Modified exhibit. (Click the Modified tab.)

   

   What should you add to the visual?

   • Aa measure
   • Ban Average line
   • Ca trendline
   • Da forecast

   Show answer

   Answer: D

   Explanation

   That's actually tricky. It clearly looks like a forecast. However a forecast wouldn't forecast a flat line but ups and downs. Flat line is what the trend or the average would look like here.

   Source: Adapted from community discussion — Danylessoucis

   Next question

3. Question 223 · 358 in bank

   You need to create a visual that enables the adhoc exploration of data as shown in the following exhibit.

   

   Which type of visual should you use?

   • Asmart narrative
   • Bdecomposition tree
   • CQ&A
   • Dkey influencers

   Show answer

   Answer: B

   Explanation

   You should use a decomposition tree visual to enable the ad hoc exploration of data as shown in the exhibit. A decomposition tree is a type of visual that is used to represent hierarchical data in a tree-like structure. It is commonly used to explore data and identify trends and patterns in the data. The visual consists of nodes that represent different data points, with the root node at the top and the child nodes branching out from it. The size and color of the nodes can be used to represent different data values or categories. The exhibit in the question shows a visual with multiple nodes that can be expanded or collapsed to reveal more detailed data. This is consistent with the behavior of a decomposition tree visual, which allows users to drill down into the data to explore it in more detail.

   Source: Adapted from community discussion — Proctored_Expert

   Next question

4. Question 224 · 358 in bank

   Your company has employees in 10 states. The company recently decided to associate each state to one of the following three regions: East, West, and North. You have a data model that contains employee information by state. The model does NOT include region information. You have a report that shows the employees by state. You need to view the employees by region as quickly as possible. What should you do?

   • ACreate a new aggregation that summarizes by state.
   • BCreate a new aggregation that summarizes by employee.
   • CCreate a new group on the state column and set the Group type to List.
   • DCreate a new group on the state column and set the Group type to Bin.

   Show answer

   Answer: C

   Explanation

   I passed the exam today (948/1000). My answer was: - Create a new group on the state column and set the Group type to List.

   Source: Adapted from community discussion — SamuComqi

   Next question

5. Question 225 · 358 in bank

   You have a collection of reports for the HR department of your company. You need to create a visualization for the HR department that shows historical employee counts and predicts trends during the next six months. Which type of visualization should you use?

   • Aribbon chart
   • Bscatter chart
   • Cline chart
   • Dkey influencers

   Show answer

   Answer: C

   Explanation

   Be aware to use the forecast feature in a line graph: - there should be enough data points to be enabled (forecasting) - date field must be clearly identified as date/time field

   Source: Adapted from community discussion — jaume

   Next question

6. Question 226 · 358 in bank

   You have a Microsoft Power BI dashboard. The report used to create the dashboard uses an imported dataset from a Microsoft SQL Server data source. The dashboard is shown in the exhibit. (Click the Exhibit tab.)

   

   What occurred at 12:03:06 PM?

   • AA new transaction was added to the data source.
   • BThe dashboard tile cache refreshed.
   • CA user added a comment to a tile.
   • DA user pressed F5.

   Show answer

   Answer: B

   Explanation

   B is the answer, we dont know if all the tiles refreshed or only 1 tile refreshed. Since the refresh date is shown only on one tile, the user DID NOT press F5

   Source: Adapted from community discussion — srikanth923

   Next question

7. Question 227 · 358 in bank

   HOTSPOT - You need to create a Power BI report. The first page of the report must contain the following two views: ✑ Sales By Postal Code ✑ Sales by Month Both views must display a slicer to select a value for a field named Chain. The Sales By Postal Code view must display a map visual as shown in the following exhibit.

   

   The Sales By Month view must display a column chart visual as shown in the following exhibit.

   

   Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. What is the minimum number of bookmarks required, and which property should you apply to each bookmark? 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: 2 - One for each visual. Note: When you edit a report in Power BI Desktop and the Power BI service, you can add report bookmarks to capture the current state of a report page. Bookmarks save the current filters and slicers, cross-highlighted visuals, sort order, and so on. When others view your report, they can get back to that exact state by selecting your saved bookmark. Box 2: Display - Users must be able to switch between the views by using buttons on the report page. The selected Chain field must be maintained when switching between views. You can select whether each bookmark will apply Data properties, such as filters and slicers; Display properties, such as spotlight and its visibility; and Current page changes, which present the page that was visible when the bookmark was added. These capabilities are useful when you use bookmarks to switch between report views or selections of visuals, in which case you'd likely want to turn off data properties, so that filters aren't reset when users switch views by selecting a bookmark. Note: When you create a bookmark, the following elements are saved with the bookmark: The current page - Filters - Slicers, including slicer type (for example, dropdown or list) and slicer state Visual selection state (such as cross-highlight filters) Sort order - Drill location - Visibility of an object (by using the Selection pane) The focus or Spotlight mode of any visible object Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-bookmarks

   Source: Adapted from community discussion — Dani_eL

   References

   • Microsoft Learn

   

   Next question

8. Question 228 · 358 in bank

   You have the visual shown in the exhibit. (Click the Exhibit tab.)

   

   You need to show the relationship between Total Cost and Total Sales over time. What should you do?

   • AAdd a play axis.
   • BFrom the Analytics pane, add an Average line.
   • CAdd a slicer for the year.
   • DCreate a DAX measure that calculates year-over-year growth.

   Show answer

   Answer: A

   Explanation

   It would be A. A Play Axis works like a Dynamic slicer. Also see shakes103's comment: "Both scatter and bubble charts can also have a play axis, which can show changes over time". https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a#scatter-bubble-and-dot-plot-chart

   Source: Adapted from community discussion — Palwashai

   References

   • Microsoft Learn

   Next question

9. Question 229 · 358 in bank

   HOTSPOT - You have the Power BI dashboard shown in the Dashboard exhibit. (Click the Dashboard tab.)

   

   You need to ensure that when users view the dashboard on a mobile device, the dashboard appears as shown in the Mobile exhibit. (Click the Mobile tab.)

   

   What should you do? 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: Report mobile layout - Power BI provides a number of features to help you create mobile-optimized versions of your reports: * A mobile layout view where you create your mobile-optimized report by dragging and dropping visuals onto a phone emulator canvas. * Etc. Box 2: The Total Sales by Parent Category tile Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/power-bi-create-mobile-optimized-report-about

   Source: Adapted from community discussion — Manikom

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 230 · 358 in bank

    You are building a Power BI report to analyze customer segments. You need to identify customer segments dynamically based on the Bounce Rate across dimensions such as source, geography, and demographics. The solution must minimize analysis effort. Which type of visualization should you use?

    • Adecomposition tree
    • Bfunnel chart
    • CQ&A
    • Dkey influencers

    Show answer

    Answer: A

    Explanation

    Answer is A The decomposition tree visual in Power BI lets you visualize data across multiple dimensions. It automatically aggregates data and enables drilling down into your dimensions in any order. The key influencers visual helps you understand the factors that drive a metric you're interested in. It analyzes your data, ranks the factors that matter, and displays them as key influencers. *Key influencers does not visualize data across dimensions*

    Source: Adapted from community discussion — shakes103

    References

    • Microsoft Learn

    Next question

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

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