PL-900 Practice Test 40 — 15 Questions

Question 1

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?

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

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 2

Which TWO scenarios are best suited for using Power Automate scheduled flows?

Accepted Answer

Generating a daily sales report at 8 AM. Scheduled flows are designed to run on a recurring schedule, such as daily or weekly, without requiring a trigger event. Option B requires a daily report to be generated at a fixed time (8 AM), which is a classic scheduled flow use case. Option C requires archiving records every Sunday, another recurring schedule. Both scenarios rely on time-based triggers, not event-driven triggers.

Answer

Sending an approval request when a new expense report is submitted

Answer

Creating a task in Planner when a new email arrives with specific subject

Answer

Posting a message to Teams when a new file is added to SharePoint

Question 3

Refer to the exhibit. You see a Power BI DAX measure. What does this measure calculate?

Accepted Answer

Total sales for the previous year relative to the selected year.. The DAX measure uses the `SAMEPERIODLASTYEAR` function, which shifts the current filter context back by one year. When placed in a visual with a year slicer or axis, it returns the total sales for the same period in the previous year relative to the selected year. This is a standard time intelligence calculation for comparing year-over-year absolute values.

Answer

Total sales for the current year.

Answer

Running total of sales up to the selected year.

Answer

Year-over-year growth percentage.

Question 4

A Power Platform administrator is planning to implement environment lifecycle management. Which TWO actions should the administrator take to ensure unused environments are automatically cleaned up?

Accepted Answer

Create a Power Automate flow that runs periodically and deletes environments that have not been accessed in 30 days.. The two correct actions are D and E. Option D: Creating a Power Automate flow that periodically deletes environments inactive for 30 days automates cleanup. Option E: Setting an environment retention policy in the Power Platform admin center automatically deletes environments after a period of inactivity. Both are automated approaches. Other options are not automatic or not effective: A assigns admin role but doesn't auto-clean, B relies on manual intervention via Copilot, C is manual and not automatic.

Answer

Assign the Environment Admin role to all makers so they can delete their own environments.

Answer

Use the Power Platform Copilot to identify unused environments.

Answer

Manually review environments each month.

Question 5

Which THREE features are available in Power Pages to customize the user interface?

Accepted Answer

Liquid templates. Options A, B, and C are correct. Liquid templates, CSS overrides, and web templates are all features in Power Pages used to customize the user interface. Option D (Dataverse tables) is incorrect because Dataverse is a data storage service, not a UI customization feature. Option E (Power BI reports) is incorrect because Power BI is an analytics tool, not used for UI customization.

Answer

Dataverse tables

Answer

Power BI reports

Question 6

A global organization has multiple environments in Power Platform. The security team wants to prevent users from sharing canvas apps with external users. What is the most effective way to enforce this restriction?

Accepted Answer

Disable ‘Share with external users’ in the Power Platform admin center tenant settings. Disabling 'Share with external users' in the Power Platform admin center tenant settings is the most direct and comprehensive way to prevent sharing canvas apps with external users across all environments. Option A is incorrect because environment-level sharing settings can be overridden by tenant settings, and external sharing control is at tenant level. Option C is incorrect because assigning a custom security role that denies the 'Share' privilege may not explicitly prevent external sharing and is less comprehensive than the tenant-level setting. Option D is incorrect because DLP policies control connectors and data flows, not sharing permissions, so they do not prevent sharing apps with external users.

Answer

Set environment-level sharing to ‘Only specific security groups’

Answer

Assign a custom security role that denies the ‘Share’ privilege

Answer

Create a Data Loss Prevention (DLP) policy that blocks connectors used by external users

Question 7

You work for a retail company that uses Microsoft Power Platform to manage inventory. The company has a Power Apps canvas app that allows store managers to update stock levels. Recently, the app has been slow to load and sometimes times out when multiple managers use it simultaneously. You need to recommend a solution to improve performance. What should you do?

Accepted Answer

Migrate the app to use a Microsoft Dataverse database.. Migrating the app to use Microsoft Dataverse database improves performance and scalability for concurrent users compared to using SharePoint as the data source. Dataverse provides better concurrency handling, caching, and load balancing. Option A is incorrect because reducing the number of fields in a SharePoint list would have minimal impact on performance for concurrent access issues. Option B is incorrect because network connection type (wired vs. Wi-Fi) does not address server-side performance bottlenecks. Option C is incorrect because implementing a custom API adds complexity and does not directly solve the underlying performance issues with SharePoint's limitations.

Answer

Reduce the number of fields in the SharePoint list.

Answer

Instruct managers to use a wired network connection instead of Wi-Fi.

Answer

Implement a custom API to handle updates.

Question 8

An organization has a Power Automate flow that runs on a schedule and processes sensitive data. The compliance team requires that the flow cannot be triggered manually and must use a managed identity for authentication. Which feature should be used to meet these requirements?

Accepted Answer

Managed identity. (Managed identity) is correct because in Power Automate, a managed identity allows flows to authenticate to resources without requiring user credentials, and flows using managed identities can be configured to run on a schedule without manual triggering. The compliance team's requirement to prevent manual triggering can be achieved by disabling the 'Run only users' option and using a managed identity for authentication. Option A (Solution checker) is a tool for validating solutions, not for authentication. Option C (Data Loss Prevention policies) controls data sharing, not authentication. Option D (On-premises data gateway) enables connectivity to on-premises data, not authentication control.

Answer

Solution checker

Answer

Data Loss Prevention (DLP) policies

Answer

On-premises data gateway

Question 9

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

Accepted Answer

The trigger does not check for attachments by default. The trigger shown in the question is likely a 'When a new email arrives' trigger, which by default does not include attachments. To process emails with attachments, you must explicitly configure the trigger to include attachments by enabling the 'Include Attachments' option or by using the 'Get attachments' action. Without this, the flow will not trigger for emails that have attachments.

Answer

The path should include '/attachments'

Answer

The connection name is incorrect

Answer

The method should be 'post' instead of 'get'

Question 10

Refer to the exhibit. An ARM template is used to deploy a connection. What is the purpose of this resource?

Accepted Answer

Create a SharePoint Online API connection for Power Apps. The resource type 'Microsoft.Web/connections' creates an API connection. In this context, it is used to create a SharePoint Online API connection for Power Apps. Option C is correct. Option A is incorrect because it does not create a Power App; it creates a connection. Option B is incorrect because it does not create a Dataverse environment. Option D is incorrect because it does not deploy a SharePoint list; it creates an API connection.

Answer

Create a new Power App

Answer

Create a Dataverse environment

Answer

Deploy a SharePoint list

Question 11

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

Accepted Answer

AI Builder. AI Builder is the correct feature because it provides prebuilt and custom AI models that can be trained to extract structured data from documents like invoices. It integrates directly into Power Apps, allowing users to add AI-powered invoice processing without writing code or managing machine learning infrastructure.

Answer

Power BI

Answer

Power Automate

Answer

Common Data Service

Question 12

An administrator configures a Data Loss Prevention (DLP) policy with the scope set to 'All environments' and places selected connectors in the 'Blocked' group. What will be the result of this policy?

Accepted Answer

The connectors are blocked in all environments. The DLP policy is configured with the scope set to 'All environments' and the selected connectors are in the 'Blocked' group. Therefore, these connectors are blocked in every environment, including production and non-production. Option A is incorrect because audit mode is not enabled; the connectors are blocked, not audited. Option B is incorrect because the policy applies to all environments, not just production. Option D is incorrect because there is no exception for the default environment—the policy applies universally.

Answer

The connectors are allowed but audited

Answer

The connectors are blocked only in production environments

Answer

The connectors are blocked except for the default environment

Question 13

A company uses Power Automate to automate approval workflows for purchase orders. The flow should send an approval request to the manager of the requestor. When the manager approves, the flow should update a SharePoint list and send a confirmation email. However, the flow fails with an error 'Unable to find the manager for the specified user'. What is the most likely cause?

Accepted Answer

The user profile in Microsoft Entra ID does not have a manager assigned.. The 'Get manager' action in Power Automate retrieves the manager from the user's profile in Microsoft Entra ID (formerly Azure AD). If the manager is not assigned in the user profile, the flow will fail with the error 'Unable to find the manager for the specified user'. Option B is incorrect because the SharePoint list column for manager is not used by the Get manager action; the flow uses the Microsoft Entra ID profile. Option C is incorrect because the error occurs during the approval process, not due to the trigger condition. Option D is incorrect because permissions on the SharePoint list do not affect the manager lookup, which happens in Microsoft Entra ID.

Answer

The SharePoint list column for manager is missing.

Answer

The flow trigger is set to 'When a new item is created' but the item already exists.

Answer

The SharePoint list does not have the correct permissions.

Question 14

Refer to the exhibit. A Power Automate flow is triggered when an item is created in a SharePoint list. However, the flow runs for every new item, even those with Status other than 'New'. What is the issue?

Accepted Answer

The trigger condition expression is incorrect because it references triggerBody() which is not available in trigger conditions.. Trigger conditions in Power Automate cannot use the triggerBody() function. Instead, they must use triggerOutputs() to reference values from the trigger. Therefore, the expression @equals(triggerBody()?['Status'], 'New') is invalid and will not filter items, causing the flow to run for all new items regardless of their Status value.

Answer

The SharePoint connection is not configured correctly.

Answer

The trigger should be set to 'When an item is created or modified'.

Answer

The flow should use a Condition action instead of a trigger condition.

Question 15

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

Accepted Answer

Use an apply to each loop and configure 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', 'has failed'. Configuring 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', and 'has failed' ensures that even if a row fails validation or the SQL insert fails, the flow continues to the next iteration of the Apply to each loop. This allows the flow to process all rows in the CSV file without stopping on an error, meeting the requirement to skip invalid data and proceed with the next row.

Answer

Use parallel branches for each row

Answer

Use an apply to each loop with default settings

Answer

Use a scope with sequential actions and set 'Configure run after' to 'is successful' only