PL-900 practice questions 281–290

1. Question 281 · 301 in bank

   A carpet cleaning company uses Dynamics 365 Sales. The process for entering customer information during onsite sales calls is very complicated. The company wants a simplified screen that allows salespeople to capture the customer name, phone number, and other information while speaking to the customer. You need to recommend a solution that works on various types of mobile devices. What should you recommend?

   • AMicrosoft Dataverse
   • BPower Automate
   • CAI Builder
   • DCanvas app
   • EPower BI

   Show answer

   Answer: D

   Explanation

   I would recommend hiring better sales people who are more inclined to do their jobs however for the purpose of PL-900 it would be Canvas App.

   Source: Adapted from community discussion — BBBM

   Next question

2. Question 282 · 301 in bank

   Select 2

   A company using Power Platform is implementing Power BI. The company plans to connect to several data sources and create reports and dashboards. You need to identify the data sources they can connect to. Which two data sources should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

   • AMicrosoft Excel
   • BMicrosoft Dataverse
   • CMicrosoft OneNote
   • DMicrosoft Word

   Show answer

   Answer: AB

   Explanation

   A. Microsoft Excel B. Microsoft Dataverse Power BI allows you to connect to a wide variety of data sources to create reports and dashboards. Two popular data sources that can be used are: A. Microsoft Excel: You can connect Power BI to Excel files and use the data in your reports and dashboards. This is a great option if the company already has data stored in Excel and they want to use that data in their Power BI reports. B. Microsoft Dataverse: Dataverse is a data platform that is part of the Power Platform. It allows you to create and manage data in a centralized location and make that data available to other applications like Power BI. This is a great option if the company wants to use Power Platform to manage their data and then use that data in their Power BI reports. C. Microsoft OneNote and D. Microsoft Word are not data sources, they can be used to store notes and documents respectively.

   Source: Adapted from community discussion — EdrisKazemi

   References

   • Microsoft Learn

   Next question

3. Question 283 · 301 in bank

   You create a multi-page Power BI report for an organization. You must enable salespeople in the organization to use the report to view data relevant to their sales region only. You need to enable security for the report. What should you use?

   • Asensitivity labels
   • BMicrosoft Azure Active Directory
   • CMicrosoft Trust Center
   • Ddata loss prevention policies
   • Erow-level security

   Show answer

   Answer: E

   Explanation

   E. row-level security Row-level security (RLS) allows you to control access to data in a Power BI report based on user roles. You can create roles that correspond to the sales regions and define the data that each role can access. Then, you can assign the salespeople to the appropriate role. This way, the salespeople will only be able to see data relevant to their sales region when they view the report. RLS is the most appropriate solution for this requirement.

   Source: Adapted from community discussion — EdrisKazemi

   References

   • Microsoft Learn

   Next question

4. Question 284 · 301 in bank

   HOTSPOT - You are building a Power Apps portal by using the Customer Self-Service template. For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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: No - Customer self-service portal does not support Azure AD authentication. Note: Employee self-service portal does support Azure AD authentication. Box 2: Yes - Customer self-service portal has multi-language support. Box 3: Yes - Customer self-service portal support advanced forms. Reference: https://docs.microsoft.com/en-us/power-apps/maker/portals/portal-templates

   Source: Adapted from community discussion — ravinperera

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 285 · 301 in bank

   User1 creates several Power BI dashboards for a company. User1 shares a dashboard with User2 who works for another company. User2 reports that she is able to view the dashboard. User2 forwards the email containing the dashboard sharing link that she received to User3. User3 reports that he receives an error message when he selects the link to view the dashboard. User3 can view a dashboard that he has created. You need to determine why User3 receives an error. What is the issue?

   • AUser3 is running an out-of-date version of Power BI and must upgrade to a newer version.
   • BUser2 is signed in to the dashboard and must sign out before User3 can sign in.
   • CForwarding the email does not share the dashboard with User3.
   • DUser1 is signed in using the wrong organizational account for Power BI.

   Show answer

   Answer: C

   Explanation

   C. Forwarding the email does not share the dashboard with User3. Sharing a Power BI dashboard with another user creates a unique sharing link that can be used to access the dashboard. The link is only valid for the user it was shared with and cannot be used by other users. If User2 forwarded the email containing the sharing link to User3, it will not work for User3. He needs to be explicitly shared by User1 to be able to view the dashboard.

   Source: Adapted from community discussion — EdrisKazemi

   References

   • Microsoft Learn

   Next question

6. Question 286 · 301 in bank

   HOTSPOT - A company plans to implement Power BI. Instructions: For each of the following statements, select Yes if the statement is true. Otherwise, select No. 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: No - There's a new way to create reports quickly in the Power BI service. Instead of downloading the Power BI Desktop app and importing the data, you can paste data straight into Power BI on the web, and Power BI automatically generates visuals for you. Box 2: No - Power BI Service only contains Power View, the report authoring and consumption experience, along with dashboards. Box 3: Yes - The Power Pivot / data modeling component is available in Power BI Desktop only. This includes adding measures, adding calculated columns, defining relationships - all DAX functionality. Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-quick-create-report https://community.powerbi.com/t5/Service/Calculated-columns-in-web-based-version-of-Power-BI/m-p/19441

   Source: Adapted from community discussion — EdrisKazemi

   

   Next question

7. Question 287 · 301 in bank

   You are developing reports for a company. You must create visualizations that include the following data: ✑ Invoices due from a third-party enterprise resource planning (ERP) system ✑ Number of calls made to the client from Microsoft Dataverse ✑ Microsoft Excel file data The reports must be displayed in a single page. You need to create the visualizations. What should you use?

   • Adeployment pipelines
   • Btables
   • Ccolumns
   • Ddashboards

   Show answer

   Answer: D

   Explanation

   D. dashboards Dashboards in Power BI allow you to display multiple visualizations on a single page. You can create visualizations that include data from different sources such as an ERP system, Microsoft Dataverse and an Excel file. You can create different visualizations such as tables, charts, and graphs to display the data and arrange them on the dashboard to display the data in a meaningful way.

   Source: Adapted from community discussion — EdrisKazemi

   References

   • Microsoft Learn

   Next question

8. Question 288 · 301 in bank

   You are using the Power BI service to view a visual on a report that has been shared with you. You need to add the visual to a dashboard as a tile. Which action should you perform?

   • AExport data
   • BPin
   • CCopy
   • DSpotlight

   Show answer

   Answer: B

   Explanation

   B. Pin To add a visual to a dashboard as a tile in Power BI, you need to "pin" the visual. This will create a copy of the visual and add it to a dashboard as a tile. You can then move the tile around and resize it as needed. (A. Export data: Exporting data will allow you to save a copy of the data used in the visual, but it will not add it to a dashboard. C. Copy: Copying the visual will allow you to create a new visual with the same data, but it will not add it to a dashboard. D. Spotlight: Spotlight is a feature that allows you to highlight a specific area of a visual and share it with others, but it will not add it to a dashboard.)

   Source: Adapted from community discussion — EdrisKazemi

   References

   • Microsoft Learn

   Next question

9. Question 289 · 301 in bank

   A company manages a chain of retail stores. The company stores a list of retail store names and numbers in one Power BI table. The company stores sales transaction data including a transaction ID in another table. The transaction ID includes the store number. You need to show the store name for all retail transactions in all Power BI reports. Which tool should you use?

   • AQuery Editor
   • BPower BI Service
   • CMicrosoft Excel
   • DData Connector

   Show answer

   Answer: A

   Explanation

   A. Query Editor In Power BI, you can use the Query Editor to join the table containing store names and numbers with the table containing sales transaction data. By joining the two tables on the store number, you will be able to show the store name in all Power BI reports that use the transaction data. B. Power BI Service: Power BI service is a web-based service that allows you to view and share Power BI reports, but it does not include the tool to join tables. C. Microsoft Excel: You can use Excel to join tables, but Power BI has its own tool called Query Editor that is more powerful and allows you to join tables in a more efficient way. D. Data Connector: Data connectors are used to connect to various data sources, but it does not include the tool to join tables.

   Source: Adapted from community discussion — EdrisKazemi

   Next question

10. Question 290 · 301 in bank

    You are creating a canvas app. You select the form factor of the app. You need to add a source of the data. What should you use?

    • Ascreen
    • Bconnector
    • Cformula
    • Dcontrol

    Show answer

    Answer: B

    Next question

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

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