PL-300 practice questions 261–270

1. Question 261 · 358 in bank

   DRAG DROP - You need to use AI insights to add a column of enhanced data based on the customer feedback. The solution must identify the following: • What the customers most often provide feedback about • Whether the customers like your company’s product • The language of the feedback Which AI insights service should you use for each output? To answer, drag the appropriate services to the correct outputs. Each service 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

   Explanation

   Guys, If you do not familiar with these phrases like me, open power query, in Home tab there is Text Analysis. you can find there.

   Source: Adapted from community discussion — Shalaleh

   References

   • Microsoft Learn

   

   Next question

2. Question 262 · 358 in bank

   Select 2

   You have a Power BI report named ReportA. You have a Power BI tenant that allows users to export data. You need to ensure that consumers of ReportA cannot export any data from visuals. Which two actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AFrom Power BI Desktop, modify the Report settings.
   • BFrom Power BI Desktop, modify the Data Load settings.
   • CFrom the Power BI service, modify the dataset permissions.
   • DFrom the Power BI service, modify the Report settings.

   Show answer

   Answer: AD

   Explanation

   Each correct answer presents a complete solution so A and D. You can configure report settings both in desktop and power bi service

   Source: Adapted from community discussion — Maverick7513

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

3. Question 263 · 358 in bank

   You have a Power BI report that will be rendered on a vertical display. You need to maximize the portion of the screen area used by the report. What should you do?

   • AFrom the Canvas background setting of Power BI Desktop, configure the Image fit setting.
   • BFrom the Canvas settings of Power BI Desktop, set a custom width and height.
   • CFrom Power BI Desktop, select Personalize visuals.
   • DFrom the Power BI service, enable the Pages pane.

   Show answer

   Answer: B

   Explanation

   B. From the Canvas settings of Power BI Desktop, set a custom width and height. To maximize the portion of the screen area used by the report when it is displayed on a vertical screen, you should set a custom width and height for the report canvas in Power BI Desktop. This will allow you to adjust the size of the report canvas to fit the dimensions of the vertical screen, which will result in the report taking up as much space as possible on the screen. Option A, configuring the Image fit setting, is not relevant to maximizing the screen area used by the report. Option C, selecting Personalize visuals, allows you to change the appearance and behavior of individual visuals within the report, but it does not relate to maximizing screen area. Option D, enabling the Pages pane, allows you to navigate between pages in a report, but it does not relate to maximizing screen area either. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   Next question

4. Question 264 · 358 in bank

   You need to create a visual that compares profit across 10 product categories fora selected quarter. What is the best visual to use to achieve the goal?

   • Aan area chart
   • Ba funnel chart
   • Ca clustered bar chart
   • Da line chart

   Show answer

   Answer: C

   Explanation

   C. A clustered bar chart. A clustered bar chart is the best visual to use to compare profit across 10 product categories for a selected quarter. It allows you to easily compare the profit of each category side-by-side, making it easy to identify the highest and lowest performers. In addition, a clustered bar chart is effective at displaying discrete data, such as categories, which makes it the ideal choice for this scenario. No confusion, and no need to discuss further

   Source: Adapted from community discussion — SanaCanada

   Next question

5. Question 265 · 358 in bank

   HOTSPOT - You have a table that contains the following three columns: City -

   

   ✑ Total Sales ✑ Occupation You need to create a key influencers visualization as shown in the exhibit. (Click the Exhibit tab.)

   

   How should you configure the visualization? 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: Total Sales - The key influencers visual helps you understand the factors that drive a metric you're interested in, here Total Sales. It analyzes your data, ranks the factors that matter, and displays them as key influencers. Box 2: Occupation - Measures and summarized columns are automatically analyzed at the level of the Explain by fields used. Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers

   Source: Adapted from community discussion — Igetmyrole

   

   Next question

6. Question 266 · 358 in bank

   You have a Power BI dataset named Finance that is hosted in a Power BI workspace. The finance team at your company is NOT currently a member of any Power BI workspace roles. You need to enable the finance team to use Microsoft Excel to analyze the Finance dataset. What should you do?

   • AGrant the finance team build permissions to the Finance dataset.
   • BProvide an Excel workbook that is connected to the Finance dataset.
   • CCreate a row-level security (RLS) role and add the finance team to the role as members.
   • DGrant the finance team write permissions to the Finance dataset.

   Show answer

   Answer: A

   Explanation

   To enable the finance team to use Microsoft Excel to analyze the Finance dataset, you need to provide them with an Excel workbook that is connected to the dataset. This can be done by installing the Power BI publisher for Excel add-in, connecting to the Finance dataset, and then importing the data into Excel. Once the data is in Excel, the finance team can use all of Excel's analytical capabilities to analyze and visualize the data. Granting build permissions (A) or write permissions (D) to the Finance dataset would allow the finance team to modify the dataset, which is not necessary for their analysis needs. Creating a row-level security (RLS) role and adding the finance team as members (C) would only be necessary if you needed to restrict access to specific rows of data in the Finance dataset based on user roles or permissions.

   Source: Adapted from community discussion — sa56

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 267 · 358 in bank

   Select 2

   You have a Power BI report that contains a visual. The visual contains a measure. You need to ensure that the report meets the following requirements: • All values must be set to two decimal places. • All negative values must be displayed in red font and parentheses. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

   • AFor the visual, apply conditional formatting to the background color.
   • BConfigure the measure to use a custom format.
   • CFor the visual, apply conditional formatting to the font color.
   • DFor the visual, set Value decimal places to 2.

   Show answer

   Answer: BC

   Explanation

   I passed the exam today (948/1000). My answer was: - Configure the measure to use a custom format - For the visual, apply conditional formatting to the font color

   Source: Adapted from community discussion — SamuComqi

   References

   • Microsoft Learn

   Next question

8. Question 268 · 358 in bank

   HOTSPOT - You are using Power Query Editor to preview the data in a column named Max Temp. The column statistics and value distribution are 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

   The first question is asking which value was repeated the most in the column, as in, frequency. When the frequency of the value increases, the bar shown in "value distribution" also increases. So the biggest bar is of the value that is repeated the most, which is 45. For the second question, the smallest NON-null value, is a fancy way of saying the minimum value that is actually a value not an error, null or an empty field. Which is shown on the left hand side as 24. This view is Column Profiling it profiles just one column and brings a lot of statistics about it as you can see. You can read more here. https://learn.microsoft.com/en-us/power-query/data-profiling-tools

   Source: Adapted from community discussion — KauK

   References

   • Microsoft Learn

   

   Next question

9. Question 269 · 358 in bank

   HOTSPOT - You have a Power BI report that contains a page. The page contains the following visuals: • A card • A matrix • A bar chart You need to configure the page to ensure that the card and the bar chart are unaffected when a user drills down in the matrix. The card and the bar chart must change when a user selects a cell in the matrix. What should you configure? 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

   I would choose: Matrix Apply drill down filters to Selected Visual https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=powerbi-desktop#change-the-interactions-of-drillable-visualizations By default, a matrix will have "Entire Page" in the "Apply drill down filters to" option inside the Format tab, which is what we don't want to happen, so changing to "Selected Visual" should give us the behavior we want

   Source: Adapted from community discussion — pverde

   References

   • Microsoft Learn

   

   Next question

10. Question 270 · 358 in bank

    You have a Power BI model that contains two tables named Population and Date. The Population table contains two columns named PopulationAmount and DateKey. DateKey contains date values that represent the first day of a year and are used to create a many-to-one relationship with the Date table. The Power BI model contains two measures that have the following definitions. Total Population = Sum(‘Population’[PopulationAmount]) 2023 Population = CALCULATE([Total Population], ‘Date'[Year] = 2023) You create a table visual that displays Date[Year] and [2023 Population]. What will the table visual show?

    • Aone row per year that contains blank values for every year except 2023
    • Bone row per date that contains the population value for the corresponding year repeated in each row
    • Ca single row for the year 2023 that contains the related population value
    • Done row per year that contains the same value repeated for each year

    Show answer

    Answer: D

    Explanation

    A. one row per year that contains blank values for every year except 2023. The `2023 Population` measure filters the `Total Population` to only show values for the year 2023. For all other years, the measure returns blank. Thus, the table visual will display one row per year with blank values except for the year 2023, which will show the population value for 2023.

    Source: Adapted from community discussion — [Removed]

    References

    • Microsoft Learn

    Next question

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

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