PL-900 Describe the business value of Microsoft Power Platform Practice Test 11 — 15 Questions

Question 1

A retail company uses Power Apps to manage inventory. The app allows store managers to scan barcodes and update stock levels in real time. The company wants to extend this capability to suppliers so they can view stock levels but not modify them. Which Power Platform component should be used to create the supplier-facing interface?

Accepted Answer

Power Apps portals. Power Apps portals (now part of Power Pages) allow external users, such as suppliers, to access data through a low-code, authenticated website without requiring a Power Apps license or internal network access. This enables suppliers to view stock levels via a browser-based interface while preventing any modification, as permissions can be set to read-only. Canvas apps, by contrast, are designed for internal users and require a license or guest access in Azure AD, making portals the correct choice for external, unauthenticated or lightly authenticated scenarios.

Answer

Power BI dashboard

Answer

Canvas app

Answer

Power Automate

Question 2

A financial services firm uses Microsoft Power Platform to automate loan approval processes. They have a Power Automate flow that triggers when a new loan application is submitted in SharePoint, then uses AI Builder to extract key fields from uploaded documents, and finally updates a Dataverse table. The compliance team requires that all automated decisions be auditable and explainable. Which feature should the firm use to meet this requirement?

Accepted Answer

Enable Power Automate audit logging in the environment. Power Automate audit logging captures detailed records of flow runs, including which automated decisions were made, when, and by which flow. This provides the compliance team with a verifiable, immutable audit trail that meets regulatory requirements for explainability and accountability. Unlike AI Builder's explainability mode, which only offers model-level insights, audit logging records the full execution context of the flow.

Answer

Enable AI Builder explainability mode

Answer

Store all extracted data in a separate SharePoint list with versioning

Answer

Use Copilot Studio to create a chatbot that logs decisions

Question 3

A non-profit organization wants to create a simple app for volunteers to log their hours and submit expenses. The app should be easy to build and require minimal coding. Which Power Platform tool should they use?

Accepted Answer

Power Apps canvas app. Power Apps canvas app is the correct choice because it allows non-developers to quickly build a custom, low-code app for data entry tasks like logging volunteer hours and submitting expenses. Canvas apps start from a blank canvas or a template, enabling drag-and-drop design with minimal coding, and can connect directly to data sources like SharePoint or Dataverse for storing records.

Answer

Power Pages

Answer

Power BI

Answer

Power Automate

Question 4

A company uses Power BI to visualize sales data from Dynamics 365. The sales team needs to see real-time updates when a deal is closed. Which Power Platform component should be used to trigger a notification when a deal is won?

Accepted Answer

Power Automate flow. Option C is correct because Power Automate can trigger a flow when a deal is won in Dynamics 365 (e.g., using the 'When a record is updated' trigger filtered to the 'Close Date' field or status change to 'Won'). The flow can then send a real-time notification (e.g., email, Teams message, or push notification) to the sales team, meeting the requirement for immediate updates without manual intervention.

Answer

Power BI real-time dashboard

Answer

Copilot Studio chatbot

Answer

Power Apps canvas app

Question 5

A manufacturing company uses Power Automate to approve purchase orders. The flow includes a condition that if the order amount exceeds $10,000, it requires approval from the finance manager; otherwise, it is auto-approved. Recently, the finance manager left the company, and the flow fails. The IT admin needs to update the flow to use a new finance manager. What is the recommended way to maintain this configuration?

Accepted Answer

Use an environment variable for the approver email. Environment variables in Power Automate allow you to store configuration values, such as an approver's email, separately from the flow logic. When the finance manager changes, you only need to update the environment variable value once, and all flows referencing it automatically use the new value. This decouples configuration from code, making maintenance easier and reducing the risk of errors.

Answer

Create a SharePoint list with the approver email and look it up in the flow

Answer

Edit the flow to hardcode the new finance manager's email

Answer

Use dynamic content from a Dataverse table

Question 6

An organization wants to empower employees to create simple automated workflows without writing code. Which Power Platform service should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is specifically designed to enable users to create automated workflows between applications and services without writing code. It provides a low-code/no-code interface with triggers and actions, allowing employees to automate repetitive tasks such as approvals, notifications, and data synchronization.

Answer

Power BI

Answer

Power Pages

Answer

Power Apps

Question 7

A company uses Power BI to analyze customer feedback from surveys. The data is stored in Excel on SharePoint. They want to refresh the report daily without manual intervention. Which feature should they use?

Accepted Answer

Power BI scheduled refresh. Power BI scheduled refresh allows you to configure automatic, recurring data refreshes for datasets stored in the cloud (including Excel files on SharePoint). This eliminates the need for manual intervention by using the Power BI service to re-import the data at defined intervals, such as daily.

Answer

Power BI gateway

Answer

DirectQuery mode

Answer

Power Automate flow to refresh the dataset

Question 8

A healthcare organization uses Power Apps to manage patient intake forms. The app is built on Dataverse and includes a field for medical record number (MRN) that must be unique. The app currently uses a text input, but duplicate MRNs have been entered. What is the best way to enforce uniqueness at the data layer?

Accepted Answer

Create a Dataverse alternate key on the MRN field. Option A is correct because a Dataverse alternate key enforces uniqueness at the database level, preventing duplicate MRN values from being saved regardless of how data enters the system. This is the only option that operates at the data layer, ensuring integrity even if the app, a flow, or an external integration submits a record. Alternate keys are indexed and validated by Dataverse before commit, making them the proper solution for unique field constraints.

Answer

Use a Power Automate flow to check for duplicates after submission

Answer

Configure a business rule on the MRN field

Answer

Add a validation rule in the app to check for duplicates before submitting

Question 9

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

Accepted Answer

Copilot Studio. Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps

Question 10

A company wants to use Power Platform to streamline its expense reporting process. Which TWO components can be used together to create a complete solution that allows employees to submit expenses, managers to approve them, and finance to analyze trends?

Accepted Answer

Power Apps. Power Apps is correct because it allows you to build a custom expense submission form that employees can use to enter expense details. Combined with Power Automate, which handles the approval workflow and data routing, and Power BI for trend analysis, this creates a complete solution. Power Apps provides the user interface, while Power Automate orchestrates the backend process.

Answer

Copilot Studio

Answer

Power BI

Answer

Power Pages

Question 11

A global organization uses Power Platform to manage IT support tickets. They have the following requirements: 1) Tickets must be routed to the appropriate team based on category. 2) The routing logic must be easy to update by non-developers. 3) All ticket data must be stored in a secure, auditable data source. Which THREE Power Platform components should they use?

Accepted Answer

Power Automate. Power Automate is correct because it provides the workflow automation needed to route tickets to the appropriate team based on category. Its low-code interface allows non-developers to easily update routing logic using triggers, conditions, and actions without writing code.

Answer

Copilot Studio

Answer

Power Apps

Question 12

A university uses Power BI to visualize student performance data. They want to allow department heads to create their own reports using the same dataset but without seeing other departments' data. Which TWO features should they implement?

Accepted Answer

Power BI workspace. Row-level security (RLS) restricts data access by user. Power BI workspaces allow organizing content. Power BI apps can distribute reports, but RLS is key for data security. Power Automate is not needed.

Answer

Data gateway

Answer

Power Automate flow

Answer

Power BI app

Question 13

You are the Power Platform administrator for a large enterprise with multiple departments. The HR department uses a Power Apps canvas app to manage employee onboarding. The app is connected to Dataverse and includes a flow that sends a welcome email via Power Automate. Recently, the IT security team mandated that all Power Platform solutions must use Microsoft Entra ID for authentication and that sensitive data (e.g., social security numbers) must be encrypted at rest. The HR app currently uses Dataverse's default encryption. Additionally, the HR team wants to extend the app to external contractors who do not have Microsoft Entra ID accounts. They need to be able to submit their personal information through a secure web form. You need to design a solution that meets security requirements and allows external access. What should you do?

Accepted Answer

Enable customer-managed encryption key (CMEK) for Dataverse, and create a Power Pages site with Microsoft Entra External ID authentication for external contractors.. Option B is correct because it addresses both security requirements: customer-managed encryption key (CMEK) for Dataverse ensures sensitive data like social security numbers is encrypted at rest with a key controlled by the enterprise, meeting the IT security mandate. Additionally, creating a Power Pages site with Microsoft Entra External ID authentication allows external contractors without Microsoft Entra ID accounts to authenticate via social or email-based identities, enabling secure submission of personal information through a web form while maintaining compliance.

Answer

Create a SharePoint list for external contractors to submit data, and use Power Automate to send emails.

Answer

Use Power Apps portals with Microsoft Entra ID B2B collaboration for external contractors, and leave encryption as default.

Answer

Implement a Power Automate flow to collect data via Microsoft Forms, and store results in Dataverse with default encryption.

Question 14

A retail chain uses Power BI to analyze sales data from multiple stores. The data is stored in an Azure SQL Database. The company wants to give store managers access to a dashboard that shows their store's sales compared to the company average. However, store managers should not see other stores' data. The company also wants to automate the process of sending a weekly sales report to regional managers via email. The regional managers need to see aggregated data for their region. You need to implement a solution using Power Platform components. What should you do?

Accepted Answer

Create a Power BI dataset with RLS to filter by store, publish a dashboard, and use a scheduled Power Automate flow to email a paginated report to regional managers.. Option C is correct because it uses Power BI Row-Level Security (RLS) to restrict store managers to only their store's data while allowing regional managers to see aggregated data via a paginated report. The scheduled Power Automate flow automates the weekly email delivery, meeting both security and automation requirements without manual intervention.

Answer

Create a Power Automate flow that runs a SQL query and sends the results via email, and give store managers access to the Azure SQL Database directly.

Answer

Create separate Power BI dashboards for each store and each region, and manually share them.

Answer

Use Power Apps to build a custom dashboard for each store, and use Power Automate to email reports.

Question 15

A small marketing team wants to automate the process of capturing leads from their website into a Dataverse table. Currently, the website sends an email notification when a lead submits a form, and a team member manually enters the data into a Power Apps app. The team wants to eliminate manual data entry. They also want to automatically send a confirmation email to the lead and create a task in Microsoft To Do for the sales representative to follow up. You need to recommend a Power Platform solution. What should you do?

Accepted Answer

Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.. Option A is correct because it directly addresses the requirement to eliminate manual data entry by using Power Automate to monitor the website's email inbox (via a trigger like 'When a new email arrives'), parse the lead data from the email body or attachments, add it to a Dataverse table, send a confirmation email, and create a task in Microsoft To Do. This solution automates the entire workflow without requiring changes to the existing website form or manual intervention.

Answer

Replace the website form with a Power Apps portal form, and use Power Automate for emails and tasks.

Answer

Use Microsoft Forms to collect leads, and Power Automate to add to Dataverse and send emails.

Answer

Create a Power Apps app on the website to capture leads, and use Power Automate to send emails and create tasks.