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

Question 1

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?

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

Accepted Answer

Remove 'quantity' from the required array inside the items schema.. The Parse JSON action validates the incoming payload against the schema, and if a property listed in the 'required' array is missing, the action fails. Since the error is specifically about a product object missing 'quantity', the fix is to remove 'quantity' from the required array inside the items schema so the property becomes optional. This allows the flow to continue processing payloads where quantity is absent.

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 2

Refer to the exhibit. A Power Automate flow definition is shown. The flow is supposed to trigger when a high-importance email with attachments arrives in the inbox, and then send a notification email to support. However, the flow does not trigger for emails that have attachments but are not marked as high importance. What is the most likely reason?

Accepted Answer

The importance filter is set to 'High', so lower importance emails are ignored.. The trigger parameters include 'importance': 'High', so only emails with high importance trigger the flow. If the email has attachments but is not marked as high importance, the flow will not trigger. Option A is incorrect because the folder path being set to 'Inbox' does not affect the trigger; the trigger fires on new emails arriving in the inbox regardless of folder. Option B is incorrect because attachments are set to 'Yes', meaning attachments are required, but the flow still triggers only on high-importance emails; the issue is the importance filter, not attachments. Option D is incorrect because the trigger is set to 'When a new email arrives', which fires on new emails; the email being read does not prevent the trigger from firing on arrival.

Answer

The folder path is set to 'Inbox' but the email was moved to a different folder.

Answer

The trigger requires attachments, so emails without attachments are ignored.

Answer

The trigger is set to 'When a new email arrives' but the email is already read.

Question 3

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 4

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 in Power Automate when using an on-premises data gateway indicates that the cloud service could not reach the gateway within the allowed time. The most common cause is that the gateway is offline, stopped, or otherwise unreachable from the internet. This directly produces the timeout rather than an authentication or configuration 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 5

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 Condition action in Power Automate supports nested conditions, allowing you to evaluate the expense amount in a hierarchical manner: first check if it exceeds $5,000 (requiring both manager and finance director approval), then within the 'No' branch, check if it's between $1,000 and $5,000 (requiring only manager approval), and finally handle the under $1,000 case. This structure directly mirrors the decision tree described in the requirements. The Condition action is the native control for if-then-else logic in Power Automate, and nesting provides the necessary multi-level branching without unnecessary complexity.

Answer

Switch action with cases for each range

Answer

Apply to each with a condition inside

Answer

Parallel branches for both approval paths

Question 6

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 'When a user is created' trigger in the Microsoft Entra ID connector is specifically designed to fire when a new user account is added to Entra ID (formerly Azure AD). This trigger can then initiate a flow to send a personalized welcome email, meeting the requirement.

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 7

Which TWO actions are valid Power Automate flow actions? (Select TWO.)

Accepted Answer

Create a record (Dataverse). Option B, 'Create a record (Dataverse)', is a valid Power Automate action because the Dataverse connector provides a built-in 'Add a new row' action that lets a flow insert records into Dataverse tables without writing code. Option C, 'Send an email (Office 365 Outlook)', is also a valid action since the Office 365 Outlook connector exposes the 'Send an email (V2)' action, which is one of the most commonly used flow actions for notifications and approvals. The remaining options are not Power Automate actions: rebooting a virtual machine (A) is an Azure or infrastructure operation not exposed as a standard flow action, compiling a C# program (D) requires a build toolchain such as the .NET compiler rather than a flow action, and designing a database schema (E) is a design-time data-modeling task, not a runtime flow action.

Answer

Reboot a virtual machine

Answer

Compile a C# program

Answer

Design a database schema

Question 8

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.. Option B is correct because 'Configure Run After' lets you define the run-after conditions on an action so that subsequent steps execute even when a prior action fails, times out, or is skipped, which is the standard way to build robust try/catch-style error handling in Power Automate. Option E is correct because enabling Secure Inputs and Secure Outputs on actions that process sensitive data (such as credentials, tokens, or personal information) prevents those values from appearing in the run history and flow logs, protecting them from unintended exposure. Option A is not a best practice because disabling logging removes the run history and diagnostic data needed to monitor, troubleshoot, and audit production flows, and logging is not the primary performance bottleneck. Option C is not a best practice because nesting 'Apply to each' loops multiplies iterations and can cause severe performance degradation or throttling; large datasets should instead be handled with pagination, filtering, batching, or the 'Select' and 'Filter array' operations. Option D is not a best practice because hardcoding connection references reduces portability and maintainability across environments; connections should be parameterized or managed through environment variables and solution-aware connection references.

Answer

Disable flow logging to improve performance.

Answer

Nest Apply to each actions to handle large datasets.

Answer

Hardcode connection references for simplicity.

Question 9

A company wants to automatically send an email notification when a new file is added to a SharePoint document library. Which type of trigger should be used in Power Automate?

Accepted Answer

A trigger. In Power Automate, a trigger is the event that starts a flow — for example, 'When a file is created in a folder' in SharePoint. The requirement is to start an automated process when a new file is added, which is precisely the definition of a trigger. The SharePoint connector provides a 'When a file is created (properties only)' trigger that fires on file creation in a document library.

Answer

A condition

Answer

A connector

Answer

An action

Question 10

A user wants to create a flow that automatically copies attachments from incoming Outlook emails to a OneDrive folder. Which trigger and action should be used?

Accepted Answer

'When a new email arrives' trigger and 'Create file' action. 'When a new email arrives' trigger initiates the flow for each incoming email, and the 'Create file' action can save attachments to a OneDrive folder. Option B is incorrect because 'Send an email' action would send an email, not create a file. Option C is incorrect because 'When an item is created' trigger is for SharePoint or similar, not for email. Option D is incorrect because 'When a file is created' trigger and 'Start an approval' action do not relate to copying email attachments.

Answer

'When a new email arrives' trigger and 'Send an email' action

Answer

'When an item is created' trigger and 'Create file' action

Answer

'When a file is created' trigger and 'Start an approval' action

Question 11

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Accepted Answer

Microsoft Teams. Microsoft Teams. The Microsoft Teams connector allows posting messages to Teams channels, which is exactly what the scenario requires. Option A (Outlook.com) is for personal email, not Teams. Option B (SharePoint) is for document management, not Teams messaging. Option C (Office 365 Outlook) is for email and calendar, not for posting to Teams channels.

Answer

Outlook.com

Answer

SharePoint

Answer

Office 365 Outlook

Question 12

A Power Automate flow processes hundreds of items daily. The flow sometimes fails due to service unavailability. Which feature should be used to automatically retry the failed action?

Accepted Answer

Enable retry policy on the action. Power Automate allows you to configure a retry policy on individual actions to automatically reattempt execution when a transient failure (such as service unavailability) occurs. This feature handles intermittent errors without manual intervention, improving flow reliability for high-volume processing.

Answer

Use a 'Scope' action

Answer

Add a 'Terminate' action

Answer

Configure a 'Configure run after' setting

Question 13

A user wants to create a flow that runs when a specific button is clicked in a mobile app. Which type of flow should be used?

Accepted Answer

Instant flow. An instant flow is triggered manually by a user action, such as clicking a button in a mobile app, and runs on demand. Power Automate provides a mobile app where users can trigger instant flows with a button, making it the correct flow type for this requirement. Instant flows are designed for manual initiation, unlike automated or scheduled flows.

Answer

Business process flow

Answer

Scheduled flow

Answer

Automated flow

Question 14

A flow uses a 'When an item is created' trigger for a SharePoint list. The flow needs to access the item's title and the user who created it. Which dynamic values should be used?

Accepted Answer

Title and Created By. The 'When an item is created' trigger for a SharePoint list exposes dynamic values that include the item's 'Title' field and the 'Created By' field, which contains the user who created the item. These are standard columns in a SharePoint list and are automatically available as dynamic content in Power Automate when the trigger fires.

Answer

Title and Modified By

Answer

ID and Modified By

Answer

Created By and Created By Email

Question 15

You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?

Accepted Answer

Schedule - Recurrence. The correct trigger for a flow that runs on a schedule (every Monday at 9 AM) is the 'Schedule - Recurrence' trigger. Option A ('When an item is created') is an event-based trigger that runs when an item is added to a list, not on a schedule. Option B ('Power Apps button') is a manual trigger that requires user interaction. Option D ('When a new email arrives') is an event-based trigger that runs when an email arrives. Therefore, only option C meets the requirement.

Answer

When an item is created

Answer

Power Apps button

Answer

When a new email arrives