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

Question 1

A company wants to build a Power Apps canvas app for field technicians to report equipment issues. The app must allow offline data entry and sync when connectivity is restored. Which feature should the developer enable?

Accepted Answer

Enable the 'Offline' feature in the app settings. Power Apps mobile app supports offline capabilities by enabling the 'Offline' feature, which allows data to be cached and synced later. Option D is correct. Option A is wrong because Power Automate flows can be triggered online but do not provide offline data caching. Option B is wrong because SharePoint lists require network connectivity unless using a third-party sync tool. Option C is wrong because the Common Data Service (Microsoft Dataverse) supports offline sync only when the app is explicitly configured for offline use, but the question asks about the feature to enable in the app.

Answer

Use a Power Automate flow to queue data submissions

Answer

Configure the app to store data in a SharePoint list

Answer

Use the Common Data Service (Dataverse) offline sync

Question 2

A business analyst creates a model-driven app using Dataverse. They need to ensure that when a new lead is created, a task is automatically assigned to the sales team. Which component should be used?

Accepted Answer

A Power Automate flow triggered on lead creation. Power Automate flows can be triggered by Dataverse events (e.g., when a record is created) to automate tasks. Option B is correct. Option A is wrong because Power Apps does not generate tasks directly. Option C is wrong because a business rule can show or hide fields but not create records. Option D is wrong because a calculated field computes a value but does not create tasks.

Answer

A business rule on the lead form

Answer

A calculated field that sets the task status

Answer

A canvas app with a button to create a task

Question 3

An organization uses Power Apps to submit expense reports. The app connects to Dataverse. Users report that some submissions fail with a 'table not found' error. The developer verified the table exists. What is the most likely cause?

Accepted Answer

The app's service principal lacks read permissions on the table. The error 'table not found' despite the table existing often indicates a permission issue. Option C is correct. Option A is wrong because the app would not work at all if connectors were misconfigured. Option B is wrong because a missing column would cause a different error. Option D is wrong because the developer verified the table exists.

Answer

The table has a missing required column

Answer

The table was renamed after the app was published

Answer

The app uses a deprecated connector

Question 4

A company is designing a Power Apps canvas app for inventory management. They want to allow managers to approve or reject requests directly from their mobile devices. Which control should be used to collect the manager's decision?

Accepted Answer

Radio control. A Radio control allows selecting one option from a set, ideal for Approve/Reject. Option A is correct. Option B is wrong because a Checkbox is for binary yes/no but usually for single items. Option C is wrong because a Drop down is for selecting from a list but less intuitive for two options. Option D is wrong because a Text input requires typing.

Answer

Drop down control

Answer

Checkbox control

Answer

Text input control

Question 5

A Power Apps canvas app that uses Dataverse is being migrated from a development environment to a production environment. After migration, the app fails to load data. The developer checks the connection and finds that the Dataverse connector is pointing to the development environment. What should the developer do?

Accepted Answer

Update the connection reference in the app to use production Dataverse. The app's connection references must be updated to point to the production Dataverse environment. Option B is correct. Option A is wrong because re-importing the solution alone does not update connection references. Option C is wrong because the app is already in production. Option D is wrong because changing environment variables is not the direct fix for hard-coded connections.

Answer

Re-import the solution into the production environment

Answer

Delete the app and recreate it in production

Answer

Modify the environment variable values for the connection

Question 6

A user wants to create a Power Apps canvas app that displays data from an Excel spreadsheet stored in Microsoft OneDrive for Business. Which connector should be used?

Accepted Answer

Excel Online (Business) connector. The OneDrive for Business connector allows Power Apps to read Excel files. Option C is correct. Option A is wrong because SharePoint is a different service. Option B is wrong because Excel Online (Business) is for Excel files in SharePoint/OneDrive but the question specifies OneDrive. Option D is wrong because Dataverse is a database, not a file storage.

Answer

Dataverse connector

Answer

OneDrive for Business connector

Answer

SharePoint connector

Question 7

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

Accepted Answer

In the Dataverse table's business rules settings. Business rules are defined on Dataverse tables and apply to model-driven apps. Option B is correct. Option A is wrong because business rules are not defined in canvas apps. Option C is wrong because Power Automate is for flows, not business rules. Option D is wrong because SharePoint lists do not support Power Apps business rules.

Answer

In the SharePoint list settings

Answer

In a Power Automate flow

Answer

In the canvas app's OnStart property

Question 8

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

Accepted Answer

Add picture control. The Add picture control allows users to upload or take a photo. Option D is correct. Option A is wrong because the Camera control captures live video but not file upload. Option B is wrong because the Image control displays images. Option C is wrong because the Button control does not capture images.

Answer

Camera control

Answer

Image control

Answer

Button control

Question 9

A business user wants to build a Power Apps app without writing any code. Which type of app should they create?

Accepted Answer

Canvas app. Canvas apps are designed for low-code/no-code development, allowing business users to create custom applications by dragging and dropping elements onto a canvas and connecting them to data sources without writing code. This aligns directly with the user's requirement to build an app without coding.

Answer

Power Automate flow

Answer

Power Pages site

Answer

Model-driven app

Question 10

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

Accepted Answer

Embed an app in Microsoft Teams. Power Apps is a low-code platform for building custom apps. Option B is correct because Power Apps can be embedded directly into Microsoft Teams as a tab or personal app, allowing users to access custom apps without leaving the Teams interface. Option C is correct because Power Apps is designed to build mobile apps that can run on iOS, Android, and Windows, making it ideal for field service technicians who need offline-capable, data-entry apps.

Answer

Automate a multi-step approval process

Answer

Create a chatbot for customer inquiries

Answer

Create a dashboard with sales data

Question 11

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

Accepted Answer

Views. Views, tables, and forms are core components of a model-driven app in Power Apps. Views define how records in a table are displayed in lists, tables store the data, and forms provide the user interface for viewing and editing records. These components are built on Microsoft Dataverse and are essential for structuring the app's data and user experience.

Answer

Galleries

Answer

Screens

Question 12

Which TWO data sources can be directly connected to a Power Apps canvas app without using an on-premises data gateway? (Choose two.)

Accepted Answer

Microsoft 365 Outlook. Microsoft 365 Outlook is a cloud-based service that can be directly connected to a Power Apps canvas app using built-in connectors without requiring an on-premises data gateway. The Outlook connector uses Microsoft Graph API to access mail, calendar, and contacts, making it a native cloud-to-cloud integration.

Answer

Oracle Database on-premises

Answer

SAP on-premises

Answer

SQL Server on-premises

Question 13

Refer to the exhibit. The Azure RBAC custom role definition shown is assigned to a user. What can this user do?

Accepted Answer

Read and install Power Apps in resource group RG1. The role includes 'Microsoft.PowerApps/apps/read' and 'install' actions, allowing the user to read and install apps in the specified scope. Option A is correct. Option B is wrong because the role does not include write or delete. Option C is wrong because the role does not include create. Option D is wrong because the role only allows read and install, not full management.

Answer

Manage all Power Apps in the subscription

Answer

Create new Power Apps in resource group RG1

Answer

Edit and delete Power Apps in resource group RG1

Question 14

Refer to the exhibit. An ARM template deploys a Power App with a connection to Office 365 Outlook. What is the purpose of the 'dependsOn' element?

Accepted Answer

To ensure the connection is deployed before the app. The dependsOn element ensures that the connection resource is created before the app resource, because the app references the connection. Option B is correct. Option A is wrong because the order is connection then app. Option C is wrong because dependsOn does not affect pricing. Option D is wrong because dependsOn is about resource creation order, not deployment scope.

Answer

To deploy the resources to different regions

Answer

To ensure the app is deployed before the connection

Answer

To reduce the cost of the deployment

Question 15

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

Accepted Answer

Returns all records from array1 where Status is 'Active'. The Filter function returns records from array1 where the Status column equals 'Active'. Option A is correct. Option B is wrong because Sort is for ordering. Option C is wrong because LookUp returns a single record. Option D is wrong because Search is for matching substrings.

Answer

Returns the first record from array1 with Status 'Active'

Answer

Sorts array1 by Status in ascending order

Answer

Searches array1 for the text 'Active' in any column