PL-900 Practice Test 35 — 15 Questions

Question 1

A company uses Power BI to visualize sales data from Dynamics 365. The sales team needs to see real-time updates when a deal is closed. Which Power Platform component should be used to trigger a notification when a deal is won?

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

Accepted Answer

Power Automate flow. Power Automate can trigger a flow when a deal is won in Dynamics 365 (e.g., using the 'When a record is updated' trigger filtered to the 'Close Date' field or status change to 'Won'). The flow can then send a real-time notification (e.g., email, Teams message, or push notification) to the sales team, meeting the requirement for immediate updates without manual intervention.

Answer

Power BI real-time dashboard

Answer

Copilot Studio chatbot

Answer

Power Apps canvas app

Question 2

You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?

Accepted Answer

Filter(SharePointList, Email = User().Email). The User() function returns a record with the current user's details, including Email. Option A is incorrect because the Search function is used for searching text across multiple columns, not for filtering by exact match. Option B is incorrect because CurrentUser is not a valid function; the correct syntax is User().Email. Option D is incorrect because Lookup returns a single record, not a filtered set of records.

Answer

Search(SharePointList, User().Email, "Email")

Answer

Filter(SharePointList, Email = CurrentUser.Email)

Answer

Lookup(SharePointList, Email = User().Email)

Question 3

A model-driven app uses a business process flow to guide users through a sales process. The flow has multiple stages, and users complain that they can move to the next stage without completing required fields. What should the app maker do to enforce data entry?

Accepted Answer

Set the fields as required in the business process flow stage. Setting fields as required in the business process flow stage ensures they must be filled before progressing to the next stage. Option A is incorrect because setting fields as business required in the entity applies globally, not just within the flow, and would affect all forms and views. Option C is incorrect because validation rules apply to the field's data integrity, not to flow stage transitions. Option D is incorrect because making fields read-only would prevent data entry entirely, not enforce required completion.

Answer

Set the fields as business required in the entity

Answer

Add a validation rule on the entity fields

Answer

Make the fields read-only in the business process flow stage

Question 4

A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?

Accepted Answer

The users do not have permissions to the underlying SharePoint list. The most likely cause is that users do not have permissions to the underlying SharePoint list. When the app is accessed via Teams, the app runs in the context of the user, and SharePoint permissions are enforced. Even though the app works when opened directly from Power Apps (if the user has permissions), adding it to a Teams channel may expose users who lack access to the list. Option A is incorrect because licenses are per user and not specific to Teams; if users have Power Apps licenses, they can use the app. Option B is incorrect because the app works outside Teams, so the connector is not deprecated. Option D is incorrect because the SharePoint connector does not require a Premium license in Teams.

Answer

The users do not have Power Apps licenses assigned

Answer

The app uses a deprecated connector

Answer

The SharePoint connector requires a Premium license in Teams

Question 5

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

Question 6

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 7

Which tool is used to create and manage a Power Pages site from start to finish?

Accepted Answer

Power Pages design studio. Power Pages design studio is the primary tool used to create and manage a Power Pages site end-to-end. Option A is incorrect because Power Apps maker portal is used for building canvas and model-driven apps, not Power Pages. Option C is incorrect because although Visual Studio Code with Power Platform extension can be used for custom development, it is not the primary tool for creating and managing a Power Pages site from start to finish. Option D is incorrect because Power Automate portal is for automating workflows, not for Power Pages site management.

Answer

Power Apps maker portal

Answer

Visual Studio Code with Power Platform extension

Answer

Power Automate portal

Question 8

A Power Pages site needs to allow external users to register and create an account. The organization uses Microsoft Entra ID for internal employee authentication. Which identity provider should be configured for external user self-registration?

Accepted Answer

Local authentication. Local authentication in Power Pages allows external users to self-register with an email and password, which is stored in the portal's contact table. This is the standard approach for external self-registration. Option A (Microsoft Entra ID) is incorrect because it is primarily used for internal employee authentication, not for external self-registration. Option B (SAML 2.0) is an enterprise federation protocol designed for single sign-on with external identity providers, not for direct self-registration. Option C (OpenID Connect) is an authentication protocol, not an identity provider, and is typically used for SSO scenarios, not self-registration. Therefore, only local authentication supports built-in self-registration for external users.

Answer

Microsoft Entra ID

Answer

SAML 2.0

Answer

OpenID Connect

Question 9

Your organization uses Microsoft Teams for collaboration. You want to create a flow that sends a welcome message to a new member when they are added to a specific team. The flow should be triggered automatically without manual intervention. Which type of flow should you create?

Accepted Answer

Automated cloud flow. An automated cloud flow can use the 'When a new member is added to a team' trigger from Microsoft Teams connector. Instant flows require manual trigger. Scheduled flows run on a schedule. Desktop flows are for desktop automation.

Answer

Desktop flow

Answer

Scheduled cloud flow

Answer

Instant cloud flow

Question 10

Which THREE of the following are best practices for creating maintainable Power Automate flows?

Accepted Answer

Use solution-aware flows to manage application lifecycle. Option A is correct because solution-aware flows are packaged inside a Power Platform solution, which enables proper application lifecycle management (ALM) — moving flows across development, test, and production environments via managed/unmanaged solutions and export/import. Option C is correct because child flows (invoked via the 'Run a Child Flow' action) encapsulate reusable logic so it can be called from multiple parent flows, reducing duplication and centralizing maintenance. Option E is correct because renaming actions and steps descriptively (instead of leaving defaults like 'Apply to each') documents intent directly in the designer, making flows far easier for others to read and maintain. Option B does not belong because cramming complex expressions into a single action hurts readability and debugging; breaking logic into well-named, smaller actions is preferred. Option D does not belong because hardcoding values reduces maintainability and portability — environment variables or configuration should be used instead so values can change per environment without editing the flow.

Answer

Use complex expressions in a single action to reduce steps

Answer

Hardcode values directly in actions for clarity

Question 11

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

Accepted Answer

Dataverse. Option D, Dataverse, is correct because it is a cloud-hosted Microsoft Power Platform service that canvas apps connect to natively through the built-in Dataverse connector, so no on-premises data gateway is required. Option E, SharePoint Online, is correct because it is a Microsoft 365 cloud service accessed directly via the standard SharePoint connector in Power Apps, again without any gateway. Options A (on-premises SQL Server), B (on-premises Oracle Database), and C (on-premises SAP HANA) are all on-premises systems, so reaching them from a canvas app requires installing and configuring an on-premises data gateway to bridge the cloud service to the local network.

Answer

On-premises SQL Server

Answer

On-premises Oracle Database

Answer

On-premises SAP HANA

Question 12

You are a Power Automate developer for a large retail company. The company uses a SharePoint Online list named 'SalesOrders' to track orders. Each order has a Status column (choice: New, Processing, Shipped, Delivered). When an order is updated to 'Shipped', a flow should send an email with tracking info to the customer. Additionally, if the order amount exceeds $10,000, a manager must approve the shipment before the email is sent. You create a flow with a trigger 'When an item is modified' and add a condition to check if Status equals 'Shipped'. Inside the condition, you add an approval action. The flow currently sends the approval to the manager for all orders, even those under $10,000. You need to modify the flow so that orders under $10,000 skip the approval and directly send the email. What should you do?

Accepted Answer

Add a second condition inside the 'Status equals Shipped' condition that checks if amount exceeds $10,000; place the approval action inside this new condition, and the email action after it. It adds a nested condition inside the existing 'Status equals Shipped' condition to check if the order amount exceeds $10,000. The approval action is placed inside this nested condition (for orders over $10,000), while the email action is placed after the nested condition but still within the 'Status equals Shipped' condition. This ensures that only orders over $10,000 require manager approval, and all shipped orders (regardless of amount) eventually send the email—either directly (if under $10,000) or after approval (if over $10,000).

Answer

Modify the existing condition to check if amount exceeds $10,000, and if false, terminate the flow

Answer

Use a 'Switch' action based on the amount, with cases for >10000 and <=10000

Answer

Add a 'Parallel branch' after the trigger: one branch for approval, one for email

Question 13

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.. Enabling concurrency control on the 'Apply to each' action allows multiple iterations to run in parallel, significantly reducing total processing time. Option A adds a condition inside the loop, which does not improve performance and may even add overhead. Option B replaces the loop with a 'Do until' loop, which still processes items sequentially. Option D reduces the number of items, which is not always feasible and does not improve the flow's efficiency when processing large lists.

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 14

Which FIVE of the following are valid connectors in Power Automate? (Choose five.)

Accepted Answer

Google Drive. Google Drive (A) is a valid Power Automate connector, offering standard and premium actions such as creating files, uploading content, and triggering flows when files change. SQL Server (B) is a valid connector that lets flows run queries, insert rows, and invoke stored procedures against on-premises or Azure SQL databases. SharePoint (C) is a core Microsoft connector providing triggers and actions for lists, libraries, files, and items. Dropbox (D) is a valid connector for file operations like upload, copy, and delete, plus triggers on file creation. Outlook (E) is a valid connector (Outlook.com and Office 365 Outlook) for sending mail, managing calendar events, and triggering on new messages. No other options are listed, so there are no unmarked choices to exclude.

Question 15

A manufacturing company wants to use Power Platform to improve operational efficiency. Which TWO benefits of using Microsoft Power Platform are most relevant?

Accepted Answer

Build custom apps without extensive coding. Option C is correct because Power Apps provides a low-code/no-code development environment with drag-and-drop designers, prebuilt connectors, and Power Fx formulas, letting the manufacturing company build custom apps without extensive coding. Option E is correct because Power Automate enables the automation of business processes and workflows through cloud flows, approvals, and connectors to services like Dynamics 365 and SharePoint, directly improving operational efficiency. The unmarked options do not belong: Power Platform does not replace all third-party software (A), hardware inventory management is a specific use case rather than a general benefit and typically requires additional tooling (B), and Power Platform relies on Microsoft Entra ID authentication rather than eliminating it (D).

Answer

Replace the need for any third-party software

Answer

Automate hardware inventory management

Answer

Eliminate the need for user authentication