PL-900 Practice Test 40 — 15 Questions

Question 1

Refer to the exhibit. A flow is triggered when an email with 'Invoice' in the subject arrives, and it saves the first attachment to a SharePoint document library. However, the flow fails with an error 'InvalidTemplate'. What is the most likely cause?

Accepted Answer

An email with 'Invoice' in the subject arrives without an attachment.. The trigger includes attachments, but if an email with 'Invoice' in the subject arrives without an attachment, the expression to access the first attachment fails because the attachments array is empty. The error 'InvalidTemplate' occurs when an expression cannot be evaluated. Option A is incorrect because the trigger is configured to include attachments. Option C is incorrect because the folder path is valid. Option D is incorrect because the file name is taken from the attachment, not the subject.

Answer

The SharePoint folder path is incorrect.

Answer

The trigger is not set to include attachments.

Answer

The file name is taken from the email subject instead of the attachment.

Question 2

A company wants to automate the process of archiving completed sales orders from a SQL Server database to a SharePoint list every night. Which approach should they use?

Accepted Answer

Use a SQL Server connector with a 'Recurrence' trigger to query and move data.. Using a SQL Server connector with a recurrence trigger is the appropriate approach for querying a database on a schedule. Option A is event-driven and not scheduled. Option C is for approval, not data movement. Option D is for real-time streaming, not batch processing.

Answer

Use a 'When an item is created' trigger on the SQL table.

Answer

Create an instant flow triggered by a Power Apps button for manual archiving.

Answer

Use a 'When a HTTP request is received' trigger from an external scheduler.

Question 3

A manufacturing company uses Power Automate to monitor equipment sensors. When a temperature sensor exceeds a threshold, a flow sends an alert to the maintenance team. However, duplicate alerts are being sent for the same event. What should the flow developer implement to prevent duplicates?

Accepted Answer

Use a 'When an HTTP request is received' trigger and check for a unique identifier.. Using a 'Cooldown' or 'Debounce' pattern with a variable or a data operation can prevent duplicate triggers. The trigger for HTTP request can receive the same event multiple times if the sensor resends. Option A would delay all alerts, not prevent duplicates. Option B would not prevent duplicates because the trigger fires for each HTTP request. Option D is not a built-in feature and would require custom logic.

Answer

Use the 'Get changes' action for the sensor data.

Answer

Increase the threshold value so alerts are less frequent.

Answer

Add a 'Delay' action of 5 minutes before sending the alert.

Question 4

Your Power Automate flow uses an HTTP action to call a REST API. The API returns a JSON array of objects. You need to process each object and create a record in a SQL Server database. Which actions should you use?

Accepted Answer

Use 'Parse JSON' to define the schema, then 'Apply to each' with 'Insert row' inside.. First, parse the JSON to define the schema, then use 'Apply to each' to iterate over the array, and inside the loop use 'Insert row' to create SQL records. Option A is missing the parse step. Option C uses 'Filter array' which is for filtering, not iteration. Option D is missing the loop.

Answer

Use 'Filter array' to select objects, then 'Insert row'.

Answer

Use 'Compose' to store the JSON, then 'Insert row' directly.

Answer

Use 'Select' to transform the array, then 'Insert row' with a batch.

Question 5

A company uses Power Automate to process incoming emails. Some emails need to be forwarded to a manager, while others need to be saved to SharePoint. The decision is based on the email subject. Which action should be used to implement the branching logic?

Accepted Answer

Condition. The 'Condition' action allows branching based on expressions. Option A is for iteration. Option B is for switching based on multiple values. Option C is for data transformation. Option D is not a flow action.

Answer

Switch

Answer

Compose

Answer

Select

Answer

Apply to each

Question 6

A Power Automate flow sends an approval request to a user's manager. The flow uses the 'Get manager' action from the Office 365 Users connector. The flow runs successfully but the approval is never received by the manager. What is the most likely reason?

Accepted Answer

The manager does not have a valid email mailbox.. Option B is correct because the 'Get manager' action returns the manager's email address, but if the manager's mailbox is not enabled (e.g., a distribution group or shared mailbox), the approval email will not be delivered. Option A is wrong because the flow succeeds so the manager is found. Option C is wrong because approvals are sent via email. Option D is wrong because the flow uses the correct connector.

Answer

The Office 365 Users connector is not properly configured.

Answer

The approval action is configured to use the Teams channel instead of email.

Answer

The manager's user profile is missing in Microsoft Entra ID.

Question 7

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.. Option D is correct because the trigger parameters include 'importance': 'High', so only emails with high importance trigger the flow. If the email has attachments but is not high importance, the flow will not trigger. Option A is wrong because the trigger is for new emails. Option B is wrong because attachments are set to 'true', so they are required. Option C is wrong because the folder path is 'Inbox'.

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 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). Option B is correct because the operationId is 'SendEmail' and the host connection is 'shared_office365', which corresponds to the Office 365 Outlook Send an email action. Option A is wrong because 'Post a message' would use a different operationId. Option C is wrong because 'Create event' would have different parameters. Option D is wrong because 'Send an HTTP request' would use 'Http' connection type.

Answer

Post a message in Microsoft Teams

Answer

Create a calendar event

Answer

Send an HTTP request

Question 9

Refer to the exhibit. The Power Automate flow definition includes a manual trigger expecting employeeId and amount. If an expense amount is $6,000, what will happen?

Accepted Answer

The flow will start an approval assigned to manager@contoso.com.. Option C is correct because the condition checks if amount > 5000; 6000 is greater, so the 'Send_approval' action runs. Option A is wrong because the flow does not check employeeId. Option B is wrong because the else branch won't run. Option D is wrong because the trigger schema does not define managerEmail.

Answer

The flow will send an approval email to the employee.

Answer

The flow will fail because employeeId is missing.

Answer

The flow will send an email to manager@contoso.com.

Question 10

You need to create a Power Automate flow that sends a daily digest email to the sales team summarizing new leads from the previous day. The flow should run automatically every morning at 8 AM. Which type of trigger should you use?

Accepted Answer

Recurrence. Option A is correct because the 'Recurrence' trigger runs on a schedule. Option B is wrong because it triggers on new email, not time. Option C is wrong because it triggers on new tweets, not time. Option D is wrong because manual triggers require user interaction.

Answer

Button trigger

Answer

When a new email arrives

Answer

When a new tweet is posted

Question 11

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.. Option B is correct because the condition expression uses 'greater(triggerBody()?['score'], 0.8)' but if the 'score' property is a string (e.g., '0.9'), the comparison will fail because string comparison is different from numeric. The expression expects a number. Option A is wrong because the trigger is manual, not SharePoint. Option C is wrong because the condition is correct syntactically. Option D is wrong because the condition uses 'greater' which is 'greater than'.

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 12

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

Accepted Answer

Create a record (Dataverse). Options A and C are correct. 'Send an email' is a standard action via Office 365 Outlook connector. 'Create a record' is common in Dataverse or SharePoint. Option B is wrong because 'Compile a program' is not a Power Automate action. Option D is wrong because 'Reboot a server' is not a built-in action (would require custom connector). Option E is wrong because 'Design a database' is not a flow action.

Answer

Reboot a virtual machine

Answer

Compile a C# program

Answer

Design a database schema

Question 13

You need to design a Power Automate flow that sends an approval request to a manager when an employee submits a leave request in SharePoint. The flow should check if the manager is on leave and, if so, escalate to the next-level manager. What is the best approach to implement this escalation logic?

Accepted Answer

Use a 'Condition' action to check if the manager is on leave, then if true, send the request to the next-level manager.. Option A is correct because a 'Condition' action allows checking manager status and escalating. Option B is wrong because parallel branches do not handle sequential escalation. Option C is wrong because 'Apply to each' is for iterating over a list, not checking a single manager. Option D is wrong because 'Scope' is for grouping actions, not conditional logic.

Answer

Use an 'Apply to each' action to iterate over an array of managers.

Answer

Use a 'Scope' action to group the escalation steps.

Answer

Use parallel branches to send the request to both the manager and next-level manager simultaneously.

Question 14

Which THREE of the following are valid connectors in Power Automate?

Accepted Answer

Microsoft Teams. Options A, B, and E are valid connectors. Option C is wrong because 'Google Drive' is not a standard connector (though third-party exists). Option D is wrong because 'Microsoft Excel' is not a connector; it's a file format.

Answer

Google Drive

Answer

Microsoft Excel

Question 15

You need to design a Power Automate flow that triggers when a specific file is added to a SharePoint document library. Which trigger should you use?

Accepted Answer

When a file is created (properties only). Option A is correct because 'When a file is created (properties only)' triggers on new file creation. Option B is wrong because that trigger is for modification. Option C is wrong because it requires manual execution. Option D is wrong because it's for shared files.

Answer

When a file is shared

Answer

When a file is modified

Answer

For a selected file (manual trigger)

PL-900 Practice Test 40 — 15 Questions

Exhibit

PL-900 Practice Test 40 — 15 Questions

Exhibit