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

Question 1

A company wants to create a Power App that uses AI to extract information from uploaded invoices. The app should allow users to upload an invoice image and then automatically populate fields like invoice number, date, and total amount. Which Power Platform feature should you use? A) AI Builder's prebuilt invoice processing model. B) Custom Vision service in Azure. C) Power Automate with OCR actions. D) Use the 'Scan' function in Power Apps.

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

Accepted Answer

AI Builder's prebuilt invoice processing model.. AI Builder's prebuilt invoice processing model is specifically designed to extract key fields such as invoice number, date, and total amount from uploaded invoice images. It is a no-code/low-code AI feature within the Power Platform, making it the most appropriate choice for this requirement.

Answer

Use the 'Scan' function in Power Apps.

Answer

Custom Vision service in Azure.

Answer

Power Automate with OCR actions.

Question 2

Which THREE of the following are capabilities of model-driven apps? (Choose THREE.)

Accepted Answer

Business rules to enforce data validation on forms.. Option B is correct because model-driven apps support business rules that run on forms and at the data layer to enforce validation, set field values, and control visibility without writing code. Option D is correct because model-driven apps render in the Unified Interface, which provides a consistent, touch-optimized experience across tablet and mobile devices via the Power Apps mobile app. Option E is correct because the Unified Interface is responsive and automatically adapts its layout and controls to the available screen size and orientation. Option A is not correct because drag-and-drop custom layout design is a hallmark of canvas apps, whereas model-driven apps derive their layout from the data model and form designer rather than free-form drag-and-drop placement. Option C is not correct because a built-in camera control for capturing images is a canvas app control/media capability, not an inherent model-driven app capability.

Answer

Ability to design custom layouts using drag-and-drop.

Answer

Built-in camera control to capture images.

Question 3

Which TWO of the following data sources can be used directly in a canvas app without using a gateway? (Choose TWO.)

Accepted Answer

Dataverse. Option D, Dataverse, is correct because it is a cloud-hosted Microsoft Power Platform service that canvas apps connect to natively through the built-in Dataverse connector, so no on-premises data gateway is required. Option E, SharePoint Online, is correct because it is a Microsoft 365 cloud service accessed directly via the standard SharePoint connector in Power Apps, again without any gateway. Options A (on-premises SQL Server), B (on-premises Oracle Database), and C (on-premises SAP HANA) are all on-premises systems, so reaching them from a canvas app requires installing and configuring an on-premises data gateway to bridge the cloud service to the local network.

Answer

On-premises SQL Server

Answer

On-premises Oracle Database

Answer

On-premises SAP HANA

Question 4

A company uses a model-driven app built on Microsoft Dataverse to manage customer cases. The support team wants to ensure that when a case is escalated, the system automatically sends an email notification to the assigned manager and updates the case priority. The team does not want to write any code. What should they use to implement this automation?

Accepted Answer

Power Automate cloud flow triggered on update of the Case table. Power Automate cloud flows provide a no-code way to automate processes across Dataverse and other services. A flow triggered when a Case record is updated can evaluate the escalation status, send an email to the manager, and update the case priority. This meets the requirement without writing code and leverages native Dataverse integration.

Answer

Business rule in Dataverse that sends an email

Answer

Power Apps formula in the model-driven app's OnSave event

Answer

Classic workflow in Dynamics 365 that runs on demand

Question 5

A sales team needs a mobile-friendly app to view and update customer information stored in Microsoft Dataverse. The app should be generated automatically from the data model and provide a consistent interface across devices. Which type of Power Apps app should they create?

Accepted Answer

Model-driven app. Model-driven apps are built on Dataverse and automatically generate a responsive UI from the data model, including forms, views, and dashboards. They are ideal for complex business processes and provide a consistent experience across devices. This makes them the correct choice for a sales team needing a mobile-friendly app generated from data.

Answer

Power BI dashboard

Answer

Power Apps portal

Answer

Canvas app

Question 6

A sales team uses a canvas app to manage customer leads. The app currently connects to a SharePoint list as its data source. The team wants to move to a more robust data platform that supports complex relationships between leads, accounts, and contacts. They also need to enforce business rules and security at the data level. Which data source should they use?

Accepted Answer

Microsoft Dataverse. Dataverse is the only option that natively supports complex relationships, business rules, and security at the data level within the Power Platform. It is designed for scenarios requiring robust data modeling and governance, unlike SharePoint lists or Excel, which are better for simpler data storage.

Answer

SQL Server on-premises via an on-premises data gateway

Answer

Microsoft Excel workbook stored in OneDrive

Answer

SharePoint list with lookup columns

Question 7

You are building a canvas app for a field service team. Technicians need to capture customer signatures on a tablet and store the image with the work order record in Dataverse. Which control should you use?

Accepted Answer

Pen input control. Capturing a handwritten signature on a tablet requires a control that records pen strokes and exposes them as an image. The Pen input control provides exactly this capability, and its Image property can be bound to an image column in Dataverse so the signature travels with the work order record. Typed text, photographs, and file uploads do not produce an on-screen signature.

Answer

Add picture control

Answer

Camera control

Answer

Text input control

Question 8

A canvas app uses a SQL Server database as its data source. The database is hosted on-premises and is not exposed to the internet. Users report that the app fails to load data. What must be configured to allow the canvas app to connect to the on-premises SQL Server?

Accepted Answer

On-premises data gateway. To connect a canvas app to an on-premises SQL Server, you must install and configure the on-premises data gateway. The gateway creates a secure channel from the Power Platform cloud services to the on-premises network, allowing the app to query and write data. Without it, the cloud-hosted app cannot reach the internal database.

Answer

VPN connection from the user's device

Answer

Azure ExpressRoute

Answer

Azure AD Application Proxy

Question 9

A Power Apps maker has built a canvas app that uses a SQL Server database as its data source. The app is used by employees in the office and remote workers. Remote workers report that the app is slow when loading data. The maker suspects that the issue is related to data retrieval. Which action should the maker take to improve performance for remote users?

Accepted Answer

Optimize queries to retrieve only necessary data. Optimizing queries to retrieve only the required data minimizes network payload and processing time, which is especially beneficial for remote users with limited bandwidth. This approach is a fundamental performance tuning technique for canvas apps using SQL Server.

Answer

Enable delegation for the SQL Server data source

Answer

Configure an on-premises data gateway in the same region as the remote users

Answer

Use the OnStart property to cache data locally

Question 10

You are building a canvas app in Power Apps. The app needs to display a chart that shows the monthly sales trend from a SharePoint list. The chart must update automatically when new sales records are added to the list. What should you use to display the chart?

Accepted Answer

A chart control bound to the SharePoint list. The chart control in Power Apps is designed to visualize data from a connected source, such as a SharePoint list. When bound to that list, it reflects changes automatically, so new sales records appear without manual intervention. This meets the requirement for a live monthly sales trend chart.

Answer

An HTML text control with static data

Answer

A Power BI tile

Answer

A gallery with conditional formatting

Question 11

A company uses Power Apps to manage field service inspections. Inspectors need to capture GPS coordinates, photos, and digital signatures while offline in remote areas with no internet connectivity. The app must sync data automatically when connectivity is restored. Which type of Power Apps app should the company build?

Accepted Answer

A canvas app with the built-in offline capability enabled and the data stored in Microsoft Dataverse.. Canvas apps with Dataverse as the data source support offline use in Power Apps Mobile, automatically caching data and syncing changes when the device reconnects. This matches the requirement for remote inspections with GPS, photos, and signatures captured without internet. Model-driven apps, gateway-connected SQL, and portals all depend on live connectivity and cannot meet the offline sync need.

Answer

A model-driven app built on Microsoft Dataverse with a custom form for inspections.

Answer

A canvas app that connects to a SQL Server database through an on-premises data gateway.

Answer

A Power Apps portal that allows inspectors to submit inspection data through a web browser.

Question 12

A canvas app includes a gallery that displays customer records from a SharePoint list. The app designer wants to ensure that when a user selects a record, the details are shown on a separate screen. Which Power Apps feature should be used to pass the selected record's data to the detail screen?

Accepted Answer

Set the OnSelect property of the gallery to Navigate(DetailScreen, ScreenTransition.Fade, {SelectedCustomer: ThisItem}). The Navigate function in Power Apps allows you to transition to a different screen and optionally pass context variables. By including a record as the third parameter, you create a variable that is scoped to the target screen, containing the selected item. The detail screen can then use this variable to display the relevant data, ensuring a seamless user experience.

Answer

Set the detail screen's OnVisible property to retrieve the selected record from the gallery

Answer

Use a global variable updated in the gallery's OnSelect and reference it on the detail screen

Answer

Configure a collection that stores the selected record and use it on the detail screen

Question 13

A business analyst needs to create a simple canvas app that lets employees submit expense reports. The app must show a form with fields for amount, category, and receipt photo, and save the data to a SharePoint list. The analyst has no programming experience. Which Power Apps feature should the analyst use to build the form quickly?

Accepted Answer

Use the Start with data wizard to generate a three-screen app from the SharePoint list.. The Start with data wizard is designed to produce a functional canvas app from a data source with minimal effort. By connecting to the SharePoint list, it automatically creates screens for browsing, viewing details, and editing or creating records, which perfectly fits the analyst's need to build a simple expense submission app without coding.

Answer

Start with a blank canvas and manually add and configure each input control.

Answer

Build a Power Automate flow that creates the form and embeds it in a SharePoint page.

Answer

Create a model-driven app and add the SharePoint list as a virtual table.

Question 14

A supply chain analyst uses a Power Apps canvas app to scan barcodes in a warehouse where network connectivity is intermittent. The app must store scanned records locally and upload them later when connectivity returns. Which Power Apps capability should the analyst use?

Accepted Answer

SaveData and LoadData functions. Canvas apps support offline use through device-local storage. The SaveData function serializes a collection to the local device, and LoadData reads it back. A warehouse app can collect scans into a collection, persist with SaveData, and later LoadData and write to the data source when the network is available. This directly satisfies the intermittent-connectivity requirement.

Answer

A Power Automate instant cloud flow triggered by the app

Answer

Delegation with a SharePoint list

Answer

Concurrent function with a Dataverse table

Question 15

A company has a canvas app that uses a SharePoint list as its data source. The list contains 8,000 items. Users report that the app's gallery only shows the first 100 items when they scroll. The app's gallery Items property is set to Filter(Expenses, Status = "Pending"). What should the maker do to ensure all pending items are displayed?

Accepted Answer

Change the gallery Items property to use the Filter function with a delegable condition and ensure the data source supports delegation.. When a canvas app uses a non-delegable query against a large data source, Power Apps retrieves only a limited number of records (default 100, configurable up to 2000). The proper fix is to use a delegable query, such as filtering on a column that the SharePoint connector can delegate, so that the data source processes the filter and returns all matching records. This ensures all pending items are shown.

Answer

Set the gallery's LoadingSpinnerColor property to a visible color to indicate more items are loading.

Answer

Increase the app's data row limit setting from 100 to 8000 in the advanced settings.

Answer

Increase the SharePoint list view threshold in the SharePoint admin center.