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

Question 1

A team lead wants to give a colleague permission to edit the structure of a canvas app, including adding screens and modifying formulas, but not to publish it to end users. Which sharing role should be assigned in Power Apps?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Co-owner. App sharing in Power Apps offers Co-owner and User roles. Co-owner lets a colleague edit the app's structure and formulas, while User only allows running the app. Environment Maker and System Administrator are environment or Dataverse roles that do not target per-app editing permissions. Co-owner is the least-privilege choice that still permits structural edits.

Answer

System Administrator

Answer

Environment Maker

Answer

User

Question 2

A team is building a canvas app that must allow users to work with data from multiple sources. The app will use Microsoft Dataverse as the primary data source and also needs to display data from an on-premises SQL Server database. Which two components are required to connect the canvas app to the on-premises SQL Server data? (Choose two.)

Accepted Answer

An on-premises data gateway installed and configured.. To connect a canvas app to an on-premises SQL Server database, the maker must install and configure an on-premises data gateway to bridge the cloud and local network, and then add the SQL Server connector to the app. These two components together enable secure, direct data access from the canvas app without additional workflows or virtual tables.

Answer

A virtual table created in Microsoft Dataverse for the SQL Server data.

Answer

A Power Automate flow that triggers on app load.

Answer

An Azure Logic Apps workflow to synchronize the data.

Question 3

A maker builds a canvas app that reads from a SharePoint list containing 50,000 rows. Users report the gallery shows only a subset of records and search results are incomplete. The maker needs the app to return complete results for filter and search operations. What should the maker do?

Accepted Answer

Rewrite queries to use only delegable functions and operators for SharePoint. Delegation is the mechanism that lets Power Apps hand processing to the data source. SharePoint supports a specific set of delegable functions and operators. When a query uses only those, all matching rows are processed server-side regardless of list size. When it uses a non-delegable expression, processing happens on the device and is limited, which explains the partial gallery and incomplete search results.

Answer

Add a second SharePoint data source pointing to the same list

Answer

Increase the app's data row limit setting to the maximum value

Answer

Enable the SharePoint list's versioning settings

Question 4

A sales team at a manufacturing company needs a mobile app where field representatives can look up customer records, view related orders, and update account details. The company already stores all this data in Microsoft Dataverse with defined relationships and business rules. The team wants to build the app with minimal custom coding and have it automatically respect the Dataverse security roles. Which type of Power Apps app should they create?

Accepted Answer

A model-driven app. Model-driven apps are the right choice because they are built directly on Microsoft Dataverse and automatically generate forms, views, and dashboards from the data model. They enforce Dataverse security roles and business rules without custom code, which satisfies the need for minimal coding and automatic security compliance. Canvas apps and Power Pages would require more manual configuration and would not natively inherit the Dataverse security model in the same way.

Answer

A Power Pages portal

Answer

A canvas app with a SharePoint list as the data source

Answer

A canvas app with a blank layout

Question 5

A company is planning a model-driven app for managing equipment inspections. The app must support business process flows, role-based security, and a unified interface across devices. Which two components are required to build this model-driven app? (Choose two.)

Accepted Answer

Dataverse tables. A model-driven app fundamentally requires Dataverse tables to hold data and define the schema, and a site map to define navigation. Business process flows, role-based security, and the unified interface are provided by the platform once these core components exist. Embedded canvas apps, cloud flows, and Power BI reports are optional additions, not prerequisites.

Answer

A canvas app embedded in a model-driven form

Answer

A Power Automate cloud flow for each table

Answer

A Power BI report embedded in the app

Question 6

A sales team at a manufacturing company needs a mobile-friendly app that shows a product catalog and lets reps submit orders. The team has no developers and wants to build the app quickly by dragging controls onto a blank screen and connecting to an existing SharePoint list. Which type of Power Apps app should the team create?

Accepted Answer

A canvas app. A canvas app is the right choice because it starts from a blank design surface, allows makers to drag and drop controls, and connects directly to data sources such as SharePoint without requiring pro-code development. The need for a custom, mobile-friendly catalog and order form built by non-developers aligns with canvas app capabilities rather than model-driven, portal, or automation technologies.

Answer

A Power Automate cloud flow

Answer

A Power Pages site

Answer

A model-driven app

Question 7

A field technician needs a mobile app that reads the device camera to capture equipment photos and writes each photo together with a work order number to a Microsoft Dataverse table. The technician wants to build it quickly with drag-and-drop controls and no server-side code. Which Power Apps app type fits best?

Accepted Answer

Canvas app. Canvas apps are the Power Apps option designed for pixel-level control and rapid drag-and-drop authoring. A maker can add a Camera control, capture an image, and use formulas to create a Dataverse record containing the image and the work order number. This requires no server-side code and is well suited to a mobile technician workflow.

Answer

Power BI dashboard embedded in the app

Answer

Power Apps portal

Answer

Model-driven app

Question 8

A company wants to create a model-driven app to manage customer cases. The app must include a custom table for cases, a form to enter case details, a view to list open cases, and a dashboard to show case metrics. The company has a Microsoft Dataverse environment. What is the minimum set of components the maker needs to create in the Power Apps maker portal?

Accepted Answer

A Dataverse table, a model-driven app, and the required forms, views, and dashboard.. Building a model-driven app requires a Dataverse table to store the case data, and then the app itself with forms for data entry, views for listing records, and a dashboard for metrics. All these components are created within the Power Apps maker portal using the app designer and solution explorer. The other options either use the wrong app type or assume automation that does not exist.

Answer

A canvas app with a SharePoint list as the data source.

Answer

A Power Apps portal with a Dataverse table and custom web pages.

Answer

A Power Automate flow that creates the table, form, view, and dashboard automatically.

Question 9

A sales team uses a Power Apps canvas app to view and update customer records stored in a Microsoft Dataverse table. A new requirement states that when a user selects a customer in the app, the app must automatically retrieve the 10 most recent related orders from a different Dataverse table and display them in a gallery. Which Power Apps capability should the maker use to retrieve and display the related orders?

Accepted Answer

Use the Filter function with a relationship-based lookup in the Items property of the gallery.. To display related records from another table in a canvas app, the maker should use the Filter function in the gallery's Items property, referencing the lookup column that establishes the relationship. This retrieves only the relevant records and updates dynamically when the selected customer changes. Other approaches either return too few records, are asynchronous, or do not filter correctly.

Answer

Add a second data source connection to the orders table and use the Default property of the gallery.

Answer

Use the LookUp function to retrieve a single order and display it in a form.

Answer

Create a Power Automate cloud flow that returns all orders and bind the gallery to the flow output.

Question 10

A maker is building a canvas app that connects to a Microsoft Dataverse table named Projects. The app includes a gallery that displays project records and a form for editing them. The maker wants to ensure that when a user selects a project in the gallery, the form automatically shows the details of that selected project. Which Power Apps control property should the maker set on the form to bind it to the gallery's selected item?

Accepted Answer

Item. The Item property on a form control is specifically designed to bind the form to a record. Setting it to the gallery's Selected property ensures the form always displays the project that the user has chosen. The Default property only sets an initial value, DataSource identifies the table, and OnSelect is for actions, so none of those directly achieve the dynamic binding required.

Answer

OnSelect

Answer

Default

Answer

DataSource

Question 11

You are troubleshooting a canvas app that connects to a SQL Server database through an on-premises data gateway. Users in the finance department receive an error stating the app cannot reach the data source, while users in IT can use the app normally. What is the most likely cause?

Accepted Answer

The finance users have not been granted access to the on-premises data gateway connection.. On-premises data gateway connections maintain a separate list of users who may use the connection. If finance users are omitted from that list, their apps cannot authenticate through the gateway and report the data source as unreachable, while IT users who were added work normally. Gateway machine availability and SQL Server connection limits would affect all users, and database permission errors would produce different messages.

Answer

The finance users lack the necessary permissions on the SQL Server database.

Answer

The gateway is installed on a machine that is turned off during finance working hours.

Answer

The SQL Server database has reached its maximum number of concurrent connections.

Question 12

A support organization is building a model-driven app for case management and wants to standardize how agents create and update case records. The organization wants to control which fields appear on the case form, enforce required fields, and define the columns shown in the case list view. Which two components should the maker configure to meet these requirements? (Choose two.)

Accepted Answer

The table view for the Case table. Forms and views are the core configuration elements that shape how records are displayed and edited in a model-driven app. The form controls field layout and required fields, while the view controls the columns and filtering of record lists. Together they standardize how agents create, update, and browse case records, which is exactly what the support organization needs.

Answer

A business process flow on the Case table

Answer

A Power BI dashboard embedded in the app

Answer

A canvas app embedded with an Iframe control

Question 13

You are building a canvas app for a field service team. Technicians need to open the app on a phone, capture a photo of damaged equipment, and attach that photo to a work order record stored in Microsoft Dataverse. You add a Camera control and a Form control bound to the Work Order table. What should you configure to store the captured image with the work order record?

Accepted Answer

Add the Camera control's Photo property to a data card in the Form control that is bound to an image or file column on the Work Orders table.. A Form control persists data through data cards, each mapped to a specific column, and SubmitForm writes the current values to Dataverse. Putting the Camera control's Photo output inside a data card bound to an image or file column means the captured image travels with the record when the technician submits the form. Actions like streaming video or cloud flows do not persist the image to the work order.

Answer

Set the Camera control's OnSelect property to Patch the Work Orders table with the Camera control's Photo value.

Answer

Enable the Camera control's UseMobileCamera property and connect the app to a Power Automate flow that reads the device gallery.

Answer

Set the Camera control's StreamRate property to a value greater than zero and rely on automatic Dataverse synchronization.

Question 14

A maker is authoring a canvas app in Power Apps Studio and wants to reuse logic and control appearance across multiple screens. Which two capabilities support this goal? (Choose two.)

Accepted Answer

Use a named formula in App.Formulas to define reusable values and logic. Components and named formulas are the two canvas app authoring features built for reuse. Components package controls, properties, and formulas that can be inserted on many screens and updated centrally. Named formulas in App.Formulas define values and logic once for use anywhere in the app. Together they let a maker maintain shared behavior and styling without duplicating definitions.

Answer

Enable the app's experimental features toggle

Answer

Set the app's theme to a custom color palette

Answer

Define a named formula with the With function for shared calculations

Question 15

You are building a canvas app for a field service team. The app must allow technicians to capture a customer signature on a touch screen and attach it to a work order record. Which Power Apps control should you add to the screen to meet this requirement?

Accepted Answer

Pen input control. The Pen input control is the only control in Power Apps canvas apps that provides a canvas for freehand drawing, making it ideal for capturing signatures. It can be bound to a data source so the signature image is saved with the work order. Other controls either display images, capture typed text, or use the camera, but none allow direct on-screen signing.

Answer

Image control

Answer

Text input control

Answer

Camera control