PL-900 Practice Test 38 — 15 Questions

Question 1

Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)

Accepted Answer

Assign the 'Help Desk Agents' security role to the help desk team. Option A is correct because assigning the 'Help Desk Agents' role to agents grants them edit permissions. Option C is correct because granting read privilege to the 'Employees' role allows view access. Option B is wrong because sharing the app does not control data permissions. Option D is wrong because business rules do not control security. Option E is wrong because creating a new table is unnecessary.

Answer

Create a new Dataverse table for ticket views

Answer

Create a business rule to restrict editing to certain users

Answer

Share the app with all employees using the Power Apps sharing feature

Question 2

A retail company is building a Power Apps canvas app for store managers to review sales performance. The app connects to a SQL database and displays real-time sales data. The managers need to be able to filter data by store and date range, and view the data in a chart. The company wants to minimize licensing costs while ensuring scalability and performance. Which TWO features should you recommend?

Accepted Answer

Create a SQL stored procedure to filter and aggregate data before sending to the app.. Option B (Power BI tile integration) allows embedding live reports and charts directly into the canvas app, providing robust filtering and visualization capabilities without additional licensing. Option D (Use a SQL stored procedure for data retrieval) improves performance and scalability by offloading complex queries to the database. Option A is incorrect because importing data into collections is not real-time. Option C is incorrect because Excel Online is not suitable for real-time SQL data integration. Option E is incorrect because custom connectors require additional development and licensing.

Answer

Build a custom connector to the SQL database for enhanced security.

Answer

Use Collect() to load all data into a collection on app start for offline access.

Answer

Use the Office365Users connector to retrieve sales data from Excel Online.

Question 3

Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)

Accepted Answer

Business rules to enforce data validation on forms.. Correct answers: A, C, E. Option A: Model-driven apps have a responsive UI. Option C: Business rules are supported. Option E: They provide a unified interface for tablets. Option B is wrong because camera control is not a standard feature; canvas apps have it. Option D is wrong because custom layout design is limited; model-driven apps use predefined forms and views.

Answer

Ability to design custom layouts using drag-and-drop.

Answer

Built-in camera control to capture images.

Question 4

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

Accepted Answer

Dataverse. Correct answers: A and C. Option A: SharePoint Online is cloud-based and does not require gateway. Option C: Dataverse is cloud-based. Option B: On-premises SQL Server requires a gateway. Option D: On-premises Oracle requires a gateway. Option E: Azure SQL Database is cloud-based but actually does not require a gateway; however, the question asks for TWO, and both A and C are correct. Azure SQL Database also does not require a gateway, but since we need exactly TWO, we choose A and C. However, note: Azure SQL Database also does not need a gateway, but the stem says 'without using a gateway', and Azure SQL is cloud. But the correct answer set should be A, C, E? Actually, the exam expects that cloud data sources like SharePoint, Dataverse, and Azure SQL do not need a gateway. But since we need exactly two correct, we pick A and C as the most common. I'll adjust: Option E also does not require gateway. But the question is designed to have exactly two correct. Let me change the options to ensure only two are correct. I'll modify: Option E: 'Azure SQL Database' is also cloud, so it would be a third correct answer. To fix, replace Option E with something that requires gateway, e.g., 'SAP HANA on-premises'. But I already set options. I'll keep as is and note that in the answer, only A and C are correct, and E is a distractor because it requires a gateway? Actually, Azure SQL Database does not require a gateway because it's cloud. So my question is flawed. Let me adjust: In the final JSON, I'll change option E to 'On-premises SAP HANA' to make it require a gateway. But I already wrote the explanation. I'll correct in the JSON output by changing option E text and explanation. In the JSON below, I'll set option E to 'On-premises SAP HANA' and mark it false. Also adjust explanation accordingly.

Answer

On-premises SQL Server

Answer

On-premises Oracle Database

Answer

On-premises SAP HANA

Question 5

You need to design a flow that runs when a new response is submitted in Microsoft Forms. The flow should send an email to the respondent with a summary of their answers. Which trigger should you use?

Accepted Answer

When a new response is submitted. The 'When a new response is submitted' trigger for Microsoft Forms is the correct trigger. Option B is for when a response is modified. Option C is for viewing responses. Option D is for editing responses.

Answer

When a response is viewed

Answer

When a response is edited

Answer

When a response is modified

Question 6

You are designing a Power Automate cloud flow that processes customer feedback from Microsoft Forms. The flow should send an email to the customer if their feedback rating is less than 3, and also post a message to a Microsoft Teams channel for all feedback. The flow works correctly for rating 2, but for rating 1 it sends two emails instead of one. What is the most likely cause?

Accepted Answer

The condition branch has two separate 'Send an email' actions that both run for rating 1.. Option C is correct because a common mistake is to use a 'Condition' action that evaluates 'Less than 3' which includes rating 1 and 2, but if the condition is not properly structured (e.g., two separate conditions or a parallel branch), it can cause duplicate actions. Option A is wrong because the trigger only fires once per submission. Option B is wrong because the Teams action does not affect email sending. Option D is wrong because the feedback rating is a number, not text.

Answer

The Teams action is configured to also send an email.

Answer

The flow is triggered multiple times due to multiple submissions.

Answer

The rating value is stored as text and the condition incorrectly compares numbers.

Question 7

You are creating a Power Automate flow to copy files from a SharePoint document library to a OneDrive for Business folder. The flow triggers when a new file is created in SharePoint. After saving the flow, you get a warning that the flow uses a trigger that is not supported in the 'Solutions' context. What does this mean?

Accepted Answer

The chosen trigger cannot be used in a solution-aware flow.. Option C is correct because the 'When a new file is created' trigger for SharePoint is not available in solution-aware flows (it is a non-solution trigger). Option A is wrong because the OneDrive action is supported. Option B is wrong because the flow can be created outside a solution. Option D is wrong because the warning indicates a limitation, not a full failure.

Answer

The OneDrive for Business connector is not licensed.

Answer

The flow cannot be saved outside a solution.

Answer

The flow will not run because of this warning.

Question 8

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. Options A and C are correct. Dataverse triggers include 'When a row is added, modified, or deleted' and 'When a row is added'. Options B and D are not Dataverse triggers; they are for SharePoint and Outlook. Option E is a manual trigger.

Answer

When a new email arrives (Outlook)

Answer

When a new file is created (SharePoint)

Answer

PowerApps button

Question 9

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). Option A is correct because 'When a user is added to a group' is a common trigger for new user scenarios, but more accurately, Microsoft Entra ID connector provides 'When a user is created' trigger. However, among the options, only option A is a valid trigger for user addition. Option B is wrong because 'When a file is created' is for SharePoint. Option C is wrong because 'When a record is created' is for Dataverse. Option D is wrong because 'When a new email arrives' is for mailboxes.

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 10

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 A and C are correct. Using 'Configure Run After' for error handling ensures robust flows. Storing credentials in Azure Key Vault and referencing them securely improves security. Option B is wrong because hardcoding values reduces maintainability. Option D is wrong because using Apply to each inside a loop can cause performance issues; better to use parallel branches. Option E is wrong because disabling logging hinders troubleshooting.

Answer

Disable flow logging to improve performance.

Answer

Nest Apply to each actions to handle large datasets.

Answer

Hardcode connection references for simplicity.

Question 11

A sales team uses Power Automate to create a lead in Dynamics 365 Sales when a new row is added to a Google Sheets spreadsheet. The flow fails with a 'Forbidden' error. What is the most likely cause?

Accepted Answer

The Google Sheets connection is not authenticated. Option C is correct because the error suggests authentication issues with the Google Sheets connection. Option A is less likely because the flow would fail at the trigger step, not after. Option B is incorrect because Google Sheets does not use Microsoft Entra ID. Option D is incorrect because the trigger is a new row event.

Answer

The Microsoft Entra ID token has expired

Answer

The SharePoint trigger is misconfigured

Answer

The Dynamics 365 action is invalid

Question 12

A Power Automate flow uses the 'Apply to each' action to process items from a SharePoint list. The flow is running slowly. What is the most effective way to improve performance?

Accepted Answer

Enable concurrency control on the 'Apply to each' action.. Option B is correct because concurrency control allows parallel processing. Option A reduces scope but not necessarily performance. Option C is not a built-in feature. Option D is for approval, not performance.

Answer

Add a 'Condition' action inside the loop.

Answer

Use a 'Do until' loop instead.

Answer

Reduce the number of items in the list.

Question 13

You have a Power Automate flow that monitors a SharePoint list for new items and then sends a custom email notification using the 'Send an email (V2)' action. The email includes an attachment from the SharePoint item. Some users report that the attachment is missing from the email. What should you check first?

Accepted Answer

Check if the flow includes a 'Get file content' action before the email action.. Option C is correct because the file content must be retrieved from SharePoint before sending. The 'Get file content' action is required to pass the binary data to the email action. Option A is wrong because the trigger is fine. Option B is wrong because permission to read the list does not guarantee access to the file. Option D is wrong because the email action itself is capable of attachments.

Answer

Verify that the flow trigger is set to 'When a new item is created'.

Answer

Ensure the SharePoint list has the correct permissions for the flow.

Answer

Change the email action to 'Send an email with options'.

Question 14

Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)

Accepted Answer

Use parallel branches for independent actions.. Options A and B are correct. Using 'Configure Run After' ensures proper error handling, and using parallel branches reduces latency for independent actions. Option C is wrong because actions run sequentially by default. Option D is wrong because using loops increases complexity and run time. Option E is wrong because approvals add overhead.

Answer

Set all actions to run sequentially to avoid conflicts.

Answer

Use 'Apply to each' loops for all list operations.

Answer

Add approval steps to all flows for accountability.

Question 15

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.. Option C is correct because adding pagination allows the flow to retrieve more rows per API call, reducing the number of requests and improving throughput. Option A is wrong because reducing the flow run frequency would only delay the issue, not fix timeout. Option B is wrong because increasing the timeout limit might mask the problem but doesn't address root cause. Option D is wrong because using an on-premises gateway is irrelevant for cloud-to-cloud operations.

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.