PL-300 practice questions 281–290

1. Question 281 · 358 in bank

   HOTSPOT - You have a Power BI workspace. You need to create two reports that meet the following requirements: • Report1: Optimized for printing and can be delivered to users via a scheduled email subscription • Report2: Optimized for dynamic user interactivity Which format should you use for each report? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   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

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 282 · 358 in bank

   You have a Power BI report that contains the table shown in the following exhibit.

   

   The table contains conditional formatting that shows which stores are above, near, or below the monthly quota for returns. You need to ensure that the table is accessible to consumers of reports who have color vision deficiency. What should you do?

   • AMove the conditional formatting icons to a tooltip report.
   • BAdd alt text that lists the values in the table.
   • CChange the icons to use a different shape for each color.
   • DRemove the icons and use red, yellow, and green background colors instead.

   Show answer

   Answer: C

   Explanation

   Given answer of B only makes sense for BLIND people...not color blind! Icons will help color blind people so should be C

   Source: Adapted from community discussion — 539d541

   Next question

3. Question 283 · 358 in bank

   You have a Power BI report that contains one visual. You need to provide users with the ability to change the visual type without affecting the view for other users. What should you do?

   • AFrom the Bookmarks pane, select Focus mode, and then select Add.
   • BFrom Report settings, select Personalize visuals.
   • CFrom Visual options in Report settings, select Use the modern visual header with updated styling options.
   • DFrom Tabular Editor, create a new perspective.

   Show answer

   Answer: B

   Next question

4. Question 284 · 358 in bank

   HOTSPOT - You have a Power BI report that contains the table visual shown in the following exhibit.

   

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

   

   How should you configure the visual? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   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

   When testing it out, need to make sure to switch the OrderDate from Rows well to Columns. Otherwise, it will not display in this format.

   Source: Adapted from community discussion — ak57

   

   Next question

5. Question 285 · 358 in bank

   You have a Power BI report that contains a card. The card displays the value for year-to-date revenue. You need to ensure that screen reader users can read the value when initially interacting with the card. The value must stay updated as the dataset is refreshed. What should you do?

   • AConvert the card into a text box.
   • BAdd the value to the chart title text.
   • CPopulate the alt text with a static value.
   • DPopulate the alt text by using conditional formatting with a DAX measure.

   Show answer

   Answer: D

   Explanation

   Enabling screen reader to read anything, you must use the alt text. Since "value must stay updated as the dataset is refreshed", we cannot use a static value but a dynamic one so option D instead C

   Source: Adapted from community discussion — jaume

   Next question

6. Question 286 · 358 in bank

   You have a Power BI report that contains a table visual. The visual contains a column. The column contains whole numbers ranging from of 1 to 20. You need to use conditional formatting to meet the following requirements: • Visually compare the values without having to read the text containing the number. • Show a different format for each distinct value. • Hide the numeric value of ColumnA. • Minimize development effort. Which formatting should you use?

   • Afont color
   • Bicons
   • Cdata bars
   • Dbackground color

   Show answer

   Answer: C

   Explanation

   Agree with explanations from 539d541. Font color or background color options would result in a mess, difficult to identify all colors and since the goal is to compare values, how can you get which value is bigger from the color (only using kind of gradient, for 20 colors, not too much contrast) Icons allows to hide the numeric value but, again, 20 different icons and/or their colors would result in a very difficult exercise to compare 20 values (worst case, all differents). With data bars, even using one single color, would make easier to compare two different values in the table by comparing widths

   Source: Adapted from community discussion — jaume

   Next question

7. Question 287 · 358 in bank

   Select 2

   You have a report that contains four pages. Each page contains slicers for the same four fields. Users report that when they select values in a slicer on one page, the selections are not persisted on other pages. You need to recommend a solution to ensure that users can select a value once to filter the results on all the pages. What are two possible recommendations to achieve this goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • ACreate a bookmark for each slicer value.
   • BReplace the slicers with report-level filters.
   • CSync the slicers across the pages.
   • DReplace the slicers with page-level filters.
   • EReplace the slicers with visual-level filters.

   Show answer

   Answer: BC

   Explanation

   Sync the slicers across the pages: This can be achieved by selecting the slicers on each page, and then clicking on the "Format" tab on the right-hand side of the Power BI desktop. In the "Visualizations" pane, under "Slicer", toggle the "Sync slicers" option to "On". This will ensure that any selections made on one page will be reflected on all other pages that have the same slicers.

   Source: Adapted from community discussion — 1sourabhpatel1

   Next question

8. Question 288 · 358 in bank

   HOTSPOT - You use Power Query Editor to preview the data in a column named Resource Location. The column statistics and value distributions of Resource Location appear 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.

   

   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

   First solution must be '0' as there are no UNIQUE values. 13 is the number of DISTINCT values in the dataset. US East is the one occuring many more times than the reast (on top in the bar chart)

   Source: Adapted from community discussion — jaume

   

   Next question

9. Question 289 · 358 in bank

   You have a Power BI report that contains the visual shown in the following exhibit.

   

   You need to make the visual more accessible to users who have color vision deficiency. What should you do?

   • AChange the font color of values in the Sales column to white.
   • BChange the red background color to orange.
   • CAdd additional measures to the table values.
   • DAdd icons to represent the sales status of each product.

   Show answer

   Answer: D

   Explanation

   "color vision deficiency" so options A and B wouldn't work as it would still be about colouring different values. Icons would support people with color deficiency to get the comparison in the visual

   Source: Adapted from community discussion — jaume

   Next question

10. Question 290 · 358 in bank

    You have a Power BI app that contains a report named Report1. You add a new page to Report1. You need to ensure that users can view the new page. The solution must minimize administrative effort. What should you do?

    • AUpdate the audience in the app.
    • BUpdate the app.
    • CUpdate the contact information in the app.
    • DUnpublish and create a new app.

    Show answer

    Answer: B

    Next question

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

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