PL-900 Demonstrate the capabilities of Power Automate Practice Test 11 — 15 Questions

Question 1

The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?

Accepted Answer

Triggers when a .xlsx file is created in the 'Incoming' folder.. The trigger is configured for file creation in the 'Incoming' folder with a condition that checks the file extension is .xlsx, so it only fires when an Excel file is created. Option A is wrong because the trigger filters for .xlsx files, not .csv files. Option B is wrong because the trigger does not fire for any file; it only fires for .xlsx files. Option C is wrong because the trigger is for file creation, not modification.

Answer

Triggers when a .csv file is created in the 'Incoming' folder.

Answer

Triggers when any file is created in the 'Incoming' folder.

Answer

Triggers when a file is modified in the 'Incoming' folder.

Question 2

The exhibit shows an action in a Power Automate flow. What does this action accomplish?

Accepted Answer

Post a message to the General channel in the Marketing team.. The action shown is 'Post message in a chat or channel' from the Microsoft Teams connector. When configured with a Team (Marketing) and a Channel (General), it posts a message to that specific channel. This is the standard way to send automated notifications to a Teams channel from a Power Automate flow.

Answer

Send an email notification.

Answer

Send a chat message to a user.

Answer

Create a new channel in the Marketing team.

Question 3

A company uses Power Automate to send approval emails when a new employee is added to Microsoft Entra ID. The approval flow fails intermittently with a '403 Forbidden' error. What is the most likely cause?

Accepted Answer

The connection used in the flow lacks appropriate permissions.. A 403 Forbidden error in Power Automate typically indicates that the connection used by the flow does not have the necessary permissions to perform the action, such as reading from Microsoft Entra ID or sending approvals. The most likely cause is an insufficiently privileged connection or an expired credential.

Answer

The Microsoft Entra ID license has expired.

Answer

The flow is exceeding the API request throttle limit.

Answer

The Power Automate connector for Microsoft Entra ID is deprecated.

Question 4

You create a Power Automate flow that runs when a new tweet matches a keyword. What type of trigger does this use?

Accepted Answer

Automated trigger. An automated trigger in Power Automate fires in response to an event, such as a new tweet matching a keyword, without any user interaction. The Twitter/X connector provides a 'When a new tweet matching a keyword is posted' trigger, which is classified as automated because it is event-driven. This is distinct from scheduled or manual triggers, which require a timer or explicit user action.

Answer

Recurrence trigger

Answer

Manual trigger

Answer

Scheduled trigger

Question 5

A Power Automate flow uses a 'When an item is created' trigger on a SharePoint list. After moving the list to a different site, the flow no longer triggers. What is the most likely reason?

Accepted Answer

The trigger still references the old site and list ID.. The 'When an item is created' trigger is bound to the original site URL and list ID. Moving the list to a different site does not automatically update the trigger's connection, so the flow continues to listen for changes on the old location and fails to trigger for the new one. Option B is incorrect because the trigger can work across sites if updated; the issue is the stale reference. Option C is incorrect because the flow is not automatically disabled during the move. Option D is incorrect because re-authentication is not related to the change in location.

Answer

The trigger does not support cross-site operations.

Answer

The flow was disabled during the move.

Answer

The SharePoint connector requires re-authentication.

Question 6

You need to design a Power Automate flow that sends a welcome email to a new user immediately after their account is created in Microsoft Entra ID. Which trigger should you use?

Accepted Answer

When a user is added. 'When a user is added' triggers when a new user is created. Option A is wrong because it triggers when a user is deleted, not created. Option B is wrong because it triggers when a group is added, not a user. Option C is wrong because it triggers when a user is updated, not created.

Answer

When a user is removed

Answer

When a group is added

Answer

When a user is updated

Question 7

A Power Automate flow runs daily to copy data from a SQL Server database to a SharePoint list. The flow fails with a 'GatewayTimeout' error. What is the most likely cause?

Accepted Answer

The SQL query is taking longer than the allowed timeout.. A GatewayTimeout error in Power Automate typically indicates that the on-premises data gateway did not receive a response from the backend (SQL Server) within the allowed timeout window. The most likely cause is that the SQL query is taking longer than the gateway's timeout setting, so the gateway returns a timeout to Power Automate. Optimizing the query or increasing the timeout resolves the issue.

Answer

The service account does not have write permission to the SharePoint list.

Answer

The on-premises data gateway is offline.

Answer

The flow has exceeded the daily API call limit.

Question 8

You create a Power Automate flow that uses AI Builder to process invoices. The flow needs to extract text from PDFs and store it in Dataverse. What is the recommended approach?

Accepted Answer

Use AI Builder's Form Processing model to extract fields and then add a 'Create a new row' action for Dataverse.. AI Builder's Form Processing model is purpose-built to extract structured fields such as invoice number, date, and total from PDFs and images. Pairing it with a Dataverse 'Create a new row' action stores the extracted data in the target table, which is the recommended end-to-end pattern.

Answer

Use AI Builder's Entity Extraction model on the raw PDF text.

Answer

Use AI Builder's Object Detection model to identify text regions.

Answer

Use AI Builder's Text Classification model to categorize invoices.

Question 9

Which TWO actions can be used to implement error handling in a Power Automate flow?

Accepted Answer

Use a Scope action to group actions and configure error handling. Option A is correct because the Scope action groups a set of actions into a single block, and its Run After settings can be configured so that a subsequent action (such as a Terminate or a notification) runs only when the Scope fails, times out, or is skipped, which is the standard pattern for try/catch-style error handling in Power Automate. Option D is correct because Run After settings define the dependency and outcome conditions (is successful, has failed, is skipped, has timed out) under which an action executes, and configuring an action to run after a previous action 'has failed' is the core mechanism for branching into error-handling logic. Option B is not the intended answer because a Condition action only evaluates data expressions at runtime and cannot by itself detect whether a prior action failed; failure detection is driven by Run After, not by Condition. Option C is not the intended answer because Compose merely outputs a value or expression for later use and does not provide any error-detection or error-handling behavior. Option E is not the intended answer because Apply to Each is a looping construct for iterating over arrays and does not implement error handling.

Answer

Add a Condition action to check for errors

Answer

Use a Compose action to store error details

Answer

Add an Apply to Each action

Question 10

Which TWO are valid trigger types in Power Automate?

Accepted Answer

For a selected file. Option A, 'For a selected file,' is a valid Power Automate trigger because it is the SharePoint 'For a selected file' trigger that lets a user manually start a flow from a selected file in SharePoint, making it a legitimate trigger type. Option E, 'When an item is created,' is also a valid trigger, as it is the standard SharePoint trigger that starts a flow automatically when a new item is added to a list or library. Option B, 'Create a new row,' is an action (for example, in Excel or Dataverse), not a trigger. Option C, 'Apply to each,' is a control/loop action used to iterate over items, not a trigger. Option D, 'Send an email,' is an action such as Outlook's 'Send an email,' not a trigger.

Answer

Create a new row

Answer

Apply to each

Answer

Send an email

Question 11

Refer to the exhibit. This Power Automate flow is triggered manually via HTTP request. The action 'Send_approval_email' sends an email. What is a potential issue with this flow design?

Accepted Answer

The flow does not include an approval action, only an email notification.. The flow is named 'Send_approval_email' and the question states it sends an email, but the design only performs a notification action rather than using Power Automate's dedicated Approvals connector (Start and wait for an approval). Without an approval action, the flow cannot capture an approve/reject decision or branch on the outcome, so it fails to fulfill its stated purpose. The HTTP request trigger is valid, authentication is a separate concern, and the email action is not deprecated.

Answer

The manual trigger cannot be used for HTTP requests.

Answer

The authentication parameter is missing.

Answer

The email action uses deprecated parameters.

Question 12

Refer to the exhibit. The flow is scheduled to run daily at 8:00 AM. However, it has not been running for the past week. What is the most likely cause?

Accepted Answer

The flow has been turned off in the Power Automate portal.. The flow's schedule is correctly configured, but the flow may have been manually turned off in the Power Automate portal, preventing it from executing. Option A is incorrect because the recurrence setting appears valid. Option C is incorrect because an invalid SharePoint URL would cause the flow to fail when triggered, not prevent it from being scheduled. Option D is incorrect because flows do not have a 'Stopped' state; they are either turned on or off.

Answer

The recurrence schedule is incorrectly formatted.

Answer

The SharePoint site URL is invalid.

Answer

The flow is in a 'Stopped' state.

Question 13

A user reports that a scheduled flow runs but does not send notifications as expected. The flow is set to run every hour. Which action should the user take first to diagnose the issue?

Accepted Answer

Check the flow run history for errors.. The first step to diagnose why a scheduled flow runs but does not send notifications is to check the flow run history. The run history provides details about each run, including success, failure, and any error messages, which can indicate why notifications are not being sent. Option B (recreating the flow) is premature without understanding the root cause. Option C (verifying notifications in the user's profile) may be relevant but should come after checking run history. Option D (adjusting the schedule) does not address the issue since the flow runs already.

Answer

Recreate the flow from scratch.

Answer

Verify that notifications are enabled in the user's profile.

Answer

Adjust the flow schedule to run more frequently.

Question 14

A company uses Power Automate to monitor a SharePoint document library for new files and then copy them to an Azure Blob Storage container. The flow runs successfully for PDF files but fails for large video files. What is the most likely cause?

Accepted Answer

Power Automate has a file size limit that the video exceeds.. Power Automate has documented message size limits (e.g., 100 MB for some connectors, and lower limits for certain actions like SharePoint 'Get file content'). Large video files exceed these limits, causing the flow to fail even though PDFs work fine. The most likely cause is that the video file size exceeds the connector or action limit.

Answer

The SharePoint connector cannot read video files.

Answer

The flow uses a 'Parallel branch' that cannot handle large files.

Answer

Azure Blob Storage does not support video file formats.

Question 15

A Power Automate flow uses an 'Apply to each' loop to iterate over a large dataset. The flow is running slowly and sometimes times out. Which approach should the administrator recommend to improve performance?

Accepted Answer

Enable concurrency control on the 'Apply to each' loop.. Enabling concurrency control on the 'Apply to each' loop allows multiple iterations to run in parallel, dramatically reducing the total execution time for large datasets. By default, the loop runs sequentially, so each iteration waits for the previous one to finish. Setting concurrency (e.g., 10 or 20) lets Power Automate process multiple items simultaneously, improving throughput and reducing timeout risk.

Answer

Split the dataset into multiple flows.

Answer

Increase the flow timeout setting to 1 hour.

Answer

Use a premium connector for the data source.