Courseiva

Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 76–150

904 questions total · 13pages · All types, answers revealed

Take a mock examExam hub
Page 1

Page 2 of 13

Page 3
76
MCQeasy

A company wants to ensure that changes to a Power Platform solution are tracked and can be rolled back if necessary. The development team uses source control. What should the administrator configure to enable solution lifecycle management?

A.Use managed solutions and export to source control
B.Backup the environment daily
C.Share the app with the team
D.Disable sharing to prevent changes
AnswerA

Managed solutions support versioning and deployment pipelines.

Why this answer

Using managed solutions and exporting them to source control enables versioning and rollback, which is essential for solution lifecycle management. Option B is incorrect because daily environment backups are not granular enough for tracking individual changes. Option C is incorrect because sharing the app does not provide version control.

Option D is incorrect because disabling sharing does not help with lifecycle management.

Full explanation →
77
MCQhard

You are designing a Power Pages site for a non-profit organization. The site will have multiple sections, each managed by different departments. The IT department wants to ensure that only authorized users can edit the site's content. Which approach should you recommend?

A.Implement a custom approval workflow using Power Automate.
B.Provide all department heads with administrative access to the Power Pages admin center.
C.Use Microsoft Entra ID groups to grant access to the site's editing features.
D.Create web roles in Power Pages and assign users to those roles to grant editing permissions.
AnswerD

Web roles define permissions for content management.

Why this answer

Power Pages uses web roles to control permissions for site content editing. Web roles allow administrators to define who can edit, design, or administer the site. Option A is incorrect because while Power Automate can be used for workflows, it is not the primary method for granting editing permissions.

Option B is incorrect because providing all department heads with administrative access to the Power Pages admin center would grant too broad permissions beyond content editing. Option C is incorrect because Microsoft Entra ID groups alone do not directly grant editing permissions; they must be mapped to web roles in Power Pages to be effective.

Full explanation →
78
MCQeasy

A small business wants to create a custom app to track inventory without hiring developers. Which Microsoft Power Platform tool should they use?

A.Power Virtual Agents
B.Power BI
C.Power Apps
D.Power Automate
AnswerC

Power Apps enables non-developers to build a custom inventory-tracking app using pre-built connectors and a low-code canvas or model-driven interface, satisfying the constraint that the business lacks hired developers. Unlike Power Automate, which orchestrates workflows, or Power BI, which visualises data, Power Apps directly creates the interactive application needed for manual inventory data entry and lookup.

Why this answer

Power Apps is the correct choice because it enables users to build custom applications with low-code or no-code tools, allowing the small business to create an inventory tracking app without hiring professional developers. Power Apps provides pre-built templates and connectors to data sources like SharePoint or SQL Server, making it ideal for rapid app development tailored to specific business needs.

Exam trap

The trap here is that candidates might confuse Power Automate with Power Apps because both involve automation, but Power Automate focuses on workflow logic and triggers, not on building the user-facing app interface required for inventory tracking.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is designed for creating conversational AI chatbots, not for building custom inventory tracking applications. Option B is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for developing custom apps with user interfaces and data entry forms. Option D is wrong because Power Automate is a workflow automation tool for orchestrating repetitive tasks and processes, not a platform for building standalone custom applications.

Full explanation →
79
Multi-Selecteasy

A retail company is building a Power Apps canvas app for store managers to review sales performance. The app connects to a SQL database and displays real-time sales data. The managers need to be able to filter data by store and date range, and view the data in a chart. The company wants to minimize licensing costs while ensuring scalability and performance. Which TWO features should you recommend?

Select 2 answers
A.Build a custom connector to the SQL database for enhanced security.
B.Create a SQL stored procedure to filter and aggregate data before sending to the app.
C.Use Collect() to load all data into a collection on app start for offline access.
D.Integrate a Power BI tile to display filtered charts and graphs.
E.Use the Office365Users connector to retrieve sales data from Excel Online.
AnswersB, D

Optimizes performance and reduces data transfer.

Why this answer

(Create a SQL stored procedure to filter and aggregate data before sending to the app) improves performance and scalability by offloading complex queries to the database. Option D (Integrate a Power BI tile to display filtered charts and graphs) allows embedding live reports and charts directly into the canvas app, providing robust filtering and visualization capabilities without additional licensing. Option A is incorrect because custom connectors require additional development and licensing, and are not necessary for security if the SQL database is properly configured.

Option C is incorrect because using Collect() to load all data on app start would not provide real-time data and could cause performance issues with large datasets. Option E is incorrect because the Office365Users connector is for user information, not for retrieving sales data from Excel Online, and Excel Online is not suitable for real-time SQL data integration.

Full explanation →
80
MCQhard

A Power Automate flow uses an 'Apply to each' loop to iterate over a large dataset. The flow is running slowly and sometimes times out. Which approach should the administrator recommend to improve performance?

A.Split the dataset into multiple flows.
B.Increase the flow timeout setting to 1 hour.
C.Enable concurrency control on the 'Apply to each' loop.
D.Use a premium connector for the data source.
AnswerC

Concurrency allows parallel processing of items.

Why this answer

Enabling concurrency control on the 'Apply to each' loop allows multiple iterations to run in parallel, significantly improving performance for large datasets and reducing the risk of timeouts. Option A is incorrect because splitting the dataset into multiple flows does not address the root cause and adds administrative complexity. Option B is incorrect because increasing the timeout does not make the flow run faster; it merely extends the allowed duration, but the flow may still be slow and could hit other limits.

Option D is incorrect because using a premium connector provides access to more APIs or higher limits but does not inherently speed up loop iterations; performance gains come from parallelism.

Full explanation →
81
MCQhard

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?

A.The model-driven app uses a canvas app component that loads excessive data.
B.The custom connector uses OAuth authentication instead of basic authentication.
C.The Power Apps license assigned to users is per app, not per user.
D.The on-premises data gateway is configured with a single data source and is not scaled for concurrent requests.
AnswerD

A single gateway can become a bottleneck under load; adding more gateways or using a cluster improves performance.

Why this answer

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.

Full explanation →
82
MCQeasy

A user wants to create a flow that automatically copies attachments from incoming Outlook emails to a OneDrive folder. Which trigger and action should be used?

A.'When a new email arrives' trigger and 'Create file' action
B.'When a new email arrives' trigger and 'Send an email' action
C.'When an item is created' trigger and 'Create file' action
D.'When a file is created' trigger and 'Start an approval' action
AnswerA

Correct trigger for incoming emails and action to save files.

Why this answer

'When a new email arrives' trigger initiates the flow for each incoming email, and the 'Create file' action can save attachments to a OneDrive folder. Option B is incorrect because 'Send an email' action would send an email, not create a file. Option C is incorrect because 'When an item is created' trigger is for SharePoint or similar, not for email.

Option D is incorrect because 'When a file is created' trigger and 'Start an approval' action do not relate to copying email attachments.

Full explanation →
83
MCQeasy

A manufacturing company uses Microsoft Power Platform to manage its inventory. They have a Power Apps app that allows warehouse staff to scan items and update quantities in a SharePoint list. Recently, the app has been slow to load and occasionally times out when scanning multiple items in quick succession. The IT team suspects the issue is related to the data source connection. They want to improve performance without changing the user interface. The company has a Microsoft 365 E3 subscription and all data resides in SharePoint Online. What should the IT team do first?

A.Implement a timer control to delay scanning between items.
B.Migrate the SharePoint list to an on-premises SQL Server database.
C.Optimize the Power Apps by enabling delegation for the SharePoint connector.
D.Replace SharePoint with Microsoft Dataverse for better performance.
AnswerC

Delegation allows queries to be processed server-side, reducing data transfer.

Why this answer

Enabling delegation for the SharePoint connector allows Power Apps to offload filtering and sorting operations to SharePoint Online, rather than retrieving all rows to the client. This reduces the amount of data transferred over the network, which directly addresses the slow load and timeout issues when scanning multiple items in quick succession, without changing the user interface.

Exam trap

The trap here is that candidates often confuse 'optimizing performance' with 'changing the data source' (Option B or D) or 'adding client-side delays' (Option A), rather than recognizing that the most immediate and non-disruptive fix is to enable delegation on the existing SharePoint connector.

How to eliminate wrong answers

Option A is wrong because adding a timer control to delay scanning would degrade user experience and does not address the root cause of slow data source performance; it merely masks the symptom. Option B is wrong because migrating to an on-premises SQL Server would introduce latency and administrative overhead, contradicting the requirement to improve performance without changing the UI and ignoring the existing cloud-based SharePoint Online environment. Option D is wrong because replacing SharePoint with Microsoft Dataverse would require significant changes to the app and data structure, violating the constraint of not changing the user interface, and Dataverse is not inherently faster for all scenarios without proper delegation and indexing.

Full explanation →
84
MCQeasy

A non-profit organization needs to collect feedback from event attendees via a form that automatically populates a SharePoint list. Which Power Platform component should they use?

A.Power Virtual Agents
B.Power Automate
C.Power BI
D.Power Apps (canvas app)
AnswerD

Power Apps (canvas app) allows you to build custom forms that can connect to SharePoint and automatically populate lists, making it the correct choice.

Why this answer

The requirement is to collect feedback via a form that automatically populates a SharePoint list. Power Apps (canvas app) is the correct component because it allows building custom forms that can directly write data to a SharePoint list. Power Virtual Agents is a chatbot platform, not a form builder, so it is not suitable.

Power Automate can automate workflows but does not provide a user-facing form interface, and Power BI is for analytics.

Exam trap

The trap is that candidates might think Power Automate is sufficient because it can populate SharePoint from a form, but the question asks for the component that provides the form interface itself, which is Power Apps. Power Virtual Agents also could collect data via a chatbot, but it is not a form; the question explicitly says 'via a form'.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is for creating conversational chatbots, not for building data-collection forms that populate SharePoint lists. Option B is wrong because Power Automate is an automation workflow tool, not a form-building interface; while it could process form submissions, the question asks for the component to collect feedback via a form, which is the role of Power Apps. Option C is wrong because Power BI is a business analytics and visualization tool, not a form or data-entry application.

Full explanation →
85
MCQmedium

A Power Automate flow is triggered when a new file is added to a SharePoint document library. The flow should then copy the file to a different library. However, the flow fails when the file name contains a colon (:). What is the most likely reason?

A.The colon character is not allowed in SharePoint file names.
B.The destination library is full.
C.The flow is using the wrong connector.
D.The flow does not have permissions to read the source library.
AnswerA

SharePoint restricts certain characters.

Why this answer

SharePoint does not allow certain characters in file names, including the colon (:). When a file name contains a colon, the flow fails because SharePoint cannot create or copy the file with that character. Option C is incorrect because the connector is not the issue; the problem is the invalid character.

Option B is not typical for this specific error, and Option D is unrelated.

Full explanation →
86
Multi-Selectmedium

Which TWO are benefits of using model-driven apps over canvas apps for enterprise data management?

Select 2 answers
A.Responsive design that automatically adapts to screen size
B.Ability to work offline on mobile devices
C.Support for custom connectors to external systems
D.Easier to create complex formulas and logic
E.Built-in role-based security and compliance
AnswersA, E

Correct. Model-driven apps automatically adapt to screen size, providing a consistent UI across devices without manual layout work.

Why this answer

Model-driven apps provide built-in role-based security and responsive design that adapts to screen size, making them ideal for enterprise data management. Option A is correct because model-driven apps automatically adapt to different devices without extra effort. Option E is correct because they inherit Dataverse role-based security.

Option B is incorrect because offline capability is more commonly associated with canvas apps. Option C is incorrect because custom connectors are available in both app types. Option D is incorrect because canvas apps are better suited for complex formulas with Power Fx.

Full explanation →
87
Multi-Selectmedium

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

Select 3 answers
A.Microsoft Excel (desktop file)
B.Microsoft SharePoint
C.SQL Server (on-premises)
D.JSON file
E.Microsoft Dataverse
AnswersB, C, E

SharePoint lists and libraries are supported data sources.

Why this answer

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.

Full explanation →
88
MCQhard

A global organization uses Power Platform with Microsoft Dataverse as the data source. They need to ensure that users in different regions only see data relevant to their region. What should they implement?

A.Power Apps app permissions
B.Power Automate conditional logic
C.Dataverse security roles with row-level security
D.Power BI dashboard filters
AnswerC

Security roles with RLS can restrict data per user/region.

Why this answer

Dataverse security roles can be configured with row-level security to restrict data access by region. This is a native capability of Dataverse.

Full explanation →
89
Multi-Selecteasy

Which TWO are benefits of using Power BI for business analytics? (Select two.)

Select 2 answers
A.Visualize data through interactive dashboards
B.Automate code deployment
C.Use AI to discover insights in data
D.Connect to a single data source only
E.Create chatbots for customer service
AnswersA, C

Power BI excels at creating interactive dashboards.

Why this answer

Power BI's core value is transforming raw data into interactive, visual dashboards that allow users to explore trends, drill down into details, and share insights across the organization. This capability directly supports business analytics by making data accessible and actionable without requiring technical expertise.

Exam trap

The trap here is that candidates confuse the broad capabilities of the Power Platform (e.g., Power Automate for automation, Power Virtual Agents for chatbots) with Power BI's specific focus on data visualization and analytics, leading them to select options like B or E that belong to other services.

Full explanation →
90
MCQhard

An insurance company wants to automate claims processing. They receive claims via email attachments (PDFs) and need to extract key information (policy number, date, amount) and enter it into a Dataverse table. Then, a workflow should evaluate the claim amount: if under $5000, auto-approve and notify the customer; if over $5000, assign to a human adjuster. The solution must be low-code and use AI where beneficial. Which combination should they use?

A.Power BI, AI Builder, Power Automate, and Dataverse
B.AI Builder, Power Automate, and Dataverse
C.Power Pages, AI Builder, Power Automate, and Dataverse
D.AI Builder, Copilot Studio, Power Automate, and Dataverse
AnswerB

AI Builder extracts data, Power Automate processes workflow, Dataverse stores data.

Why this answer

It combines AI Builder (to extract data from PDFs using prebuilt AI models), Power Automate (to orchestrate the workflow and conditional logic based on claim amount), and Dataverse (to store the extracted data in a structured table). This low-code solution leverages AI where beneficial (PDF extraction) and automates the approval routing without requiring custom development.

Exam trap

The trap here is that candidates may think Power BI or Power Pages are needed for data handling or external access, but the scenario only requires data extraction, storage, and conditional workflow—all achievable with AI Builder, Power Automate, and Dataverse alone.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and analytics tool, not a workflow automation or data extraction tool; it does not help extract PDF data or trigger conditional approvals. Option C is wrong because Power Pages is for building external-facing websites, not for automating internal claims processing workflows or AI-based PDF extraction. Option D is wrong because Copilot Studio is for building conversational AI chatbots, not for extracting structured data from PDF attachments or implementing conditional workflow logic.

Full explanation →
91
Multi-Selectmedium

Which TWO permissions must be configured to allow authenticated users to submit a support ticket form in Power Pages?

Select 2 answers
A.Site setting permissions
B.Content snippet permissions
C.Web role assignment for the authenticated user
D.Page permissions for the support page
E.Table permissions on the support ticket table
AnswersC, E

The user must be in a web role that has the necessary table permissions.

Why this answer

Options C and E are correct. To allow authenticated users to submit a support ticket form, you need web role assignment (C) to associate the user with a role that grants access, and table permissions on the support ticket table (E) to enable create (and read) operations on the underlying Dataverse table. Option A is incorrect because site setting permissions control global settings, not form submission.

Option B is incorrect because content snippet permissions are for editing content snippets, not form submission. Option D is incorrect because page permissions control page access, not table operations.

Full explanation →
92
MCQmedium

A Power Platform administrator notices that a production environment has exceeded its storage quota. The administrator needs to free up storage without impacting active solutions. Which action should the administrator take first?

A.Analyze storage by entity and delete unused custom tables
B.Increase the storage quota
C.Remove the environment and create a new one
D.Delete all audit logs older than 30 days
AnswerA

This targets specific large tables for cleanup.

Why this answer

Analyzing storage by entity allows the administrator to identify which custom tables consume the most space, and deleting unused custom tables directly frees up storage without affecting active solutions. This is the recommended first step in the Power Platform admin center, as it targets the root cause of storage overage while preserving production functionality.

Exam trap

The trap here is that candidates may assume deleting audit logs is the quickest fix, but the question emphasizes 'without impacting active solutions,' and audit logs are often not the largest storage consumer, making analysis of custom tables the correct first step.

How to eliminate wrong answers

Option B is wrong because increasing the storage quota does not free up existing storage; it only adds capacity, which may incur additional costs and does not resolve the underlying issue of excessive data consumption. Option C is wrong because removing the environment and creating a new one would destroy all solutions, data, and configurations, severely impacting active solutions and causing data loss. Option D is wrong because deleting audit logs older than 30 days may free some storage, but audit logs are typically a small fraction of total storage; this action is not the first step and may not address the primary storage consumer, which is often custom table data.

Full explanation →
93
MCQeasy

A user wants to create a flow that automatically sends a thank-you email when a customer fills out a Microsoft Forms survey. Which trigger should the user select?

A.When a response is submitted (Forms Pro)
B.When an item is created or modified
C.When a new email arrives
D.When a new response is submitted
AnswerD

This trigger fires on new form submission.

Why this answer

The correct trigger is 'When a new response is submitted' because it is the standard Microsoft Forms connector trigger that fires immediately when a survey response is submitted. This trigger is specifically designed for Microsoft Forms (not Forms Pro) and provides the response data needed to send a personalized thank-you email via Power Automate.

Exam trap

The trap here is that candidates often confuse the standard Forms trigger with the Forms Pro trigger, assuming 'Forms Pro' is the same as 'Forms', but Microsoft distinguishes them as separate connectors with different licensing and capabilities.

How to eliminate wrong answers

Option A is wrong because 'When a response is submitted (Forms Pro)' is a trigger for Microsoft Forms Pro, which is a premium survey tool with advanced features like branching and analytics, not the standard Microsoft Forms used in this scenario. Option B is wrong because 'When an item is created or modified' is a trigger for SharePoint or Dataverse lists, not for Microsoft Forms responses. Option C is wrong because 'When a new email arrives' is a trigger for an email inbox (e.g., Outlook), which does not directly respond to a Forms survey submission.

Full explanation →
94
Multi-Selecteasy

Which TWO of the following are benefits of using Microsoft Power Platform for citizen developers? (Select two.)

Select 2 answers
A.Low-code/no-code tools enable non-developers to create solutions.
B.Provides pre-built templates and connectors.
C.Requires extensive coding knowledge.
D.High-performance computing for complex algorithms.
E.Only available for enterprise customers.
AnswersA, B

This is a primary benefit.

Why this answer

Microsoft Power Platform provides low-code/no-code tools like Power Apps, Power Automate, and Power BI that allow citizen developers—users without formal programming training—to build applications, automate workflows, and create data visualizations using drag-and-drop interfaces and simple logic. This democratizes solution creation by reducing the technical barrier to entry.

Exam trap

The trap here is that candidates may mistakenly think Power Platform requires coding (Option C) or is only for enterprises (Option E), but the exam emphasizes its accessibility and broad licensing availability for all organization sizes.

Full explanation →
95
MCQhard

Your model-driven app uses a custom entity 'Project' with a 1:N relationship to 'Task'. You need to add a subgrid on the Project form that shows related tasks, but only tasks assigned to the current user. How should you achieve this?

A.Create a workflow that updates a field on the Project form to filter the subgrid
B.Add a business rule on the Project form to filter the subgrid
C.Create a system view on the Task entity that filters by 'Owner equals Current User' and select it in the subgrid properties
D.Configure the subgrid to use the default view and assign security roles to filter tasks
AnswerC

System views can use dynamic filters like current user.

Why this answer

You can create a system view on the Task entity that filters by 'Owner equals Current User' and then select that view in the subgrid properties. Option A is wrong because workflows cannot filter subgrids; they can only automate processes. Option B is wrong because business rules control form behavior (like visibility or field values) but cannot filter subgrid data.

Option D is wrong because using the default view would show all tasks (or those allowed by security roles), not filtered by current user; security roles control access rights, not subgrid filtering criteria.

Full explanation →
96
MCQeasy

You are the Power Platform administrator for your organization. A user reports that they cannot create a new environment. What is the most likely cause?

A.The environment creation feature is disabled in the tenant settings.
B.The user is trying to create a production environment without a valid default environment.
C.The tenant has reached its maximum number of environments.
D.The user does not have the appropriate license or role to create environments.
AnswerD

Users need the Power Platform admin role or appropriate license to create environments.

Why this answer

Creating environments in the Power Platform requires either a Power Apps, Power Automate, or Dynamics 365 license, and the user must be assigned the Environment Admin or Global Admin role. Without the appropriate license or role, the 'New environment' button is disabled, and the user cannot proceed with environment creation.

Exam trap

The trap here is that candidates often assume environment creation is limited by tenant quotas or disabled settings, but the PL-900 exam emphasizes that the most common cause is insufficient licensing or role assignment, not configuration limits.

How to eliminate wrong answers

Option A is wrong because there is no tenant-level setting to disable environment creation; environment creation is controlled by licensing and roles, not a toggle in tenant settings. Option B is wrong because a default environment always exists in a tenant (created automatically for each user), and production environments can be created independently of the default environment. Option C is wrong because the default environment limit per tenant is 3, but this limit can be increased by Microsoft support upon request, and reaching the limit would not prevent creation of a new environment if the user has the correct role and license.

Full explanation →
97
MCQeasy

Which tool is used to create and manage a Power Pages site from start to finish?

A.Power Apps maker portal
B.Power Pages design studio
C.Visual Studio Code with Power Platform extension
D.Power Automate portal
AnswerB

The main tool for building Power Pages sites.

Why this answer

Power Pages design studio is the primary tool used to create and manage a Power Pages site end-to-end. Option A is incorrect because Power Apps maker portal is used for building canvas and model-driven apps, not Power Pages. Option C is incorrect because although Visual Studio Code with Power Platform extension can be used for custom development, it is not the primary tool for creating and managing a Power Pages site from start to finish.

Option D is incorrect because Power Automate portal is for automating workflows, not for Power Pages site management.

Full explanation →
98
MCQhard

You are designing a Power Automate flow that processes orders. The flow must wait for a manager's approval if the order amount exceeds $10,000. If the approval is rejected, the flow should notify the salesperson and stop processing. Which actions should be used?

A.Use 'Scope' to group approval actions
B.Use 'Start an approval' and then a 'Condition' action
C.Use 'Start and wait for an approval' and then a 'Condition' action
D.Use 'Start and wait for an approval' and then a 'Terminate' action
AnswerC

Correct. 'Start and wait for an approval' pauses the flow until a decision is made, and a 'Condition' action can then evaluate the outcome (e.g., approved/rejected) to take appropriate actions.

Why this answer

'Start and wait for an approval' pauses the flow until a decision is made, and a 'Condition' action can check the outcome (e.g., 'Approve' or 'Reject') to notify the salesperson or stop processing. Option A is wrong because 'Scope' is used to group actions and does not provide approval functionality. Option B is wrong because 'Start an approval' does not wait, so the flow continues immediately without waiting for a response.

Option D is wrong because 'Terminate' ends the flow but cannot check the approval outcome and handle the rejected scenario appropriately.

Full explanation →
99
MCQmedium

Refer to the exhibit. A developer created a Power Automate flow based on the JSON. The flow is not updating the item status even when the manager approves. What is the most likely reason?

A.The email is sent to the wrong recipient.
B.The flow does not wait for the approval response before running the condition.
C.The update item action is missing.
D.The condition expression has incorrect syntax.
AnswerB

Email send is not a synchronous approval; need an approval action.

Why this answer

The flow lacks a 'Wait for an approval' action or equivalent configuration. Without this, the flow proceeds immediately to the condition step before the manager has responded, so the condition evaluates based on the initial (unapproved) state of the approval variable, not the actual response. Power Automate requires an explicit 'Wait for an approval' action to pause execution until the approval decision is made.

Exam trap

The trap here is that candidates assume the approval action inherently pauses the flow, but Power Automate requires an explicit wait action to synchronize execution with the approval response.

How to eliminate wrong answers

Option A is wrong because the email recipient is irrelevant to the core issue; even if the email reaches the correct manager, the flow still does not wait for their response before evaluating the condition. Option C is wrong because the exhibit shows an 'Update item' action present in the flow, so the problem is not a missing action but the timing of its execution. Option D is wrong because the condition expression syntax is not the cause; the condition likely evaluates correctly but uses the default (unapproved) value of the approval variable due to the lack of a wait step.

Full explanation →
100
Drag & Dropmedium

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4

Why this order

Solutions are created, components added, exported, imported, and then published.

Full explanation →
101
MCQhard

A healthcare organization is deploying Power Apps for patient intake. They must ensure that the app complies with HIPAA regulations. Which feature should they use to protect patient data at rest?

A.Require multi-factor authentication (MFA) for app users.
B.Enable audit logging in the Power Platform admin center.
C.Enable Customer Managed Key (CMK) for the Power Platform environment.
D.Create a Data Loss Prevention (DLP) policy to restrict connectors.
AnswerC

CMK encrypts data at rest with a key the organization controls.

Why this answer

Customer Managed Key (CMK) allows the healthcare organization to control the encryption key used to protect data at rest in their Power Platform environment. This ensures that even Microsoft cannot access the underlying data without the organization's key, which is a critical requirement for HIPAA compliance regarding data encryption at rest.

Exam trap

The trap here is that candidates confuse data protection features (like MFA, audit logging, or DLP policies) with encryption at rest, assuming any security feature satisfies HIPAA's data-at-rest requirement, but only CMK provides the necessary customer-controlled encryption for stored data.

How to eliminate wrong answers

Option A is wrong because multi-factor authentication (MFA) protects data in transit and access control, not data at rest encryption. Option B is wrong because audit logging tracks user activities and changes but does not encrypt or protect data at rest. Option D is wrong because Data Loss Prevention (DLP) policies control which connectors can be used to share data externally, but they do not encrypt or protect data stored within the environment.

Full explanation →
102
MCQeasy

A small business wants to adopt Power Apps to create a custom inventory management app. They have a single Microsoft 365 Business Basic subscription which includes Power Apps and Power Automate capabilities. The IT manager, who is not a dedicated administrator, needs to set up the environment. They want to ensure that the app's data is stored securely and that only authorized employees can access it. The IT manager plans to create a new environment for the app. What should the IT manager do first to ensure proper governance and security?

A.Purchase additional Power Apps licenses for each user before creating the environment.
B.Use the default environment and configure data loss prevention (DLP) policies to restrict data sharing.
C.Create a trial environment to test the app before deploying to production.
D.Create a new production environment in the Power Platform Admin Center.
AnswerB

The default environment is sufficient; DLP policies help secure data.

Why this answer

Because the organization has a single Microsoft 365 Business Basic subscription, the default environment already exists. Creating a new environment is not necessary and could complicate management. The best course is to use the default environment with appropriate data policies and sharing settings.

Full explanation →
103
MCQeasy

A user reports that a Power App button does nothing when clicked. The button's OnSelect property contains: Navigate(Screen2). What is the most likely cause?

A.The formula is missing parentheses
B.The user lacks permission to navigate to Screen2
C.The app is not published
D.Screen2 does not exist in the app
AnswerD

Navigate to a non-existent screen causes failure

Why this answer

If Screen2 does not exist, the Navigate function fails silently, causing the button to appear to do nothing. Option A is incorrect because the formula syntax is valid and parentheses are properly used. Option B is incorrect because navigation permissions are not enforced within the same app; any user can navigate between screens.

Option C is incorrect because the app does not need to be published for the button to work in the editor or when running the app.

Exam trap

Candidates may assume a missing formula error or permission issue, but the silent failure of Navigate to a nonexistent screen is a common pitfall.

Full explanation →
104
Multi-Selectmedium

Which TWO authentication providers are natively supported by Power Pages for external user access?

Select 2 answers
A.Azure AD B2C
B.Microsoft Entra ID
C.Google
D.Facebook
E.Local authentication
AnswersA, E

Supports social and local accounts.

Why this answer

Azure AD B2C and local authentication are the two natively supported authentication providers for external user access in Power Pages. Azure AD B2C is designed for customer identities, while local authentication uses email and password stored in Dataverse. Microsoft Entra ID is intended for internal organizational users, not external.

Google and Facebook are not native providers; they require custom OAuth configuration.

Full explanation →
105
Multi-Selecteasy

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

Select 3 answers
A.Environment
B.Condition
C.Connector
D.Action
E.Trigger
AnswersB, D, E

A control action that branches logic.

Why this answer

Options B, D, and E are correct. A trigger starts the flow, actions perform tasks, and conditions control the flow logic. Option A (Environment) is the container for resources, not a component of a single flow definition.

Option C (Connector) is a connection to a service, not a component of the flow itself.

Full explanation →
106
MCQeasy

A company wants to add a chatbot to its Power Pages site to handle common customer inquiries. The chatbot should answer questions based on a knowledge base and escalate to a human agent if needed. Which Power Platform capability integrates with Power Pages for this purpose?

A.Power BI
B.Power Virtual Agents
C.Power Automate
D.Power Apps
AnswerB

Power Virtual Agents provides AI-powered chatbots.

Why this answer

Power Virtual Agents (now part of Microsoft Copilot Studio) can be embedded as a chatbot in Power Pages.

Full explanation →
107
MCQeasy

A marketing team needs to create a public event registration page that captures attendee information and stores it in Dataverse. They want to design the page using drag-and-drop components without writing code. Which feature of Power Pages should they use?

A.Power Automate cloud flow
B.Power Pages Studio
C.Power Apps canvas app
D.Power BI dashboard
AnswerB

Power Pages Studio is the low-code designer for pages.

Why this answer

Power Pages Studio provides a WYSIWYG drag-and-drop interface for building pages.

Full explanation →
108
MCQmedium

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

A.Canvas app
B.Power Virtual Agents bot
C.Model-driven app
D.Power Apps portal
AnswerD

Portals provide external access to Dataverse data via web.

Why this answer

Power Apps portals (now Power Pages) are specifically designed to create external-facing websites that allow external users, such as partners, to interact with Dataverse data through a web interface. Canvas apps and model-driven apps are intended for internal users, while Power Virtual Agents is for chatbots.

Full explanation →
109
MCQeasy

You need to restrict access to a specific page on a Power Pages site to only authenticated users from your organization. Which authentication provider should you configure?

A.Microsoft Entra ID
B.LinkedIn
C.Azure AD B2C
D.Local authentication
AnswerA

Entra ID authenticates organizational users.

Why this answer

Microsoft Entra ID is used for organizational identity. Option B is wrong because Azure AD B2C is for external identities. Option C is wrong because local authentication is for generic users.

Option D is wrong because LinkedIn is not supported natively.

Full explanation →
110
MCQhard

Refer to the exhibit. An organization is configuring IP address and domain restrictions for a Power Pages site. The policy JSON allows traffic from the 131.107.0.0/16 IP range and from contoso.com domain. A user from IP 192.168.1.10 with an email user@fabrikam.com tries to access the site. What will happen?

A.Access is denied because the IP is not in the allowed range and the domain is not contoso.com
B.Access is granted because the domain is not disallowed
C.Access is granted because one of the conditions could be met
D.Access is granted because the IP is not in the disallowed list
AnswerA

Both IP and domain checks fail, so access is denied.

Why this answer

The policy JSON explicitly allows traffic only from IPs in the 131.107.0.0/16 range and from the contoso.com domain. The user's IP (192.168.1.10) is not in that range, and the domain (fabrikam.com) does not match contoso.com. Since both conditions are required (the policy uses an AND logic), access is denied.

Therefore, option A is correct.

Full explanation →
111
MCQmedium

A sales team needs to create a custom app to track leads and manage follow-ups, but they have no coding experience. Which Power Platform tool should they use?

A.Power Pages
B.Power BI
C.Power Automate
D.Power Apps
AnswerD

Power Apps allows non-developers to build custom apps with low-code.

Why this answer

Power Apps (Option D) is the correct tool because it enables users with no coding experience to build custom apps using a low-code, drag-and-drop interface. The sales team can create a lead-tracking app with forms, galleries, and data connections to Microsoft Dataverse or SharePoint without writing traditional code.

Exam trap

The trap here is that candidates often confuse Power Automate (workflow automation) with Power Apps (app building), because both are low-code tools, but Power Automate cannot create user interfaces or custom app screens.

How to eliminate wrong answers

Option A (Power Pages) is wrong because it is designed for creating external-facing websites, not custom apps for internal team use. Option B (Power BI) is wrong because it is a business analytics tool for data visualization and reporting, not for building interactive apps. Option C (Power Automate) is wrong because it focuses on workflow automation and process orchestration, not on constructing user interfaces or app logic.

Full explanation →
112
MCQmedium

An organization has multiple Power Platform environments. They need to ensure that all environments have consistent DLP policies and that any changes are tracked. What should the administrator implement?

A.Export DLP policies as solutions and import them into each environment
B.Use the Power Platform Center of Excellence (CoE) Starter Kit to manage and monitor policies
C.Enable audit logging in each environment
D.Create environment groups and assign DLP policies to the group
AnswerB

The CoE Starter Kit includes tools for governance and monitoring.

Why this answer

The Power Platform Center of Excellence (CoE) Starter Kit provides governance and monitoring capabilities, including consistent DLP policy management and change tracking across environments. Option A is incorrect because exporting DLP policies as solutions does not maintain live consistency or track changes. Option C is incorrect because audit logging only records changes but does not enforce consistency.

Option D is incorrect because environment groups allow grouping but do not directly enforce DLP policies consistently across environments.

Full explanation →
113
MCQmedium

A manufacturing company is deploying Microsoft Power Platform for its sales team. The environment must be segregated from production to allow experimentation without affecting live data. The solution must also support automated deployment pipelines. What should the administrator create?

A.A production environment with Dataverse
B.A Dataverse for Teams environment
C.A developer environment
D.A trial environment
AnswerC

Developer environments are isolated and support automated deployment.

Why this answer

(a developer environment) is designed for isolated development and testing, and it can be used with automated deployment pipelines via solutions. Option A is wrong because a production environment is for live use. Option B is wrong because Dataverse for Teams is limited in scope.

Option D is wrong because a trial environment expires.

Full explanation →
114
Matchingmedium

Match each connector type in Power Automate to its description.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Common connectors like Office 365, SharePoint

Connectors requiring additional licensing

Connectors built by developers for specific APIs

Connects to on-premises data via gateway

Connector that wraps multiple APIs

Why these pairings

Standard connectors are free and cover common services; Premium connectors require a paid license; Custom connectors allow custom API integration; On-premises connectors use a data gateway. Common confusions include swapping definitions between Standard and Premium, or confusing Custom with Standard.

Full explanation →
115
MCQmedium

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?

A.Clear the browser cache and cookies.
B.Verify the connection to the SharePoint data source.
C.Check if the app uses delegation for large lists.
D.Review the app formulas for syntax errors.
AnswerB

Data source connection issues are a common cause of generic save errors.

Why this answer

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.

Full explanation →
116
Multi-Selecthard

Which THREE are valid data sources for a canvas app? (Choose three.)

Select 3 answers
A.Azure DevOps work items
B.SharePoint list
C.SQL Server
D.Excel workbook in OneDrive
E.Power BI dataset
AnswersB, C, D

SharePoint lists are a common data source.

Why this answer

SharePoint lists are supported. Option C is correct because SQL Server is supported. Option D is correct because Excel files stored in OneDrive are supported.

Option A is wrong because Azure DevOps is not a direct canvas app data source (use connectors). Option E is wrong because Power BI datasets are not data sources; you can embed reports but not use as source.

Full explanation →
117
MCQmedium

A company uses Power BI to analyze customer feedback from surveys. The data is stored in Excel on SharePoint. They want to refresh the report daily without manual intervention. Which feature should they use?

A.Power BI gateway
B.DirectQuery mode
C.Power BI scheduled refresh
D.Power Automate flow to refresh the dataset
AnswerC

Scheduled refresh automatically updates the dataset from SharePoint Excel files.

Why this answer

Power BI scheduled refresh allows you to configure automatic, recurring data refreshes for datasets stored in the cloud (including Excel files on SharePoint). This eliminates the need for manual intervention by using the Power BI service to re-import the data at defined intervals, such as daily.

Exam trap

The trap here is that candidates often confuse the on-premises data gateway (needed for local data sources) with the cloud-based scheduled refresh (needed for cloud data sources like SharePoint), or they overcomplicate the solution by choosing Power Automate when the built-in feature is sufficient.

How to eliminate wrong answers

Option A is wrong because the Power BI gateway is used to connect on-premises data sources (like SQL Server) to the Power BI cloud service, not to refresh data already stored in SharePoint Online. Option B is wrong because DirectQuery mode queries the source directly without importing data, which is not suitable for scheduled refresh scenarios and does not apply to Excel files on SharePoint. Option D is wrong because while a Power Automate flow could trigger a dataset refresh, it is an additional, unnecessary layer of complexity; the built-in scheduled refresh feature in Power BI is the standard, simpler solution for this requirement.

Full explanation →
118
MCQeasy

An administrator is reviewing an ARM template for deploying a Power Platform environment. Based on the exhibit, what type of environment will be created?

A.Trial environment
B.Developer environment
C.Production environment
D.Sandbox environment
AnswerB

(Developer) is correct because the ARM template specifies 'environmentSku' as 'Developer', which creates a Developer environment.

Why this answer

The ARM template sets 'environmentSku' to 'Developer', which creates a Developer environment. Option A (Trial) is wrong because 'Developer' is not a Trial SKU. Option C (Production) is wrong because 'Developer' is not a Production SKU.

Option D (Sandbox) is wrong because 'Developer' is not a Sandbox SKU.

Full explanation →
119
MCQmedium

A company wants to automatically send a welcome email to new customers when they submit a form on the company website. Which Power Platform tool should be used?

A.Power BI
B.Power Automate
C.Power Apps
D.Power Virtual Agents
AnswerB

Power Automate can automate email sending based on triggers.

Why this answer

Power Automate is the correct tool because it enables the creation of automated workflows that can trigger when a form is submitted, then send a welcome email via an email connector. This aligns with Power Automate's core purpose of automating business processes across applications and services without manual intervention.

Exam trap

The trap here is that candidates may confuse Power Automate with Power Apps, mistakenly thinking a custom app is required to send emails, when in fact Power Automate is the dedicated tool for event-driven automation like sending emails upon form submission.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and business analytics tool, not designed for workflow automation or sending emails. Option C is wrong because Power Apps is a low-code platform for building custom applications, but it lacks native workflow triggers and email automation capabilities without integrating Power Automate. Option D is wrong because Power Virtual Agents is a chatbot-building tool for conversational AI, not for triggering automated email responses based on form submissions.

Full explanation →
120
MCQhard

A financial services firm uses Power Platform in a highly regulated environment. They have a production environment that contains sensitive customer data. The compliance officer requires that all changes to apps and flows in production be approved before deployment. The development team uses a separate sandbox environment. The admin needs to implement a change management process that ensures only approved solutions are deployed to production. What should the admin do?

A.Use Power Automate approval flows to send notifications when a change is made.
B.Restrict permissions so only the admin can deploy solutions to production.
C.Enable Managed Environments for the production environment and configure the deployment pipeline with approval gates.
D.Manually review and approve changes by checking version history in the sandbox.
AnswerC

Managed Environments with deployment pipelines enforce approval before deployment.

Why this answer

Managed Environments in Power Platform provide governance rules, including deployment pipelines that require approval before solutions are deployed to production. This meets the compliance requirement.

Full explanation →
121
MCQmedium

Refer to the exhibit. The JSON shows the definition of a Power App. What can be concluded?

A.The app is deployed to production
B.The app connects to SharePoint Online
C.The app uses Dataverse as its data source
D.The app is a model-driven app
AnswerB

The connectionId indicates SharePoint Online.

Why this answer

The JSON includes a connection reference to SharePoint Online, indicating that the app uses SharePoint as its data source. Option A is incorrect because the JSON does not provide any deployment status information. Option C is incorrect because the data source is SharePoint, not Dataverse.

Option D is incorrect because the 'type' field in the JSON indicates it is a CanvasApp, not a model-driven app.

Full explanation →
122
MCQeasy

A company is implementing Microsoft Power Platform. The administrator needs to prevent users from creating personal productivity environments. What should they configure?

A.Configure a Data Loss Prevention (DLP) policy
B.Set a conditional access policy in Microsoft Entra ID
C.Disable the 'Create personal productivity environments' setting in the Power Platform admin center
D.Reduce the tenant-level environment capacity limits
AnswerC

This setting directly controls whether users can create personal environments.

Why this answer

The Power Platform admin center includes a tenant-wide setting specifically named 'Create personal productivity environments' that, when disabled, prevents users from creating their own personal environments. This setting directly controls the ability to create environments for personal productivity, which is distinct from other environment creation permissions.

Exam trap

The trap here is that candidates may confuse environment creation controls with capacity limits or security policies, but the PL-900 exam specifically tests the knowledge that a dedicated admin setting exists for disabling personal productivity environments.

How to eliminate wrong answers

Option A is wrong because a Data Loss Prevention (DLP) policy controls data movement between connectors and services, not the ability to create environments. Option B is wrong because a conditional access policy in Microsoft Entra ID governs authentication and access to applications, not environment creation within Power Platform. Option D is wrong because reducing tenant-level environment capacity limits restricts the total storage or number of environments but does not specifically prevent users from creating personal productivity environments; users could still create them until capacity is exhausted.

Full explanation →
123
MCQmedium

A Power Automate flow uses the trigger configuration shown. Users report that the flow does not start when a new order is added with Status = 'Pending'. What is the most likely cause?

A.The SharePoint dataset URL is incorrect
B.The flow is paused or turned off
C.The trigger only fires on modification, not creation
D.The trigger condition only allows items with Status = 'New'
AnswerD

Correct. The trigger condition filters out items with Status = 'Pending'.

Why this answer

The trigger condition explicitly filters for items where Status equals 'New'. When a new order is added with Status = 'Pending', the condition evaluates to false, so the flow does not trigger. Trigger conditions in Power Automate act as a pre-filter on the trigger event, preventing the flow from running if the condition is not met.

Exam trap

The trap here is that candidates often overlook the trigger condition configuration and assume the flow should run on any new item, confusing the trigger event type (creation/modification) with the filtering logic applied by the condition.

How to eliminate wrong answers

Option A is wrong because an incorrect SharePoint dataset URL would cause a connection error or failure to retrieve data, not a silent failure to start when a specific item is added. Option B is wrong because if the flow were paused or turned off, it would not start for any trigger event, not just for items with Status = 'Pending'. Option C is wrong because the trigger shown is configured for 'When an item is created or modified', which fires on both creation and modification; the issue is not the trigger event type but the trigger condition filtering.

Full explanation →
124
MCQhard

Refer to the exhibit. You are reviewing an ARM template for deploying a Power Pages site. The template sets the 'AllowedExternalDomains' to 'contoso.com'. What is the purpose of this setting?

A.Restrict authentication to users from contoso.com.
B.Allow users from any external domain to sign in.
C.Enable cross-origin resource sharing (CORS) for contoso.com.
D.Allow embedding of content from contoso.com.
AnswerA

Only users from the specified domain can authenticate.

Why this answer

The 'AllowedExternalDomains' setting in an ARM template for Power Pages restricts which external domains can be used for authentication. By setting it to 'contoso.com', only users from that domain can sign in, matching option A. Option B is incorrect because it does not allow any domain; option C is incorrect because CORS is not controlled by this setting; option D is incorrect because this setting does not control embedding content.

Full explanation →
125
Multi-Selecthard

Which THREE capabilities does Microsoft Power Platform include to help organizations achieve digital transformation?

Select 3 answers
A.Custom AI model training from scratch
B.Low-code application development
C.Replacement of all custom coding
D.Workflow automation
E.Data analytics and visualization
AnswersB, D, E

Power Apps enables low-code app creation.

Why this answer

Power Platform includes low-code app development (Power Apps), workflow automation (Power Automate), and data analytics (Power BI). Custom AI model training is via AI Builder, not a separate component, and it does not replace all coding.

Full explanation →
126
MCQeasy

A Power Platform administrator wants to delegate the responsibility of managing environments to regional leads without granting them full admin privileges. Which role should the administrator assign?

A.Environment Admin role.
B.Dynamics 365 Administrator role.
C.System Customizer role.
D.Power Platform Administrator role.
AnswerA

This role provides full management of a specific environment.

Why this answer

The Environment Admin role allows a user to manage all aspects of a specific environment, including security and settings, without tenant-wide privileges. Option B, Dynamics 365 Administrator, is a broader role that includes Dynamics 365 apps and is not specific to Power Platform environment management. Option C, System Customizer, only allows customization of system settings and forms, not full environment management.

Option D, Power Platform Administrator, is a tenant-wide role that grants administrative access to all environments, which is more than what is needed for delegation to regional leads.

Full explanation →
127
MCQeasy

A company has a Power Platform environment that contains several unmanaged solutions. The administrator wants to promote a solution to production. Which action should the administrator take to ensure the solution can be deployed to other environments?

A.Export the solution as a managed solution
B.Use the 'Backup' feature in the admin center
C.Apply a solution patch and export it
D.Clone the solution and export as unmanaged
AnswerA

Managed solutions are designed for deployment to other environments.

Why this answer

Exporting a solution as a managed solution is the correct action because managed solutions are designed for deployment to production and other non-development environments. They prevent direct customization of components, enforce solution layering, and allow for proper lifecycle management, including upgrades and patching. Unmanaged solutions, by contrast, are intended for development and cannot be reliably deployed to production without breaking the component ownership model.

Exam trap

The trap here is that candidates confuse the 'Backup' feature with solution deployment, or assume that exporting as unmanaged is acceptable for production because it preserves all components, but they overlook the critical requirement for managed solutions to enforce lifecycle control and prevent direct customization.

How to eliminate wrong answers

Option B is wrong because the 'Backup' feature in the admin center creates a full environment backup, not a portable solution package; it cannot be selectively deployed to another environment and does not support solution lifecycle management. Option C is wrong because applying a solution patch and exporting it creates a patch that depends on the parent managed solution; patches are intended for minor updates to an already-deployed managed solution, not for initial deployment to production. Option D is wrong because cloning a solution and exporting it as unmanaged preserves the unmanaged state, which allows direct customization in the target environment, breaking the managed solution deployment model and causing future upgrade conflicts.

Full explanation →
128
MCQhard

Your organization uses Microsoft Power Platform to manage customer support tickets. The current process: when a ticket is created in Dataverse, a Power Automate flow sends an email to the support team. The team then updates the ticket status manually in a Power Apps canvas app. However, the team often forgets to update the status, leading to delayed responses. The manager wants an automated solution that sends a reminder if the status is not changed within 24 hours. Additionally, if the status is not changed within 48 hours, the ticket should be escalated to the manager. You need to design a solution using Power Automate and Power Apps. Which approach should you take?

A.Modify the Power Apps app to include a reminder notification using the notify function after 24 hours.
B.Create two scheduled Power Automate flows: one runs daily to check tickets older than 24 hours and send reminder; another runs daily to check tickets older than 48 hours and escalate.
C.Create one Power Automate flow with a recurrence trigger every hour. Check tickets older than 24 hours and send reminder; if also older than 48 hours, escalate. Add condition to avoid duplicate actions.
D.Create a single Power Automate flow triggered when a ticket is created. Add a 24-hour delay then check status; if not updated, send reminder and wait another 24 hours then escalate.
AnswerB

Scheduled flows can check conditions and perform actions on multiple tickets.

Why this answer

It uses two separate scheduled flows that run daily to check ticket ages and perform actions based on conditions. This approach ensures automatic reminders after 24 hours and escalation after 48 hours without relying on user action. Option A is wrong because the Power Apps notify function would require the app to be open and doesn't provide recurring checks.

Option C is wrong because an hourly recurrence may waste resources and create duplicate actions; a daily schedule is more appropriate. Option D is wrong because a single flow triggered on creation with delays would only run once per ticket, not continuously check for updates.

Full explanation →
129
MCQhard

You are designing a Power Automate cloud flow that processes customer feedback from Microsoft Forms. The flow should send an email to the customer if their feedback rating is less than 3, and also post a message to a Microsoft Teams channel for all feedback. The flow works correctly for rating 2, but for rating 1 it sends two emails instead of one. What is the most likely cause?

A.The Teams action is configured to also send an email.
B.The condition branch has two separate 'Send an email' actions that both run for rating 1.
C.The flow is triggered multiple times due to multiple submissions.
D.The rating value is stored as text and the condition incorrectly compares numbers.
AnswerB

Duplicate email actions cause multiple sends.

Why this answer

The most likely cause is that the condition branch for 'Yes' (rating less than 3) contains two separate 'Send an email' actions, both of which are triggered when the condition is met. For rating 1, the condition is true, so both email actions execute, sending two emails. This is a common design error where a duplicate action is accidentally added.

Option A is incorrect because the Teams action does not send emails. Option C is incorrect because the trigger fires once per submission. Option D is incorrect because the rating is numeric and the condition works correctly for rating 2, so comparison is not the issue.

Full explanation →
130
MCQeasy

A company is implementing Microsoft Power Platform and needs to ensure that only licensed users can create environments. Which setting should be enabled?

A.Enable 'Create database' in the tenant settings
B.Enable 'Create solutions' in the Power Platform admin center
C.Enable 'Create environments' in the Power Platform admin center tenant settings
D.Enable 'Create apps' in the Power Platform admin center
AnswerC

This setting controls whether users can create environments.

Why this answer

The 'Create environments' setting in the Power Platform admin center tenant settings is the specific control that restricts environment creation to licensed users only. By default, this setting is enabled for all users, but administrators can disable it to limit creation to users with a Power Platform license (e.g., Power Apps per user plan, Power Automate per user plan, or Dynamics 365 licenses). This ensures compliance with licensing requirements and prevents unlicensed users from consuming capacity.

Exam trap

The trap here is that candidates confuse environment-level permissions (like 'Create database' or 'Create apps') with the tenant-level setting that controls environment creation, leading them to select a granular permission that does not address the licensing requirement.

How to eliminate wrong answers

Option A is wrong because 'Create database' is a setting within a specific environment (not tenant-wide) that controls whether users can add a Dataverse database to an existing environment; it does not govern who can create new environments. Option B is wrong because 'Create solutions' is a permission related to building and managing solutions within an environment, not a tenant-level setting for environment creation. Option D is wrong because 'Create apps' is a permission that controls the ability to create canvas or model-driven apps within an environment, not the ability to provision new environments.

Full explanation →
131
MCQhard

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

A.Remove the field from the form and create a separate form for Premium Support agents
B.Use the 'Visible' property of the field in a Canvas app embedded in the model-driven app
C.Configure field-level security in Microsoft Dataverse
D.Create a business rule that sets the field as read-only for non-Premium roles
AnswerC

Field-level security allows or denies read/write on a field per security role.

Why this answer

Field-level security in Microsoft Dataverse allows administrators to restrict access to a specific field based on security roles. This ensures only agents in the 'Premium Support' role can see the 'SLA Level' field. Option A is incorrect because removing the field from the form would affect all users.

Option B is not a standard security feature; Canvas apps are not designed for field-level permissions in model-driven apps. Option D is incorrect because a business rule can only make a field read-only, but it cannot hide the field from specific roles.

Full explanation →
132
MCQmedium

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

A.Workflow
B.SLA KPIs
C.Routing rule set
D.Business process flow
AnswerC

Routing rule sets assign records to queues automatically based on criteria.

Why this answer

Routing rule set, is correct because routing rule sets automatically assign records to queues based on defined conditions such as case category. This feature is specifically designed for automatic queue assignment in model-driven apps. Option A (Workflow) runs background processes but does not handle queue assignment directly.

Option B (SLA KPIs) tracks service level performance, not routing. Option D (Business process flow) guides users through a process but does not automatically assign cases to queues.

Full explanation →
133
Multi-Selecteasy

Which TWO are benefits of using Microsoft Power Platform for business process automation?

Select 2 answers
A.Reduces need for custom coding
B.Integrates seamlessly with Microsoft 365 and Dynamics 365
C.Requires dedicated IT team for every automation
D.Only works on-premises
E.Requires deep knowledge of programming languages
AnswersA, B

Low-code tools allow business users to create solutions without extensive coding.

Why this answer

Microsoft Power Platform provides low-code and no-code tools like Power Automate and Power Apps, enabling users to create automated workflows and applications without writing custom code. This reduces reliance on professional developers and accelerates business process automation.

Exam trap

The trap here is that candidates may think automation always requires IT involvement (Option C) or deep coding skills (Option E), but Power Platform's low-code paradigm directly contradicts those assumptions.

Full explanation →
134
Multi-Selecteasy

Which TWO of the following are valid trigger types in Power Automate?

Select 2 answers
A.Instant
B.Event
C.Automated
D.Manual
E.Calendar
AnswersA, C

Instant triggers are started manually.

Why this answer

Options A and C are correct. Instant triggers (A) are started manually by a user, while Automated triggers (C) respond to events such as an email arriving or a file being created. Option B (Event) is not a valid trigger type; Power Automate uses 'Scheduled' or 'Automated' for event-based flows.

Option D (Manual) is not a distinct trigger type—it is a subtype of Instant. Option E (Calendar) is not a trigger type; scheduling is done via 'Scheduled' triggers.

Full explanation →
135
Multi-Selecthard

Which THREE of the following are capabilities of AI Builder within Power Platform? (Select three.)

Select 3 answers
A.Sentiment analysis
B.Replacing Azure Machine Learning
C.Object detection in images
D.Form processing
E.Building custom machine learning models from scratch
AnswersA, C, D

AI Builder can analyze sentiment in text.

Why this answer

AI Builder includes a prebuilt sentiment analysis model that analyzes text and returns sentiment scores (positive, negative, neutral, or mixed) using natural language processing (NLP). This capability allows Power Apps and Power Automate to assess customer feedback, social media posts, or survey responses without requiring custom machine learning expertise.

Exam trap

The trap here is that candidates may confuse AI Builder's ability to train custom models (e.g., for object detection or form processing) with building machine learning models from scratch, which is not supported—AI Builder only allows customization of prebuilt model templates, not full model architecture design.

Full explanation →
136
MCQmedium

A company uses Power Virtual Agents (now Copilot Studio) to handle customer inquiries. They want to escalate complex issues to a human agent when the bot cannot resolve them. What should they configure?

A.Create a Power Automate flow to send an email to the support team.
B.Use the 'Escalate' topic to hand off to a live agent.
C.Remove all topics except the escalation topic.
D.Configure the bot to transfer to a second bot.
AnswerB

Escalation topics allow handoff to human agents.

Why this answer

Power Virtual Agents (Copilot Studio) includes a built-in 'Escalate' topic that, when triggered, hands off the conversation to a live agent via a configured engagement hub (e.g., Dynamics 365 Customer Service or Omnichannel for Customer Service). This is the native mechanism for transferring unresolved issues to a human agent without requiring custom automation or removing other topics.

Exam trap

The trap here is that candidates often confuse a simple notification (like an email) with a proper context-preserving handoff, or they mistakenly think removing all other topics is a valid way to force escalation, when in fact the built-in 'Escalate' topic is the correct and only supported method.

How to eliminate wrong answers

Option A is wrong because sending an email via Power Automate does not transfer the ongoing conversation context to a human agent; it only sends a notification, leaving the customer in the bot without a live handoff. Option C is wrong because removing all topics except the escalation topic would break the bot's ability to handle any other inquiries, making it useless for most customer interactions. Option D is wrong because Power Virtual Agents does not support transferring to a second bot as a built-in escalation path; the intended handoff is to a human agent, not another bot.

Full explanation →
137
MCQeasy

Refer to the exhibit. A Power Automate flow triggers when an item is created in a SharePoint list. The flow does not trigger for items created immediately after the flow is enabled. What is the most likely cause?

A.The utcNow() function returns a static time.
B.The trigger uses a polling interval that may not capture items created shortly after enablement.
C.The $filter expression is invalid.
D.The site ID is incorrect.
AnswerB

Polling can miss items if not immediate.

Why this answer

The SharePoint trigger in Power Automate uses a polling interval; when the flow is enabled, it may not immediately capture items created before the first poll completes. This is a common cause of missing recent items. Option A is incorrect because utcNow() is evaluated dynamically at each poll, not static.

Option C is incorrect because there is no evidence the $filter expression is invalid. Option D is incorrect because the site ID is typically correct if the flow connects successfully.

Full explanation →
138
MCQmedium

A retail company uses Power Apps to manage inventory. The app allows store managers to scan barcodes and update stock levels in real time. The company wants to extend this capability to suppliers so they can view stock levels but not modify them. Which Power Platform component should be used to create the supplier-facing interface?

A.Power Apps portals
B.Power BI dashboard
C.Canvas app
D.Power Automate
AnswerA

Power Apps portals enable external users to interact with data through a secure website.

Why this answer

Power Apps portals (now part of Power Pages) allow external users, such as suppliers, to access data through a low-code, authenticated website without requiring a Power Apps license or internal network access. This enables suppliers to view stock levels via a browser-based interface while preventing any modification, as permissions can be set to read-only. Canvas apps, by contrast, are designed for internal users and require a license or guest access in Azure AD, making portals the correct choice for external, unauthenticated or lightly authenticated scenarios.

Exam trap

The trap here is that candidates confuse a canvas app’s ability to share with external users (via guest access) with a purpose-built external-facing portal, forgetting that canvas apps require licensing and are not designed for anonymous or lightly authenticated external access without complex Azure AD setup.

How to eliminate wrong answers

Option B is wrong because a Power BI dashboard is a visualization and analytics tool, not an interactive interface for external users to view and query live stock data; it cannot provide per-user read-only data entry or form-based views. Option C is wrong because a canvas app requires each external user to have a Power Apps license (or be added as a guest in Azure AD with appropriate licensing), and it is typically run on a mobile device or within the same tenant, not as a publicly accessible website. Option D is wrong because Power Automate is an automation workflow engine, not a user-facing interface; it cannot present a UI for suppliers to browse stock levels.

Full explanation →
139
MCQmedium

A data analyst notices that a Power BI report takes a long time to load when filtering by a specific date range. The data source is a SQL Server view that contains millions of rows. What is the most effective way to improve performance?

A.Create a calculated column for the date range filter
B.Use DirectQuery and optimize the SQL view with indexes and filters
C.Switch from DirectQuery to Import mode
D.Hide unnecessary columns in the report
AnswerB

DirectQuery with query folding pushes processing to the source, and indexes improve performance.

Why this answer

The performance bottleneck is at the data source level—millions of rows in a SQL Server view. Using DirectQuery with optimized indexes and filters pushes query execution back to SQL Server, allowing it to leverage database-level performance features like index seeks and query plan caching. This reduces the amount of data transferred and processed in Power BI, directly addressing the root cause of slow filtering.

Exam trap

The trap here is that candidates often assume Import mode is always faster for large datasets, but they overlook that DirectQuery with source-side optimization avoids transferring all data and leverages the database's native query processing power.

How to eliminate wrong answers

Option A is wrong because a calculated column is computed in Power BI after data is loaded, which does not reduce the volume of data retrieved from the source and adds processing overhead, worsening performance. Option C is wrong because switching from DirectQuery to Import mode would load all millions of rows into the Power BI model, increasing memory usage and initial load time, and does not solve the underlying slow query execution on the SQL Server side. Option D is wrong because hiding unnecessary columns only affects report visuals, not the data retrieval or query execution; the SQL view still returns all columns and rows, so performance remains unchanged.

Full explanation →
140
Multi-Selecteasy

Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)

Select 2 answers
A.When a new email arrives (Outlook)
B.When a row is added, modified, or deleted
C.When a new file is created (SharePoint)
D.PowerApps button
E.When a row is added
AnswersB, E

Standard Dataverse trigger.

Why this answer

The correct answers are B and E. Dataverse provides triggers such as 'When a row is added, modified, or deleted' (option B) and 'When a row is added' (option E). These triggers initiate flows based on changes to rows in a Dataverse table.

Options A and C are incorrect because they are triggers for Outlook and SharePoint respectively, not Dataverse. Option D is a manual trigger, not a Dataverse trigger.

Full explanation →
141
MCQeasy

Refer to the exhibit. The JSON shows permissions for a user in a Power Apps environment. What can be inferred?

A.The user is a maker who can create apps
B.The user has no access to any app
C.The user can only view apps
D.The user is an administrator of the environment
AnswerD

The Environment Admin role indicates administrative privileges.

Why this answer

The JSON shows the user has the Environment Admin role, which grants full administrative permissions over the environment. Option A is incorrect because the maker role is separate and not indicated. Option B is incorrect because having an admin role implies access.

Option C is incorrect because an admin can perform actions beyond viewing.

Full explanation →
142
MCQhard

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?

A.Copy the entire development environment to production
B.Export an unmanaged solution from development and import it into production
C.Manually re-create all components in production
D.Export a managed solution from development and import it into production
AnswerD

Managed solutions are the standard for deploying between environments.

Why this answer

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.

Exam trap

The trap here is that candidates often confuse unmanaged and managed solutions, mistakenly thinking that exporting an unmanaged solution (Option B) is acceptable for production deployment, when in fact only managed solutions enforce the intended lifecycle and prevent unauthorized edits in production.

How to eliminate wrong answers

Option A is wrong because copying the entire development environment to production would overwrite production data and configurations, and it is not a supported method for solution deployment—Power Platform does not allow direct environment cloning for production use. Option B is wrong because exporting an unmanaged solution from development and importing it into production would leave all components editable in production, which violates change management best practices and can lead to configuration drift; unmanaged solutions are intended for development work, not production deployment. Option C is wrong because manually re-creating all components in production is error-prone, time-consuming, and defeats the purpose of using solutions for lifecycle management; it also introduces a high risk of inconsistencies between environments.

Full explanation →
143
Matchingmedium

Match each Microsoft Dataverse security concept to its definition.

Drag a concept onto its matching description — or click a concept then click the description.

Concepts
Matches

Set of privileges assigned to users

Permission to perform an action on a table

Group sharing access without owning records

Group that owns records and can share them

Logical grouping of users and data

Why these pairings

Dataverse uses role-based security as its foundation. Role-based security controls access via user roles, field-level security restricts specific attributes, row-level security governs records, and team-based security applies roles to groups. Common mistakes include confusing field-level with row-level or mixing definition of role-based security.

Full explanation →
144
Multi-Selecthard

Which THREE are valid connectors in Power Automate? (Choose three.)

Select 4 answers
A.Outlook
B.SharePoint
C.Microsoft Teams
D.Power BI
E.Excel
AnswersA, B, C, D

Correct. Outlook connector allows automation of email, calendar, and contacts.

Why this answer

Outlook, SharePoint, Microsoft Teams, and Power BI are all valid connectors in Power Automate. Excel is not a direct connector; its integration is typically achieved through OneDrive or SharePoint connectors.

Full explanation →
145
MCQmedium

A company wants to build a custom app to track inventory across multiple warehouses. The app must use existing data from a SQL Server database and provide real-time updates. Which Power Platform component should they use to connect the app to the data source?

A.Power Apps with a connector
B.Microsoft Dataverse
C.Power BI
D.Power Automate
AnswerA

Power Apps uses connectors to connect to various data sources including SQL Server.

Why this answer

Power Apps connectors provide pre-built integration with SQL Server, enabling the app to read and write data directly from the existing database. This allows real-time updates by using the SQL Server connector, which supports live queries and triggers without requiring data migration.

Exam trap

The trap here is that candidates often confuse Dataverse as the only data source for Power Apps, but connectors allow direct integration with existing SQL Server databases without migration.

How to eliminate wrong answers

Option B is wrong because Microsoft Dataverse is a cloud-based data platform that would require importing or replicating the SQL Server data, not directly connecting to the existing database. Option C is wrong because Power BI is an analytics and visualization tool, not an app-building platform, and it cannot serve as the data source for a custom app. Option D is wrong because Power Automate is an automation workflow tool that can trigger actions but cannot itself host or connect an app to a data source for real-time updates.

Full explanation →
146
MCQhard

A Power Automate flow is designed to copy files from OneDrive for Business to a SharePoint document library. Some files fail to copy because the file name contains special characters. Which action should be added to the flow to handle this?

A.Add an 'Apply to each' loop
B.Add a 'Condition' to check for special characters
C.Add a 'Compose' action to replace special characters
D.Add a 'Scope' action to manage the operation
AnswerC

Correct: Compose can transform strings using expressions.

Why this answer

The 'Compose' action can be used to sanitize file names by replacing special characters. Option A is wrong because 'Apply to each' iterates over items but does not modify names. Option B is wrong because 'Condition' checks conditions but does not transform data.

Option D is wrong because 'Scope' groups actions but does not handle errors.

Full explanation →
147
MCQmedium

You are designing a solution to automatically send a welcome email to new employees after their record is created in a Dataverse table. The solution must use a Microsoft Power Platform component. Which component should you use?

A.Power Apps
B.Power BI
C.Power Automate
D.Power Pages
AnswerC

Power Automate can trigger on Dataverse record creation and perform actions like sending emails.

Why this answer

Power Automate can create automated workflows that trigger on record creation in Dataverse and send welcome emails. Option A is incorrect because Power Apps is for building custom apps, not for automation. Option B is incorrect because Power BI is for data visualization and analytics.

Option D is incorrect because Power Pages is for creating external-facing websites.

Full explanation →
148
MCQeasy

A company wants to allow customers to view their order history on a Power Pages site. Customers must log in to see their own orders only. Which feature should be used to enforce data security?

A.Configure entity permissions for the Orders table and assign to a web role.
B.Enable column-level security on the Orders table.
C.Use a custom authentication provider to filter data.
D.Set page permissions to require authentication.
AnswerA

Entity permissions allow record-level security based on user identity.

Why this answer

Entity permissions in Power Pages allow you to define granular access rights (Create, Read, Update, Delete) for specific Dataverse tables. By configuring entity permissions for the Orders table and assigning them to a web role that is associated with the authenticated user, you ensure that customers can only see their own orders based on the relationship between the Contact record and the Orders table. This is the correct approach because it enforces row-level security tied to the authenticated user's identity.

Exam trap

The trap here is that candidates confuse authentication (logging in) with authorization (data filtering), assuming that requiring a login (Option D) is sufficient to secure data, when in fact row-level security requires explicit entity permissions.

How to eliminate wrong answers

Option B is wrong because column-level security restricts access to specific columns (fields) within a table, not to entire rows, so it cannot filter which orders a customer sees. Option C is wrong because custom authentication providers handle identity verification and login, not data filtering; data filtering is a separate authorization concern managed by entity permissions. Option D is wrong because page permissions only control access to the page itself (requiring authentication), but they do not enforce row-level filtering on the data displayed within the page.

Full explanation →
149
MCQhard

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

A.Total sales for the previous year relative to the selected year.
B.Total sales for the current year.
C.Running total of sales up to the selected year.
D.Year-over-year growth percentage.
AnswerA

Correct: it calculates the sum for the year before the selected one.

Why this answer

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.

Exam trap

The trap here is that candidates confuse `SAMEPERIODLASTYEAR` with a year-over-year growth percentage calculation, but the measure only returns the absolute value from the previous year, not the growth rate.

How to eliminate wrong answers

Option B is wrong because the measure explicitly uses `SAMEPERIODLASTYEAR`, which returns data from the prior year, not the current year; a current year measure would use `SUM(Sales[Amount])` without a time shift. Option C is wrong because a running total would require a function like `TOTALYTD` or `CALCULATE` with a `FILTER` over all dates up to the current context, not a simple `SAMEPERIODLASTYEAR` shift. Option D is wrong because year-over-year growth percentage requires a division formula (e.g., `(CurrentYear - PreviousYear) / PreviousYear`), but this measure only returns the absolute previous year sales, not a percentage or growth calculation.

Full explanation →
150
MCQeasy

A non-profit organization uses Microsoft 365 but has no IT staff. They want to create a simple app to track volunteer hours and automatically send reminders to volunteers who haven't logged hours in a week. They also need a dashboard to view total hours by project. Which combination of Power Platform tools should they use?

A.Power Apps, AI Builder, and Power BI
B.Power Pages, Power Automate, and Power BI
C.Copilot Studio, Power Automate, and Power BI
D.Power Apps, Power Automate, and Power BI
AnswerD

Power Apps builds the app, Power Automate sends reminders, Power BI creates the dashboard.

Why this answer

Power Apps provides the low-code platform to build the volunteer hour logging app, Power Automate handles the automated reminder emails based on a weekly trigger, and Power BI creates the dashboard for total hours by project. This combination directly addresses all three requirements without needing IT staff, as all tools are designed for citizen developers.

Exam trap

The trap here is that candidates may overcomplicate the solution by adding unnecessary tools like AI Builder or Copilot Studio, when the core requirement is simply a data-entry app, automated workflow, and dashboard—all covered by Power Apps, Power Automate, and Power BI.

How to eliminate wrong answers

Option A is wrong because AI Builder is used for adding AI capabilities like object detection or form processing, not for sending automated reminders or creating dashboards, so it is unnecessary here. Option B is wrong because Power Pages is for creating external-facing websites, not for building a simple app for internal volunteer hour tracking; it adds complexity without benefit. Option C is wrong because Copilot Studio is for creating custom copilots (chatbots) and does not provide the app-building capability needed for the volunteer hour logging interface.

Full explanation →
Page 1

Page 2 of 13

Page 3

All pages

12345678910111213

Practice PL-900 by domain

Target a specific domain to shore up weak areas.

Demonstrate the capabilities of Power AutomateDescribe the business value of Microsoft Power PlatformManage the Microsoft Power Platform environmentDemonstrate the capabilities of Power AppsDemonstrate the capabilities of Microsoft Copilot Studio
See all domains with question counts →