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

Question 1

A user reports that a canvas app is loading slowly on mobile devices. The app uses multiple galleries with large data sources. What is the most effective optimization to improve performance?

Accepted Answer

Use delegable queries to filter data server-side. Delegable queries reduce the data loaded into the app. Option A is wrong as it increases load. Option B is wrong as it adds overhead. Option D is wrong as it moves data, not optimize.

Answer

Increase the number of columns in the data source

Answer

Migrate from SharePoint to Excel Online

Answer

Add multiple nested galleries

Question 2

Your organization uses Power Apps and Power Automate to manage a vendor onboarding process. The app must send an email notification to the compliance team when a high-risk vendor is added. The compliance team resides in a different Microsoft Entra ID tenant. Which approach should you use?

Accepted Answer

Use the HTTP connector with a custom API. The HTTP connector can send email to external recipients without sharing a mailbox. Option A is wrong because Dataverse connectors are tenant-scoped. Option B is wrong because Outlook connector requires shared mailbox or user credentials. Option C is wrong because Teams connector is for internal users.

Answer

Use the Outlook 365 connector with a shared mailbox

Answer

Use the Dataverse connector with a custom action

Answer

Use the Microsoft Teams connector to post a message

Question 3

Which THREE components are required to build a model-driven app in Power Apps? (Choose three.)

Accepted Answer

View. Option C (Microsoft Dataverse database) is correct because a model-driven app is fundamentally built on Dataverse, which provides the data platform, security model, and metadata that drive the app's UI generation. Option B (Table/entity) is correct because tables define the data schema and records that the model-driven app renders through forms, views, and dashboards. Option A (View) is correct because views are required components that define how table records are filtered, sorted, and displayed within the model-driven app's navigation and grids. Option D (Canvas app component) is incorrect because canvas apps are a separate Power Apps app type with a pixel-based designer, not a required component of model-driven apps. Option E (Power Automate flow) is incorrect because flows are optional automation that can be added to a model-driven app but are not a required building component.

Answer

Canvas app component

Answer

Power Automate flow

Question 4

You need to share a canvas app with all users in a specific Microsoft Entra ID group. The app connects to a SharePoint list. Which step is required to ensure users can access the app and data?

Accepted Answer

Share the app with the group and ensure the group has access to the SharePoint list. Sharing a canvas app requires both app-level sharing (via Power Apps) and ensuring the group has permissions to the underlying data source (SharePoint list). Option A is incorrect because adding users as co-owners gives them edit access to the app, but they still need data access; co-ownership is not required for usage. Option B is incorrect because a Power Automate flow is not necessary; app permissions and data source permissions are the only requirements. Option D is incorrect because granting Can Use permission only allows users to run the app, but they cannot access the SharePoint list data unless the group also has permissions to the list.

Answer

Add users as co-owners of the app

Answer

Create a Power Automate flow to grant access

Answer

Share the app with the group and grant Can Use permission

Question 5

Which TWO features are unique to model-driven apps compared to canvas apps? (Choose two.)

Accepted Answer

Business process flows. Business process flows (B) are unique to model-driven apps because they are built on the Common Data Service/Dataverse entity model and guide users through defined stages tied to table columns, a capability not natively available in canvas apps. Responsive design that adapts to screen size (C) is also unique to model-driven apps, as their UI is generated from the data model and automatically renders responsively across devices, whereas canvas apps require the maker to manually design for each form factor. Custom controls from Microsoft AppSource (A) are not unique, since both canvas and model-driven apps can use them. Power Fx formulas (D) are the native formula language of canvas apps, not a model-driven app feature. Offline capability (E) is not unique to model-driven apps and is typically associated with canvas apps via Power Apps mobile offline.

Answer

Custom controls from Microsoft AppSource

Answer

Power Fx formulas

Answer

Offline capability

Question 6

You are creating a canvas app for expense reporting. The app must allow managers to approve or reject expenses using a dropdown. Which control should you use for the approval action?

Accepted Answer

Dropdown. A dropdown is ideal for selecting from a short list. Option A is wrong because radio buttons are better for 2-3 options. Option C is wrong because text input is for free text. Option D is wrong because slider is for numeric ranges.

Answer

Radio button

Answer

Text input

Answer

Slider

Question 7

Which THREE are valid ways to embed a canvas app in another application? (Choose three.)

Accepted Answer

Embed in a SharePoint page using the Power Apps web part. Option A is correct because the Power Apps web part for SharePoint pages is a first-party, supported method for embedding a canvas app directly into a SharePoint Online page. Option C is correct because Power BI allows a canvas app to be added as a custom visual within a report, enabling app interaction alongside report data. Option D is correct because Microsoft Teams supports adding a canvas app as a tab, which is a standard embedding scenario for Power Apps. Option B is not a supported embedding method because Excel custom add-ins are not a documented Power Apps canvas app embedding path. Option E is not a valid embedding method because Dynamics 365 Sales Hub does not provide a native canvas app embedding feature; model-driven apps are the relevant app type there.

Answer

Embed in Microsoft Excel using a custom add-in

Answer

Embed in Dynamics 365 Sales Hub

Question 8

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 pushes the filtering to SharePoint so only matching records are retrieved, rather than loading all 10,000 items into the gallery. Delegation ensures the query is executed server-side, dramatically reducing load time and memory usage.

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 9

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 on Dataverse provides rapid, no-code creation of forms, views, and navigation for mobile use, with responsive layouts out of the box. It is the recommended approach when the data model is well-defined and the goal is fast delivery without custom code.

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 10

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 11

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

Accepted Answer

Create a custom mobile app that connects to SharePoint. Option A is correct because Power Apps is a low-code platform for building custom apps, and its SharePoint connector lets a canvas or model-driven app read and write SharePoint lists directly, making a custom mobile app connected to SharePoint a standard Power Apps scenario. Option E is correct because canvas apps can be published and embedded as tabs or personal apps in Microsoft Teams via the Power Apps app for Teams, so users interact with the app inside Teams. Option B is not a Power Apps action: multi-source dashboards with visualizations are built in Power BI. Option C is not a Power Apps action: chatbots are created with Microsoft Copilot Studio (formerly Power Virtual Agents). Option D is not a Power Apps action: event-driven workflow automation is handled by Power Automate.

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 12

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

Accepted Answer

Form. In Power Apps, a model-driven app is composed of components defined in the app designer, and Form (C) is a core component because it defines the data-entry and display layout for a table's records. Dashboard (D) is also a valid model-driven app component, as dashboards can be added to the app to present charts and views of table data. Business process flow (E) is correct because business process flows are added to model-driven apps to guide users through a defined sequence of stages and steps. Gallery (A) is incorrect because galleries are a control used in canvas apps, not a model-driven app component. Cloud flow (B) is incorrect because cloud flows are Power Automate resources that can be triggered from an app but are not themselves a component of a model-driven app.

Answer

Gallery

Answer

Cloud flow

Question 13

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 ARM template resource in question is used to create a SharePoint Online API connection for Power Apps. This type of resource defines a connection to a specific API (SharePoint) that can be used within Power Apps to interact with SharePoint data.

Answer

Create a new Power App

Answer

Create a Dataverse environment

Answer

Deploy a SharePoint list

Question 14

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 runs validation logic (via the form's OnSuccess/OnFailure or a conditional formula) before the record is written to the data source. By embedding a check against the employee's leave balance in that validation path, the app can block submission when the balance is insufficient, ensuring the business rule is enforced at the point of entry. This keeps the decision synchronous with the user's action and prevents invalid requests from ever reaching the approver.

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 15

A user wants to build a Power Apps app that connects to Microsoft Dataverse and uses AI to suggest next best actions. Which feature should they use?

Accepted Answer

AI Builder. AI Builder allows adding AI models like prediction or suggestion to Power Apps. Option A is wrong because Power Automate is for workflows, not for AI suggestions. Option C is wrong because Power Virtual Agents is for chatbots. Option D is wrong because Copilot in Power Apps is a general AI assistant, not a specific feature for suggestions.

Answer

Power Automate

Answer

Power Virtual Agents

Answer

Copilot in Power Apps