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

Question 1

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 custom role includes 'Microsoft.PowerApps/apps/read' and 'Microsoft.PowerApps/apps/install' actions, which grant the user permission to read and install Power Apps in the assigned scope (resource group RG1). Therefore, option D is correct. Option A is incorrect because 'manage' implies full control (including write and delete), which is not granted. Option B is incorrect because creating new apps requires write permission, which is not included. Option C is incorrect because editing and deleting require write and delete permissions, which are not included.

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 2

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 3

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 in Power Apps returns a table of records that meet the specified condition. In this expression, Filter(array1, Status = "Active") evaluates each record in array1 and includes only those where the Status column equals 'Active'. This is correct because Filter always returns all matching records, not just the first one.

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

Question 4

A company wants to build a canvas app to allow field technicians to report equipment issues from their mobile devices. The app must work offline and sync data when connectivity is restored. Which feature should the developer use?

Accepted Answer

Offline. Power Apps canvas apps support offline capability using the Offline feature, which caches data on the device and syncs when connectivity is restored. Option A (Power Automate) is a workflow automation tool, not an offline data sync feature. Option B (Power Platform admin center) is used for administration and governance, not for app-level offline capabilities. Option C (Common Data Service, now Microsoft Dataverse) is a data platform that can enable offline sync when used with the Offline feature, but the question specifically asks for the feature the developer should use, which is the Offline feature itself. Therefore, D is the correct answer.

Answer

Power Automate

Answer

Power Platform admin center

Answer

Common Data Service

Question 5

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

Accepted Answer

Security roles. Security roles in model-driven apps define permissions, including the ability to delete records. Option B is wrong because business rules define business logic and form behavior, not security permissions. Option C is wrong because the SharePoint connector is used for integration with SharePoint, not for security. Option D is wrong because app properties control settings like appearance and ownership, not security permissions.

Answer

Business rules

Answer

SharePoint connector

Answer

App properties

Question 6

A user reports that a canvas app displays an error: 'The data source is not found.' The app connects to a SQL Server database via an on-premises data gateway. The gateway status shows 'Running' and the connection is configured. What is the most likely cause?

Accepted Answer

The SQL table name in the app formula is incorrect. The error 'The data source is not found' typically indicates that the app formula references a table name that does not exist or is misspelled in the SQL database. Option A is incorrect because missing environment variables cause different errors. Option B is incorrect because a deleted SharePoint list would affect SharePoint-based data sources, not SQL Server. Option D is incorrect because the gateway status shows 'Running' and the connection is configured, so the gateway is not offline.

Answer

A required environment variable is missing

Answer

A SharePoint list used in the app was deleted

Answer

The on-premises data gateway is offline

Question 7

An organization needs to create a form for employees to submit vacation requests. The form should automatically calculate the number of days requested based on the start and end dates. Which type of app should they build?

Accepted Answer

Canvas app. Canvas apps allow flexible formulas, such as DateDiff, to automatically calculate the number of days between two dates, making them ideal for forms requiring custom calculations. Option A is wrong because Power Apps portal is designed for external-facing websites, not internal employee forms. Option C is wrong because Power Automate is an automation tool, not a form-building app. Option D is wrong because model-driven apps use standardized forms and custom calculations are less straightforward compared to canvas apps.

Answer

Power Apps portal

Answer

Power Automate

Answer

Model-driven app

Question 8

A company wants to build a Power Apps solution that integrates with Microsoft Teams. They want to embed the app directly into a Teams channel. Which type of app should they build?

Accepted Answer

Canvas app. Canvas apps can be embedded directly into a Teams channel using the Power Apps app in Teams. Option B is incorrect because AI Builder is not an app type; it is a feature for adding AI models to apps. Option C is incorrect because model-driven apps are designed for data-centric business applications and, while they can be added to Teams as a tab, they are not typically embedded directly into a Teams channel like a canvas app. Option D is incorrect because Power Virtual Agents are chatbots, not the type of app needed for embedding into Teams.

Answer

AI Builder

Answer

Model-driven app

Answer

Power Virtual Agents

Question 9

A developer is troubleshooting a canvas app that uses a SharePoint list as a data source. The app works for some users but fails for others with the error 'Access denied.' All users have read access to the SharePoint list. What could be the issue?

Accepted Answer

The users do not have permissions to the SharePoint list. Even though all users have read access to the SharePoint list, the issue may be that some users lack specific permissions at the item or column level, or the app may be trying to access data beyond read permissions (e.g., creating or modifying items). Option B is incorrect because if the list were set to private, no users would have read access. Option C is incorrect because Power Apps licenses are not required for accessing SharePoint data through an app shared with them. Option D is incorrect because the environment does not affect data source permissions.

Answer

The SharePoint list is set to private

Answer

The users do not have Power Apps licenses

Answer

The app is in a different environment than the users

Question 10

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

Accepted Answer

AI Builder. AI Builder is the correct feature because it provides prebuilt and custom AI models that can be trained to extract structured data from documents like invoices. It integrates directly into Power Apps, allowing users to add AI-powered invoice processing without writing code or managing machine learning infrastructure.

Answer

Power BI

Answer

Power Automate

Answer

Common Data Service

Question 11

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

Accepted Answer

Power Apps maker portal. Model-driven app forms are customized using the form designer in the Power Apps maker portal (make.powerapps.com). Option A is incorrect because editing from within the app only changes data, not the form layout. Option C is incorrect because Power Automate is for automation, not form design. Option D is incorrect because SharePoint list settings are unrelated to model-driven app form customization.

Answer

From the app itself by selecting Edit

Answer

Power Automate

Answer

SharePoint list settings

Question 12

A canvas app includes a gallery that shows a list of customers. The app loads slowly when the gallery displays more than 500 records. What is the best way to improve performance?

Accepted Answer

Apply a filter to the gallery data source. Applying a filter to the gallery data source reduces the number of records loaded into the gallery, which improves performance because fewer records need to be transferred and rendered. Option A (non-delegable query) would actually worsen performance by loading all records locally. Option B (converting to a model-driven app) is a significant redesign and not a simple performance fix. Option D (increasing gallery height) does not affect the amount of data loaded; it only changes the display area.

Answer

Use a non-delegable query

Answer

Convert the app to a model-driven app

Answer

Increase the gallery height

Question 13

Which TWO components are required to create a model-driven app in Power Apps? (Choose two.)

Accepted Answer

Dataverse table. Dataverse tables (Option B) are the fundamental data storage structure for model-driven apps. Every model-driven app must be built on top of at least one Dataverse table to provide the data schema, relationships, and security context that the app's views, forms, and dashboards rely on. Without a Dataverse table, the app has no data source to interact with.

Answer

AI Builder model

Answer

Power Automate flow

Answer

Power BI dashboard

Question 14

Which THREE are valid data sources for a canvas app? (Choose three.)

Accepted Answer

SharePoint list. SharePoint lists are supported. Option C is correct because SQL Server is supported. Option D is correct because Excel files stored in OneDrive are supported. Option A is wrong because Azure DevOps is not a direct canvas app data source (use connectors). Option E is wrong because Power BI datasets are not data sources; you can embed reports but not use as source.

Answer

Azure DevOps work items

Answer

Power BI dataset

Question 15

Which TWO capabilities does Power Apps provide? (Choose two.)

Accepted Answer

Implementing business process flows. Power Apps provides capabilities for building custom user interfaces with canvas apps and implementing business process flows through model-driven apps. Option C is correct because model-driven apps include business process flows to guide users through processes. Option D is correct because canvas apps allow custom UI layouts. Option A is incorrect because creating Power BI dashboards is a Power BI capability, not Power Apps. Option B is incorrect because scheduling automated workflows is handled by Power Automate. Option E is incorrect because training custom AI models is done with AI Builder, which is an add-on, not a core Power Apps capability.

Answer

Creating Power BI dashboards

Answer

Scheduling automated workflows

Answer

Training custom AI models