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

Question 1

A Power Apps developer needs to store an image uploaded by a user in a canvas app. The app uses Microsoft Dataverse. Which column type should be used for the image?

Accepted Answer

Image column. The Image column type in Microsoft Dataverse is purpose-built for storing a single image per record and is optimized for rendering in model-driven and canvas apps. It stores the image in a special format that supports thumbnail generation and efficient display, unlike generic file or binary storage. This makes it the correct choice when a user uploads an image that needs to be displayed directly in the app.

Answer

Text column

Answer

File column

Answer

Binary column

Question 2

A company wants to build a Power App that uses AI to analyze survey responses and extract sentiment. Which Power Platform capability should they use?

Accepted Answer

AI Builder sentiment analysis model. AI Builder provides prebuilt AI models, including a sentiment analysis model, that can be invoked directly from Power Apps and Power Automate without custom ML code. For analyzing survey text and extracting sentiment, the AI Builder sentiment analysis model is the purpose-built capability. It returns a sentiment score and label per response, which can then be stored or visualized.

Answer

Power BI dashboards

Answer

Power Automate flows

Answer

Power Apps Canvas app with formulas

Question 3

Which THREE components are part of a model-driven app? (Choose three.)

Accepted Answer

Forms. In Power Apps, a model-driven app is composed of metadata-driven components rendered by the platform, and Forms (A) are one of them: they define the data-entry and display layout for a table's records, with types like Main, Quick Create, and Card forms. Views (B) are also core components, since they define how lists of records are filtered, sorted, and displayed in the app's grids. The Sitemap (E) is the component that defines the app's navigation structure, organizing tables, views, and other elements into areas, groups, and subareas shown in the app. Screens (C) belong to canvas apps, where the maker drags-and-drops UI controls onto a blank canvas, not to model-driven apps. Triggers (D) are not a model-driven app component; event-driven logic in model-driven apps is implemented through business rules, workflows, plug-ins, or Power Automate, not a 'Triggers' building block.

Answer

Screens

Answer

Triggers

Question 4

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

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse and SharePoint are standard connectors that can be used without a premium license. Salesforce requires a premium connector. Excel Online (Business) is also a standard connector, but the correct answers for this question are Dataverse and SharePoint. SQL Server requires a premium connector.

Answer

Salesforce

Answer

Excel Online (Business)

Answer

SQL Server

Question 5

A company wants to create a custom app to track inventory in their warehouse. The app needs to integrate with their existing SQL Server database and allow users to scan barcodes to update stock levels. Which type of Power Apps should they use?

Accepted Answer

Canvas app. (Canvas app) is correct because Canvas apps allow custom integration with SQL Server and barcode scanning via device capabilities. Model-driven apps are more for data management but not as flexible for custom scanning. Power Pages is for external websites, not scanning. Power Automate is for workflows, not app building.

Answer

Power Pages

Answer

Power Automate

Answer

Model-driven app

Question 6

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

Accepted Answer

Configure field-level security in Microsoft Dataverse. Field-level security in Microsoft Dataverse allows administrators to restrict access to a specific field based on security roles. This ensures only agents in the 'Premium Support' role can see the 'SLA Level' field. Option A is incorrect because removing the field from the form would affect all users. Option B is not a standard security feature; Canvas apps are not designed for field-level permissions in model-driven apps. Option D is incorrect because a business rule can only make a field read-only, but it cannot hide the field from specific roles.

Answer

Remove the field from the form and create a separate form for Premium Support agents

Answer

Use the 'Visible' property of the field in a Canvas app embedded in the model-driven app

Answer

Create a business rule that sets the field as read-only for non-Premium roles

Question 7

A business analyst wants to build an app quickly using a pre-built template. Which Power Apps capability should they use?

Accepted Answer

Use a Power Apps template from the template gallery. Power Apps offers templates for common scenarios. Canvas apps from blank require more effort. Model-driven apps are not template-based. Power Automate is for workflows.

Answer

Create a Model-driven app from a Dataverse table

Answer

Use Power Automate to generate the app

Answer

Create a Canvas app from blank

Question 8

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

Accepted Answer

Disable the submit button after the first click using the DisplayMode property. Setting the submit button's DisplayMode property to Disabled after the first click prevents the user from triggering the OnSelect logic a second time, which directly stops duplicate records at the source. This is the standard Power Apps pattern for idempotent form submission because it blocks the second event before it can create another Dataverse row.

Answer

Set the form to require a unique ID before submission

Answer

Add a business rule to check for duplicates before saving

Answer

Use a Power Automate flow to delete duplicates after creation

Question 9

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

Accepted Answer

Offline capability in Dataverse (mobile offline sync). Dataverse mobile offline sync is the built-in Power Apps capability that lets canvas and model-driven apps download a filtered subset of Dataverse tables to the device, so field technicians can read and write data without connectivity. When the device reconnects, queued changes are synchronized back to Dataverse automatically, resolving conflicts server-side. This directly satisfies the offline-first requirement without custom code.

Answer

Power Apps portals

Answer

Power Apps component framework

Answer

Monitor tool in Power Apps

Question 10

Which TWO of the following are capabilities of Power Apps? (Choose TWO.)

Accepted Answer

Create custom business apps with low-code. Option B is correct because Power Apps is Microsoft's low-code application development platform, letting makers build custom business apps using canvas or model-driven design with connectors to data sources like Dataverse, SharePoint, and SQL. Option D is correct because Power Apps can be published and embedded directly into Microsoft Teams as personal apps, channel tabs, or via the Power Apps app for Teams, enabling users to run apps within their Teams workspace. Option A is not correct because interactive dashboards and reports are the domain of Power BI, not Power Apps. Option C is not correct because running serverless code in the cloud is a capability of Azure Functions (or Azure Logic Apps for workflows), not Power Apps. Option E is not correct because automating workflows and processes is the core purpose of Power Automate, not Power Apps.

Answer

Build interactive dashboards and reports

Answer

Run serverless code in the cloud

Answer

Automate workflows and processes

Question 11

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

Accepted Answer

They have built-in role-based security. Option B is correct because model-driven apps inherit the role-based security model of Microsoft Dataverse, where access is governed by security roles, teams, business units, and record-level sharing rather than custom code. Option C is correct because model-driven apps are built directly on Microsoft Dataverse, using its tables, relationships, and metadata to define the app's data model and behavior. Option D is correct because model-driven apps use the Unified Interface, which is responsive and adapts to different screen sizes, so they work across desktop, tablet, and mobile devices. Option A is incorrect because model-driven apps rely on declarative configuration such as business rules, workflows, and Power Automate flows rather than custom formulas for business logic. Option E is incorrect because model-driven apps are also available through the Power Apps mobile app on iOS and Android, not only in web browsers.

Answer

They require custom formulas for business logic

Answer

They can only be used on web browsers

Question 12

You are designing a model-driven app for a sales team. The app must show related opportunities on an account form using a subgrid. The subgrid should only display open opportunities. Which configuration should you apply?

Accepted Answer

Add a subgrid and select a view that filters for status equals 'Open'. To display only open opportunities in a subgrid, you should select a view that filters for status equals 'Open'. This ensures that the subgrid shows only the relevant records. The view can be a system view or a custom view with the appropriate filter.

Answer

Use a business rule to hide closed opportunities

Answer

Set a calculated field to mark opportunities as open

Answer

Create a workflow to remove closed opportunities from the subgrid

Question 13

An organization needs a Power App that allows employees to submit expense reports by filling out a form and attaching receipts. Which type of app should you create and why?

Accepted Answer

Canvas app, because it provides flexible form design and supports file attachments. A canvas app is correct because it gives the maker full control over the layout and controls, allowing a custom form with a file attachment control (e.g., the Attachments control or the Add Picture control) bound to a data source like SharePoint or Dataverse. Canvas apps are ideal for task-specific, form-based scenarios where the UI must be tailored to the user's needs, such as submitting expense reports with receipts. Model-driven apps use standard forms that are less flexible for custom attachment handling, and AI Builder is an add-on capability, not an app type. Power Apps portals are for external users, not employees.

Answer

Model-driven app, because it uses standard Dataverse forms

Answer

AI Builder app, because it can process receipts automatically

Answer

Power Apps portal, because it allows external users to submit expenses

Question 14

A company wants to build a Power App that uses AI to extract information from uploaded invoices. Which capability should they use?

Accepted Answer

AI Builder invoice processing model. AI Builder's invoice processing model is a prebuilt AI capability in Power Platform specifically designed to extract structured data (vendor, total, line items) from invoices using OCR plus machine learning. It integrates directly with Power Apps and Power Automate and requires no custom model training. This is the purpose-built solution for the stated requirement.

Answer

Power Automate with OCR actions

Answer

Power Virtual Agents

Answer

Copilot Studio

Question 15

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

Accepted Answer

Use delegable queries to filter data at the source. Using delegable queries to filter data at the source reduces the amount of data retrieved from the data source, which significantly improves performance. When queries are delegable, the filtering and sorting are performed by the data source (e.g., SQL, SharePoint) rather than in Power Apps, minimizing data transfer and processing. This is especially important with many data sources and complex formulas.

Answer

Increase the data row limit for each data source

Answer

Disable the formula-level error checking

Answer

Remove unused data sources from the app