PL-900 Practice Test 21 — 15 Questions

Question 1

Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)

Accepted Answer

When a row is added, modified, or deleted. The correct answers are B and E. Dataverse provides triggers such as 'When a row is added, modified, or deleted' (option B) and 'When a row is added' (option E). These triggers initiate flows based on changes to rows in a Dataverse table. Options A and C are incorrect because they are triggers for Outlook and SharePoint respectively, not Dataverse. Option D is a manual trigger, not a Dataverse trigger.

Answer

When a new email arrives (Outlook)

Answer

When a new file is created (SharePoint)

Answer

PowerApps button

Question 2

Which THREE are valid connectors in Power Automate? (Select THREE.)

Accepted Answer

Office 365 Outlook. The correct answers are A, D, and E. Office 365 Outlook, Microsoft Teams, and SharePoint are all standard connectors in Power Automate. Option B is incorrect because the connector is named 'SQL Server', not 'SQL Server Management Studio'. Option C is incorrect because the official connector name is 'Azure DevOps', not 'Azure DevOps Services'.

Answer

SQL Server Management Studio

Answer

Azure DevOps Services

Question 3

Which TWO of the following are types of connectors available in Power Automate? (Select TWO.)

Accepted Answer

Standard. A and E are correct. Standard connectors are available to all Power Automate users without additional licensing. Premium connectors, such as those for Salesforce or Common Data Service, require a Premium license. Option B (Custom) is a type of connector but not a licensing tier, and it is not one of the two correct answers. Option C (Enterprise) is not a recognized connector tier in Power Automate. Option D (On-premises) refers to the data gateway needed for on-premises data sources, not a connector type.

Answer

Custom

Answer

Enterprise

Answer

On-premises

Question 4

Which THREE of the following are valid ways to handle errors in a Power Automate flow? (Select THREE.)

Accepted Answer

Scope. A, B, and E are correct. 'Configure run after settings' allows actions to run based on success, failure, or timeout of previous actions. 'Scope' groups actions and can handle errors by enabling 'Configure run after' settings at the scope level. 'Parallel branch' can be used for error handling by running alternative logic in parallel. C is incorrect because 'Apply to each' is for iterating over arrays, not error handling. D is incorrect because 'Condition' controls branching but is not specifically for error handling.

Answer

Apply to each

Answer

Condition

Question 5

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 6

Which THREE are valid trigger types in Power Automate? (Select THREE.)

Accepted Answer

Scheduled. Options A, C, and E are correct. The three main trigger types in Power Automate are Automated (e.g., when an email arrives), Instant (e.g., button trigger), and Scheduled (e.g., recurrence). Option B (Business process flow) is not a trigger type; it is a feature for modeling business processes. Option D (Manual) is not a separate trigger type; manual triggers are covered under Instant triggers.

Answer

Business process flow

Answer

Manual

Question 7

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 8

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 posts a message to the 'General' channel of the 'Marketing' team, including dynamic content from the trigger. Option A is wrong because it does not send an email. Option B is wrong because it is not a chat. Option D is wrong because it does not create a channel.

Answer

Send an email notification.

Answer

Send a chat message to a user.

Answer

Create a new channel in the Marketing team.

Question 9

Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)

Accepted Answer

Configure Run After settings. The correct answers are A and D. Configure Run After settings allow you to specify actions that run on failure, timeout, or skip, enabling error handling. Scope actions group actions and allow you to configure error handling at the scope level, including running subsequent actions on failure. Option B (Apply to each) is for iterating over lists, not error handling. Option C (Compose) is for creating data, not error handling. Option E (Condition) is for branching logic, not error handling.

Answer

Apply to each

Answer

Compose

Answer

Condition

Question 10

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 11

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.

Question 12

Refer to the exhibit. A Power Automate flow uses the 'When a new email arrives' trigger with a filter for emails that have attachments. The trigger sometimes fires even when the incoming email has no attachment. What is the most likely reason?

Accepted Answer

The $filter parameter is not supported by the trigger type.. The most likely reason is that the $filter parameter is not supported by the trigger type. In Power Automate, the 'When a new email arrives' trigger for Office 365 Outlook uses server-side filtering via OData $filter. However, the 'hasAttachments' property is not a valid filtering property for the Mail API, so the filter is ignored. Instead, use an action to check for attachments after the trigger fires.

Answer

The filter is applied after the trigger fires.

Answer

The trigger is configured to ignore the filter.

Answer

The filter should be on 'attachmentCount' instead of 'hasAttachments'.

Question 13

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 14

A Power Automate flow processes sensitive employee data and must be run only by HR managers. Which is the best way to restrict access?

Accepted Answer

Share the flow only with HR managers and set their permissions to 'Owner'.. Sharing the flow with specific users (HR managers) and assigning them Owner permissions is the standard method to restrict access in Power Automate. Option A is wrong because separate environments don't restrict access by role; they isolate resources but permissions must still be set. Option B is wrong because DLP policies control data connectivity, not flow ownership or access. Option D is wrong because disabling sharing affects all flows but doesn't grant specific access to HR managers.

Answer

Create a separate environment for HR flows.

Answer

Use a Data Loss Prevention (DLP) policy to block non-HR users.

Answer

Disable sharing for all flows in the environment.

Question 15

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.