PL-300 practice questions 241–250

1. Question 241 · 358 in bank

   Select 2

   You have a Power BI workspace named Inventory that contains a dataset, a report, and a dashboard. You need to add an additional tile to the dashboard. The tile must show inventory by location. This information is NOT visualized in the report. The solution must minimize the impact on the report. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AAsk a question by using Q&A.
   • BHide the report page.
   • CPin the visual to the dashboard.
   • DUse quick insights on the dashboard.
   • EAdd the visual to the report.

   Show answer

   Answer: AC

   Explanation

   A and C To be clear on this point, it is fact that you can generate new visuals by using both Q&A and Quick insights. However, the difference is: - Q&A - you ask questions (natural language) about a specific visual that doesn't exist in your report. - Quick insights - you need to provide the users of Dashboards with additional tiles that are related to the content of an existing visual on a dashboard. For this case, you want to generate a tile that doesn't exist on your report. Therefore, you use Q&A that will generate the tile that should be pinned to the dashboard.

   Source: Adapted from community discussion — 0e18c76

   References

   • Microsoft Learn

   Next question

2. Question 242 · 358 in bank

   HOTSPOT - You have a dataset named Pens that contains the following columns: ✑ Item ✑ Unit Price ✑ Quantity Ordered You need to create a visualization that shows the relationship between Unit Price and Quantity Ordered. The solution must highlight orders that have a similar unit price and ordered quantity. Which type of visualization and which feature should you use? 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: A scatter plot of Quantity Ordered and Unit Price by item A scatter chart shows the relationship between two numerical values. Note: Scatter charts are a great choice: To show relationships between two numerical values. To plot two groups of numbers as one series of x and y coordinates. To use instead of a line chart when you want to change the scale of the horizontal axis. To turn the horizontal axis into a logarithmic scale. To display worksheet data that includes pairs or grouped sets of values. To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers. To compare large numbers of data points without regard to time. The more data that you include in a Scatter chart, the better the comparisons that you can make. Box 2: Automatically find clusters Scatter charts are a great choice: * To show patterns in large sets of data, for example by showing linear or non-linear trends, clusters, and outliers. Reference: https://github.com/Microsoft/powerbi-visuals-corrplot/

   References

   • Microsoft Learn

   

   Next question

3. Question 243 · 358 in bank

   HOTSPOT - You have a report in Power BI Desktop. You add a key influencers visual as shown in the exhibit. (Click the Exhibit tab.)

   

   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: moving fields from Explain by to Expand by You can use Expand By to add fields you want to use for setting the level of the analysis without looking for new influencers. Why do certain factors become influencers or stop being influencers as I move more fields into the Explain by field? The visualization evaluates all explanatory factors together. A factor might be an influencer by itself, but when it's considered with other factors it might not. Box 2: 3 - 0.30 instead of 0.10. A factor of 3 greater. Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

   Source: Adapted from community discussion — Manikom

   References

   • Microsoft Learn

   

   Next question

4. Question 244 · 358 in bank

   You have a Power BI report that contains three pages named Page1, Page2, and Page3. All the pages have the same slicers. You need to ensure that all the filters applied to Page1 apply to Page1 and Page3 only. What should you do?

   • AOn each page, modify the interactions of the slicer.
   • BEnable visibility of the slicers on Page1 and Page3. Disable visibility of the slicer on Page2.
   • CSync the slicers on Page1 and Page3.

   Show answer

   Answer: C

   Explanation

   ChatGPT4 trained with the PL-300 reading materials: The document does not provide a direct answer to this question. However, based on general knowledge of Power BI and slicer functionality, you should: Sync the slicers on Page1 and Page3 (Option C). Slicer syncing allows slicers to be used across multiple pages. This means that if a user applies a filter on Page1, the same filter will be applied on Page3 because the slicers are synced. This would not affect Page2 as the slicers are not synced with it.

   Source: Adapted from community discussion — globalexamtopics

   Next question

5. Question 245 · 358 in bank

   You have a Power BI report that contains five pages. Pages 1 to 4 are visible and page 5 is hidden. You need to create a solution that will enable users to quickly navigate from the first page to all the other visible pages. The solution must minimize development and maintenance effort as pages are added to the report. What should you do first?

   • AAdd a blank button to page 1.
   • BAdd a page navigation button to page 1.
   • CCreate a bookmark for each page.
   • DAdd a bookmark navigation button to page 1.

   Show answer

   Answer: B

   Explanation

   Wrong B is correct. Add a page navigation button to page 1 because the solution must minimize development and maintenance effort as pages are added to the report. If we add more pages the report they will be automatically added to the page navigator. Only thing is you have to change 'show hidden pages' option to off. But with the bookmark navigator, lot of efforts required to create individual bookmark to each page and also the newly added pages manually. another problem is it also adds all other bookmarks to the navigator which we dont need. so we should create a page navigator button in page 1(and set 'show hidden pages' to off)

   Source: Adapted from community discussion — Sushvij

   Next question

6. Question 246 · 358 in bank

   You build a Power BI report that displays IoT temperature data streaming from a refrigerator. You publish the report to the Power BI service. You need to be notified when the temperature rises above four degrees Celsius. What should you do?

   • ASet an alert on a KPI visual in the report.
   • BPin a card visual to a dashboard and create a subscription.
   • CPin a card visual to a dashboard and set an alert on the tile.
   • DPin a report page to a dashboard and set an alert on the page.

   Show answer

   Answer: C

   Explanation

   C. Pin a card visual to a dashboard and set an alert on the tile. To be notified when the temperature rises above four degrees Celsius, you can pin a card visual showing the temperature to a dashboard and set an alert on the tile. To do this, first create the card visual on the report page showing the temperature data, then click on the "Pin visual" button in the top right corner of the visual and select the dashboard where you want to pin it. Once the card is pinned, click on the ellipsis menu in the top right corner of the tile and select "Set alert". From there, you can configure the alert settings to notify you when the temperature rises above four degrees Celsius. This solution allows you to receive notifications without having to constantly monitor the report or dashboard, and provides a targeted alert specific to the temperature data you're interested in. No confusion, no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   Next question

7. Question 247 · 358 in bank

   You have the dashboard shown in the following exhibit.

   

   You need to modify the dashboard to display as shown in the following exhibit.

   

   What should you do?

   • ACreate and apply a custom dashboard theme.
   • BChange the colors of the visuals in the report.
   • CApply the Dark dashboard theme.
   • DUpload a snapshot image of the dashboard.

   Show answer

   Answer: A

   Explanation

   The visual colors can't be changed on the dashboard from a report after the visual has already been pinned. Applying a dashboard custom theme will do it.

   Source: Adapted from community discussion — JPGo

   Next question

8. Question 248 · 358 in bank

   You need to create a Power BI theme that will be used in multiple reports. The theme will include corporate branding for font size, color, and bar chart formatting. What should you do?

   • AFrom Power BI Desktop, customize the current theme.
   • BFrom Power BI Desktop, use a built-in report theme.
   • CCreate a theme as a PBIVIZ file and import the theme into Power BI Desktop.
   • DCreate a theme as a JSON file and import the theme into Power BI Desktop.

   Show answer

   Answer: D

   Explanation

   D. Create a theme as a JSON file and import the theme into Power BI Desktop. To create a Power BI theme that can be used across multiple reports and workspaces, the best approach would be to create a theme as a JSON file and then import it into Power BI Desktop. This will allow you to define the corporate branding for font size, color, and bar chart formatting in a single file, which can then be easily imported into all the reports that require it. To create a theme as a JSON file, you can use the built-in Theme Generator tool in Power BI or create the file manually. Once you have the JSON file, you can import it into Power BI Desktop by going to the "Switch Theme" menu and selecting "Import Theme." From there, you can select the JSON file and apply the theme to the current report. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   Next question

9. Question 249 · 358 in bank

   You have a Power BI report that contains one page. The page contains two line charts and one bar chart. You need to ensure that users can perform the following tasks for all three visuals: • Switch the measures used in the visuals. • Change the visualization type. • Add a legend. The solution must minimize development effort. What should you do?

   • ACreate a bookmark for each acceptable combination of visualization type, measure, and legend in the bar chart.
   • BEdit the interactions between the three visuals.
   • CEnable personalization for the report.
   • DEnable personalization for each visual.

   Show answer

   Answer: C

   Explanation

   Correct. Personalization can be enabled for each visual or the entire report. Here we have a single page report with 3 visuals and all three visuals need personalization, the answer is 'enable personalization for the entire report' to minimize development efforts

   Source: Adapted from community discussion — Sushvij

   Next question

10. Question 250 · 358 in bank

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have a clustered bar chart that contains a measure named Salary as the value and a field named Employee as the axis. Salary is present in the data as a numerical amount representing US dollars. You need to create a reference line to show which employees are above the median salary. Solution: You create a median line by using the Salary measure. Does this meet the goal?

    • AYes
    • BNo

    Show answer

    Answer: A

    Explanation

    This question is in continuation of the series question # 22 of Topic 3. Answer is Yes We can definitely create a median line for the measure of salary (Tested) Also the other solution in this series is create a percentile line at 50% for the salary measure because percentile value at 50 % is exactly equal to the median value.

    Source: Adapted from community discussion — Sushvij

    Next question

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

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