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

Question 1

A power user is designing a canvas app for inventory management. The app has a gallery that displays products. The user wants to filter the gallery to show only products with stock less than 10. Which formula should the user use in the Items property of the gallery?

Accepted Answer

Filter(Products, Stock < 10). Option A is correct because the Filter function in Power Apps applies a condition to show only records where Stock < 10. Option B is wrong because LookUp returns a single record. Option C is wrong because Search is for text search. Option D is wrong because Sort does not filter.

Answer

LookUp(Products, Stock < 10)

Answer

Sort(Products, Stock)

Answer

Search(Products, "10", "Stock")

Question 2

A company uses a model-driven app to manage support tickets. Users want to automate the creation of a follow-up task when a ticket is resolved. Which component should be used?

Accepted Answer

Power Automate flow. Option B is correct because Power Automate can trigger on record changes (e.g., status change) to create tasks. Option A is wrong because Business Rules are for simple logic forms, not automation. Option C is wrong because Power Apps is for app creation. Option D is wrong because Microsoft Copilot Studio is for chatbots.

Answer

Microsoft Copilot Studio

Answer

Custom Power Apps page

Answer

Business Rule

Question 3

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

Accepted Answer

Use the app from data wizard (e.g., from SharePoint). Option C is correct because the app from data wizard in Power Apps allows creating a simple app from a data source with minimal customization. Option A is wrong because blank canvas app requires more manual work. Option B is wrong because model-driven apps are more complex. Option D is wrong because Power Automate is not for app creation.

Answer

Start from a blank canvas app

Answer

Create a model-driven app

Answer

Use Power Automate to create the app

Question 4

In a model-driven app, a user wants to see a map of all customer addresses on a form. Which feature should be enabled?

Accepted Answer

Map control. Option D is correct because the Map control in model-driven apps displays addresses on a map. Option A is wrong because the Timeline shows activities. Option B is wrong because the Notes section is for notes. Option C is wrong because the Associated View shows related records.

Answer

Notes section

Answer

Associated View

Answer

Timeline control

Question 5

Which TWO are valid ways to share a canvas app with other users in your organization?

Accepted Answer

Share directly from the Power Apps maker portal. Correct: B and D. Sharing via the Power Apps portal (B) is the standard method. Embedding in Microsoft Teams (D) is also a valid sharing option. A is wrong because sharing via email attachment is not supported. C is wrong because sharing via a direct link to the app's source file is not the intended method. E is wrong because sharing via a SharePoint list is not how apps are shared.

Answer

Publish the app to a SharePoint list

Answer

Provide a direct link to the .msapp file

Answer

Send the app file as an email attachment

Question 6

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Accepted Answer

Role-based security to control access to data. Correct: A, B, and D. Dataverse provides role-based security (A), business rules (B), and calculated fields (D). C is wrong because real-time co-authoring is a Power Apps feature, not Dataverse. E is wrong because server-side pagination is not exposed directly in Dataverse.

Answer

Real-time co-authoring of canvas apps

Answer

Server-side pagination for large datasets

Question 7

Which TWO are types of apps you can create with Microsoft Power Apps?

Accepted Answer

Model-driven app. Correct: A and C. Canvas apps (A) and model-driven apps (C) are the two primary types. B is wrong because Flow is Power Automate. D is wrong because Power BI is a separate product. E is wrong because Copilot Studio is for chatbots.

Answer

Copilot Studio bot

Answer

Flow app

Answer

Power BI report

Question 8

Which THREE are valid data sources for canvas apps in Power Apps?

Accepted Answer

SQL Server database. Correct: A, C, and E. SharePoint (A), SQL Server (C), and Microsoft Dataverse (E) are all supported. B is wrong because Excel workbooks are not supported directly as a data source (must be in OneDrive or SharePoint). D is wrong because Oracle Database is not a built-in connector.

Answer

Local Excel file

Answer

Oracle Database

Question 9

Which THREE are features of model-driven apps compared to canvas apps?

Accepted Answer

Automatic form generation from Dataverse tables. Correct: A, B, and C. Model-driven apps are responsive (A), have built-in business process flows (B), and automatically generate forms from Dataverse (C). D is wrong because drag-and-drop layout is a canvas app feature. E is wrong because model-driven apps are not customizable in the same way as canvas apps.

Answer

Drag-and-drop layout customization

Answer

Full control over pixel-perfect design

Question 10

Refer to the exhibit. The following JSON shows a Power Apps component (canvas app) manifest snippet:

{
  "properties": {
    "dataSources": [
      {
        "name": "SalesData",
        "type": "Microsoft Dataverse",
        "entity": "accounts"
      }
    ],
    "screens": [
      {
        "name": "MainScreen",
        "controls": [
          {
            "name": "AccountGallery",
            "type": "Gallery",
            "items": "Filter(SalesData, status = 'Active')"
          }
        ]
      }
    ]
  }
}

What is the data source for the gallery named AccountGallery?

Accepted Answer

The filtered Dataverse Accounts data source. Option B is correct because the gallery's Items property uses Filter(SalesData, ...), and SalesData is defined as a Dataverse entity 'accounts'. Option A is wrong because the gallery uses a filtered set, not the raw entity. Option C is wrong because the data source is Dataverse, not SharePoint. Option D is wrong because SQL Server is not referenced.

Answer

A SQL Server table named Accounts

Answer

A SharePoint list named SalesData

Answer

The raw Dataverse Accounts entity

Question 11

Contoso, Ltd. is a multinational company with a global sales team. They use Microsoft Power Apps to build a model-driven app for managing customer accounts and opportunities. The app uses Microsoft Dataverse as the data source. The sales team accesses the app on mobile devices while traveling. Recently, users have reported that the app is slow when loading large numbers of opportunities. The app has a custom page that displays a list of all opportunities without any filters. The page uses a gallery that loads all records at once. The app also uses several custom connectors to external systems, but the slowness is primarily observed when loading the opportunities list. The IT team has confirmed that the Dataverse environment is in the same region as the users, and network latency is not an issue. They need to improve the performance of the app. Which two actions should the IT team take? (Choose two.)

Accepted Answer

Implement delegation in the gallery to filter data on the server. Option B is correct because implementing delegation in the gallery to filter data server-side reduces the amount of data transferred. Option D is correct because adding a search box to filter records locally (but with delegation) improves performance. Option A is wrong because increasing Dataverse capacity does not address query performance. Option C is wrong because using a canvas app might not solve the underlying data loading issue. Option E is wrong because disabling real-time sync is not recommended and may cause data inconsistency.

Answer

Disable real-time synchronization with Microsoft Entra ID

Answer

Replace the model-driven app with a canvas app

Answer

Increase the Dataverse storage capacity

Question 12

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

Accepted Answer

Use AI Builder's receipt processing model in Power Apps. Option C is correct because AI Builder provides prebuilt models for receipt processing. Option A is wrong because there is no receipt scanner control in Power Apps without AI Builder. Option B is wrong because Power Automate can be used but is not required if AI Builder is used directly. Option D is wrong because Copilot Studio is for chatbots, not receipt scanning.

Answer

Create a Power Automate flow that processes the image and returns the data

Answer

Use the Camera control to capture the image and use a custom formula to extract text

Answer

Integrate Microsoft Copilot Studio to handle the receipt scanning

Question 13

Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)

Accepted Answer

Assign the 'Help Desk Agents' security role to the help desk team. Option A is correct because assigning the 'Help Desk Agents' role to agents grants them edit permissions. Option C is correct because granting read privilege to the 'Employees' role allows view access. Option B is wrong because sharing the app does not control data permissions. Option D is wrong because business rules do not control security. Option E is wrong because creating a new table is unnecessary.

Answer

Create a new Dataverse table for ticket views

Answer

Create a business rule to restrict editing to certain users

Answer

Share the app with all employees using the Power Apps sharing feature

Question 14

You are a Power Apps developer at Contoso Ltd. The company uses Microsoft 365 E5 licenses and has a complex environment with multiple departments. The HR department needs a canvas app to manage employee onboarding. The app must connect to a SharePoint Online list containing employee records, and also to the Microsoft Graph API to retrieve manager information. The app should be accessible to HR staff only, who are in a security group named 'HR-Staff'. You need to design the app to ensure data security and minimize licensing costs. The app will be used by 50 HR staff members. You have the following options: A) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group. B) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users. C) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users. D) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group. Choose the best option.

Accepted Answer

Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group.. Option D is correct because model-driven apps support security group sharing and the Microsoft Graph connector is native. Option A uses canvas app which may not support security group sharing directly (requires premium licensing for group sharing) and uses custom HTTP connector which is more complex. Option B shares with individual users which is inefficient. Option C shares with individual users and uses custom HTTP connector.

Answer

Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users.

Answer

Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group.

Answer

Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users.

Question 15

You are building a canvas app for a retail company to track inventory. The app needs to display a list of products from a Dataverse table and allow users to update quantities. The product table has a column 'QuantityOnHand' of type Whole Number. When a user reduces the quantity below zero, the app should show an error message and not save the data. You have added a form and a submit button. What approach should you use to enforce the business rule? A) Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting. B) Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0. C) Use the Patch function with an If condition to check the value before updating. D) Add a workflow in Power Automate to validate the quantity after submission.

Accepted Answer

Use the Patch function with an If condition to check the value before updating.. Option C is correct because using Patch with an If condition allows real-time validation in the app. Option A: Form validation rules are client-side but may not prevent submission if bypassed. Option B: Dataverse business rules apply on the server but are not triggered by canvas app submissions directly (they work in model-driven apps). Option D: Power Automate would run after submission, not preventing the invalid data entry.

Answer

Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0.

Answer

Add a workflow in Power Automate to validate the quantity after submission.

Answer

Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting.