PL-900 practice questions 271–280

1. Question 271 · 301 in bank

   DRAG DROP - A company plans to implement Power BI to analyze retail operations data. You need to recommend solutions for the company. Which Power BI components should the company use? To answer, drag the appropriate Power BI components to the correct requirements. Each Power BI component 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. Select and Place:

   

   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

   Reference: https://docs.microsoft.com/en-us/power-bi/service-set-data-alerts https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel

   Source: Adapted from community discussion — Kekzs1

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

2. Question 272 · 301 in bank

   HOTSPOT - You are creating Power BI visualizations. You need to display the visuals where a user can perform each function. Which solution should you use? To answer, select the appropriate option 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

   Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill

   Source: Adapted from community discussion — jvpenna18

   References

   • Microsoft Learn

   

   Next question

3. Question 273 · 301 in bank

   A company is using Power BI. The company wants to see which data connectors are available for building dashboards. You need to evaluate the available connectors. What should you use to see all the available connectors?

   • APower BI Workspace
   • BCommon Data Service
   • CPower BI Dataflows
   • DPower Platform admin center
   • EPower BI Desktop

   Show answer

   Answer: D

   Explanation

   D is more likely for 2 reasons: One (as xav1er states), dashboards are a BI Service feature, not BI Desktop. Two, the PPAC at https://admin.powerplatform.microsoft.com/dlp allows you to define policies that allow or block connectors. You will not be able to see some of those in BI Desktop.

   Source: Adapted from community discussion — fuddyduddy

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

4. Question 274 · 301 in bank

   HOTSPOT - A company is using Power BI. The company plans to analyze a large number of datasets. The company is concerned that this may negatively impact performance. You need to identify and implement features to mitigate any performance issues. Which features 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

   Reference: https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-storage-mode

   Source: Adapted from community discussion — Shradz93

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 275 · 301 in bank

   You create a set of dashboards and reports for a project team that combines data from different sources in Power BI. Some of the data is considered sensitive. You need to distribute the dashboards and reports securely to the team. What should you create?

   • Aa custom data connector
   • Ba published app
   • Ca Microsoft flow
   • Da Power BI workspace

   Show answer

   Answer: B

   Explanation

   I just passed today 2/2023 with a 900, and I can say with 100 certainty that the correct answer is D, Workspace. The reason I can say that is because "Publish an app" wasn't even one of the available answers to choose.

   Source: Adapted from community discussion — Silnt

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 276 · 301 in bank

   Select 2

   You are creating visuals in Power BI. You create area charts, pie charts, and donut charts that use your company's data. You need to display the charts to others at the company. Which two objects can you add the charts to? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • APower BI service
   • BPower BI reports
   • CPower BI desktop
   • DPower BI dashboards

   Show answer

   Answer: BD

   Explanation

   Power BI reports and Power BI dashboards are the two objects where you can add your charts to display them to others at your company. Power BI reports allow you to create and publish a collection of visualizations and data, and Power BI dashboards allow you to create a single view of important metrics and data using visualizations such as area charts, pie charts, and donut charts. The Power BI service is used to publish and share the reports and dashboards. Power BI Desktop is a tool that allows you to create and design the reports and dashboards, but it cannot be used to share them with others.

   Source: Adapted from community discussion — EdrisKazemi

   Next question

7. Question 277 · 301 in bank

   DRAG DROP - A company is implementing Power BI to track sales. Each of the company's regions has specific quarterly and yearly sales goals. You need to build a Power BI dashboard for various reporting requirements. Which chart types should you use? To answer, drag the appropriate chart types to the correct requirements. Each chart type 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. Select and Place:

   

   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: KPIs - A Key Performance Indicator (KPI) is a visual cue that communicates the amount of progress made toward a measurable goal. Box 2: Line chart - Line charts emphasize the overall shape of an entire series of values, usually over time. Box 3: Donut - Doughnut charts are similar to pie charts. They show the relationship of parts to a whole. The only difference is that the center is blank and allows space for a label or icon. Reference: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-types-for-reports-and-q-and-a

   Source: Adapted from community discussion — AnetaK

   References

   • Microsoft Learn

   

   Next question

8. Question 278 · 301 in bank

   DRAG DROP - You create a Power BI dashboard. Match each option to its function. To answer, drag the appropriate option from the column on the left to its function on the right. Each option may be used once, more than once, or not at all. NOTE: Each correct match is worth one point. Select and Place:

   

   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

   Reference: https://docs.microsoft.com/en-us/power-bi/service-set-data-alerts https://docs.microsoft.com/en-us/power-bi/service-analyze-in-excel https://docs.microsoft.com/en-us/power-bi/service-dashboard-pin-tile-from-report

   Source: Adapted from community discussion — burp

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

9. Question 279 · 301 in bank

   Select 3

   You need to implement Microsoft Business Applications along with the Microsoft Power platform. Which three Microsoft products are part of the Power platform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • APower Apps
   • BAzure Active Directory
   • CPower Automate
   • DAzure Machine Learning
   • EPower BI

   Show answer

   Answer: ACE

   Next question

10. Question 280 · 301 in bank

    You are using Dynamics 365 Sales. You need to pull data into a Power BI report for your team. The City and State columns must be combined to form one column on the report. Which function would you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

    • AUse Power Query to merge columns.
    • BImport the data.
    • CExport data to Microsoft Excel.
    • DCreate a view.

    Show answer

    Answer: A

    Explanation

    A: merge columns is correct. And if there would be DAX as another option, I would choose this since you have to choose two options. All the other answers don't make much sense

    Source: Adapted from community discussion — techwen

    Next question

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

PL-900 practice, question 271. 301 questions available.