PL-900 Practice Test 20 — 15 Questions

Question 1

A company uses Power Apps to manage employee leave requests. They want to automate the approval process so that managers receive an email when a request is submitted. Which component should they add?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that trigger actions based on events. In this scenario, when a leave request is submitted in Power Apps, a Power Automate flow can be configured to send an email notification to the manager, automating the approval process without manual intervention.

Answer

Power BI

Answer

AI Builder

Answer

Power Virtual Agents

Question 2

You are designing a Power Automate flow to approve expense reports. The flow must allow managers to approve or reject directly from the email notification without signing in. Which action should you use?

Accepted Answer

Start and wait for an approval. The 'Start and wait for an approval' action is specifically designed to send an approval request via email or the Power Automate mobile app, and it allows recipients to approve or reject directly from the email notification without needing to sign in, using adaptive cards or lightweight approval buttons. This meets the requirement for manager approval without authentication.

Answer

Create a file

Answer

Send an email (V2)

Answer

Send an HTTP request

Question 3

Which THREE of the following are capabilities of Power Apps?

Accepted Answer

Use AI Builder to add artificial intelligence. Power Apps is a low-code application development platform, and option C is correct because it natively integrates with AI Builder, allowing makers to add prebuilt or custom AI models (such as form processing, object detection, and prediction) directly into canvas and model-driven apps. Option D is correct because Power Apps provides hundreds of built-in connectors, including standard connectors to Microsoft 365 services like SharePoint lists/libraries and Outlook (mail, calendar, contacts), enabling apps to read and write that data without custom code. Option E is correct because Power Apps ships Power Apps Mobile for iOS and Android plus the Power Apps app for Windows, so the same app runs on those mobile devices. Option A does not belong because complex, multi-step workflow automation is the role of Power Automate, not Power Apps itself. Option B does not belong because real-time streaming analytics is handled by Azure Stream Analytics (or Power BI streaming datasets), not by Power Apps.

Answer

Create complex workflow automations

Answer

Perform real-time streaming analytics

Question 4

You are creating a flow that should run only when a button is pressed in a mobile app. The flow will send an email to a manager with the current location of the user. Which type of flow should you create?

Accepted Answer

Instant cloud flow. An instant cloud flow is triggered manually by a user action, such as pressing a button in a mobile app. It runs immediately upon trigger and is ideal for scenarios where the flow should execute on demand, like sending an email with the current location. This matches the requirement exactly.

Answer

Scheduled cloud flow

Answer

Automated cloud flow

Answer

Desktop flow

Question 5

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.. The cleanest way to implement conditional escalation in Power Automate is a 'Condition' action that evaluates whether the manager is on leave (e.g., by checking a SharePoint list, Dataverse table, or Outlook calendar) and, if true, routes the approval to the next-level manager. This keeps the logic explicit, readable, and easy to maintain within a single flow.

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 6

A global organization wants to standardize expense reporting across subsidiaries using Power Platform. They require integration with Microsoft Entra ID for identity and must ensure data residency compliance. Which TWO capabilities should they use?

Accepted Answer

Dataverse environments with specific regions. Dataverse environments can be created in specific geographic regions to ensure data residency compliance by storing data at rest within that region. Integration with Microsoft Entra ID is inherent to Dataverse, which uses Entra ID as its identity provider for authentication and authorization, meeting the requirement for standardized identity management across subsidiaries. Additionally, Data Loss Prevention (DLP) policies enforce data residency by restricting data sharing across connectors and preventing data from leaving the designated region, ensuring compliance with regulatory requirements.

Answer

AI Builder

Answer

Power BI dashboards

Answer

Copilot Studio

Question 7

Which THREE components are part of a model-driven app in Power Apps? (Choose three.)

Accepted Answer

Views. In a model-driven app, the core building blocks are defined by the data model and the Dataverse metadata, so Tables (C) are correct because they define the entities, columns, and relationships that store the app's data. Views (B) are correct because they are saved queries that determine how records from a table are listed and filtered in the app's navigation. Forms (D) are correct because they define the layout and fields used to create, view, and edit records in a model-driven app. Galleries (A) and Screens (E) are not part of model-driven apps; they are canvas app controls and containers used to build pixel-perfect, free-form layouts.

Answer

Galleries

Answer

Screens

Question 8

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

Accepted Answer

Use delegable queries to filter data at the source. Using delegable queries to filter data at the source reduces the amount of data retrieved from the data source, which significantly improves performance. When queries are delegable, the filtering and sorting are performed by the data source (e.g., SQL, SharePoint) rather than in Power Apps, minimizing data transfer and processing. This is especially important with many data sources and complex formulas.

Answer

Increase the data row limit for each data source

Answer

Disable the formula-level error checking

Answer

Remove unused data sources from the app

Question 9

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

Accepted Answer

They have built-in role-based security. Option B is correct because model-driven apps inherit the role-based security model of Microsoft Dataverse, where access is governed by security roles, teams, business units, and record-level sharing rather than custom code. Option C is correct because model-driven apps are built directly on Microsoft Dataverse, using its tables, relationships, and metadata to define the app's data model and behavior. Option D is correct because model-driven apps use the Unified Interface, which is responsive and adapts to different screen sizes, so they work across desktop, tablet, and mobile devices. Option A is incorrect because model-driven apps rely on declarative configuration such as business rules, workflows, and Power Automate flows rather than custom formulas for business logic. Option E is incorrect because model-driven apps are also available through the Power Apps mobile app on iOS and Android, not only in web browsers.

Answer

They require custom formulas for business logic

Answer

They can only be used on web browsers

Question 10

Which THREE actions can be performed in the Power Query Editor?

Accepted Answer

Change data types. In the Power Query Editor, option B (Change data types) is correct because the Transform and Add Column tabs provide data type commands (e.g., Text, Whole Number, Date) that let you convert a column's type as part of shaping the data. Option C (Merge queries) is correct because the Home tab's Merge Queries feature performs a join between two queries using a common column, similar to a SQL JOIN. Option D (Remove columns) is correct because the Home tab offers Remove Columns and Remove Other Columns to drop unneeded fields during transformation. Option A (Create measures) is not available in Power Query Editor; DAX measures are created in the Power BI report/Data view or in a Power Pivot model. Option E (Create relationships between tables) is also not done in Power Query Editor; relationships are defined in the model view (Power BI) or the Data Model (Excel Power Pivot).

Answer

Create measures

Answer

Create relationships between tables

Question 11

In a Power Apps canvas app, the App.OnStart property contains the code above. The LookUp function returns blank for a user who exists in the Roles data source. What is the most likely cause?

Accepted Answer

The Roles data source column name does not match 'UserEmail'.. The LookUp function in Power Apps relies on exact column name matching. If the Roles data source has a column named 'Email' or 'UserID' instead of 'UserEmail', the function will not find a match and will return blank, even if the user exists. This is a common schema mismatch issue in canvas apps.

Answer

The app needs to refresh the Roles data source first.

Answer

The Set function cannot store records.

Answer

The User() function is not available in Power Apps.

Question 12

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

Accepted Answer

Use a gallery to list orders and navigate to a detail screen on selection. The gallery control is the standard Power Apps pattern for displaying a list of records from a data source, and its OnSelect property can navigate to a detail screen while passing the selected record's context. This approach is efficient because it uses a single reusable detail screen that dynamically displays the selected order, avoiding duplication. It also leverages built-in delegation and performance optimizations for large datasets when configured correctly.

Answer

Use a data table connected directly to the data source

Answer

Use a single form with navigation buttons to move between orders

Answer

Export the data to Excel and use Power Apps to display the Excel file

Question 13

A company wants to allow external users to access a Power Pages site without requiring them to sign in. Which authentication setting should be configured?

Accepted Answer

Enable anonymous access in the site settings. Enabling anonymous access in the site settings allows users to browse the Power Pages site without signing in. Option A is incorrect because configuring Microsoft Entra ID as the identity provider requires authentication. Option B is incorrect because local authentication also requires sign-in. Option D is incorrect because creating a web role for everyone still requires authentication; web roles are for authorization after authentication.

Answer

Configure Microsoft Entra ID as the identity provider

Answer

Set up local authentication with username and password

Answer

Create a web role that grants access to everyone

Question 14

A business analyst wants to create a simple app to track employee vacation requests without writing code. Which type of Power App should they use?

Accepted Answer

Canvas app from a template. Canvas apps from templates provide a low-code or no-code way to build apps with a drag-and-drop interface, ideal for simple tasks like tracking vacation requests. Option A is wrong: Power Pages is for building external-facing websites, not internal apps. Option B is wrong: Model-driven apps are more complex and rely on Dataverse, requiring more structure than needed. Option D is wrong: Power Automate is for automating workflows, not for building interactive apps.

Answer

Power Pages site

Answer

Model-driven app

Answer

Power Automate flow

Question 15

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for data visualization and business analytics, capable of connecting directly to a SQL database to create real-time dashboards. It supports DirectQuery or live connections to SQL Server, enabling near-real-time updates without requiring data to be imported into a separate store.

Answer

Power Apps

Answer

Power Automate

Answer

AI Builder