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

Question 1

Refer to the exhibit. The app uses a Dataverse entity 'contoso_inventory'. Users report that the gallery does not show items with Stock < 10. What is the most likely cause?

Accepted Answer

The data source filter 'status eq Active' excludes records with Stock < 10. The data source filter 'status eq Active' is applied to the datasource before the gallery's Filter function. If records with Stock < 10 have a status other than 'Active', they are excluded by the datasource filter and never reach the gallery, causing the issue. Option B is false because Dataverse supports filter delegation for many operations. Option C is the delegation limit of 500 records would limit the number of items shown, but it would not exclude all items with Stock < 10 unless they are all beyond the limit, which is unlikely. Option D is false because Dataverse supports delegation for numeric comparisons like '<' on the Stock column, so the Filter function is delegable and should apply to all records.

Answer

Dataverse does not support Filter delegation

Answer

The app has a delegation limit of 500 records

Answer

The Filter function in Gallery1 is non-delegable and may not apply to all records

Question 2

A company wants to create a Power Apps app that can be embedded in Microsoft Teams. Which type of Power Apps should they use?

Accepted Answer

Canvas app. Canvas apps can be directly embedded in Microsoft Teams using the 'Add to Teams' feature. Option A is incorrect because Power Pages are for building public-facing websites, not for embedding in Teams. Option B is incorrect because Copilot Studio is a tool for creating conversational AI, not a Power Apps type. Option C is incorrect because Model-driven apps are not directly embeddable in Teams; they require additional integration steps.

Answer

Power Pages

Answer

Copilot Studio

Answer

Model-driven app

Question 3

A model-driven app uses a custom business process flow. Users report that they cannot progress beyond a stage even after completing all required fields. What should you check?

Accepted Answer

Whether the stage has a condition that is not being met. Business process flow stages can have conditions that must be satisfied before progressing. If a condition is not met, the user cannot move to the next stage. Option A is incorrect because stages are not locked by administrators in standard configurations. Option B is incorrect because required fields on the form may not be part of the stage condition; the condition could involve other criteria. Option C is incorrect because security roles control access to records, not the progression within a business process flow.

Answer

Whether the stage is locked by an administrator

Answer

Whether the required fields on the form are marked as business required

Answer

Whether the user has the correct security role to update the stage

Question 4

Which TWO features are available in Canvas apps but NOT in model-driven apps? (Choose two.)

Accepted Answer

Custom connectors to external APIs. Options C and D are correct because Canvas apps allow custom connectors to external APIs and custom JavaScript/Power Fx formulas, while model-driven apps use predefined logic and connectors. Option A is wrong because both Canvas and model-driven apps can embed Power BI reports. Option B is wrong because both support Dataverse integration. Option E is wrong because both types support offline capability.

Answer

Embedding Power BI reports

Answer

Integration with Microsoft Dataverse

Answer

Offline capability

Question 5

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

Accepted Answer

Formula bar. Options A, C, and D are correct because Power Apps Studio for building canvas apps includes the Formula bar, Tree view, and Property pane. Option B (Solution Explorer) is incorrect because it is a component of Power Apps for model-driven apps, not canvas apps. Option E (Report Designer) is incorrect because it is a component of Power BI, not Power Apps Studio.

Answer

Solution Explorer

Answer

Report Designer

Question 6

Which THREE data sources support delegation in Power Apps? (Choose three.)

Accepted Answer

SharePoint lists. SharePoint lists, SQL Server, and Microsoft Dataverse all support delegation in Power Apps. Since the question asks for three, all three are correct. SharePoint uses its OData endpoint for server-side queries. SQL Server supports delegation for most operations, though with limitations. Dataverse uses its own query engine for full delegation. Excel workbooks and text files lack server-side processing and do not support delegation.

Answer

Excel workbooks

Answer

Text files

Question 7

Your organization is a multi-national corporation using Microsoft Power Platform. The compliance team requires that all Power Apps apps be auditable: every data modification (create, update, delete) must be logged with the user, timestamp, and old/new values. Additionally, the app must enforce that only users from the same business unit can view each other's records. The app uses Dataverse as the data source. You need to design the solution. Which approach should you take?

Accepted Answer

Enable Dataverse auditing for the entity and configure business unit security to restrict access. Dataverse provides built-in auditing that logs data modifications (create, update, delete) with user, timestamp, and old/new values. Business unit security in Dataverse can restrict record visibility to users within the same business unit, meeting the compliance requirement. Option B is incorrect because hierarchy security is not designed for record visibility restrictions based on business units; business unit security is the appropriate feature. Option C is incorrect because while Power Automate can create custom logs, it is not a native auditing solution and adds unnecessary complexity; field-level security does not restrict record visibility but rather specific field access. Option D is incorrect because creating a separate audit table and using Power Automate for logging is redundant since Dataverse auditing already provides this capability.

Answer

Enable Dataverse auditing and use hierarchy security with business units

Answer

Use Power Automate to create custom logs and use field-level security to restrict visibility

Answer

Create a separate audit table and use Power Automate to write logs, and use role-based security

Question 8

A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?

Accepted Answer

Use a SharePoint list as the data source and a Canvas app. SharePoint lists are easy to set up with no extra licensing (often included with Microsoft 365) and can be used with Canvas apps, which are low-code and easy to maintain. Option A is wrong because Dataverse requires additional licensing and Model-driven apps are more complex to build and maintain. Option B is wrong because Excel on OneDrive does not support multi-user concurrent access reliably and can lead to data conflicts. Option C is wrong because SQL Server requires dedicated infrastructure and maintenance, which is not feasible for a small business with limited budget and no IT staff.

Answer

Use Dataverse as the data source and a Model-driven app

Answer

Use Excel stored on OneDrive and a Canvas app

Answer

Use SQL Server as the data source and a Canvas app

Question 9

A company uses Power Apps to build a canvas app for field technicians to report equipment issues. The app includes a GPS location control and requires offline capability. During a pilot, technicians report that the app fails to load data when they are in remote areas with no internet. Which design change should the app maker implement to address this issue?

Accepted Answer

Enable offline use and configure the app to cache data locally.. Enabling offline use in canvas apps allows users to load data while connected and work with cached data when disconnected. Option A is wrong because adjusting GPS settings does not affect offline data availability. Option B is wrong because Power Automate flows require connectivity and do not enable offline data storage. Option D is wrong because converting to a model-driven app does not inherently solve offline requirements unless specifically configured.

Answer

Adjust the GPS control to use high accuracy mode.

Answer

Add a Power Automate flow to sync data periodically.

Answer

Convert the canvas app to a model-driven app.

Question 10

A business analyst creates a model-driven app to manage customer service cases. The app includes a custom form with a field called 'Priority' that has three options: Low, Medium, High. The analyst wants to ensure that only users in the 'Service Managers' security role can change the priority of a case. What should the analyst do?

Accepted Answer

Configure a field security profile for the Priority field and grant read-only access to other roles.. Field security profiles allow restricting write access to specific fields based on user roles. Option B is wrong because editing the Service Manager security role to include write privileges for the Case entity would grant write access to all fields, not just Priority, and would not restrict other roles. Option C is wrong because setting the field to 'Read-Only' in the form editor applies to all users, not based on roles. Option D is wrong because a business rule to hide the field does not prevent users with direct URL access or other methods from changing the field; it only hides it in the form.

Answer

Edit the Service Manager security role to include write privileges for the Case entity.

Answer

Set the Priority field to 'Read-Only' in the form editor.

Answer

Create a business rule to hide the field when the user is not a Service Manager.

Question 11

An organization has a model-driven app that uses a custom connector to an on-premises SQL Server database via an on-premises data gateway. Recently, users reported that the app is slow when loading data from the SQL Server. The network team confirms that the gateway server has sufficient resources. Which factor is most likely causing the performance degradation?

Accepted Answer

The on-premises data gateway is configured with a single data source and is not scaled for concurrent requests.. The on-premises data gateway, if configured with a single data source and not scaled for concurrent requests, can become a bottleneck when multiple users or queries access the SQL Server simultaneously, leading to slow performance. Option A is incorrect because the presence of a canvas app component doesn't inherently cause excessive data loading; data loading depends on how the app is built. Option B is incorrect because authentication method (OAuth vs basic) affects security, not performance. Option C is incorrect because the Power Apps license type (per app vs per user) affects licensing cost and access, not the performance of data retrieval through the gateway.

Answer

The model-driven app uses a canvas app component that loads excessive data.

Answer

The custom connector uses OAuth authentication instead of basic authentication.

Answer

The Power Apps license assigned to users is per app, not per user.

Question 12

A company uses Power Apps to create a canvas app for employee expense reporting. The app needs to integrate with the corporate HR system to fetch employee details such as manager email and cost center. The HR system exposes a REST API that requires an API key in the header. Which approach should the app maker use to securely connect to the HR system?

Accepted Answer

Create a custom connector with API key authentication and use it in the app.. The correct approach is to create a custom connector with API key authentication. This securely stores the API key in the connector definition and allows the canvas app to call the HR system's REST API without exposing the key in the app code. Option A is wrong because a SharePoint list is not a REST API and cannot integrate with an external HR system. Option B is wrong because although Power Automate can call the API, it does not inherently provide a more secure way to handle the API key than a custom connector; the custom connector is specifically designed for this purpose within Power Apps. Option D is wrong because hardcoding the API key in the app's HTTP action headers exposes the key in the app code, which is not secure.

Answer

Store the HR data in a SharePoint list and connect the app to SharePoint.

Answer

Build a Power Automate flow that calls the API and returns data to the app.

Answer

Use the HTTP action in Power Apps to call the API and include the API key in the headers as a static value.

Question 13

A model-driven app uses a custom button that runs a Power Automate flow to send an email notification. Users report that the button sometimes does not appear on the command bar. The app maker checks the form customizations and confirms the button is configured correctly. What is the most likely cause?

Accepted Answer

The custom button is configured with visibility rules that hide it for certain security roles.. Custom buttons in model-driven apps can have visibility rules based on security roles, which would hide the button for users without the appropriate role. Option A is incorrect because browser compatibility does not affect button visibility. Option B is incorrect because the button was configured for all form factors. Option D is incorrect because flow permissions affect the execution of the flow, not the visibility of the button.

Answer

The user's browser does not support the Power Apps client.

Answer

The app is opened in the phone form factor, and the button is only shown on web.

Answer

The Power Automate flow is disabled or not shared with the user.

Question 14

An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?

Accepted Answer

Filter(Accounts, City = "Seattle"). The Filter function in Power Apps filters a table based on a condition, returning a subset of records that meet the condition. In this case, Filter(Accounts, City = "Seattle") will return all accounts where the City field equals "Seattle". Option A is incorrect because the parentheses syntax does not filter; it is not a valid Power Apps function. Option C is incorrect because the LookUp function returns a single record, not a filtered set. Option D is incorrect because the Search function searches for a string across one or more columns, not for an exact match on a specific field; it returns records containing the search term, not exact equality.

Answer

Accounts(City = "Seattle")

Answer

LookUp(Accounts, City = "Seattle")

Answer

Search(Accounts, "Seattle", "City")

Question 15

A company uses a model-driven app to manage IT support tickets. The app includes a timeline control to track activities. Recently, users noticed that emails sent from the app are not appearing in the timeline. The email activity is configured correctly. What could be the issue?

Accepted Answer

Server-side synchronization is not configured to track sent emails.. Server-side synchronization must be configured to automatically track sent emails in the timeline. Without this configuration, emails sent from the app may not be recorded. Option A is incorrect because the issue is not about shared mailbox; emails from shared mailboxes can still appear in the timeline if configured. Option B is incorrect because 'Auto-track' in Outlook is a client-side setting and does not affect server-side tracking of sent emails. Option D is incorrect because the timeline control is already present and working for other activities; the problem is specifically with sent emails not appearing.

Answer

The email is sent from a shared mailbox.

Answer

The 'Auto-track' setting in Outlook is disabled.

Answer

The timeline control is not added to the form.