PL-900 Demonstrate the capabilities of Power Apps Practice Test 14 — 15 Questions

Question 1

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

Accepted Answer

Routing rule set. Routing rule set, is correct because routing rule sets automatically assign records to queues based on defined conditions such as case category. This feature is specifically designed for automatic queue assignment in model-driven apps. Option A (Workflow) runs background processes but does not handle queue assignment directly. Option B (SLA KPIs) tracks service level performance, not routing. Option D (Business process flow) guides users through a process but does not automatically assign cases to queues.

Answer

Workflow

Answer

SLA KPIs

Answer

Business process flow

Question 2

A canvas app uses a gallery to display records from a SharePoint list. The app loads slowly because the gallery is set to load all items. The list contains 10,000 items. What is the most efficient way to improve performance?

Accepted Answer

Add a search box and use a Delegation-compatible filter. Adding a search box with a Delegation-compatible filter allows Power Apps to push the filtering operation to the data source (SharePoint), retrieving only matching records instead of downloading all 10,000 items locally. This drastically improves performance. Option A is incorrect because the function is named `LoadData`, not `Variables.loadData`, and `LoadData` loads data from a local cache, not from a datasource efficiently. Option C is incorrect because setting the gallery's Items property to 'None' results in an empty gallery, which does not solve the performance problem. Option D is incorrect because `ClearCollect` loads all 10,000 items into a collection on the client side, causing the same slow performance as loading all items directly.

Answer

Use the Variables.loadData function

Answer

Set the gallery's Items property to 'None'

Answer

Use ClearCollect to load all items into a collection

Question 3

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

Accepted Answer

Add a quick view form for the Account entity. A quick view form displays related data from the lookup entity (Account) directly on the Project form without storing duplicate fields. Option A is incorrect because calculated fields only compute values from existing fields within the same entity, not from related entities. Option B is incorrect because creating a new main form for the Project entity does not automatically show related Account fields. Option C is incorrect because adding account fields directly to the Project entity would duplicate data and violate normalization.

Answer

Use a calculated field on the Project entity

Answer

Create a new main form for the Project entity

Answer

Add the account fields directly to the Project entity

Question 4

A sales manager wants a mobile app to view customer details and open orders. The app should be built quickly without custom code. Which approach should they use?

Accepted Answer

Create a model-driven app from Dataverse. A model-driven app built from Dataverse (formerly Common Data Service) is the best choice because it is generated automatically from the data model, requiring minimal customization and no custom code. This allows the sales manager to quickly create a mobile app that displays customer details and open orders. Canvas apps (B) require manual design and custom code. Power BI (C) is for analytics dashboards, not interactive apps. Power Automate (D) is for workflow automation, not app creation.

Answer

Build a canvas app from scratch

Answer

Use Power BI to create a mobile dashboard

Answer

Use Power Automate to create a mobile flow

Question 5

A canvas app uses a SharePoint list with a choice column 'Status' (Pending, Approved, Rejected). The app needs to filter the gallery to show only 'Pending' items. The list has 50,000 items. Why does the filter not work as expected?

Accepted Answer

The choice column is non-delegable in Power Apps. SharePoint choice columns are non-delegable in Power Apps. When filtering a gallery with a choice column, the filter is applied locally, which fails to return all items when the list exceeds the delegation limit (default 500 items). This explains why filtering for 'Pending' does not work as expected with 50,000 items. Option A is incorrect because the issue is delegation, not the column type itself (choice columns are delegable for some operations but not for filters with '='). Option B is incorrect because the gallery's Items property is set using the Filter function; the problem is that Filter is non-delegable for choice columns. Option D is incorrect because the syntax is not the issue; the formula may be syntactically correct but still fails due to non-delegable filter.

Answer

The column is not a single line of text

Answer

The gallery's Items property is set to 'Filter' incorrectly

Answer

The filter formula uses the wrong syntax

Question 6

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

Accepted Answer

Power Apps portal. Power Apps portals (now Power Pages) are specifically designed to create external-facing websites that allow external users, such as partners, to interact with Dataverse data through a web interface. Canvas apps and model-driven apps are intended for internal users, while Power Virtual Agents is for chatbots.

Answer

Canvas app

Answer

Power Virtual Agents bot

Answer

Model-driven app

Question 7

Which TWO actions can be performed using Power Apps? (Choose two.)

Accepted Answer

Create a custom mobile app that connects to SharePoint. Options A and E are correct. Power Apps allows you to create custom mobile apps that connect to various data sources, including SharePoint, and to embed canvas apps into Microsoft Teams. Option B is incorrect because creating dashboards with visualizations from multiple data sources is a capability of Power BI, not Power Apps. Option C is incorrect because building a chatbot to answer customer questions is a capability of Power Virtual Agents, not Power Apps. Option D is incorrect because automating a workflow when a new email arrives is a capability of Power Automate, not Power Apps.

Answer

Create a dashboard with visualizations from multiple data sources

Answer

Build a chatbot to answer customer questions

Answer

Automate a workflow when a new email arrives

Question 8

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

Accepted Answer

Form. In a model-driven app, Forms (C) provide the data entry interface, Dashboards (D) offer visual overviews of key metrics, and Business process flows (E) guide users through a defined process. Galleries (A) are components of canvas apps, not model-driven apps. Cloud flows (B) are automation tools in Power Automate and not part of the app UI.

Answer

Gallery

Answer

Cloud flow

Question 9

Which TWO data sources can be used with a canvas app? (Choose two.)

Accepted Answer

SharePoint list. SharePoint lists and Microsoft Dataverse are both valid data sources for canvas apps. SharePoint lists allow you to read and write data from SharePoint. Microsoft Dataverse is a scalable data platform that stores business data. The other options are not data sources: Microsoft Power Platform is the product family, Microsoft Teams is a collaboration app, and Power Automate is an automation service.

Answer

Microsoft Power Platform

Answer

Microsoft Teams

Answer

Power Automate

Question 10

Refer to the exhibit. The JSON describes a Power Apps function. What is the correct usage of this function to return a date 7 days from today?

Accepted Answer

AddDays(Today(), 7). The AddDays function in Power Apps (Power Fx) uses the syntax AddDays(DateTime, NumberOfDays). So AddDays(Today(), 7) returns the date 7 days from today. Option A uses a semicolon and has the arguments reversed. Option C also reverses the arguments (days first, then date). Option D uses a string for the number of days, which is invalid.

Answer

AddDays(7; Today())

Answer

AddDays(7, Today())

Answer

AddDays('7', Today())

Question 11

Refer to the exhibit. An ARM template is used to deploy a connection. What is the purpose of this resource?

Accepted Answer

Create a SharePoint Online API connection for Power Apps. The resource type 'Microsoft.Web/connections' creates an API connection. In this context, it is used to create a SharePoint Online API connection for Power Apps. Option C is correct. Option A is incorrect because it does not create a Power App; it creates a connection. Option B is incorrect because it does not create a Dataverse environment. Option D is incorrect because it does not deploy a SharePoint list; it creates an API connection.

Answer

Create a new Power App

Answer

Create a Dataverse environment

Answer

Deploy a SharePoint list

Question 12

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

Accepted Answer

Filter(Accounts, Status = 'Active'). The Filter function in Power Apps takes the data source as the first argument and a formula as the second argument. Option B correctly uses Filter(Accounts, Status = 'Active'). Option A is incorrect because 'Active' alone is not a valid formula. Option C has the arguments reversed. Option D has the formula as the first argument and the source as the second, which is invalid.

Answer

Filter(Accounts, 'Active')

Answer

Filter('Active', Accounts)

Answer

Filter(Status = 'Active', Accounts)

Question 13

A company uses Power Apps to build a leave request app. Managers must approve requests only if the employee has sufficient leave balance. Which approach ensures the balance is checked before submission?

Accepted Answer

Use the SubmitForm function with a validation formula checking leave balance. The SubmitForm function in Power Apps can include a validation formula in the Items property or via the OnSelect property to check the leave balance before the form is submitted, preventing submission if the balance is insufficient. Option A is wrong because Power BI is for analytics, not validation. Option C is wrong while it can auto-reject, it does not prevent submission, and the requirement is to check before submission. Option D is wrong because foreign key constraints in Dataverse cannot dynamically check leave balance based on current data.

Answer

Create a Power BI report to visualize leave balances and have managers manually check

Answer

Configure a Power Automate flow to check balance after submission and auto-reject if insufficient

Answer

Set a foreign key constraint in Dataverse to limit leave requests based on balance

Question 14

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

Accepted Answer

Use delegable filters like Filter() with indexed columns to limit data retrieved. Delegable filters such as Filter() with indexed columns allow Power Apps to push filtering to the data source (SharePoint), reducing the amount of data retrieved and improving performance. Option A is incorrect because reducing columns has minimal impact on the amount of data loaded, and delegable queries are more effective. Option B is incorrect because increasing the data row limit for non-delegable queries only affects the number of records displayed, not the data retrieved from SharePoint; the query still fetches all 10,000 items. Option C is incorrect because moving to SQL and using Power Automate introduces additional complexity and potential latency, and is not the most direct optimization for a SharePoint data source.

Answer

Reduce the number of columns in the SharePoint list

Answer

Increase the data row limit for non-delegable queries to 2000

Answer

Move the data to a SQL database and connect via Power Automate

Question 15

A company has a Power Apps model-driven app for sales. Sales reps need to see their assigned leads only. Which security feature should be configured?

Accepted Answer

Assign security roles that filter leads by owner. Security roles with 'User' access level on the Lead entity filter records so that users see only records they own. This is the appropriate method to restrict leads by assigned owner in a model-driven app. Option B is incorrect because field-level security controls read/write permissions on a specific field (like 'Assigned To'), not which records are visible. It does not filter the list of records. Option A is incorrect because business unit security isolates data at the business unit level, not per user. Option D is incorrect because sharing the app grants access to the app but does not filter the underlying data.

Answer

Configure business unit security to isolate each rep's data

Answer

Use field-level security to set permissions on the 'Assigned To' field

Answer

Share the app with each rep individually