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

Question 1

A business analyst wants to create a Power App without writing code. They need to build a mobile-friendly form for inventory tracking. Which approach should they use?

Accepted Answer

Create a canvas app from a template or blank, using drag-and-drop controls. Canvas apps allow drag-and-drop design without code, enabling the creation of mobile-friendly custom forms. Option B (model-driven app) is less flexible for custom form design and requires more configuration. Option C (Power Apps portal) is designed for external user-facing websites, not internal inventory tracking. Option D (customize SharePoint list form) is limited in mobile optimization and customization compared to a canvas app.

Answer

Create a model-driven app using Dataverse

Answer

Create a Power Apps portal

Answer

Customize a SharePoint list form

Question 2

Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)

Accepted Answer

Microsoft Dataverse. Option C, Microsoft Dataverse, is correct because it is a cloud-hosted service that canvas apps connect to natively through the built-in Dataverse connector, so no on-premises data gateway is required. Option D, SharePoint, is correct because SharePoint Online is a cloud service and canvas apps use the standard SharePoint connector to read and write lists and libraries directly without a gateway. Options A (SQL Server on-premises) and B (Oracle database on-premises) are not correct because on-premises databases are only reachable from Power Platform via the on-premises data gateway. Option E (SAP on-premises) is also not correct because on-premises SAP systems require the on-premises data gateway (or an equivalent secure bridge) to be accessed from a canvas app.

Answer

SQL Server on-premises

Answer

Oracle database on-premises

Answer

SAP on-premises

Question 3

A Power Apps canvas app uses a SharePoint list as its data source. Users report that the app is slow to load when the list contains over 10,000 items. What is the best approach to improve performance?

Accepted Answer

Use delegation-compatible functions and filters in the app.. Delegation allows queries to be processed on the data source side, reducing the amount of data transferred and improving performance. Option D is correct because delegation-compatible functions (e.g., Filter, LookUp) ensure only relevant data is retrieved. Option A is wrong because increasing the data row limit loads more data, worsening performance. Option B is wrong because switching to Dataverse might help but is not the best approach—it requires migration and may not always be feasible. Option C is wrong because reducing columns only marginally reduces data size, but without delegation, performance issues persist due to large row counts.

Answer

Increase the data row limit in the app settings.

Answer

Switch to a Microsoft Dataverse data source.

Answer

Reduce the number of columns in the SharePoint list.

Question 4

You are designing a Power Apps model-driven app for a sales team. The app must enforce that a discount field cannot exceed 50% of the total price. Where should you implement this validation?

Accepted Answer

Create a business rule on the table.. Business rules in Dataverse run server-side on the table regardless of which client (model-driven app, canvas app, API, or import) touches the record, so the 50% discount constraint is enforced consistently. They also work in model-driven forms without custom code and can show validation errors directly on the form. This is the standard low-code way to enforce cross-field validation on a Dataverse table.

Answer

In the canvas app formula bar.

Answer

Use a Power Automate flow triggered on record creation.

Answer

Write JavaScript in the form customisation.

Question 5

A company wants to build an app that allows employees to submit expense reports. The app must include approval workflow. Which Power Platform component should be used to define the approval process?

Accepted Answer

Power Automate. Power Automate is the Power Platform component specifically designed for workflow automation and approvals. It provides built-in approval actions and templates that allow you to define multi-step approval processes, send approval requests, and track responses. Power Apps is for building the user interface, Power BI for analytics, and Power Virtual Agents for chatbots, none of which natively handle approval workflows.

Answer

Power Virtual Agents

Answer

Power Apps

Answer

Power BI

Question 6

Your organisation has a Power Apps canvas app that uses a custom connector to call an external API. The API key is stored in a global variable. What is the security concern with this approach?

Accepted Answer

The API key can be exposed to end users in the app code.. Storing an API key in a global variable within a Power Apps canvas app is insecure because the app's code is accessible to end users. Anyone with access to the app can view the global variable's value through the App object or by inspecting the app's formulas, potentially exposing the API key. The correct answer is D. Option A is incorrect because custom connectors can be used with Power Apps. Option B is incorrect because global variables in Power Apps are writable, not read-only. Option C is incorrect because API keys typically do not expire quickly; the security concern is exposure, not expiration.

Answer

The custom connector cannot be used with Power Apps.

Answer

Global variables cannot store API keys because they are read-only.

Answer

The API key will expire quickly.

Question 7

A manager wants to create an app without writing any code. Which Power Apps type should they use?

Accepted Answer

Canvas app from a template. A canvas app from a template is the correct choice because it provides a pre-built, drag-and-drop design surface where a business user can customize screens, controls, and data connections without writing code. Templates accelerate development by supplying working layouts and sample data bindings that can be modified visually. This directly satisfies the 'no code' requirement while still producing a functional Power Apps application.

Answer

Power BI

Answer

Model-driven app

Answer

Power Automate

Question 8

You have a model-driven app that includes a custom table. You need to add a field that calculates a value based on other fields (e.g., total price = quantity * unit price). Which type of field should you create?

Accepted Answer

Calculated field. A Calculated field in Dataverse computes its value at runtime using a formula that references other columns in the same table, such as quantity * unit price. It is read-only and automatically updates when the referenced fields change. This matches the requirement for a field that derives its value from other fields.

Answer

Text field

Answer

Choice field

Answer

Rollup field

Question 9

Which THREE of the following are capabilities of Power Apps?

Accepted Answer

Use AI Builder to add artificial intelligence. Power Apps is a low-code application development platform, and option C is correct because it natively integrates with AI Builder, allowing makers to add prebuilt or custom AI models (such as form processing, object detection, and prediction) directly into canvas and model-driven apps. Option D is correct because Power Apps provides hundreds of built-in connectors, including standard connectors to Microsoft 365 services like SharePoint lists/libraries and Outlook (mail, calendar, contacts), enabling apps to read and write that data without custom code. Option E is correct because Power Apps ships Power Apps Mobile for iOS and Android plus the Power Apps app for Windows, so the same app runs on those mobile devices. Option A does not belong because complex, multi-step workflow automation is the role of Power Automate, not Power Apps itself. Option B does not belong because real-time streaming analytics is handled by Azure Stream Analytics (or Power BI streaming datasets), not by Power Apps.

Answer

Create complex workflow automations

Answer

Perform real-time streaming analytics

Question 10

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they provide a drag-and-drop, no-code/low-code design surface that lets makers build a custom mobile-friendly UI and connect to data sources like SharePoint, Dataverse, or SQL without writing code. They are ideal for task-oriented apps such as expense submission that need a tailored form and mobile deployment via Power Apps mobile or Teams.

Answer

Power Automate

Answer

Power Pages

Answer

Model-driven app

Question 11

An organization needs to create a custom app that displays data from Dynamics 365 Sales and allows users to update records. The app should automatically generate a responsive UI based on the data model. Which type of app should they build?

Accepted Answer

Model-driven app. A model-driven app is the correct choice because it automatically generates a responsive UI based on the underlying data model (e.g., Dynamics 365 Sales entities like Account, Contact, Opportunity). It provides built-in forms, views, and business process flows that allow users to view and update records without manual UI design, aligning with the requirement for automatic UI generation and data update capabilities.

Answer

Canvas app

Answer

Power Automate

Answer

Power Pages

Question 12

A company uses a canvas app to collect customer feedback. The app stores data in Microsoft Dataverse. Users report that some submissions are not saved when the app loses internet connection. How should the app be modified to prevent data loss?

Accepted Answer

Enable offline capability in the app settings. Enabling offline capability with a local cache allows data to be saved locally and synced when online. Reducing controls or increasing data limit won't solve offline loss.

Answer

Use a SharePoint list instead of Dataverse

Answer

Reduce the number of controls on the form

Answer

Increase the data row limit in Dataverse

Question 13

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

Accepted Answer

Create a canvas app from the Excel file. A canvas app can be created directly from an Excel file stored in OneDrive using the Power Apps 'Start from data' option. This generates a three-screen app (browse, detail, edit) that connects to the Excel table via the OneDrive for Business connector, making it ideal for simple personal expense tracking without requiring Dataverse or custom development.

Answer

Use Power Pages to display the Excel file

Answer

Create a model-driven app using Dataverse

Answer

Use Power Automate to create a mobile app

Question 14

Which THREE components are part of a canvas app's formula language?

Accepted Answer

Functions. In Power Apps canvas apps, the formula language (Power Fx) is built from functions such as Filter, Sum, and Patch, which perform calculations and data operations, so option A is correct. Operators like +, -, =, &&, and in are also core elements of the formula language because they combine and compare values within expressions, making option D correct. Controls and properties are essential because formulas are written into a control's property, such as a Label's Text or a Button's OnSelect, and those properties are what the formula evaluates, so option E is correct. Dataverse tables (B) are data sources that formulas can reference, but they are not themselves components of the formula language, and Power Automate flows (C) are separate automation resources invoked from apps rather than part of the formula syntax.

Answer

Dataverse tables

Answer

Power Automate flows

Question 15

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

Accepted Answer

Excel (OneDrive/SharePoint). Option A (Excel in OneDrive/SharePoint) is correct because Excel workbooks stored in OneDrive for Business or SharePoint are accessed through the standard Excel connector, which is a non-premium (Standard) connector included with Power Apps. Option C (SharePoint) is correct because the SharePoint connector is also a Standard connector, allowing canvas apps to read and write SharePoint lists and libraries without a premium license. Option B (Microsoft Dataverse) is incorrect because Dataverse requires premium licensing/connectors. Option D (SQL Server) is incorrect because the SQL Server connector is a premium connector. Option E (Salesforce) is incorrect because the Salesforce connector is a premium connector.

Answer

Microsoft Dataverse

Answer

SQL Server

Answer

Salesforce