PL-900 Practice Test 19 — 15 Questions

Question 1

A business needs to build a Power Apps app that allows sales representatives to view customer information and update order status while offline. The data source is Microsoft Dataverse. Which type of Power App should the maker create?

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

Accepted Answer

Canvas app with offline enabled.. Canvas apps can be enabled for offline use with Dataverse, allowing sales reps to view customer information and update order status without connectivity. Option A is incorrect because model-driven apps require online connectivity for full functionality; although offline profiles exist for mobile clients, they do not support all operations like creating new records or updating data while completely offline. Option B is incorrect because Power Pages is for external-facing websites, not offline mobile app scenarios. Option C is incorrect because AI Builder provides AI capabilities, not offline data access.

Answer

Model-driven app with offline profile.

Answer

Power Pages site.

Answer

AI Builder model.

Question 2

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. Image column (B) in Dataverse is designed to store images. A is for text. C is for files. D is binary but not directly accessible.

Answer

Text column

Answer

File column

Answer

Binary column

Question 3

A Power Apps model-driven app includes a business process flow (BPF) for order processing. After editing the BPF, some users see the old version while others see the new version. What is the most likely reason?

Accepted Answer

Some users have not refreshed their app session. BPF changes are cached and refreshed when users reload the app. Admin vs. user views can differ due to security roles, but the inconsistency is due to caching.

Answer

Users have different security roles that show different BPF stages

Answer

The BPF was published to only a subset of users

Answer

The BPF was not activated after editing

Question 4

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. Calculated fields perform calculations at the data source level, such as total price = quantity * unit price. Option A is correct. Option B is wrong because text fields store plain text, not calculations. Option C is wrong because choice fields provide a dropdown list of options. Option D is wrong because rollup fields aggregate data from related records, not compute values from fields in the same record.

Answer

Text field

Answer

Choice field

Answer

Rollup field

Question 5

Which of the following are valid data sources for Power Apps?

Accepted Answer

Microsoft SharePoint. SharePoint Online (B), SQL Server on-premises with a gateway (C), and Microsoft Dataverse (E) are all valid data sources for Power Apps. Option A is incorrect because a desktop Excel file is not directly supported; it must be stored in OneDrive or SharePoint. Option D is incorrect because JSON is a data format, not a data source.

Answer

Microsoft Excel (desktop file)

Answer

JSON file

Question 6

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 7

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 8

A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?

Accepted Answer

Create a Power Automate flow with a trigger 'When a record is updated' and condition on status change.. The correct approach is to create a Power Automate flow with a trigger 'When a record is updated' and a condition on the status change to 'Resolved'. This automates the email sending when the status is updated. Option A (PCF control) requires custom development and does not automatically trigger on status change. Option C (manual button) requires user interaction and does not trigger automatically. Option D (business rule) cannot send emails directly; business rules only modify fields or show messages.

Answer

Use a Power Apps component framework (PCF) control to trigger an email.

Answer

Add a button on the form that runs a Power Automate flow on demand.

Answer

Create a business rule that sends an email when the status is updated.

Question 9

Which TWO Power Apps features allow you to integrate AI capabilities into your app? (Choose two.)

Accepted Answer

Copilot integration. Options D and E are correct because AI Builder allows you to add AI models directly to Power Apps, and Copilot integration enables embedding AI-powered copilots. Option A (Power Virtual Agents) is a standalone product for chatbots, not a feature within Power Apps. Option B (Power Automate) is a separate automation product. Option C (Common Data Model) is a data schema, not an AI-capability feature.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Common Data Model

Question 10

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

Accepted Answer

Use a gallery to list orders and navigate to a detail screen on selection. Using a gallery to list orders and navigating to a detail screen on selection is the most efficient pattern for browsing and drilling into details. Option A is incorrect because a data table directly connected to the data source does not provide an easy way to drill into each order's details without additional configuration. Option C is incorrect because a single form with navigation buttons is less efficient for browsing a list and requires manual navigation. Option D is incorrect because exporting to Excel defeats the purpose of a real-time app and is not efficient.

Answer

Use a data table connected directly to the data source

Answer

Use a single form with navigation buttons to move between orders

Answer

Export the data to Excel and use Power Apps to display the Excel file

Question 11

A sales manager wants a mobile app to view customer details and open orders. The app should be built quickly without custom code. Which approach should they use?

Accepted Answer

Create a model-driven app from Dataverse. A model-driven app built from Dataverse (formerly Common Data Service) is the best choice because it is generated automatically from the data model, requiring minimal customization and no custom code. This allows the sales manager to quickly create a mobile app that displays customer details and open orders. Canvas apps (B) require manual design and custom code. Power BI (C) is for analytics dashboards, not interactive apps. Power Automate (D) is for workflow automation, not app creation.

Answer

Build a canvas app from scratch

Answer

Use Power BI to create a mobile dashboard

Answer

Use Power Automate to create a mobile flow

Question 12

Refer to the exhibit. The JSON shows the definition of a Power Apps canvas app. Based on the exhibit, which data source is the app connected to?

Accepted Answer

SharePoint list. The JSON clearly shows the data source type as 'SharePointList'. Option A is correct. Option B is wrong because Dataverse is not listed. Option C is wrong because SQL Server is not listed. Option D is wrong because Excel is not listed.

Answer

Microsoft Dataverse

Answer

SQL Server

Answer

Excel Online

Question 13

Which TWO features are available in model-driven apps but not in canvas apps?

Accepted Answer

Business process flows. Model-driven apps include business process flows and dashboards natively, while canvas apps require custom implementation. Custom connectors and offline capability are available in both.

Answer

Custom connectors

Answer

Responsive design

Answer

Offline capability

Question 14

Which TWO Power Apps features allow sharing apps with users who have a Power Apps per app plan?

Accepted Answer

Sharing the app with a security group. Sharing an app with a security group allows you to assign per app plan licenses to all members of that group. Option C is correct because you must assign per app plan licenses to users explicitly to grant access. Option A is incorrect because adding users as co-owners does not provide them with a license; they still need a per app plan or per user plan. Option D is incorrect because granting Dataverse access does not include a Power Apps license. Option E is incorrect because sharing with everyone in the organization requires a per user plan or different licensing agreement.

Answer

Adding users as co-owners of the app

Answer

Granting Dataverse access to users

Answer

Sharing the app with everyone in the organization

Question 15

A user created a canvas app to collect feedback. The app writes data to an Excel file stored in OneDrive. When multiple users submit feedback simultaneously, some entries are lost. What is the most likely cause?

Accepted Answer

Excel is not designed for concurrent multi-user writes. Excel is not designed for concurrent multi-user writes. When multiple users submit data simultaneously, conflicts and data loss occur. Option A is incorrect because the issue is not performance but concurrency. Option B is incorrect because OneDrive sync does not lock the file in a way that causes data loss; the underlying problem is Excel's lack of concurrent write support. Option C is incorrect because a Power Automate flow would not cause entries to be lost; it might introduce delays but not data loss.

Answer

The app has a performance issue

Answer

The Excel file is locked by OneDrive sync

Answer

A Power Automate flow is delaying the write