PL-900 Practice Test 39 — 15 Questions

Question 1

A regional health clinic chain wants to reduce the time staff spend manually copying patient intake details from paper forms into its electronic records system. The IT team has no developers available and wants a solution that non-technical clinical staff can build and maintain themselves. The solution must capture the form data, store it in a structured cloud table, and notify the records team automatically. Which combination of Power Platform services should the clinic use?

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

Accepted Answer

Power Apps, Microsoft Dataverse, and Power Automate. The clinic needs three capabilities: a low-code way to capture intake data, structured cloud storage, and an automated notification. Power Apps delivers the buildable interface, Microsoft Dataverse provides the governed relational table that non-developers can extend, and Power Automate handles the trigger-based notification. The other combinations substitute analytics, chatbot, or portal services that do not fulfill the capture-store-notify chain.

Answer

Microsoft Dataverse, Power BI, and Power Pages

Answer

Power Automate, AI Builder, and Power BI

Answer

Power BI, Power Virtual Agents, and Power Pages

Question 2

A help desk analyst receives a high volume of support emails in a shared Outlook 365 mailbox. The analyst needs to automatically create a task in Microsoft Planner whenever an email is flagged with a specific category called 'Escalation'. The analyst has no coding experience and wants to build the automation with minimal effort. What should the analyst use?

Accepted Answer

A Power Automate cloud flow with the 'When a new email arrives in a shared mailbox (V2)' trigger and a condition that checks the category, followed by the 'Create a task' Planner action.. The requirement is an event-driven, no-code automation that reacts to categorized email in a shared mailbox and creates a Planner task. Power Automate is the only service in the Power Platform built for this kind of trigger-and-action workflow, and the Outlook 365 shared mailbox trigger plus the Planner connector directly satisfy both the source and destination requirements.

Answer

A Microsoft Power BI dataflow that ingests the mailbox and pushes records to Planner.

Answer

A Power Automate desktop flow that uses UI automation to read the Outlook desktop client and create Planner tasks.

Answer

A Power Apps canvas app that polls the mailbox every minute and inserts Planner tasks.

Question 3

A company uses Power Automate to process invoices. A cloud flow is triggered when a new row is added to a Microsoft Dataverse table. The flow must retrieve related customer information from another Dataverse table and then update the invoice row with a calculated risk score. The flow runs but fails at the step that updates the invoice. The error message indicates that the record is currently locked by another process. What is the most likely cause of this failure?

Accepted Answer

The flow is trying to update a record that is locked by another transaction, such as a plugin or another flow.. Dataverse uses record-level locking to maintain data consistency. When one process, such as a plugin or another flow run, is updating a record, other processes attempting to update the same record may fail with a lock error. To resolve this, you can implement retry policies on the action, reduce concurrency, or coordinate the processes so they do not contend for the same record. The other options describe permission, trigger, or connection issues that would produce different error messages.

Answer

The flow uses a personal connection instead of a service principal, causing session conflicts.

Answer

The flow's connection to Dataverse uses an account without write privileges on the invoice table.

Answer

The Dataverse trigger is misconfigured and is firing multiple times for the same record.

Question 4

A company uses Power Automate to automate approval processes. They need to create a cloud flow that sends an approval request to a manager when a new item is added to a SharePoint list, and then updates the list item with the approval outcome. Which two actions are required to achieve this? (Choose two.)

Accepted Answer

Start and wait for an approval. The two essential actions are 'Start and wait for an approval' to solicit and capture the manager's decision, and 'Update item' to write that decision back to the SharePoint list. These actions together automate the approval workflow from request to record update. Other actions like sending a separate email or creating a new record are not needed because the approval action handles notification and the scenario requires updating an existing item.

Answer

Send an email (V2)

Answer

Get item

Answer

Create a record

Question 5

A human resources manager wants to create a Power Automate cloud flow that runs every Monday at 9:00 AM to remind the team about timesheet submission. The flow should not depend on any external event. Which trigger should the manager use?

Accepted Answer

Recurrence. The Recurrence trigger is designed for flows that must run at regular intervals, such as daily, weekly, or monthly. By setting it to repeat every week on Monday at 9:00 AM, the HR manager creates a reliable, unattended reminder. Other triggers are event-driven and depend on external actions like receiving an email or creating a list item, which may not occur on the desired schedule. Recurrence ensures the flow runs regardless of external activity.

Answer

Manually trigger a flow

Answer

When an item is created – SharePoint

Answer

When a new email arrives (V3) – Office 365 Outlook

Question 6

A financial analyst builds a Power Automate cloud flow that retrieves invoice data from a SharePoint list and must write the total amount into a Dataverse table. During testing, the flow fails at the Dataverse action with an error indicating the required table column was not provided. The analyst sees the column in the Dataverse table. What is the most likely cause?

Accepted Answer

The Dataverse action's required column is not mapped to a dynamic content value from the SharePoint step.. Dataverse enforces required columns at the service layer, so an action that omits a value for a required field is rejected with a validation error even though the column exists in the table. Mapping dynamic content from the preceding SharePoint step supplies the value, resolving the failure without changing the table schema.

Answer

The SharePoint list is in a different environment than the Dataverse table.

Answer

The SharePoint list contains more than 5,000 items, so the flow cannot read the invoice.

Answer

The flow's connection to Dataverse uses an account without a Power Apps license.

Question 7

A company has a Power Automate cloud flow that processes invoices. The flow uses a condition to check if the invoice amount is greater than $10,000. If true, it sends an approval request to the finance manager. The flow is not sending approval requests for some invoices that exceed $10,000. What is the most likely cause?

Accepted Answer

The condition is using the 'is greater than' operator, but the invoice amount field is stored as text.. The most likely cause is a data type mismatch in the condition. If the invoice amount is stored as text, the 'is greater than' comparison uses lexicographic ordering, causing incorrect results. For example, '9000' is considered greater than '10000'. Converting the field to a numeric type or using a numeric function in the condition ensures accurate comparison. Other options would cause different symptoms, such as no runs at all or all approvals failing.

Answer

The flow's trigger is set to run only on weekdays, and some invoices are created on weekends.

Answer

The approval action is inside an 'Apply to each' loop that is not iterating over all invoices.

Answer

The approval action is configured to send to a user who is out of office.

Question 8

A user wants to create a Power Automate cloud flow that automatically posts a message to a Microsoft Teams channel whenever a new task is added to a Planner plan. Which trigger should the user select to start the flow?

Accepted Answer

When a new task is created (Planner). The Planner 'When a new task is created' trigger is the only one that detects new tasks in a Planner plan. It supplies task details that can be included in a Teams message. The other triggers monitor Teams messages, task completion, or SharePoint items, none of which correspond to the creation of a Planner task. Therefore, the Planner trigger is the correct starting point for this flow.

Answer

When a new item is created (SharePoint)

Answer

When a new channel message is added (Microsoft Teams)

Answer

When a task is completed (Planner)

Question 9

A mid-sized logistics company wants to give its drivers a mobile app to log delivery confirmations and capture customer signatures. The company has no professional developers and wants to build the app quickly using a drag-and-drop interface. Which Microsoft Power Platform service should they use?

Accepted Answer

Power Apps. Power Apps is the low-code application development service in the Microsoft Power Platform. It enables non-developers to assemble mobile and web apps with drag-and-drop controls, connect to data sources, and include features like signature capture and offline use. The other services focus on automation, analytics, or chatbots, none of which deliver an interactive driver-facing app.

Answer

Power Virtual Agents

Answer

Power BI

Answer

Power Automate

Question 10

Your company is migrating a legacy paper-based expense report process to Power Apps. Employees will submit expenses via a Canvas app. The app must integrate with the corporate travel system to fetch trip details (e.g., dates, destination). The travel system exposes a REST API with OAuth 2.0 authentication. Finance requires that all expense reports over $1,000 receive a second-level approval from a manager. Additionally, the app must be available on mobile devices. Which combination of technologies should you use?

Accepted Answer

Canvas app with custom connector to travel API, and Power Automate for conditional approval. A Canvas app can use a custom connector to authenticate with OAuth 2.0 and fetch trip details from the travel REST API. Power Automate can handle the conditional approval workflow for expenses over $1,000. Canvas apps are suitable for mobile use. Option B is wrong: the travel API uses OAuth 2.0, which requires a custom connector; standard connectors may not support the specific authentication or endpoints. Option C is wrong: AI Builder is for AI capabilities like form processing, not for fetching data from a REST API or handling approvals. Option D is wrong: while a model-driven app can be used for mobile, it relies on Dataverse as a data source, not direct integration with an external REST API; the travel system API requires a custom connector, which is easier to implement with a Canvas app.

Answer

Canvas app with standard connector to travel API and Power Automate

Answer

Canvas app with AI Builder to extract trip details and Power Automate for approval

Answer

Model-driven app with Dataverse and Power Automate for approval

Question 11

A Power Automate maker builds a flow that processes expense reports. The flow uses a 'When an item is created' trigger on a SharePoint list and then an 'Apply to each' loop over the returned items to call an external HTTP endpoint for currency conversion. The maker notices the flow sometimes processes the same expense twice and occasionally misses items. Which action should the maker take to make the flow reliably process each expense exactly once?

Accepted Answer

Add a unique identifier check that skips items already logged in a Dataverse tracking table before calling the HTTP endpoint.. Duplicate and missed processing in event-driven flows is best handled by making the business action idempotent. Recording each expense's unique identifier in a Dataverse table and checking it before the external HTTP call means retries or overlapping triggers skip already-processed items, while unprocessed items can be safely retried.

Answer

Change the trigger to 'When an item is created or modified' so the flow reruns on updates.

Answer

Increase the 'Apply to each' concurrency control to 10 so items are processed faster.

Answer

Enable the 'Secure inputs' and 'Secure outputs' settings on the HTTP action to protect the payload.

Question 12

A marketing coordinator creates a Power Automate cloud flow that sends a personalized email to each attendee of an event. The coordinator stores attendee names and email addresses in a Microsoft Excel table in OneDrive for Business. After the flow runs, the coordinator discovers the emails were sent to the wrong recipients. The flow uses an 'Apply to each' loop over the Excel rows. What is the most likely cause?

Accepted Answer

The email action references dynamic content from outside the loop instead of the current iteration's row.. In an 'Apply to each' loop, dynamic content must reference the current iteration's item. If the email action instead uses a token from an earlier step, that single value is reused for every recipient, producing misrouted emails. Binding the recipient field to the loop's current row properties resolves the issue.

Answer

The Excel connector cannot read tables in OneDrive for Business and returned cached data.

Answer

The flow's connection to Excel expired, so the loop reused the first row for all iterations.

Answer

The 'Apply to each' loop requires a Filter array action to sort rows before sending.

Question 13

A logistics company wants to improve its operations by using Microsoft Power Platform capabilities. The IT director asks which capabilities are provided by the Power Platform to enable business users to build solutions with less coding. (Choose two.)

Accepted Answer

Connect to hundreds of data sources through built-in connectors. The Power Platform enables low-code solution building primarily through its extensive connector ecosystem and its visual workflow designer. Connectors let makers reach data and services without custom integration code, while the visual designer in Power Automate lets them automate processes without programming. Together these capabilities empower business users to deliver solutions faster, which is what the IT director is evaluating.

Answer

Provision and manage virtual machines in Azure

Answer

Build responsive web applications by writing HTML, CSS, and JavaScript

Answer

Replace all existing line-of-business systems with a single database

Question 14

A Power Automate maker is building a cloud flow that must read data from an on-premises SQL Server and write results to a SharePoint Online list. The maker needs to understand which components are required to connect to the on-premises data source. Which two components are required? (Choose two.)

Accepted Answer

A SQL Server connection configured in the flow to use the gateway. Connecting a cloud flow to an on-premises SQL Server requires both a registered on-premises data gateway and a connection that is configured to use that gateway with valid credentials. The gateway provides the network path, while the connection provides authentication and connector configuration. Networking features such as VNet peering or VPN tunnels are not part of the Power Automate connectivity model for this scenario.

Answer

A virtual network peering between the tenant and the on-premises network

Answer

A site-to-site VPN tunnel between the maker's laptop and Azure

Answer

A Power BI data gateway in personal mode

Question 15

A sales team uses a Power Automate cloud flow that creates a new lead in Dynamics 365 whenever a form response is submitted. The flow works, but the team wants to ensure that if the lead creation fails due to a temporary service outage, the flow automatically retries a few times before notifying an administrator. Which configuration should they use?

Accepted Answer

Enable 'Retry Policy' on the action that creates the lead and set it to a fixed interval with a count of 3.. The retry policy on an individual action defines how many times and how often Power Automate attempts the action again after a failure. Configuring a fixed interval with a count of three ensures the lead creation is retried automatically before the run fails. Other settings control branching or parallelism and do not provide automatic retries for transient errors.

Answer

Add a 'Configure run after' setting on the lead creation action to run only if the previous action succeeds.

Answer

Create a separate scheduled flow that checks for missing leads every hour and recreates them.

Answer

Increase the flow's concurrency control setting to allow multiple simultaneous runs.