PL-300 practice questions 271–280

1. Question 271 · 358 in bank

   You have a Power BI dataset that contains quarterly sales performance data. You need to enable managers to review the data in a format that meets the following requirements: • Is optimized for printing. • Renders data in Microsoft Excel, Word, PowerPoint, and PDF formats. What should you create?

   • Aa template app
   • Ba dashboard
   • Ca paginated report
   • Dan interactive report

   Show answer

   Answer: C

   Explanation

   Whenever I find a question mentioning "optimized for printing", I'm almost sure "Paginated report" would be in the list of proposed solutions. No doubt for me it's option C

   Source: Adapted from community discussion — jaume

   Next question

2. Question 272 · 358 in bank

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

   

   You need to modify the location of each visual. What should you modify for each visual?

   • Athe layer order
   • Bthe padding
   • Cthe position
   • Dthe tab order

   Show answer

   Answer: C

   Explanation

   C. should be the correct answer because the position of a visual in Power BI determines where it appears on the report page.

   Source: Adapted from community discussion — MITZ619

   Next question

3. Question 273 · 358 in bank

   Select 2

   You have a Power BI report. The report contains a line chart that displays sales data for several regions. You need to add an element to the report that will enable users to filter the sales data to include only a selected region. Which two elements achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • Aa slicer visual
   • Ba drillthrough filter
   • Ca table visual
   • Da card visual
   • Ea Key Performance Indicator (KPI) visual

   Show answer

   Answer: AC

   Explanation

   drillthrough filter is a possible solution but you have to add several elements for this solution (new page, new sales visual on this page). So i go with AC

   Source: Adapted from community discussion — RonStrassburg

   Next question

4. Question 274 · 358 in bank

   DRAG DROP - You plan to use Power BI to create a quarterly profit report that meets the following requirements: • Emphasizes the percentage of total profits contributed by each product category in dollars and as a percentage • Compares profit margins across sales regions Which type of visual should you use for each requirement? To answer, drag the appropriate visuals to the correct requirements. Each visual may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. 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

   

   Next question

5. Question 275 · 358 in bank

   You have the CSV file shown in the following table.

   

   You use Power Query Editor to preview the data in the file. You need to transform the data to meet the following requirements: • The first column must contain the month. • The second column must contain the year. • The third column must contain the order amount for the month and year. Which transformation should you use first?

   • Aremove
   • Bunpivot
   • Ctranspose
   • Dpivot

   Show answer

   Answer: B

   Next question

6. Question 276 · 358 in bank

   You are using the key influencers visual to identify which factors affect the quantity of items sold in an order. You add the following fields to the Explain By field: ✑ Customer Country ✑ Product Category ✑ Supplier Country ✑ Sales Employee ✑ Supplier Name ✑ Product Name ✑ Customer City The key influencers visual returns the results shown in the following exhibit.

   

   What can you identify from the visual?

   • ACustomers in Austria order 18.8 more units than the average order quantity.
   • BCustomers in Boise order 20.37 percent more than the average order quantity.
   • CProduct Category positively influences the quantity per order.
   • DCustomers in Cork order lower quantities than average.

   Show answer

   Answer: A

   Explanation

   I passed the exam today (948/1000). My answer was: - Customers in Austria order 18.8 more units than the average order quantity

   Source: Adapted from community discussion — SamuComqi

   References

   • Microsoft Learn

   Next question

7. Question 277 · 358 in bank

   You are creating a Power BI single-page report. Some users will navigate the report by using a keyboard, and some users will navigate the report by using a screen reader. You need to ensure that the users can consume content on a report page in a logical order. What should you configure on the report page?

   • Athe layer order
   • Bthe X position
   • Cthe bookmark order
   • Dthe tab order

   Show answer

   Answer: D

   Explanation

   Tab order is correct. Dont think about the report tab, thats the throw-off. Think tab as in pressing the tab key on your keyboard on a webpage. As you tab thru the page, certain fields get highlighted. So for this example, you want to "tab" thru the report in the correct order: the order should be the flow in which a user reads a report. reference: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-creating-reports

   Source: Adapted from community discussion — 9d92039

   References

   • Microsoft Learn

   Next question

8. Question 278 · 358 in bank

   Select 2

   You are configuring a Power BI report for accessibility as shown in the following table.

   

   You need to change the default colors of all three visuals to make the report more accessible to users who have color vision deficiency. Which two settings should you configure in the Customize theme window? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AFirst-level elements colors
   • BTheme colors
   • CDivergent colors
   • DSentiment colors

   Show answer

   Answer: BC

   Explanation

   B- theme colors cause you can customize it yourself C- Divergent specifically address color blind users D is not correct because it uses colors like RED, GREEN, which hurts visual impaired users

   Source: Adapted from community discussion — desibaby09

   Next question

9. Question 279 · 358 in bank

   HOTSPOT - You have a Power BI workspace that contains a semantic model and a report named Sales report. All users in the sales department are assigned the Viewer role for the workspace. The Sales report is configured as shown in the Sales report exhibit. (Click the Sales report tab.)

   

   From Power BI Desktop, you configure the Report settings as shown in the Report settings exhibit. (Click the Report settings tab.)

   

   For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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

   Yes, No, No. I believe the answer shown are correct. For the second one, the viewer role does not have access to share/reshare: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-roles-new-workspaces For third, there is no mention of being able to add a new measure: https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-personalize-visuals?tabs=powerbi-desktop

   Source: Adapted from community discussion — ak57

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 280 · 358 in bank

    You need to use Power BI to create a visual that will allow users to compare the sales performance of five sales regions for the current month. Which visual should you use?

    • Aa line chart
    • Ba stacked bar chart
    • Ca 100% stacked bar chart
    • Da waterfall chart

    Show answer

    Answer: B

    Next question

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

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