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

Question 1

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?

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

Accepted Answer

Disable the submit button after the first click using the DisplayMode property. Disabling the submit button after the first click using the DisplayMode property prevents duplicate submissions by ensuring the button cannot be clicked again. Option A is not feasible because requiring a unique ID before submission would change the data entry process and does not address the double-click issue directly. Option C is incorrect because a business rule in Dataverse runs after submission, so it would not prevent duplicates from the same double-click. Option D is incorrect because a Power Automate flow to delete duplicates after creation does not prevent the duplicates from being submitted in the first place.

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 2

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 provides offline capability for mobile apps, allowing field technicians to work without connectivity and sync data when reconnected. Option B, Power Apps portals, is for external-facing websites, not offline mobile apps. Option C, Power Apps component framework, is for building custom controls, not offline sync. Option D, Monitor tool, is for debugging and performance monitoring, not offline functionality.

Answer

Power Apps portals

Answer

Power Apps component framework

Answer

Monitor tool in Power Apps

Question 3

A user wants to add a chart to a model-driven app to visualize sales data. Which component should they use?

Accepted Answer

Chart component from the Dataverse table. Model-driven apps include built-in chart visualization for Dataverse data. Option B is for Canvas apps. Option C is for custom visuals in Power BI. Option D is not a standard chart component.

Answer

Chart control from the Power Apps canvas

Answer

Excel chart imported into the app

Answer

Power BI tile embedded in the app

Question 4

An administrator needs to ensure that a Canvas app can only be used by licensed users within the organization. What should they configure?

Accepted Answer

Share the app with specific security groups that contain licensed users. To restrict a Canvas app to licensed users only, the administrator should share the app with specific security groups that contain licensed users. Power Apps licensing is per user; sharing the app with a security group ensures that only members of that group (who must have appropriate licenses) can access it. Option A is incorrect because removing the app from the Teams catalog does not enforce licensing. Option B is incorrect because publishing the app to everyone in the tenant would allow all users to access it regardless of license status. Option C is incorrect because there is no 'Require user license' setting in Power Apps; licensing is enforced at the user level when sharing.

Answer

Remove the app from the Microsoft Teams app catalog

Answer

Publish the app to everyone in the tenant

Answer

Set the app to 'Require user license' in the app settings

Question 5

A developer is building a Canvas app that uses a custom connector to an external API. The API requires OAuth 2.0 authentication. What must the developer do to set up the connector?

Accepted Answer

Register an application in Microsoft Entra ID and configure the custom connector with the client ID and secret. Custom connectors with OAuth 2.0 require registering the app in Microsoft Entra ID. Option A is not possible. Option B is for custom API, not authentication. Option C is for API key authentication, not OAuth.

Answer

Select 'OAuth 2.0' as the authentication type and enter the API key

Answer

Create the connector with a Swagger file and set authentication to 'Anonymous'

Answer

Use the built-in HTTP connector with Basic authentication

Question 6

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

Accepted Answer

Create custom business apps with low-code. Options B and D are correct. Power Apps enables users to create custom business applications with low-code or no-code development, and these apps can be embedded directly into Microsoft Teams for easy access. Option A is incorrect because building interactive dashboards and reports is a capability of Power BI, not Power Apps. Option C is incorrect as running serverless code in the cloud is done via Azure Functions. Option E is incorrect as workflow automation is the domain of Power Automate.

Answer

Build interactive dashboards and reports

Answer

Run serverless code in the cloud

Answer

Automate workflows and processes

Question 7

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

Accepted Answer

They have built-in role-based security. Options B, C, and D are correct. Model-driven apps are built on Microsoft Dataverse, have built-in role-based security, and are responsive across devices. Option A is incorrect because model-driven apps do not require custom formulas; they use declarative logic and business rules. Option E is incorrect because model-driven apps work on both web browsers and mobile devices.

Answer

They require custom formulas for business logic

Answer

They can only be used on web browsers

Question 8

Which TWO of the following are valid data sources for a Canvas app? (Choose TWO.)

Accepted Answer

SharePoint Online list. Options A and E are correct. Canvas apps can connect to SharePoint Online lists and Microsoft Dataverse, both of which are valid data sources. Option D (Microsoft Entra ID) is an identity service, not a data source. Option B (Power Automate flow) is an automation service, not a data source. Option C (Microsoft Intune) is a device management service and not a data source.

Answer

Power Automate flow

Answer

Microsoft Intune

Answer

Microsoft Entra ID

Question 9

A company wants to create a canvas app for field technicians to report equipment issues. The app must work offline and sync data when connectivity is restored. Which Power Apps feature should you enable?

Accepted Answer

Enable the 'Enable offline' feature in the Power Apps mobile app settings. The 'Enable offline' feature in the Power Apps mobile app settings allows canvas apps to cache data locally and sync with the server when connectivity is restored, enabling offline operation. Option A is incorrect because Power Automate flows can queue operations but do not provide native offline data caching for canvas apps. Option B is incorrect because Dataverse offline profiles are used for model-driven apps, not canvas apps. Option C is incorrect because the on-premises data gateway is for accessing on-premises data sources, not for enabling offline capabilities.

Answer

Create a Power Automate flow to queue operations

Answer

Use a Dataverse offline profile

Answer

Configure an on-premises data gateway

Question 10

Your model-driven app uses a custom entity 'Project' with a 1:N relationship to 'Task'. You need to add a subgrid on the Project form that shows related tasks, but only tasks assigned to the current user. How should you achieve this?

Accepted Answer

Create a system view on the Task entity that filters by 'Owner equals Current User' and select it in the subgrid properties. You can create a system view on the Task entity that filters by 'Owner equals Current User' and then select that view in the subgrid properties. Option A is wrong because workflows cannot filter subgrids; they can only automate processes. Option B is wrong because business rules control form behavior (like visibility or field values) but cannot filter subgrid data. Option D is wrong because using the default view would show all tasks (or those allowed by security roles), not filtered by current user; security roles control access rights, not subgrid filtering criteria.

Answer

Create a workflow that updates a field on the Project form to filter the subgrid

Answer

Add a business rule on the Project form to filter the subgrid

Answer

Configure the subgrid to use the default view and assign security roles to filter tasks

Question 11

You are building a canvas app that collects customer feedback. The app must send an email notification to the manager whenever a new feedback entry is submitted. What is the recommended approach?

Accepted Answer

Create a Power Automate flow that triggers when a new row is added to the data source and sends an email. Power Automate can trigger on data changes in the data source and send emails. Option A is wrong because the Outlook connector in Power Apps requires user interaction. Option B is wrong because direct email from Power Apps is not secure and not recommended. Option D is wrong because SharePoint lists don't automatically send emails.

Answer

Use the Office365 Outlook connector within Power Apps to send an email directly

Answer

Configure the app to call a custom API that sends an email

Answer

Store feedback in a SharePoint list and use 'Send email' action in SharePoint

Question 12

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. I Builder invoice processing model. AI Builder provides a prebuilt model specifically for extracting information from invoices. Option A (Power Automate with OCR actions) can be used but is not a dedicated AI capability for invoice processing. Option C (Power Virtual Agents) is for chatbots, and Option D (Copilot Studio) is for custom copilots, neither of which is designed for invoice data extraction.

Answer

Power Automate with OCR actions

Answer

Power Virtual Agents

Answer

Copilot Studio

Question 13

You need to design a Power App that allows users to view and update customer records from a SQL Server database. The app must enforce row-level security based on the user's region. What should you use?

Accepted Answer

SQL Server row-level security with the USER_NAME() function. SQL Server row-level security with the USER_NAME() function. This allows you to filter rows in SQL Server based on the user's identity, which can be passed from Power Apps using the User() function. Option A is incorrect because Power Apps security groups control access to the app itself, not data row-level filtering. Option B is incorrect because Dataverse security roles apply to Dataverse tables, not SQL Server. Option C is incorrect because environment security restricts access to the environment, not specific rows in a SQL Server database.

Answer

Power Apps security groups

Answer

Dataverse security roles

Answer

Environment security

Question 14

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. Delegable queries process filtering on the data source server, reducing the amount of data transferred to the app and improving load time. Option A is incorrect because increasing the data row limit can actually increase the amount of data loaded, worsening performance. Option C is incorrect because disabling formula-level error checking does not affect performance and can hide issues. Option D is incorrect because removing unused data sources helps reduce app size but may not be the most impactful action for slow loading due to excessive data retrieval.

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

Question 15

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