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

Question 1

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.. Gateway timeout indicates the SQL query took too long. Option A is wrong because connection issues cause different errors. Option C is wrong because permission errors are 401/403. Option D is wrong because throttling returns 429.

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 2

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. Options A and D are correct because a Scope action can group actions and allow you to configure error handling for the group, and the Run After settings let you specify what happens when a previous action fails, succeeds, or times out. Option B is incorrect because a Condition action is used for conditional logic, not error handling. Option C is incorrect because a Compose action is used to build data, not handle errors. Option E is incorrect because the Apply to Each action is used to iterate over arrays, not for 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 3

Which THREE components are required to create an automated approval process using Power Automate and Microsoft Teams?

Accepted Answer

A 'Start and wait for an approval' action. Options A, C, and E are correct because they represent the trigger, approval action, and notification. Option B is wrong because it's for manual triggers. Option D is wrong because it's not required for approvals.

Answer

A manual button to start the flow

Answer

A SharePoint list to store approval history

Question 4

Which TWO are valid trigger types in Power Automate?

Accepted Answer

For a selected file. Options A and E are correct because they are valid trigger types in Power Automate. 'For a selected file' triggers a flow when a file is selected, and 'When an item is created' triggers when an item is created in a data source. Options B, C, and D are actions, not triggers.

Answer

Create a new row

Answer

Apply to each

Answer

Send an email

Question 5

Refer to the exhibit. The Power Automate flow trigger is configured to run when a new email arrives. What will trigger this flow?

Accepted Answer

Emails with 'Invoice' in the subject line. The trigger condition 'subjectFilter' is set to 'Invoice', meaning only emails with 'Invoice' in the subject line will trigger the flow. Option A is incorrect because 'includeAttachments' is set to false, so attachments are not required. Option C is incorrect because 'importance' is set to 'Any', so importance is not a filter. Option D is incorrect because the flow requires a specific subject filter, not any email.

Answer

Any email with an attachment

Answer

Emails marked as high importance

Answer

Any email with or without attachments

Question 6

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 lacks an approval action; it only sends an email notification. To implement an approval process, a 'Start and wait for an approval' action must be included. Option A is wrong because the 'When an HTTP request is received' trigger can be used for manual or external triggers. Option B is wrong because email actions in Power Automate authenticate via the connection, not explicit authentication parameters. Option D is wrong because the 'Send an email' action supports required parameters like To, Subject, and Body, which are 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 7

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 8

A company uses Power Automate to automate invoice processing. The flow must send an email with the invoice PDF as an attachment to the manager for approval. However, the approval step is failing with an error. What is the most likely cause?

Accepted Answer

The flow does not include the 'Attachments' parameter in the 'Start and wait for an approval' action.. The approval step fails because the 'Start and wait for an approval' action requires the 'Attachments' parameter to be populated with the file content. Without it, no attachment is sent, even if the file is referenced elsewhere. Option A is incorrect because the issue is not about licensing; standard connectors support attachments. Option B is incorrect because there is no 10 MB limit for standard approvals; the file size limit is higher and not the cause here. Option C is incorrect because SharePoint connectors can access PDF files.

Answer

The flow is not using a premium license for the approval action.

Answer

The file size exceeds the 10 MB limit for Power Automate attachments.

Answer

The SharePoint connector cannot access PDF files.

Question 9

A Power Automate flow triggers when a new item is added to a SharePoint list. The flow uses a 'Send an HTTP request to SharePoint' action to update a related item in another list. The flow runs but the update does not occur. What is the most likely cause?

Accepted Answer

The site address in the HTTP request is incorrect.. If the site address in the 'Send an HTTP request to SharePoint' action is incorrect, the request cannot reach the target SharePoint list, and the update fails. Option A is wrong because the HTTP request action is indeed available and can update items. Option B is wrong because the flow typically runs under the creator's or configured connection credentials; permission is usually not the issue unless explicitly insufficient. Option C is wrong because the action can update list items when the URI and method are correct.

Answer

The HTTP request action is not available in Power Automate.

Answer

The flow does not have permission to access the target list.

Answer

The HTTP request action cannot update SharePoint list items.

Question 10

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 11

A company has a Power Automate flow that posts a message to Microsoft Teams when a new lead is created in Dynamics 365. The flow uses the 'Post a message' action. Some users report they do not receive the message in Teams. What should the administrator check first?

Accepted Answer

Review the Teams connector connection status and permissions.. The Teams connector requires proper authentication and permissions; if the connection is broken or insufficient, messages will fail to post. Option A is incorrect because the 'Post a message' action configuration is not the first thing to check; the trigger and connection status are more fundamental. Option C is incorrect because the flow triggering on new lead creation is a separate issue from the Teams connector itself. Option D is incorrect because Teams notification settings are per-user and not the primary cause of the flow not sending messages.

Answer

Verify that the 'Post a message' action is correctly configured.

Answer

Confirm the flow is triggered by new lead creation.

Answer

Check the Teams notification settings for each user.

Question 12

A Power Automate flow uses the 'Apply to each' control to process a list of items. The flow runs but only processes the first 10 items. What is the most likely reason?

Accepted Answer

The flow has a 'Terminate' action after the 10th item.. The 'Apply to each' control does not have a default limit of 10 items. It processes all items in the array sequentially by default. If only the first 10 items are processed, the most likely reason is that a 'Terminate' action is placed inside the loop after the 10th iteration, which stops the entire flow and prevents further processing. Option A is incorrect because there is no such default limit. Option C is incorrect because if the list contained exactly 10 items, all 10 would be processed, not just 'the first 10' implying there are more items. Option D is incorrect because the concurrency setting affects parallel execution, not the total number of items processed.

Answer

The 'Apply to each' control only processes the first 10 items by default.

Answer

The list contains exactly 10 items.

Answer

The 'Apply to each' has a concurrency setting limiting the number of items processed.

Question 13

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 a file size limit (default 100 MB) for actions like 'Get file content'. Large video files often exceed this limit, causing failures. Option A is incorrect because the SharePoint connector can read video files; file type is not the issue. Option B is incorrect because parallel branches are unrelated to file size limits. Option D is incorrect because Azure Blob Storage supports large files, including videos.

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 14

A user wants to create a flow that automatically sends a thank-you email when a customer fills out a Microsoft Forms survey. Which trigger should the user select?

Accepted Answer

When a new response is submitted. The correct trigger is 'When a new response is submitted' because it is the standard Microsoft Forms connector trigger that fires immediately when a survey response is submitted. This trigger is specifically designed for Microsoft Forms (not Forms Pro) and provides the response data needed to send a personalized thank-you email via Power Automate.

Answer

When a response is submitted (Forms Pro)

Answer

When an item is created or modified

Answer

When a new email arrives

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, significantly improving performance for large datasets and reducing the risk of timeouts. Option A is incorrect because splitting the dataset into multiple flows does not address the root cause and adds administrative complexity. Option B is incorrect because increasing the timeout does not make the flow run faster; it merely extends the allowed duration, but the flow may still be slow and could hit other limits. Option D is incorrect because using a premium connector provides access to more APIs or higher limits but does not inherently speed up loop iterations; performance gains come from parallelism.

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.