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

Question 1

A mortgage company uses a canvas app for loan officers to submit new loan applications. The app must automatically route each application to the correct underwriting team based on the loan amount and property state. The routing logic must be reusable across several apps and must be maintainable without editing each app individually. What should you use?

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

Accepted Answer

Create a Power Automate cloud flow that contains the routing logic, and call it from each app.. The requirement is for logic that is reusable across several apps and maintainable in one place. A Power Automate cloud flow is the correct service because it can be invoked from any canvas app and centralizes the routing rules. Updating the flow updates the behavior for all apps, eliminating the need to edit each app individually.

Answer

Create a model-driven app that includes a business rule on the Loan table.

Answer

Add the routing logic as a formula in the OnStart property of each canvas app.

Answer

Use a Power Apps component framework (PCF) code component to implement the routing logic.

Question 2

You are developing a canvas app that connects to a SQL Server database on-premises using the SQL Server connector. The app will be used by employees in your organization. You need to ensure that the app can access the data securely without exposing the database directly to the internet. What should you configure?

Accepted Answer

Set up an on-premises data gateway and create a connection to the SQL Server through the gateway.. The on-premises data gateway is the correct solution because it enables secure connectivity between Power Apps and on-premises SQL Server without exposing the database to the internet. The gateway must be installed and configured, and then a connection using that gateway is created in Power Apps. Other options either do not integrate with Power Apps or fail to meet the security requirement.

Answer

Enable Azure Hybrid Connections and configure the SQL Server connector to use the hybrid connection endpoint.

Answer

Use the SQL Server connector with the 'Connect via on-premises data gateway' option and specify the gateway name.

Answer

Publish the SQL Server database to Azure SQL Database and connect to it using the Azure SQL connector.

Question 3

A company is planning to build a canvas app that will be used by employees in the field. The app must work offline when there is no internet connectivity and synchronize data when the connection is restored. The maker is evaluating which data sources can support offline capabilities in a canvas app. Which two data sources natively support offline use in a canvas app? (Choose two.)

Accepted Answer

Collections. Microsoft Dataverse and Collections both support offline scenarios in canvas apps. Dataverse offers native offline capabilities with automatic synchronization, while Collections can be persisted locally using SaveData and LoadData. SharePoint, SQL Server, and Office 365 Users do not provide native offline support and would require manual caching without automatic sync, making them unsuitable for this requirement.

Answer

SQL Server

Answer

Office 365 Users

Answer

SharePoint

Question 4

A company uses a canvas app that connects to a SharePoint list with over 20,000 items. Users report that the app only shows the first 500 items in a gallery. You need to ensure that all items can be accessed. What should you do?

Accepted Answer

Increase the 'Data row limit' in the app's advanced settings.. The Data row limit setting in Power Apps determines how many records are retrieved when a query cannot be delegated to the data source. Increasing it from 500 to a higher value (up to 2000) allows the app to load more items into the gallery. This is the correct approach when delegation is not possible and you need to access more than 500 items.

Answer

Change the SharePoint list to a Dataverse table.

Answer

Enable the 'Use SharePoint list view' option in the app settings.

Answer

Add an index to the SharePoint list column used in the gallery filter.

Question 5

A canvas app uses a SharePoint list named Projects as its data source. The list has 8,000 items and a column named Status. The app contains a gallery whose Items property is set to Projects. Users report that the gallery only ever shows about 500 projects and that filtering by Status sometimes misses items. Which change resolves both symptoms?

Accepted Answer

Replace the SharePoint list with a Microsoft Dataverse table and bind the gallery to a Dataverse view or a delegable Filter expression.. The symptoms point to SharePoint connector limits: it returns a bounded number of rows per call and delegates only a narrow set of operations, so large lists appear truncated and filters can silently drop records. Moving the data to Dataverse and using a delegable query gives the gallery access to the full set and accurate filtering. Cosmetic or nonexistent settings cannot overcome connector-level limits.

Answer

Enable the app's experimental "Optimize for large lists" setting and leave the gallery Items as Projects.

Answer

Raise the gallery's Height property and set the Items property to FirstN(Projects, 8000).

Answer

Change the gallery's Items property to Filter(Projects, Status = "Active") so the server performs the filter.

Question 6

A maker needs to give a colleague permission to edit a canvas app's screens and formulas, but the colleague must not be able to publish the app to users or change its sharing. Which action should the maker take?

Accepted Answer

Share the app with the colleague as a co-owner. Canvas app sharing distinguishes between users, who can run the app, and co-owners, who can edit it. Granting co-owner access lets the colleague modify screens and formulas while the maker keeps control over publishing and sharing to end users. Broad environment roles or Dataverse security roles operate at different scopes and are not the right tool.

Answer

Create a security role in Dataverse that includes the app table

Answer

Share the app with the colleague as a user

Answer

Add the colleague to the environment's System Administrator role

Question 7

A Power Apps maker is building a canvas app that uses a SharePoint list as its data source. The list contains 8,000 items. The maker wants to display a gallery that shows only items where the Status column equals 'Open'. The maker writes the following formula for the gallery's Items property: Filter(SharePointList, Status = 'Open'). When testing, the gallery only shows the first 500 items and does not show all open items. What is the cause of this issue?

Accepted Answer

The Filter function is not delegable for the Status column because it is not indexed, causing Power Apps to retrieve only the first 500 items.. The issue is delegation. When a query like Filter on a SharePoint list is not delegable, Power Apps retrieves only the first 500 items (by default) and then applies the filter locally. Since the Status column is not indexed, the filter is not delegated, so only the first 500 items are considered. Indexing the Status column in SharePoint allows the query to be delegated, returning all matching items regardless of the total list size.

Answer

The gallery's Items property must use the LookUp function instead of Filter to retrieve all records.

Answer

The SharePoint list exceeds the 2,000-item limit for canvas apps, so the app cannot display more than 2,000 items.

Answer

The SharePoint list has more than 5,000 items, so the Filter function cannot retrieve all records.

Question 8

You are building a canvas app that needs to display a list of products from a SharePoint list. Users must be able to filter the list by category and search by product name. The app should also allow users to view details of a selected product and edit its information. Which two Power Apps controls are most appropriate to display the product list and enable filtering? (Choose two.)

Accepted Answer

Gallery control. The Gallery control is the primary control for displaying a list of records and supports filtering and selection. The Dropdown control is commonly used to provide filter options, such as categories, which can then be applied to the gallery's data source. Together, they enable users to view the product list and filter it by category. Other controls like Text input can assist with search but are not the main list display or filter selection controls.

Answer

Data table control

Answer

Form control

Answer

Text input control

Question 9

A company uses a canvas app to manage customer orders. The app currently connects to a SharePoint list. The order volume has grown to over 50,000 items, and users report that filtering and sorting are slow, often timing out. The company wants to improve performance without rewriting the app. What should you do?

Accepted Answer

Replace the SharePoint list with a Microsoft Dataverse table and update the app's data source.. SharePoint lists have delegation limits that cause non-delegable queries to process only the first 2000 items, leading to slow performance and timeouts with large datasets. Dataverse supports delegation for a broader set of functions and is optimized for large volumes. Switching the data source to Dataverse allows filtering and sorting to be performed server-side, resolving the performance issue without rewriting the app.

Answer

Enable delegation warnings and increase the SharePoint list threshold in the app settings.

Answer

Create a Power Automate flow that retrieves all items and passes them to the app as a collection.

Answer

Add an index to the SharePoint list and enable the 'Allow items to be retrieved in batches' setting.

Question 10

A maker is building a canvas app that uses a Microsoft Dataverse table called Orders. The app includes a button that, when selected, should create a new order record and then immediately navigate to a confirmation screen. The maker writes the following formula in the button's OnSelect property: Patch(Orders, Defaults(Orders), {OrderDate: Today(), Status: "New"}); Navigate(ConfirmationScreen). After testing, the maker notices that the new record is created but the navigation does not occur. What is the most likely cause?

Accepted Answer

The Patch function returns a record, and the Navigate function is being treated as part of the record's field definitions.. The most likely cause is a syntax issue where the Navigate function is being interpreted as part of the Patch function's arguments rather than a separate action. In Power Apps, functions that return values must be properly closed before chaining with a semicolon. If parentheses are mismatched or the semicolon is misplaced, the subsequent function may not execute as a standalone action. Ensuring correct syntax allows both actions to run sequentially.

Answer

The Navigate function must be placed before the Patch function because canvas apps execute formulas from right to left.

Answer

The Patch function does not support creating new records in Dataverse; it can only update existing ones.

Answer

The semicolon separator is not valid in Power Apps formulas; the chaining operator should be a double ampersand.

Question 11

You are designing a canvas app that will be used by employees in the field. The app must work offline and synchronize data when connectivity is restored. Which two features should you implement to meet these requirements? (Choose two.)

Accepted Answer

Use the Connection.Connected property to detect network status and trigger synchronization.. To support offline use in a canvas app, you must cache data locally using SaveData and LoadData, and detect connectivity changes with Connection.Connected to trigger synchronization. These two features together allow the app to function without a network and sync when back online. Other options are either non-existent or infrastructure-level solutions that do not address app-level offline requirements.

Answer

Configure the app to use a SQL Server connection with Always On availability groups.

Answer

Set the app's 'OnStart' property to load data from a local cache file.

Answer

Enable the 'Offline sync' option in the app settings.

Question 12

A small business wants to give its sales team a mobile app that reads and writes rows in a Microsoft Excel workbook stored in OneDrive for Business. The maker has no programming experience and wants to build the app quickly with drag-and-drop controls. Which type of Power Apps app should the maker create?

Accepted Answer

A canvas app that connects to the Excel workbook as a data source.. The scenario calls for a no-code, drag-and-drop mobile app over an Excel workbook, which is exactly what a canvas app provides. Canvas apps connect to Excel through the Excel Online connector and let makers build screens with controls that read and write rows. Model-driven apps, portals, and Power BI all depend on different data platforms or serve different purposes.

Answer

A model-driven app based on a Microsoft Dataverse table that imports the Excel data.

Answer

A Power BI dashboard that writes back to the workbook through dataflows.

Answer

A Power Apps portal that exposes the workbook to external users through a public website.

Question 13

You are building a canvas app that uses a custom connector to an internal REST API. The API requires an API key for authentication. You need to ensure that the API key is not exposed to users of the app and is stored securely. What should you do?

Accepted Answer

Use Azure Key Vault to store the API key and configure the custom connector to retrieve it via a policy or environment variable.. Azure Key Vault is the recommended service for securely storing secrets like API keys. By integrating Key Vault with the custom connector, you can retrieve the key at runtime without exposing it in the connector or app. This separation of secrets from code and configuration is essential for security. Other options either store the key insecurely or do not provide adequate protection.

Answer

Store the API key in an environment variable and reference it in the custom connector's security configuration.

Answer

Configure the custom connector to use API key authentication and enter the key directly in the connector's security settings.

Answer

Hardcode the API key in the app's formulas and obfuscate it using a custom function.

Question 14

A maker builds a canvas app that records equipment inspections. The app must let users see and edit inspection records while offline in areas with no network coverage, then sync changes when connectivity returns. Which approach should the maker use?

Accepted Answer

Enable the app's offline capability by using the SaveData and LoadData functions to cache collections in the local device storage and reconcile them when online.. Offline support in a canvas app is achieved by caching data locally with SaveData and LoadData and monitoring connectivity with the Connection signal, then pushing queued changes to the data source once the device is back online. SharePoint lists, cloud flows, and model-driven offline profiles do not provide this behavior for an existing canvas app in the way the scenario requires.

Answer

Set the app's data source to a SharePoint list and rely on SharePoint's built-in offline sync to queue edits.

Answer

Add a Power Automate flow that runs on the device to buffer writes when the network is unavailable.

Answer

Convert the app to a model-driven app, which automatically stores all records offline and syncs later.

Question 15

You are building a canvas app that must display a chart showing sales by region. The data resides in a SharePoint list. Which Power Apps feature should you use to visualize the data?

Accepted Answer

Embed a Power BI tile that uses the SharePoint list as a data source.. Power BI integration through the Power BI tile control is the standard way to embed rich visualizations like charts in a canvas app. You can build a Power BI report connected to the SharePoint list and then embed a specific tile. This leverages Power BI's robust charting capabilities without custom development. Other options either do not exist or are impractical.

Answer

Create a custom connector to a charting API and display the chart in an Image control.

Answer

Use the Gallery control with conditional formatting to simulate a chart.

Answer

Add a Chart control and bind it to the SharePoint list.