PL-900 Practice Test 22 — 15 Questions

Question 1

A user reports that a canvas app is loading slowly. The app connects to a large SharePoint list with over 10,000 items. Which change would most improve performance?

Accepted Answer

Apply a delegable filter on the data source to limit records returned.. Delegation is the key to performance with large data sources. When a canvas app connects to SharePoint, operations that can be translated into a query (delegable) are processed server-side, returning only the necessary records. Applying a delegable filter (e.g., using '=' or 'StartsWith' on indexed columns) reduces the amount of data transferred and processed by the app, directly improving load time. Non-delegable operations force Power Apps to fetch the first 500 (or up to 2000) records and process them locally, which is slow and may miss data.

Answer

Increase the delegation limit to 10,000.

Answer

Add more screens to distribute the data.

Answer

Disable offline mode.

Question 2

A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?

Accepted Answer

Canvas app. A canvas app is the correct choice because it allows full control over the user interface and supports conditional formatting using Power Apps formulas. The business analyst can connect to a SharePoint list and use functions like If and Color to highlight overdue tasks based on due dates. Canvas apps are ideal for custom designs and data-driven formatting.

Answer

Power Virtual Agents chatbot

Answer

Model-driven app

Answer

Power BI report

Question 3

A company wants to restrict the ability to create Power Apps and Power Automate flows in the default environment to only a specific security group. What is the recommended approach?

Accepted Answer

Assign the security group to the Environment Maker role for the default environment.. The recommended approach to restrict app and flow creation in the default environment is to assign only the desired security group to the Environment Maker role for that environment. The Environment Maker role grants permissions to create resources like Power Apps and Power Automate flows, and by assigning it exclusively to a security group, you effectively limit creation capabilities to members of that group while removing the role from all other users.

Answer

Create a DLP policy that blocks creation of apps and flows.

Answer

Disable the default environment and create a new one with restricted access.

Answer

Remove the Environment Maker role from all users and add the security group as co-admins.

Question 4

A company has a legacy on-premises SQL Server database and wants to build a Power BI report that refreshes daily. However, the database is behind a firewall. What should they use to securely access the data?

Accepted Answer

An on-premises data gateway. An on-premises data gateway is the correct solution because it acts as a secure bridge between on-premises data sources (like SQL Server behind a firewall) and cloud services such as Power BI. The gateway encrypts data in transit and allows scheduled refresh without opening inbound ports in the firewall, using outbound connections to Azure Service Bus.

Answer

Power Automate with SQL connector

Answer

Microsoft Dataverse

Answer

A VPN connection to the database

Question 5

A company uses Power Automate to automate approval workflows for expense reports. When an expense report exceeds $5,000, the flow should send an email to the manager and then wait for approval before processing payment. Which type of trigger should be used to start the flow when a new expense report is submitted?

Accepted Answer

When a new item is created trigger. The 'When a new item is created' trigger starts the flow when a new expense report is submitted. Option A is wrong because 'When an item is modified' triggers on updates, not new items. Option B is wrong because a scheduled trigger runs at specified times, not on item creation. Option D is wrong because a manual trigger requires a user to run the flow.

Answer

When an item is modified trigger

Answer

Recurrence trigger

Answer

Manual trigger

Question 6

You need to create a Power Automate flow that sends a personalized welcome email to new users when they are added to Microsoft Entra ID. Which trigger should you select?

Accepted Answer

When a user is created (Microsoft Entra ID connector). The 'When a user is created' trigger in the Microsoft Entra ID connector is specifically designed to fire when a new user account is added to Entra ID (formerly Azure AD). This trigger can then initiate a flow to send a personalized welcome email, meeting the requirement.

Answer

When a new email arrives (Outlook connector)

Answer

When a record is created (Dataverse connector)

Answer

When a file is created (SharePoint connector)

Question 7

An organization has multiple Power Platform environments. The administrator needs to move a solution from a development environment to a production environment. The solution includes custom connectors and environment variables. What is the correct process?

Accepted Answer

Export a managed solution from development and import it into production. Managed solutions are the standard mechanism for deploying customizations (including custom connectors and environment variables) from a development environment to a production environment. Exporting a managed solution from development and importing it into production ensures that components are packaged as a single, deployable unit, and it prevents accidental modifications in production by making the solution layers read-only after import.

Answer

Copy the entire development environment to production

Answer

Export an unmanaged solution from development and import it into production

Answer

Manually re-create all components in production

Question 8

A business analyst wants to create a real-time dashboard showing sales performance from Dynamics 365 Sales data. Which tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool for creating real-time dashboards because it is designed specifically for data visualization and business intelligence. It can connect directly to Dynamics 365 Sales data via the Dataverse connector or direct query mode, enabling live, interactive dashboards that refresh automatically as data changes.

Answer

Power Apps

Answer

Power Pages

Answer

Power Automate

Question 9

A Power Automate flow uses the 'HTTP' action to call an external API. The flow fails intermittently with a 429 (Too Many Requests) error. What is the best practice to handle this?

Accepted Answer

Configure retry policy with exponential backoff. The 429 error indicates the API is rate-limiting requests. Configuring a retry policy with exponential backoff allows the flow to automatically retry after increasing delays, reducing server load and respecting the API's rate limits. This is the standard best practice for handling transient throttling errors in Power Automate.

Answer

Switch to a different API endpoint

Answer

Add a 'Terminate' action to stop the flow on error

Answer

Reduce the timeout of the HTTP action

Question 10

You are designing a Power Apps solution for a global sales team. The app must display data in the user's local time zone. The data is stored in Dataverse in UTC. What is the best practice for time zone handling?

Accepted Answer

Store times in UTC and let Power Apps handle conversion automatically. Best practice for time zone handling in Power Apps with Dataverse is to store all datetime values in UTC and let the platform handle conversion to the user's local time zone automatically. Dataverse stores datetime fields in UTC and the Power Apps client automatically converts them to the user's local time zone based on their device settings or user profile. This ensures consistency and avoids errors from manual conversions.

Answer

Convert UTC to each time zone using Power Fx formulas

Answer

Store local time in the database based on user's location

Answer

Use a Power Automate flow to convert time zones

Question 11

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.. To automatically send an email when a record's status changes to 'Resolved', the best approach is to create a Power Automate flow with a trigger 'When a record is updated' and a condition that checks if the status field changed to 'Resolved'. This provides a no-code, automated solution that runs in the background.

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 12

A Power Automate flow runs daily to copy data from a SQL Server database to a SharePoint list. The flow fails with a 'GatewayTimeout' error. What is the most likely cause?

Accepted Answer

The SQL query is taking longer than the allowed timeout.. A GatewayTimeout error in Power Automate typically indicates that the on-premises data gateway did not receive a response from the backend (SQL Server) within the allowed timeout window. The most likely cause is that the SQL query is taking longer than the gateway's timeout setting, so the gateway returns a timeout to Power Automate. Optimizing the query or increasing the timeout resolves the issue.

Answer

The service account does not have write permission to the SharePoint list.

Answer

The on-premises data gateway is offline.

Answer

The flow has exceeded the daily API call limit.

Question 13

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.. Creating a custom connector with API key authentication is the recommended approach because it securely stores the API key in the connector's authentication configuration, and the connector can be reused across apps and flows. This avoids exposing the key in the app's formulas or client-side code.

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 14

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

Accepted Answer

In the Dataverse table's business rules settings. Business rules in Power Apps that target Dataverse tables are defined in the table's Business Rules settings within the Power Apps maker portal. These rules run server-side on Dataverse, apply across all apps (canvas, model-driven, Power Pages), and can set field values, show errors, or lock fields without requiring code. This is the correct location for a rule that automatically sets Priority to 'High' for VIP customers.

Answer

In the SharePoint list settings

Answer

In a Power Automate flow

Answer

In the canvas app's OnStart property

Question 15

A nonprofit organization wants to create a public website to accept donations without writing code. Which Power Platform component should they use?

Accepted Answer

Power Pages. Power Pages is the correct choice because it enables users to create low-code, externally facing websites that can securely accept payments and donations without writing custom code. It provides built-in templates, data integration with Dataverse, and supports anonymous access for public users, making it ideal for a nonprofit's donation portal.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps