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

Question 1

Which THREE Power Automate features are available only in premium licenses? (Choose 3)

Accepted Answer

Robotic Process Automation (RPA). Options B, C, and E are correct. Robotic Process Automation (RPA), business process flows, and AI Builder models require premium licenses. Options A and D are available with standard licenses.

Answer

SharePoint triggers

Answer

Approval flows

Question 2

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 3

Refer to the exhibit. You are designing a Power Automate flow that receives an HTTP request with a JSON body. You use the 'Parse JSON' action with the schema shown. The flow fails when the incoming JSON contains an 'items' array with a product object missing the 'quantity' field. What is the best way to fix this?

Accepted Answer

Remove 'quantity' from the required array inside the items schema.. The schema defines 'quantity' as required in each item. To make it optional, you should remove it from the 'required' array inside the items schema. Option B is wrong because the 'items' array itself is not required. Option C is wrong because changing the type to 'string' is incorrect. Option D is wrong because the issue is in the child object, not the parent.

Answer

Add 'items' to the top-level required array.

Answer

Change the type of 'quantity' to 'string'.

Answer

Remove the 'required' array from the top level.

Question 4

Refer to the exhibit. A Power Automate flow definition is shown. The flow is triggered by an HTTP request with a 'score' property. When the score is greater than 0.8, it sends an approval email to the manager. Otherwise, it logs the score to a SharePoint list. The flow runs but when a score of 0.9 is submitted, no email is sent and the SharePoint log is created. What is the most likely cause?

Accepted Answer

The 'score' value is passed as a string instead of a number.. If the 'score' property is passed as a string (e.g., '0.9') instead of a number, the comparison 'greater(triggerBody()?['score'], 0.8)' will compare a string to a number, which will not work as intended. Power Automate's 'greater' function requires both arguments to be numbers; a string comparison will not evaluate correctly, causing the condition to evaluate to false, thus the approval email is not sent and the flow proceeds to the default action (log to SharePoint). Option A is incorrect because 'greater' is the correct function name in Power Automate; 'greaterThan' is not a valid function. Option C is also incorrect because the function 'greater' is spelled correctly; the issue is data type, not spelling. Option D is incorrect because the trigger is explicitly described as an HTTP request in the stem, not 'When a file is created'.

Answer

The condition uses 'greater' but should use 'greaterThan'.

Answer

The condition expression is misspelled as 'greater' instead of 'greaterThan'.

Answer

The trigger is set to 'When a file is created' but the request is HTTP.

Question 5

You need to automatically send an email notification when a new file is added to a SharePoint document library. Which trigger should you use in a Power Automate cloud flow?

Accepted Answer

When a file is created. The 'When a file is created' trigger is designed to start a flow when a new file appears in a SharePoint library. Option A is wrong because 'When a file is deleted' triggers on file removal, not creation. Option B is wrong because 'When a file is modified' triggers on updates, not new files. Option D is wrong because 'When a file is created or modified' includes modification events, which are not required for the specified requirement.

Answer

When a file is deleted

Answer

When a file is modified

Answer

When a file is created or modified

Question 6

A Power Automate flow fails with the error 'GatewayTimeout'. The flow uses an on-premises data gateway to connect to a SQL Server database. What is the most likely cause?

Accepted Answer

The on-premises data gateway is offline or unreachable.. A GatewayTimeout error typically indicates that the gateway is not reachable or has been offline due to network issues, maintenance, or misconfiguration. Option A is wrong because incorrect credentials would cause authentication errors, not timeout. Option B is wrong because a misconfigured trigger would cause a different error at flow start. Option D is wrong because insufficient license would cause a quota or permission error.

Answer

The SQL Server credentials are incorrect.

Answer

The flow creator does not have a Power Automate license.

Answer

The flow trigger is misconfigured.

Question 7

You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?

Accepted Answer

Condition action with nested conditions. The scenario requires conditional logic to evaluate the expense amount and branch accordingly. A Condition action is ideal for the primary split (above/below thresholds), and nested conditions handle the sub-branches (e.g., condition for >$5,000 with nested approval actions, else condition for $1,000-$5,000, else no approval). Option A is incorrect because a Switch action is suitable for discrete values, not numerical ranges. Option B is incorrect because Apply to each is used for iterating over arrays, not for conditional branching. Option D is incorrect because Parallel branches execute actions concurrently and do not implement decision-based branching logic.

Answer

Switch action with cases for each range

Answer

Apply to each with a condition inside

Answer

Parallel branches for both approval paths

Question 8

Refer to the exhibit. The JSON snippet shows a Power Automate action definition. Which action is this?

Accepted Answer

Send an email (Office 365 Outlook). The operationId 'SendEmail' and the host connection 'shared_office365' correspond to the Office 365 Outlook Send an email action. Option A is incorrect because 'Post a message in Microsoft Teams' would use a different operationId (e.g., 'PostMessage') and connection type. Option B is incorrect because 'Create a calendar event' would have operationId like 'CreateEvent' and different parameters. Option C is incorrect because 'Send an HTTP request' would use the 'Http' connection type, not 'shared_office365'.

Answer

Post a message in Microsoft Teams

Answer

Create a calendar event

Answer

Send an HTTP request

Question 9

A Power Automate flow runs on a schedule and exports data from Microsoft Dataverse to a CSV file in SharePoint. Recently, the flow has been taking longer than expected and sometimes times out. Which approach should you take to improve performance?

Accepted Answer

Enable pagination in the Dataverse 'List rows' action.. Enabling pagination in the Dataverse 'List rows' action allows the flow to retrieve more rows per API call, reducing the number of requests and improving throughput, which helps avoid timeouts when dealing with large datasets. Option B is incorrect because an on-premises data gateway is used for connecting to on-premises data sources, not for speeding up cloud-to-cloud data transfer. Option C is incorrect because reducing the schedule frequency does not address the performance issue; it only runs the flow less often, but the flow itself will still take too long when it runs. Option D is incorrect because increasing the action timeout setting only gives the flow more time to complete but does not improve performance; it may just delay the failure or mask the underlying issue.

Answer

Install an on-premises data gateway to speed up data transfer.

Answer

Reduce the schedule frequency to run less often.

Answer

Increase the action timeout setting in the flow.

Question 10

Your organization uses Power Automate to automate approval workflows for purchase orders. The compliance team requires that all approvals be auditable and that the flow logs include the identity of the user who initiated the approval. Which feature should you use?

Accepted Answer

Enable 'Run only user' in the flow's trigger settings.. The 'Run only user' setting in a flow's trigger captures the context of the user who triggered the flow, enabling audit trails. Option A is wrong because the 'When an item is created' trigger does not log the initiator by default. Option B is wrong because 'Configure Run After' settings are for error handling, not for capturing user identity. Option C is wrong because the 'Start and wait for an approval' action does not include the trigger context beyond its own inputs.

Answer

Use the 'When an item is created' trigger for the approval.

Answer

Configure 'Run After' settings for the approval action.

Answer

Use the 'Start and wait for an approval' action.

Question 11

You need to create a Power Automate flow that sends a personalized welcome email to new users when they are added to Microsoft Entra ID. Which trigger should you select?

Accepted Answer

When a user is created (Microsoft Entra ID connector). The correct trigger is 'When a user is created' from the Microsoft Entra ID connector (formerly Azure AD). This trigger initiates a flow when a new user object is created in Microsoft Entra ID, which is ideal for sending a welcome email. Option A is incorrect because it triggers on incoming emails, not on user creation. Option B is for record creation in Dataverse, not for Microsoft Entra ID users. Option C is for file creation in SharePoint, not relevant to user provisioning.

Answer

When a new email arrives (Outlook connector)

Answer

When a record is created (Dataverse connector)

Answer

When a file is created (SharePoint connector)

Question 12

A Power Automate flow that processes incoming emails and creates tasks in Microsoft To Do is not triggering for some emails. The flow uses the 'When a new email arrives' trigger with a filter on the subject containing 'Task'. What is the most likely reason some emails are missed?

Accepted Answer

The emails are older than 7 days.. The 'When a new email arrives' trigger in Power Automate only processes emails from the last 7 days by default. Older emails are ignored, so even if the subject contains 'Task', they won't trigger the flow. Option A is incorrect because the trigger can handle emails from external senders. Option B is incorrect because shared mailboxes work with proper configuration. Option C is incorrect because the subject filter applies to the entire subject line, not just the first word.

Answer

The emails are from external senders.

Answer

The mailbox is a shared mailbox.

Answer

The subject filter only applies to the first word.

Question 13

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 14

Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)

Accepted Answer

Use 'Configure Run After' to implement error handling.. Options B and E are correct. Using 'Configure Run After' allows you to specify actions to run based on the success, failure, or timeout of previous actions, which is essential for robust error handling in production flows. Option E, using secure inputs and outputs, prevents sensitive data from being displayed in flow run histories, protecting confidential information. Option A is incorrect because disabling logging would hinder troubleshooting and monitoring of production flows. Option C is incorrect because nesting 'Apply to each' actions can lead to performance degradation and throttling; instead, use parallel branches or optimized data processing. Option D is incorrect because hardcoding connection references reduces maintainability and security; use connection references stored in environments or Azure Key Vault for flexibility and security.

Answer

Disable flow logging to improve performance.

Answer

Nest Apply to each actions to handle large datasets.

Answer

Hardcode connection references for simplicity.

Question 15

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

Accepted Answer

Condition. Options B, D, and E are correct. A trigger starts the flow, actions perform tasks, and conditions control the flow logic. Option A (Environment) is the container for resources, not a component of a single flow definition. Option C (Connector) is a connection to a service, not a component of the flow itself.

Answer

Environment

Answer

Connector