Microsoft Microsoft Certifications PL-900 Questions & Answers

• Question 101:

  A company uses Microsoft 365, Power Platform, and Dynamics 365. You do not assign permissions to any licensed users.

  Users are able to create and edit Power Apps canvas apps.

  In which environment are users creating and editing the apps?

  A. Production

  B. Default

  C. Sandbox

  Correct Answer: B

  Reference: https://docs.microsoft.com/en-us/power-platform/admin/working-with-environments

• Question 102:

  You create a Power Apps canvas app.

  You need to ensure that your coworkers can run the app.

  What should you do?

  A. Share the app.

  B. Send the URL for the app to coworkers.

  C. Add a license for the app.

  D. Create a Flow for the app.

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/share-app

• Question 103:

  You are a sales representative. You create a Power BI report to visualize data from a Microsoft Excel workbook.

  Users need to be able to view and share the report.

  Which two actions should you perform? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Pin the report to a dashboard.

  B. Export the data.

  C. Publish the dashboard.

  D. Share the dashboard.

  Correct Answer: AD

  Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboard-pin-live-tile-from-report https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-share-dashboards#limitations-and-considerations

• Question 104:

  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?

  A. Query Editor

  B. Power BI Service

  C. Microsoft Excel

  D. Data Connector

  Correct Answer: A

  Power BI Desktop comes with Query Editor, where you can connect to one or many data sources, shape and transform the data to meet your needs, then load that model into Power BI Desktop.

  Reference: https://docs.microsoft.com/en-us/power-bi/desktop-query-overview

• Question 105:

  You need to display sales orders greater than a specific threshold in a Power BI report. What should you use?

  A. filter

  B. Power Query

  C. Common Data Service

  D. connector

  Correct Answer: A

• Question 106:

  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?

  A. Common Data Service

  B. Power Automate

  C. AI Builder

  D. Canvas app

  E. Power BI

  Correct Answer: E

  Reference: https://powerapps.microsoft.com/en-us/build-powerapps/

• Question 107:

  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.

  A. Use Power Query to merge columns.

  B. Import the data.

  C. Export data to Microsoft Excel.

  D. Create a view.

  Correct Answer: A

  Reference: https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

• Question 108:

  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?

  A. a custom data connector

  B. a published app

  C. a Microsoft flow

  D. a Power BI workspace

  Correct Answer: B

  Reference: https://docs.microsoft.com/en-us/power-bi/service-how-to-collaborate-distribute-dashboards-reports

• Question 109:

  This question requires that you evaluate the underlined text to determine if it is correct.

  You have a Power BI report with a page named RevReceived. The page shows revenue received by your company. You want to create an almost identical page that shows net revenue instead of gross revenue. To accomplish this task, you

  modify the RevReceived page.

  Review the underlined text. If it makes the statement correct, "No change is needed". If the statement is incorrect, select the answer choice that makes the statement correct.

  A. No change is needed.

  B. duplicate the RevReceived page and update the duplicate copy.

  C. import the RevReceived page.

  D. copy the visuals from RevReceived to a new page.

  Correct Answer: B

  Reference: https://www.tutorialspoint.com/power_bi/power_bi_quick_guide.htm

• Question 110:

  A manufacturing company uses Internet of Things (IoT) devices to monitor the temperature in different parts of their warehouse.

  The current IoT monitoring software is extremely outdated and is not user friendly.

  You need to view near-real time information from the IoT devices in Power BI Service dashboards.

  Which tool should you use?

  A. Scheduled refresh dataset

  B. Streaming dataset

  C. Content Pack dataset

  D. Power BI dataflows

  E. Quick Insights

  Correct Answer: B

  Reference: https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming

  https://powerbi.microsoft.com/en-us/blog/using-power-bi-real-time-dashboards-to-display-iot-sensor-data-a-step-by-step-tutorial/