PL-900 Practice Test 47 — 15 Questions

Question 1

A company uses Microsoft Power Apps to build a leave request application. The app uses SharePoint as the data source. Users report that when they submit a leave request, the app sometimes fails to save the data and shows a generic error. Which should you investigate first?

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

Accepted Answer

Verify the connection to the SharePoint data source.. Generic errors when saving data in Power Apps often indicate a problem with the data source connection, such as network interruption or permission changes. Option A is incorrect because clearing browser cache and cookies typically affects app loading performance, not data submission. Option C is incorrect because delegation issues in Power Apps affect data retrieval (e.g., filtering large lists), not the ability to save new records. Option D is incorrect because formula syntax errors usually produce specific error messages, not a generic save failure.

Answer

Clear the browser cache and cookies.

Answer

Check if the app uses delegation for large lists.

Answer

Review the app formulas for syntax errors.

Question 2

A sales manager wants to create a Power BI report that shows monthly sales trends and allows drilling down from year to quarter to month. Which feature should they use?

Accepted Answer

Hierarchy. A hierarchy in Power BI allows users to create a parent-child relationship between fields (e.g., Year → Quarter → Month) that enables automatic drill-down and drill-up actions in visuals. This directly supports the sales manager's requirement to view monthly trends and drill from year to quarter to month without manual configuration.

Answer

Drill-through

Answer

Bookmarks

Answer

Slicers

Question 3

A data analyst needs to combine data from two Excel tables that have a common column 'ProductID'. Which Power BI tool should they use?

Accepted Answer

Merge Queries. Merge Queries is the correct tool because it combines two tables by matching rows based on a common column (ProductID), similar to a SQL JOIN. This allows the analyst to bring in additional columns from one table into the other, which is exactly what is needed when data from two Excel tables must be integrated on a shared key.

Answer

Append Queries

Answer

Pivot Column

Answer

Group By

Question 4

A Power Platform administrator is configuring a data loss prevention (DLP) policy for a production environment. The policy must block the use of the SharePoint connector but allow the use of the SQL Server connector. The administrator creates a policy and assigns it to the environment. However, users can still use the SharePoint connector. What is the most likely reason?

Accepted Answer

A tenant-level DLP policy allows SharePoint and is set to a higher priority.. Data loss prevention (DLP) policies can be configured at both the tenant level and the environment level. When both levels have policies, the tenant-level policy takes precedence if it is set to a higher priority. In this scenario, a tenant-level DLP policy that allows the SharePoint connector would override the environment-level policy that blocks it, explaining why users can still use SharePoint. Option A is incorrect because the policy was assigned to the environment. Option B is incorrect because user roles do not bypass DLP policies. Option D is incorrect because saved and published policies take effect immediately.

Answer

The policy was not assigned to the correct environment.

Answer

The users have the System Administrator role in the environment.

Answer

The DLP policy has not been saved and published.

Question 5

An organization uses Power Automate flows that connect to Microsoft SharePoint Online and Microsoft Dataverse. The security team requires that all connections to Dataverse use service principal authentication instead of user credentials. The administrator needs to ensure that flows relying on Dataverse connections continue to work after the change. What should the administrator do?

Accepted Answer

Register a service principal in Microsoft Entra ID and update connection references in the flows' solution. Service principal authentication in Power Automate requires registering an application in Microsoft Entra ID (formerly Azure AD) and using its credentials to authenticate to Dataverse. Updating the connection references in the flows' solution to point to a service principal-based connection ensures all flows continue to work without requiring user credentials, meeting the security team's requirement.

Answer

Create a new environment and migrate flows there

Answer

Recreate all flows with a shared connection using a service principal

Answer

Delete existing connections and ask users to create new ones

Question 6

Which TWO of the following are benefits of using Microsoft Power Platform for business process automation? (Choose two.)

Accepted Answer

Provides seamless integration with Microsoft 365 and Azure services.. Microsoft Power Platform is designed with native connectors and deep integration with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL). This allows business users to automate workflows and build apps that directly leverage existing Microsoft cloud investments without custom coding or third-party middleware.

Answer

Only works with on-premises data sources.

Answer

Eliminates the need for any manual data entry.

Answer

Requires extensive programming knowledge to build solutions.

Question 7

Which THREE components are included in the Microsoft Power Platform? (Select three.)

Accepted Answer

Power Apps. The Microsoft Power Platform consists of several core components including Power Apps, Power Automate, and Power BI. This question asks to select three components from the list. All three are valid components, so the correct answers are Power Apps, Power Automate, and Power BI. The remaining options, Microsoft Entra ID and Microsoft 365, are not part of the Power Platform.

Answer

Microsoft Entra ID

Answer

Microsoft 365

Question 8

An administrator needs to assign user roles in a Power Platform environment. Which TWO roles can be assigned to allow users to create and edit Power Apps and flows, but not manage environments?

Accepted Answer

System Customizer. Environment Maker allows users to create and edit Power Apps and flows without environment management. System Customizer also allows creating and editing apps and flows, and additionally can customize system settings, but does not manage environments. Basic User only allows running apps and flows, not creating or editing. System Administrator and Global Administrator include environment management capabilities, which are not desired.

Answer

Basic User

Answer

System Administrator

Answer

Global Administrator

Question 9

Which TWO of the following are prerequisites for creating a Power Pages site?

Accepted Answer

A Dataverse database. A Dataverse database is a prerequisite for Power Pages because Power Pages stores all site data, metadata, and configuration (such as web pages, content snippets, and table permissions) in Dataverse tables. Without a Dataverse database provisioned in the target environment, you cannot create a Power Pages site, as the platform relies on Dataverse as its underlying data storage and management layer.

Answer

A SharePoint Online license

Answer

A Power BI Pro license

Answer

A Microsoft Entra ID tenant

Question 10

A company wants to build a custom app that allows field technicians to view and update work orders on their mobile devices, with data stored in Dataverse. Which approach minimizes development effort?

Accepted Answer

Create a canvas app in Power Apps. Using Power Apps to create a canvas app provides a low-code solution that can connect to Dataverse and be deployed on mobile devices quickly.

Answer

Use Power Automate to generate a mobile app

Answer

Build a custom iOS app using Swift and Xcode

Answer

Create a model-driven app in Power Apps

Question 11

A company uses Power Apps for a field service app. They notice that the app loads slowly when users access it on mobile devices. What is the most likely cause?

Accepted Answer

The app contains large images that are not optimized. Large, unoptimized images increase the payload size that must be downloaded to the mobile device, directly impacting load times, especially over cellular networks. Power Apps loads all resources, including images, when the app starts, so oversized images cause significant delays. Optimizing images (e.g., compressing, resizing, using modern formats like WebP) reduces bandwidth usage and speeds up app loading.

Answer

The app has too many Power Automate flows

Answer

The Dataverse environment is in a different region

Answer

The app uses Microsoft Entra ID for authentication

Question 12

You are a Power Platform administrator. A user reports that they cannot create a new environment in the Power Platform admin center. The user has a Power Apps per user plan license. What is the most likely reason?

Accepted Answer

The user does not have a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2.. Creating environments in the Power Platform admin center requires a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2. The user's Power Apps per user plan license only allows them to use apps and flows, not to create or manage environments. Without the appropriate license, the environment creation option is disabled in the admin center.

Answer

The user does not have access to the Power Platform admin center.

Answer

The user is not a global administrator in Microsoft Entra ID.

Answer

The user has not assigned the license to themselves.

Question 13

Which THREE components are part of the Power Platform environment lifecycle management?

Accepted Answer

Environment creation. Environment creation is a core component of Power Platform environment lifecycle management because it establishes the isolated container where apps, flows, and data reside. The lifecycle begins when an administrator provisions a new environment, which sets up a dedicated Dataverse database, security boundaries, and resource limits. Without creation, no subsequent lifecycle operations (backup, restore, deletion) can occur.

Answer

Creating users in Microsoft Entra ID

Answer

Publishing Power BI reports

Question 14

You have a Power Automate flow that sends an email notification when a new file is added to a SharePoint document library. Users report that emails are not being sent for some files. What is the most likely cause?

Accepted Answer

A trigger condition is filtering out some files. Trigger conditions in Power Automate allow you to define expressions that must evaluate to true for the flow to run. If a condition is configured to filter out certain files (e.g., based on file name, metadata, or size), those files will not trigger the flow, and no email will be sent. This is the most likely cause when emails are missing for some files but not all.

Answer

The flow uses a premium connector that requires a license

Answer

The file is being co-authored by multiple users

Answer

The file content contains sensitive information

Question 15

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

Accepted Answer

Use of formulas like If, Switch, Filter. Canvas apps provide the ability to write formulas (like If, Switch, Filter) directly in the app, which is not available in model-driven apps. Model-driven apps use business rules and workflows instead of formulas. Additionally, canvas apps can directly access device capabilities (camera, GPS), whereas model-driven apps do not have direct access to native device features. Option A (Integration with Dataverse) is available in both canvas and model-driven apps, so it is not exclusive. Option C (Ability to use AI Builder models) is also available in both. Option E (Embedding a canvas app in a model-driven app) is a feature of model-driven apps, not canvas apps.

Answer

Integration with Microsoft Dataverse

Answer

Ability to use AI Builder models

Answer

Embedding a canvas app in a model-driven app