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

Question 1

Your organization uses Microsoft Power Platform to manage customer support tickets. The current process: when a ticket is created in Dataverse, a Power Automate flow sends an email to the support team. The team then updates the ticket status manually in a Power Apps canvas app. However, the team often forgets to update the status, leading to delayed responses. The manager wants an automated solution that sends a reminder if the status is not changed within 24 hours. Additionally, if the status is not changed within 48 hours, the ticket should be escalated to the manager. You need to design a solution using Power Automate and Power Apps. Which approach should you take?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Create two scheduled Power Automate flows: one runs daily to check tickets older than 24 hours and send reminder; another runs daily to check tickets older than 48 hours and escalate.. It uses two separate scheduled flows that run daily to check ticket ages and perform actions based on conditions. This approach ensures automatic reminders after 24 hours and escalation after 48 hours without relying on user action. Option A is wrong because the Power Apps notify function would require the app to be open and doesn't provide recurring checks. Option C is wrong because an hourly recurrence may waste resources and create duplicate actions; a daily schedule is more appropriate. Option D is wrong because a single flow triggered on creation with delays would only run once per ticket, not continuously check for updates.

Answer

Modify the Power Apps app to include a reminder notification using the notify function after 24 hours.

Answer

Create one Power Automate flow with a recurrence trigger every hour. Check tickets older than 24 hours and send reminder; if also older than 48 hours, escalate. Add condition to avoid duplicate actions.

Answer

Create a single Power Automate flow triggered when a ticket is created. Add a 24-hour delay then check status; if not updated, send reminder and wait another 24 hours then escalate.

Question 2

Your company has a Power BI dashboard that displays sales data from a SQL Server database hosted on-premises. The dashboard is used by the sales team to monitor daily performance. Recently, the dashboard has been showing stale data. The data is supposed to refresh every night at 2:00 AM. You have confirmed that the SQL Server database is updated with new data each night. However, the Power BI dataset refresh fails. You need to ensure that the dashboard shows up-to-date data every morning. What should you do?

Accepted Answer

Install and configure an on-premises data gateway and assign it to the dataset.. An on-premises data gateway is required to bridge the connection between Power BI (a cloud service) and an on-premises SQL Server database. Since the dataset refresh fails despite the database being updated, the gateway is either missing or misconfigured. Installing and configuring the gateway allows the scheduled refresh to access the on-premises data source securely, ensuring the dashboard displays up-to-date data each morning.

Answer

Disable scheduled refresh and manually refresh the dataset every morning.

Answer

Change the data source to an Excel file stored in SharePoint Online.

Answer

Republish the Power BI report from Power BI Desktop.

Question 3

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 4

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 5

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 6

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. 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 7

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 8

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 9

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 10

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. 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 11

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 12

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 allows employees to submit expenses via a custom app, while Power Automate handles the approval workflow and routes data to finance. Together they form a complete solution for submission and approval; Power BI can be added later for trend analysis but is not required for the core process.

Answer

Copilot Studio

Answer

Power BI

Answer

Power Pages

Question 13

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 14

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 15

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.. 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.