Microsoft PL-900 Certification Exam Practice Questions – 2

Microsoft Exam PL-900: Microsoft Power Platform Fundamentals

Below are some practice questions for Microsoft Exam PL-900: “Microsoft Power Platform Fundamentals” which can help you to prepare for exam and pass with good marks. These are not real exam questions but similar to the questions you can get in exam so practicing these question will boost your confidence.

Question -11
A company plans to use AI Builder to help improve business performance.
You need to determine which AI Models are available for use.
Which three types of models can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. linear regression
B. binary classification
C. object detection
D. anomaly detection
E. text classification
Correct Answer: BCE
Reference:
https://carldesouza.com/using-the-ai-builder-in-the-microsoft-power-platform-for-binary-classification/

Question -12
A company uses Microsoft 365 and Dynamics 365 Sales. The company does not have any developers on its staff.
You need to explain to the executives the benefits of using Power Platform apps.
What are two benefits? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Users can send emails from Dynamics 365 Sales to their personal email addresses.
B. Users can create Power Apps to create apps for different departments.
C. Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales.
D. The company must unify all the mobile devices to one vendor.
Correct Answer: BC

Reference:
https://docs.microsoft.com/en-us/power-automate/getting-started

https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-overview

https://powerapps.microsoft.com/pl-pl/blog/business-model-may/

Question -13
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 -14
You create a Power BI dashboard that displays data from Dynamics 365 Customer Engagement.
You need to share the Power BI dashboard with coworkers.
What are three possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Create a Power BI workspace and grant coworkers permissions.
B. Publish the dashboard as an app to your coworkers.
C. Export the data into Common Data Service for others to manipulate in Power BI.
D. Export the data to Microsoft Excel for coworkers to import and view in Power BI.
E. Embed reports in your company’s internal web portal.

Correct Answer: ABE

Question -15
Your company has an on-premises Microsoft SQL Server database that contains legacy sales data. You must display information from the database in a new Power Apps app.
You need to establish a secure connection between the database and the app.
What should you use?
A. Data source
B. App
C. Data gateway
D. Power Automate
Correct Answer: C
For an on-premises database, identify a data gateway that was shared with you (or create one).
Specify Connect using on-premises data gateway, type or paste the server name, the database name, the user name, and the password for the database that you want to use, and specify the authentication type and the gateway.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabase

Question -16
A recent update has been made to a canvas app.
The update causes a negative impact to users.
You need to roll back the app to a previous version.
What should you do?
A. Restore the previous version of the app.
B. Uninstall the app for all users and reinstall by using the package from a previous version.
C. Deactivate the live app, import the previous version of the app, and then activate the app.
D. Delete the app and create a new app based on the previous version.
Correct Answer: A
Restore a canvas app to a previous version in PowerApps.
Restore an app from your account
1. Open powerapps.com, and then click or tap Apps in the left navigation bar.
2. Near the right edge, click or tap the info icon for the app that you want to restore.
3. Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore.
4. In the confirmation dialog box, click or tap Restore. A new version is added to your list.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app

Question -17
What is a benefit of deploying Microsoft 365 and Dynamics 365 apps in the same tenant?
A. You do not need to manually back up data.
B. Both will use the same time zone.
C. You can use Power BI to display data that comes from both environments.
D. You can implement Single Sign-On (SSO).
Correct Answer: C
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/use-power-bi

Question -18
A company runs a call center to handle customer support inquires.
The company tracks metrics including the number of incoming calls, call resolution rates, and escalations. The company wants to display the metrics on a shared screen that is visible to all call center staff.
You need to recommend a solution for the company.
Which Power Platform feature should you recommend?
A. AI Builder
B. Power Automate
C. Power Apps
D. Power BI
Correct Answer: D

Question -19
You are creating Power BI reports.
You need to choose which filters you can use for reports.
Which three types of filters can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. drill-down
B. automatic
C. database
D. manual
E. external
Correct Answer: ABD
Reference:
https://docs.microsoft.com/en-us/power-bi/power-bi-report-filter-types

Question -20
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/

Question -21
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.
• 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