Courseiva

Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 301–375

976 questions total · 14pages · All types, answers revealed

Take a mock examExam hub
Page 4

Page 5 of 14

Page 6
301
Multi-Selectmedium

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

Select 2 answers
A.Sending an approval request when a new expense report is submitted
B.Generating a daily sales report at 8 AM
C.Archiving records older than 30 days every Sunday
D.Creating a task in Planner when a new email arrives with specific subject
E.Posting a message to Teams when a new file is added to SharePoint
AnswersB, C

A scheduled flow can run daily at a specific time.

Why this answer

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

Both scenarios rely on time-based triggers, not event-driven triggers.

Exam trap

The trap here is that candidates often confuse event-driven triggers (e.g., 'when a new item is created') with scheduled triggers, mistakenly thinking any recurring task can be automated with a scheduled flow, but only time-based, non-event-driven scenarios qualify.

Full explanation →
302
MCQhard

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

A.The trigger condition expression is incorrect because it references triggerBody() which is not available in trigger conditions.
B.The SharePoint connection is not configured correctly.
C.The trigger should be set to 'When an item is created or modified'.
D.The flow should use a Condition action instead of a trigger condition.
AnswerA

Trigger conditions must use triggerOutputs() or workflow() functions.

Why this answer

Option A is correct because the trigger condition is incorrectly placed; it should be in the trigger definition but the syntax is correct. Actually, the trigger condition is correct, but the condition only filters at trigger time. However, the exhibit shows the triggerCondition parameter, which is correct.

The issue might be that the condition is not being evaluated because the trigger is set to 'When an item is created' which fires on creation regardless. But the triggerCondition should filter. Actually, the correct answer is B: The trigger condition should be inside an action, not the trigger.

Wait, in Power Automate, trigger conditions are supported. The exhibit shows it inside the trigger inputs, which is valid. But the question says it runs for all items.

Perhaps the condition is not correct because it uses 'triggerBody()' which may not be available in the trigger condition. In Power Automate, trigger conditions use the trigger outputs. The correct syntax might be @equals(triggerOutputs()?['body/Status'], 'New').

So the issue is the expression. Option B is more accurate: the condition is using the wrong expression. However, the options are: A: The trigger condition expression is incorrect because it references triggerBody() which is not available in trigger conditions.

B: The flow should use a Condition action instead of a trigger condition. C: The SharePoint connection is not configured correctly. D: The trigger should be set to 'When an item is created or modified'.

The best answer is A because triggerBody() is not a valid function in the trigger condition; you should use triggerOutputs(). I'll go with A.

Full explanation →
303
MCQmedium

A sales team uses Power Automate to create a lead in Dynamics 365 Sales when a new row is added to a Google Sheets spreadsheet. The flow fails with a 'Forbidden' error. What is the most likely cause?

A.The Microsoft Entra ID token has expired
B.The Google Sheets connection is not authenticated
C.The SharePoint trigger is misconfigured
D.The Dynamics 365 action is invalid
AnswerB

A 'Forbidden' error typically indicates an authentication problem with the connection.

Why this answer

Option C is correct because the error suggests authentication issues with the Google Sheets connection. Option A is less likely because the flow would fail at the trigger step, not after. Option B is incorrect because Google Sheets does not use Microsoft Entra ID.

Option D is incorrect because the trigger is a new row event.

Full explanation →
304
MCQhard

An organization is using Microsoft Power Platform to build a compliance solution. They need to ensure that sensitive data in Dataverse is encrypted at rest and that access is audited. Which feature should they enable?

A.Data Loss Prevention (DLP) policies
B.Customer-managed encryption key (CMK) and Audit logging
C.Power Apps business rules
D.Microsoft Entra ID Conditional Access policies
AnswerB

CMK allows the organization to manage encryption keys, and audit logging tracks access to data.

Why this answer

Customer-managed encryption key (CMK) provides control over the encryption key used to encrypt data at rest in Dataverse, ensuring sensitive data is encrypted with a key managed by the organization. Audit logging records all access and changes to data, enabling compliance auditing. Together, they directly address the requirements for encryption at rest and access auditing.

Exam trap

The trap here is that candidates often confuse Data Loss Prevention (DLP) policies with data protection at rest, but DLP only governs data movement and does not provide encryption or auditing of stored data.

How to eliminate wrong answers

Option A is wrong because Data Loss Prevention (DLP) policies control data movement between connectors and prevent data exfiltration, but they do not encrypt data at rest or provide access auditing. Option C is wrong because Power Apps business rules enforce business logic and validation on forms, not encryption or auditing. Option D is wrong because Microsoft Entra ID Conditional Access policies control authentication and access based on conditions like location or device compliance, but they do not encrypt data at rest or audit data access within Dataverse.

Full explanation →
305
MCQmedium

A company has a Power Automate flow that posts a message to Microsoft Teams when a new lead is created in Dynamics 365. The flow uses the 'Post a message' action. Some users report they do not receive the message in Teams. What should the administrator check first?

A.Verify that the 'Post a message' action is correctly configured.
B.Review the Teams connector connection status and permissions.
C.Confirm the flow is triggered by new lead creation.
D.Check the Teams notification settings for each user.
AnswerB

Connection issues cause silent failures.

Why this answer

Option D is correct because the Teams connector requires proper authentication; if the connection is broken or permissions are insufficient, messages fail. Option A is wrong because the flow triggers on creation. Option B is wrong because notifications are per action.

Option C is wrong because the flow uses a specific connection, not user settings.

Full explanation →
306
MCQeasy

A manager needs to quickly analyze sales data from multiple sources and share interactive dashboards with the team. Which Power Platform tool should they use?

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

Power BI enables data integration, analysis, and interactive dashboard sharing.

Why this answer

Power BI is the correct tool because it is designed specifically for data analytics and visualization. It can connect to multiple data sources, transform and model the data, and create interactive dashboards that can be shared securely with team members via the Power BI service. This directly meets the manager's need to analyze sales data from multiple sources and share interactive dashboards.

Exam trap

The trap here is that candidates may confuse Power BI's dashboard and visualization capabilities with Power Apps' UI-building features, or assume Power Automate can handle data analysis because it can process data in flows, but neither tool provides the interactive, shareable analytics dashboards that Power BI offers.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for creating automated processes between apps and services, not for analyzing data or building interactive dashboards. Option B is wrong because Power Apps is a low-code application development platform for building custom business apps, not for data analysis or dashboard creation. Option C is wrong because Power Virtual Agents is a tool for creating conversational AI chatbots, not for analyzing data or sharing dashboards.

Full explanation →
307
Matchingmedium

Match each AI Builder model type to its use case.

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

Concepts
Matches

Extract text from forms

Identify objects in images

Categorize text into predefined classes

Extract specific data from text

Classify text into categories

Why these pairings

AI Builder provides prebuilt AI models.

Full explanation →
308
MCQmedium

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

A.The user profile in Microsoft Entra ID does not have a manager assigned.
B.The SharePoint list column for manager is missing.
C.The flow trigger is set to 'When a new item is created' but the item already exists.
D.The SharePoint list does not have the correct permissions.
AnswerA

The Get Manager action requires a manager attribute in the directory.

Why this answer

Option B is correct because the Get Manager connector requires the Azure AD (now Microsoft Entra ID) organization profile to be populated with manager information. Option A is wrong because SharePoint permissions do not affect the manager lookup. Option C is wrong because the flow is not triggered by a new item but by an approval action.

Option D is wrong because the flow fails on the manager lookup, not on the SharePoint update.

Full explanation →
309
Multi-Selecthard

Which THREE features are available in Power Platform managed environments? (Select 3)

Select 3 answers
A.Data loss prevention (DLP) policies
B.Weekly analytics digests
C.Solution checker integration
D.Sharing limits for canvas apps
E.Data policies enforcement
AnswersB, C, D

Managed environments provide weekly email digests with analytics.

Why this answer

Option A is correct because managed environments support weekly analytics digests. Option B is correct because solution checker integration is a feature. Option D is correct because sharing limits for canvas apps can be configured.

Option C is wrong because data policies are part of standard environment management. Option E is wrong because data loss prevention is a separate feature, not exclusive to managed environments.

Full explanation →
310
Multi-Selectmedium

Which TWO are valid ways to share a canvas app with other users in your organization?

Select 2 answers
A.Publish the app to a SharePoint list
B.Share directly from the Power Apps maker portal
C.Embed the app in Microsoft Teams
D.Provide a direct link to the .msapp file
E.Send the app file as an email attachment
AnswersB, C

You can share by entering user emails or security groups in the portal.

Why this answer

Correct: B and D. Sharing via the Power Apps portal (B) is the standard method. Embedding in Microsoft Teams (D) is also a valid sharing option.

A is wrong because sharing via email attachment is not supported. C is wrong because sharing via a direct link to the app's source file is not the intended method. E is wrong because sharing via a SharePoint list is not how apps are shared.

Full explanation →
311
MCQeasy

A company wants to automate the process of moving files from a local network drive to SharePoint Online. Which Power Automate feature should they use?

A.On-premises data gateway with cloud flow
B.Cloud flow with SharePoint connector
C.UI flow
D.Business process flow
AnswerA

Gateway enables secure on-premises access.

Why this answer

Option C is correct because the on-premises data gateway enables connectivity to on-premises data sources. Option A is wrong because cloud flows run in the cloud. Option B is wrong because business process flows are for guided processes.

Option D is wrong because UI flows are for robotic process automation, not file transfer.

Full explanation →
312
Multi-Selectmedium

Which TWO Power Apps features allow sharing apps with users who have a Power Apps per app plan?

Select 2 answers
A.Adding users as co-owners of the app
B.Sharing the app with a security group
C.Assigning per app plan licenses to users
D.Granting Dataverse access to users
E.Sharing the app with everyone in the organization
AnswersB, C

Security groups can be assigned per app plan licenses.

Why this answer

Option A is correct because per app plan users need a license. Option B is correct because sharing the app with a security group allows assignment of licenses. Option C is wrong because sharing with the entire organization is not recommended and may require other licenses.

Option D is wrong because individual user sharing requires per user plan. Option E is wrong because Dataverse access does not provide per app licensing.

Full explanation →
313
MCQhard

A Power Pages site uses Azure AD B2C for authentication. The marketing team wants to collect user consent for email communications during registration. Where should they add the consent checkbox?

A.In a content snippet for the registration page
B.In the Site Settings under 'Authentication'
C.In the Power Pages sign-in page template
D.In the Azure AD B2C user flow for sign-up
AnswerD

Azure AD B2C user flows allow adding custom attributes and UI elements.

Why this answer

Option C is correct because customizing the Azure AD B2C user flow allows adding attributes and UI elements like checkboxes during sign-up. Option A is wrong because the Power Pages default sign-in page is limited. Option B is wrong because Site Settings do not include user interface customization.

Option D is wrong because content snippets are for text, not form fields.

Full explanation →
314
MCQeasy

A marketing team wants to share a Power BI dashboard with external stakeholders who do not have Power BI licenses. Which sharing method should the team use?

A.Share the dashboard from the Power BI service
B.Add the stakeholders to a Power BI workspace with viewer role
C.Use Publish to web (embed code) to create a public link
D.Export the report to PDF and email it
AnswerC

Allows anyone to view the report without a license.

Why this answer

Option C is correct because 'Publish to web' generates an embed code that creates a publicly accessible link to the Power BI dashboard, which can be viewed by anyone without requiring a Power BI license or authentication. This is the only method listed that allows external stakeholders without licenses to access the dashboard directly in a browser.

Exam trap

The trap here is that candidates often confuse 'sharing from the service' or 'workspace access' as viable for external users without licenses, but Power BI requires licenses for those methods, whereas 'Publish to web' is the only option that completely removes the license requirement.

How to eliminate wrong answers

Option A is wrong because sharing a dashboard from the Power BI service requires each recipient to have a Power BI Pro or Premium Per User license to view the shared content. Option B is wrong because adding stakeholders to a Power BI workspace with the viewer role still requires each user to have a Power BI Pro license (or the workspace must be backed by Premium capacity, but even then, free users need to be in the same tenant and have a free license). Option D is wrong because exporting to PDF creates a static snapshot that loses all interactivity, live data refresh, and drill-down capabilities, which defeats the purpose of sharing a live dashboard.

Full explanation →
315
MCQhard

A company has a Power Platform environment that is running low on storage. The administrator needs to free up storage without deleting important data. What should they do first?

A.Disable auditing for all environments
B.Review storage analytics in the Power Platform admin center to identify large entities
C.Delete all audit logs
D.Purchase additional storage capacity
AnswerB

Storage analytics help pinpoint where storage is used, enabling targeted cleanup.

Why this answer

Option B is correct because the first step in freeing up storage without deleting important data is to identify which entities consume the most space. The Power Platform admin center provides storage analytics that break down storage usage by entity, allowing administrators to make informed decisions about data cleanup or archiving. This approach ensures that only non-essential data is targeted, preserving critical business data.

Exam trap

The trap here is that candidates often jump to disabling auditing or deleting logs as a quick fix, not realizing that storage analytics must be reviewed first to avoid accidentally removing critical data.

How to eliminate wrong answers

Option A is wrong because disabling auditing stops the creation of new audit logs but does not reclaim existing storage; audit logs must be explicitly deleted to free space. Option C is wrong because deleting all audit logs indiscriminately removes potentially important compliance and security records, which violates the requirement to not delete important data. Option D is wrong because purchasing additional storage does not free up existing storage; it only increases capacity, which may not address the root cause of storage inefficiency.

Full explanation →
316
Multi-Selectmedium

Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)

Select 2 answers
A.Use parallel branches for independent actions.
B.Set all actions to run sequentially to avoid conflicts.
C.Use 'Apply to each' loops for all list operations.
D.Use 'Configure Run After' to handle failures and retries.
E.Add approval steps to all flows for accountability.
AnswersA, D

Improves performance.

Why this answer

Options A and B are correct. Using 'Configure Run After' ensures proper error handling, and using parallel branches reduces latency for independent actions. Option C is wrong because actions run sequentially by default.

Option D is wrong because using loops increases complexity and run time. Option E is wrong because approvals add overhead.

Full explanation →
317
MCQmedium

A company uses Microsoft Power Platform to manage customer support tickets. The support team wants to automatically categorize incoming emails as 'Complaint', 'Request', or 'Other' before creating a ticket. Which component should be used?

A.Power Automate with a trigger
B.Power Apps with a dropdown
C.Power BI with a report
D.AI Builder
AnswerD

Provides prebuilt or custom AI models for classification.

Why this answer

AI Builder provides prebuilt models for text classification, enabling automatic categorization of incoming emails into categories like 'Complaint', 'Request', or 'Other' without manual coding. This component integrates directly with Power Automate to process emails and create tickets based on the classification result.

Exam trap

The trap here is that candidates often assume Power Automate alone can perform intelligent classification, but it requires AI Builder for AI-based text analysis, as Power Automate is a workflow automation tool without built-in NLP capabilities.

How to eliminate wrong answers

Option A is wrong because Power Automate with a trigger can initiate a flow when an email arrives, but it cannot perform text classification on its own; it requires AI Builder or a custom model to categorize the content. Option B is wrong because Power Apps with a dropdown is a user interface control for manual selection, not an automated classification solution. Option C is wrong because Power BI with a report is used for data visualization and analytics, not for real-time email categorization or ticket creation.

Full explanation →
318
Multi-Selecthard

Which THREE components are required to create a Power BI dashboard?

Select 3 answers
A.An on-premises data gateway
B.A dataset
C.A report
D.A dataflow
E.A dashboard canvas
AnswersB, C, E

A dataset is the source of data for the dashboard.

Why this answer

A dataset is required because it provides the data model and source that powers the visualizations in a Power BI dashboard. Without a dataset, there is no underlying data to display, making it a fundamental component for any dashboard.

Exam trap

Microsoft often tests the misconception that a data gateway or dataflow is a prerequisite for dashboard creation, when in fact they are optional components for specific connectivity or data preparation scenarios.

Full explanation →
319
MCQhard

A company has a Power Automate flow that processes incoming emails and creates tasks in Microsoft Planner. The flow includes a 'Parse JSON' action to extract information from the email body. The flow has been working correctly, but after a recent update to the email template, the flow fails with a 'BadRequest' error at the 'Parse JSON' action. What is the most likely cause?

A.The email connection credentials have expired
B.The email body structure changed and no longer matches the JSON schema
C.The flow does not have permission to read emails
D.The Microsoft Planner API is unavailable
AnswerB

'Parse JSON' expects specific structure; changes cause 'BadRequest'.

Why this answer

Option C is correct because the 'Parse JSON' action requires the input to match the schema; if the email body format changed, parsing will fail. Option A is incorrect because the error is 'BadRequest', not authentication. Option B is incorrect because permission errors would be 'Forbidden' or 'Unauthorized'.

Option D is incorrect because Planner creation errors would occur later.

Full explanation →
320
MCQeasy

A user needs to create an app that shows data from a SQL Server database and allows users to edit records. The user has no coding experience. Which Power Apps approach should they use?

A.Create a model-driven app
B.Use the Power Apps template for SQL Server
C.Start from blank canvas and use SQL Server connector
D.Use Power Automate to create a user interface
AnswerB

Provides a pre-built app for SQL Server data.

Why this answer

Option B is correct because the Power Apps template for SQL Server provides a ready-made app that can be connected to a database. Option A is wrong because model-driven apps require Dataverse. Option C is wrong because starting from blank is more complex.

Option D is wrong because Power Automate is for automation.

Full explanation →
321
Multi-Selecteasy

Which TWO are valid methods to create a new Power Platform environment?

Select 2 answers
A.Using the Power Platform admin center web interface.
B.Using the Power Platform API.
C.Using the Microsoft Teams admin center.
D.Using the Power Apps mobile app.
E.Using the SharePoint admin center.
AnswersA, B

This is the primary administrative interface.

Why this answer

Environments can be created through the Power Platform admin center and via the Power Platform API. Option B is incorrect because SharePoint is not used. Option C is incorrect because the Teams admin center does not create environments.

Option E is incorrect because the Power Apps mobile app does not create environments.

Full explanation →
322
MCQmedium

A business wants to create a chatbot that answers common IT support questions and can escalate to a human agent if needed. Which Power Platform component should be used?

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

Power Virtual Agents is the chatbot builder.

Why this answer

Power Virtual Agents (D) is the correct choice because it is a Power Platform component specifically designed to create conversational AI chatbots with minimal code. It allows you to build a bot that answers common IT support questions using prebuilt topics and can seamlessly escalate to a human agent via a handoff to a live chat system or Dynamics 365 Customer Service.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger flows from a chatbot with the chatbot itself, but Power Automate is only an integration tool, not the chatbot platform.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating chatbots. Option B is wrong because Power BI is a data visualization and business analytics tool, not a chatbot builder. Option C is wrong because Power Automate is a workflow automation service that orchestrates repetitive tasks and processes, but it does not natively provide conversational AI capabilities or a chatbot interface.

Full explanation →
323
MCQmedium

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

A.Adjust the GPS control to use high accuracy mode.
B.Add a Power Automate flow to sync data periodically.
C.Enable offline use and configure the app to cache data locally.
D.Convert the canvas app to a model-driven app.
AnswerC

Offline capability allows cached data access without internet.

Why this answer

Option D is correct because enabling offline use in canvas apps allows users to load data while connected and work with cached data when disconnected. Option A is wrong because adjusting GPS settings does not affect offline data availability. Option B is wrong because using a model-driven app does not inherently solve offline requirements unless specifically configured.

Option C is wrong because Power Automate flows require connectivity and do not enable offline data storage.

Full explanation →
324
MCQeasy

A user reports they cannot create a new Power Apps app in the default environment. They have a Power Apps license. What is the most likely cause?

A.A data loss prevention (DLP) policy is blocking app creation.
B.The user has not been assigned the Environment Maker security role for the default environment.
C.The environment has reached its maximum number of apps.
D.The user does not have a Power Apps license.
AnswerB

The Environment Maker role is required to create apps in an environment.

Why this answer

The most likely cause is that the user has not been assigned the Environment Maker security role for the default environment. Even with a Power Apps license, a user must be explicitly granted the Environment Maker role in a specific environment (including the default environment) to create apps. Without this role, the user can only run apps, not create or edit them.

Exam trap

The trap here is that candidates often assume having a Power Apps license alone is sufficient to create apps, but the PL-900 exam tests the understanding that environment-level security roles (specifically Environment Maker) are required for app creation, even in the default environment.

How to eliminate wrong answers

Option A is wrong because a data loss prevention (DLP) policy controls which connectors can be used in apps and flows, but it does not block the creation of a new app itself. Option C is wrong because Power Apps environments do not have a hard maximum limit on the number of apps; the limit is on storage and API calls, not app count. Option D is wrong because the question explicitly states the user has a Power Apps license, so lack of license is not the issue.

Full explanation →
325
Multi-Selecteasy

Which TWO data sources can be used with a canvas app? (Choose two.)

Select 2 answers
A.Microsoft Power Platform
B.Microsoft Teams
C.SharePoint list
D.Power Automate
E.Microsoft Dataverse
AnswersC, E

Canvas apps can connect to SharePoint lists.

Why this answer

Options A and C are correct. SharePoint lists and Microsoft Dataverse are common data sources. Option B is a service, not a data source.

Option D is a product family. Option E is a chat platform.

Full explanation →
326
MCQmedium

You need to create a flow that automates the onboarding process for new employees. When a new employee record is added to a Human Resources (HR) system in Dataverse, the flow should: (1) send a welcome email, (2) create user accounts in Microsoft Entra ID, and (3) assign licenses. The flow must run with high reliability and should not fail if one of the actions fails. Which flow design pattern should you use?

A.Use a single branch with sequential actions and configure retry policy
B.Use a scope to group actions and configure scope timeout
C.Use a condition to check success before proceeding
D.Use parallel branches for each independent action
AnswerD

Parallel branches allow actions to run independently; one failure does not stop others.

Why this answer

Option A is correct because parallel branches allow independent execution so that failure in one branch does not affect others. Option B is incorrect because a single branch with sequential actions will stop the entire flow if any action fails. Option C is incorrect because a condition is for decision making, not for parallel execution.

Option D is incorrect because a scope groups actions but does not provide isolation from failures.

Full explanation →
327
MCQhard

Refer to the exhibit. You are reviewing a Power Apps app definition. Based on the exhibit, which connector does the app use?

A.Microsoft Dataverse
B.Office 365 Users
C.SQL Server
D.SharePoint
AnswerA

The connection ID 'shared_commondataservice' corresponds to Dataverse.

Why this answer

The exhibit shows a Power Apps app definition that includes a reference to a Microsoft Dataverse table (e.g., 'Accounts' or 'Contacts') as the data source. Dataverse is the native data platform for Power Apps, providing relational tables, business logic, and security directly within the Power Platform. The connector used is Microsoft Dataverse, which is the default connector when building canvas or model-driven apps with Dataverse tables.

Exam trap

The trap here is that candidates often confuse the Dataverse connector with SharePoint or SQL Server because they see a table-like structure, but Dataverse is a distinct platform service with its own connector, not a SharePoint list or SQL database.

How to eliminate wrong answers

Option B is wrong because Office 365 Users connector is used to retrieve user profile data from Microsoft Entra ID, not to connect to a Dataverse table as shown in the exhibit. Option C is wrong because SQL Server connector requires a specific SQL Server instance and connection string, which is not indicated in the app definition; Dataverse is not SQL Server. Option D is wrong because SharePoint connector is used for SharePoint lists or document libraries, not for Dataverse tables; the exhibit clearly shows a Dataverse table reference.

Full explanation →
328
Multi-Selecthard

Which THREE are features of model-driven apps compared to canvas apps?

Select 3 answers
A.Automatic form generation from Dataverse tables
B.Responsive design that adapts to different screen sizes
C.Drag-and-drop layout customization
D.Built-in business process flows
E.Full control over pixel-perfect design
AnswersA, B, D

Forms are generated based on the table definition.

Why this answer

Correct: A, B, and C. Model-driven apps are responsive (A), have built-in business process flows (B), and automatically generate forms from Dataverse (C). D is wrong because drag-and-drop layout is a canvas app feature.

E is wrong because model-driven apps are not customizable in the same way as canvas apps.

Full explanation →
329
Multi-Selecthard

Which TWO methods can be used to customize the appearance of a Power Pages site?

Select 2 answers
A.Add custom HTML to pages in the studio
B.Add custom CSS through the Portal Management app
C.Edit the Liquid templates directly
D.Create a Power Automate flow to update styles
E.Use Power Pages Studio to modify the theme
AnswersB, E

Custom CSS can be injected via site settings.

Why this answer

Power Pages Studio allows theme and layout changes, and custom CSS can be added via the Portal Management app. Editing Liquid templates is for advanced customization, but adding custom HTML directly is not standard. Power Automate does not affect appearance.

Full explanation →
330
MCQmedium

Refer to the exhibit. An admin runs the PowerShell command and gets the output shown. How many environments are in the tenant?

A.1
B.3
C.4
D.6
AnswerB

The output shows three environments.

Why this answer

Option B is correct because the output lists three environments: Contoso Sales, Contoso Dev, Contoso Test. Option A is wrong because there are three, not one. Option C is wrong because there are not four.

Option D is wrong because there are not six.

Full explanation →
331
MCQhard

You have a Power Automate flow that uses a Dataverse connector to update a record when an approval is completed. The flow previously worked but now fails with an error 'Connection not found'. You verify that the connection to Dataverse still exists and the user has appropriate permissions. What is the most likely cause?

A.The Dataverse environment was deleted or renamed
B.The Microsoft 365 tenant has a service outage
C.The flow owner's Power Automate license expired
D.The approval action is not configured correctly
AnswerA

If the environment no longer exists, the connection references an invalid environment.

Why this answer

If the connection exists and permissions are fine, the trigger or action might be using a deleted or renamed environment. The Dataverse environment might have been recently changed or deleted. Other options like license expiry or service outage would show different errors.

Full explanation →
332
Multi-Selecteasy

Which THREE components are required to build a model-driven app in Power Apps? (Choose three.)

Select 3 answers
A.View
B.Table (entity)
C.Microsoft Dataverse database
D.Canvas app component
E.Power Automate flow
AnswersA, B, C

Views define how data is displayed.

Why this answer

Options A, C, and D are correct because a model-driven app requires a Dataverse database, tables, and views. Option B is wrong because flows are optional. Option E is wrong because canvas apps are a different type.

Full explanation →
333
Multi-Selectmedium

Which TWO actions can be performed using Power Apps? (Choose two.)

Select 2 answers
A.Create a custom mobile app that connects to SharePoint
B.Create a dashboard with visualizations from multiple data sources
C.Build a chatbot to answer customer questions
D.Automate a workflow when a new email arrives
E.Embed a canvas app into Microsoft Teams
AnswersA, E

Power Apps can create canvas apps connecting to SharePoint.

Why this answer

Options A and C are correct. Power Apps can create custom apps and integrate with Microsoft 365. Option B is for Power Automate, D is for Power BI, E is for Power Virtual Agents.

Full explanation →
334
MCQhard

A canvas app uses a Patch function to update a SharePoint list item. The update fails silently without error. What is the most likely cause?

A.The user does not have permission to the SharePoint list.
B.The column name or data type in the Patch function does not match the SharePoint list.
C.The Patch function is being called with incorrect arguments.
D.The app is not using delegation.
AnswerB

Mismatched column names or types cause the update to fail without error in some cases.

Why this answer

When a Patch function fails silently, the most common cause is a mismatch between the column name or data type in the function and the actual SharePoint list schema. Power Apps does not throw an error for such mismatches; it simply does not apply the update. This is because the Patch function validates the data against the list's column definitions at runtime, and if the names or types don't align, the operation is ignored without raising an exception.

Exam trap

The trap here is that candidates often assume a silent failure must be a permission or delegation issue, but the PL-900 exam specifically tests the nuance that column name/type mismatches in Patch cause silent failures, not errors.

How to eliminate wrong answers

Option A is wrong because a permission issue would typically result in a clear error message (e.g., 'Access denied') when the app tries to write to the SharePoint list, not a silent failure. Option C is wrong because incorrect arguments (e.g., wrong number of parameters or invalid record structure) would cause a compilation error or a runtime error with a descriptive message, not a silent failure. Option D is wrong because delegation is a concept for data source filtering and retrieval in galleries or data tables, not for the Patch function, which operates on individual records and does not rely on delegation.

Full explanation →
335
Multi-Selecthard

Which TWO are best practices for designing Power Automate flows in a production environment? (Select TWO.)

Select 2 answers
A.Disable flow logging to improve performance.
B.Use 'Configure Run After' to implement error handling.
C.Nest Apply to each actions to handle large datasets.
D.Hardcode connection references for simplicity.
E.Use secure inputs and outputs for actions handling sensitive data.
AnswersB, E

This handles failures gracefully.

Why this answer

Options A and C are correct. Using 'Configure Run After' for error handling ensures robust flows. Storing credentials in Azure Key Vault and referencing them securely improves security.

Option B is wrong because hardcoding values reduces maintainability. Option D is wrong because using Apply to each inside a loop can cause performance issues; better to use parallel branches. Option E is wrong because disabling logging hinders troubleshooting.

Full explanation →
336
Multi-Selecthard

Which THREE are capabilities of model-driven apps?

Select 3 answers
A.Business process flows to guide users through steps
B.Custom CSS to style the app
C.Pixel-perfect layout design using drag and drop
D.Server-side logic using classic workflows or Power Automate
E.Business rules to enforce field requirements and visibility
AnswersA, D, E

Business process flows provide a step-by-step data entry experience.

Why this answer

Options A, C, and D are correct. Model-driven apps have business process flows, business rules, and server-side logic like workflows. Option B is wrong because pixel-perfect layout is a feature of canvas apps.

Option E is wrong because model-driven apps do not support custom CSS; they have a responsive design.

Full explanation →
337
MCQhard

Refer to the exhibit. A Power Platform administrator runs a PowerShell command to check the status of an environment. What does the output indicate?

A.The environment is a sandbox
B.The environment has been deleted
C.The environment is disabled
D.The environment is active and usable
AnswerD

State Enabled indicates the environment is active.

Why this answer

The PowerShell command output shows the environment's state as 'Ready' and its provisioning status as 'Succeeded', which together indicate the environment is fully provisioned and operational. In Power Platform, a 'Ready' state means the environment is active and available for use, confirming option D is correct.

Exam trap

The trap here is that candidates may confuse the 'State' field with environment type (sandbox vs. production) or assume any non-error output implies deletion, but the 'Ready' and 'Succeeded' values specifically indicate an active, usable environment.

How to eliminate wrong answers

Option A is wrong because a sandbox environment would be indicated by the 'EnvironmentType' property (e.g., 'Sandbox'), not by the 'State' or 'ProvisioningState' fields shown in the output. Option B is wrong because a deleted environment would not return any output or would show an error; the presence of a 'State' of 'Ready' confirms the environment exists. Option C is wrong because a disabled environment would have a 'State' of 'Disabled' or 'Suspended', not 'Ready'.

Full explanation →
338
Multi-Selecteasy

Which TWO statements accurately describe the business value of Microsoft Power Platform?

Select 2 answers
A.It can only be used with Microsoft 365 data.
B.It requires professional developers to write all code.
C.It provides integration with Microsoft 365 and Azure services.
D.It is primarily a data analytics tool.
E.It enables citizen developers to create apps and automate workflows without extensive coding.
AnswersC, E

Power Platform integrates deeply with Microsoft ecosystem.

Why this answer

Option C is correct because Microsoft Power Platform is designed to seamlessly integrate with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL Database), enabling organizations to extend their existing investments and build end-to-end solutions. This integration is a core business value, as it allows data and processes to flow across the Microsoft ecosystem without custom middleware.

Exam trap

The trap here is that candidates may mistakenly think Power Platform is only for analytics (Option D) because of Power BI's prominence, or assume it requires professional developers (Option B) due to its integration with Azure, when in fact its core value is enabling citizen developers with low-code tools.

Full explanation →
339
MCQeasy

A business analyst wants to create a simple app to track employee vacation requests without writing code. Which type of Power App should they use?

A.Power Pages site
B.Model-driven app
C.Canvas app from a template
D.Power Automate flow
AnswerC

Canvas apps provide a low-code drag-and-drop interface and can start from templates.

Why this answer

Option A is correct because canvas apps allow building from a blank canvas or template with a drag-and-drop interface, requiring minimal code. Option B is wrong because model-driven apps are more structured and require Dataverse. Option C is wrong because Power Automate is for workflows.

Option D is wrong because Power Pages is for external websites.

Full explanation →
340
MCQeasy

A canvas app displays a label with the formula shown. Users report that the label shows 'Welcome, !' without a name. What is the most likely cause?

A.The FullName property is spelled incorrectly
B.The user is not authenticated with Power Apps
C.The ampersand (&) operator is incorrect
D.The User() function is not available in canvas apps
AnswerB

Correct: User() returns blank if not authenticated.

Why this answer

The User() function returns the current user's details. If the user is not signed in or the app doesn't have permission, FullName may be blank. The formula syntax is correct, and concatenation works.

Full explanation →
341
Matchingmedium

Match each Power Apps license type to its description.

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

Concepts
Matches

License for one app per user

License for unlimited apps per user

License for one flow (legacy)

Includes Power Apps rights

Access to run apps without additional cost

Why these pairings

Licensing determines how users can access Power Apps.

Full explanation →
342
MCQmedium

A Power Pages site uses Entity Lists to display data from a Dataverse table. The requirement is that users should be able to click a row and navigate to a detail page for that record. What must be configured to enable this navigation?

A.Page permissions
B.List forms
C.Details page setting in the Entity List
D.Web roles
AnswerC

The Entity List configuration includes a 'Details page' field that sets the target page for record navigation.

Why this answer

Entity Lists have a 'Details page' setting where you can specify which page to navigate to when a user clicks a row. The detail page typically contains a basic form to display the record. Option A is incorrect because web roles are for access control, not navigation.

Option B is incorrect because page permissions control access, not navigation. Option C is incorrect because list forms are for inline editing, not for linking to a detail page.

Full explanation →
343
MCQhard

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

A.Reduce the number of columns in the SharePoint list
B.Increase the data row limit for non-delegable queries to 2000
C.Move the data to a SQL database and connect via Power Automate
D.Use delegable filters like Filter() with indexed columns to limit data retrieved
AnswerD

Correct: Delegable queries process on the server, reducing data transferred.

Why this answer

Option C is correct because delegable queries reduce the data retrieved from SharePoint, improving performance. Option A is wrong because increasing the limit doesn't help if the query is non-delegable. Option B is wrong because more columns increase data volume.

Option D is wrong because Power Automate can be used but adds latency.

Full explanation →
344
MCQhard

You need to create a Power Pages site that displays real-time data from an external API. The solution must minimize latency and avoid exposing API keys on the client side. Which approach should you use?

A.Use a Liquid template to fetch data server-side
B.Use JavaScript in a web template to call the API directly
C.Call a Power Automate flow from the page
D.Use a Power Apps custom connector
AnswerA

Liquid runs server-side, hiding keys and reducing client-side load.

Why this answer

Option A is correct because Power Pages Liquid templates can call external APIs server-side, hiding API keys. Option B is wrong because JavaScript exposes keys. Option C is wrong because Power Automate adds latency.

Option D is wrong because custom connectors are for Power Apps, not Power Pages.

Full explanation →
345
MCQmedium

A company has a Power Platform environment used for development. The development team needs to deploy a solution to a test environment. What is the recommended approach?

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

Managed solutions are the standard for deploying between environments.

Why this answer

Option D is correct because managed solutions are the recommended approach for deploying to non-development environments (e.g., test, UAT, production). A managed solution locks components to prevent direct editing in the target environment, supports lifecycle management (upgrades, patches, and removal), and ensures that only the intended customizations are deployed. Exporting an unmanaged solution (Option A) would leave components editable in the test environment, breaking the managed lifecycle pattern.

Exam trap

The trap here is that candidates often confuse unmanaged and managed solutions, thinking that exporting an unmanaged solution (Option A) is sufficient for deployment, when in fact managed solutions are required for proper lifecycle management and to prevent accidental edits in test/production environments.

How to eliminate wrong answers

Option A is wrong because exporting an unmanaged solution from development and importing it into test would create editable components in the test environment, which violates the recommended managed-solution deployment pattern and can lead to configuration drift. Option B is wrong because manually recreating all components is error-prone, time-consuming, and not a scalable or repeatable approach for environment promotion. Option C is wrong because copying the entire development environment would duplicate all data, settings, and unmanaged customizations, which is not a clean or controlled way to promote a specific solution and can introduce unwanted artifacts.

Full explanation →
346
MCQeasy

A sales team wants to track their deals in a shared workspace without using Excel. They need a solution that can be customized quickly and accessed from mobile devices. Which Power Platform component should you recommend?

A.Microsoft Lists
B.Power Automate
C.Power BI
D.Power Virtual Agents
AnswerA

Microsoft Lists provides a simple, customizable list app that works on mobile.

Why this answer

Microsoft Lists is the correct recommendation because it provides a customizable, mobile-accessible shared workspace for tracking deals without requiring Excel. Lists allows users to create, share, and update structured data (e.g., deal stages, amounts, owners) with built-in templates and conditional formatting, all accessible via the Microsoft Lists mobile app or SharePoint. This meets the team's need for quick customization and mobile access without the complexity of automation or analytics tools.

Exam trap

The trap here is that candidates may confuse Microsoft Lists with Excel or assume Power Automate is needed for tracking, but the question specifically asks for a shared workspace that can be customized quickly and accessed from mobile devices, which Lists provides natively without additional tools.

How to eliminate wrong answers

Option B (Power Automate) is wrong because it is a workflow automation tool for creating flows between apps and services, not a shared workspace for tracking deals; it lacks native data storage and a user-friendly list interface. Option C (Power BI) is wrong because it is a business analytics and visualization tool for creating reports and dashboards, not a collaborative data entry or tracking workspace; it requires data from another source to populate. Option D (Power Virtual Agents) is wrong because it is a chatbot creation tool for building conversational AI, not a shared list or workspace for tracking deals; it cannot store or manage deal data directly.

Full explanation →
347
MCQeasy

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

A.Publish the report from Power BI Desktop and schedule a daily data refresh in Power BI service
B.Use Power BI Desktop to connect to the Excel file and publish a new report weekly
C.Use Power Query to merge data from the Excel file and create a composite model
D.Upload the Excel file to the Power BI service each week
AnswerA

Scheduled refresh automates data updates without manual intervention.

Why this answer

Option A is correct because it separates the report creation (in Power BI Desktop) from the data refresh schedule (in the Power BI service). By publishing the report once and configuring a daily scheduled refresh, the dashboard automatically reflects the latest data from the Excel file without manual intervention, which is the most efficient approach for weekly updates.

Exam trap

The trap here is that candidates may confuse manual re-publishing (Option B) or manual upload (Option D) with the automated refresh capability, overlooking that Power BI service can schedule data refreshes from a published report without needing to re-publish the .pbix file.

How to eliminate wrong answers

Option B is wrong because it requires manually re-publishing the report each week, which is inefficient and error-prone compared to automating the refresh. Option C is wrong because using Power Query to merge data and create a composite model is a data transformation technique, not a method for ensuring the dashboard reflects updated data from a changing Excel file. Option D is wrong because manually uploading the Excel file each week is labor-intensive and does not leverage Power BI's automated refresh capabilities.

Full explanation →
348
MCQhard

A canvas app displays incorrect data because the source SharePoint list has a lookup column to another list. The app maker used 'Choices' function to populate a dropdown, but the dropdown shows IDs instead of display names. What is the cause?

A.The Choices function was used on a lookup column, which returns a table of IDs; use Choices( [List].[Column].DisplayName ) instead.
B.The Choices function was used correctly but the dropdown's DisplayFields property is not set to the display name column.
C.The lookup column is a number type, not text, so it cannot show names.
D.The formula is not delegable, causing only partial data.
AnswerA

For lookup columns, Choices returns the ID table; use the DisplayName property to get display names.

Why this answer

The Choices function returns a table with IDs by default when used with a lookup column; to get display names, the maker should use the 'DisplayName' property. Option A is wrong because delegation is not the issue. Option B is wrong because the formula is correct for single-choice columns.

Option D is wrong because the data type is not number.

Full explanation →
349
Multi-Selecteasy

A company wants to use Microsoft Copilot Studio to build a chatbot that helps employees reset their passwords. Which TWO components are required? (Choose two.)

Select 2 answers
A.Power Automate to connect to the password reset system
B.Power Virtual Agents (classic)
C.Microsoft Copilot Studio to build and deploy the chatbot
D.Power Apps to create the user interface
E.AI Builder to process natural language
AnswersA, C

Automation is needed to perform the reset.

Why this answer

Option A is correct because Power Automate is required to create a flow that connects the chatbot to the password reset system, enabling automated execution of the reset process. Without this integration, the chatbot cannot perform the backend action of resetting the password.

Exam trap

The trap here is that candidates may think AI Builder is required for natural language processing, but Copilot Studio has built-in NLU, making AI Builder unnecessary for this scenario.

Full explanation →
350
MCQhard

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

A.Increase the data row limit for each data source
B.Use delegable queries to filter data at the source
C.Disable the formula-level error checking
D.Remove unused data sources from the app
AnswerB

Delegation pushes filtering to the data source, reducing data transfer.

Why this answer

Option C is correct because delegable queries reduce the amount of data transferred by processing on the server side. Option A is wrong because removing data sources might break functionality. Option B is wrong because increasing the data row limit can worsen performance.

Option D is wrong because disabling error checking does not affect performance.

Full explanation →
351
MCQhard

A developer builds a canvas app that uses a custom connector to call an external API. The API requires an OAuth 2.0 client credentials flow. Which authentication type should the developer configure in the custom connector?

A.OAuth 2.0
B.Windows Authentication
C.API Key
D.Basic Authentication
AnswerA

Supports client credentials grant type.

Why this answer

Option D is correct because OAuth 2.0 client credentials is a standard OAuth flow. Option A is wrong because API Key is a different mechanism. Option B is wrong because Basic authentication is not OAuth.

Option C is wrong because Windows Authentication is not OAuth.

Full explanation →
352
MCQmedium

A company uses Power Automate to monitor a SharePoint document library for new files and then copy them to an Azure Blob Storage container. The flow runs successfully for PDF files but fails for large video files. What is the most likely cause?

A.The SharePoint connector cannot read video files.
B.The flow uses a 'Parallel branch' that cannot handle large files.
C.Power Automate has a file size limit that the video exceeds.
D.Azure Blob Storage does not support video file formats.
AnswerC

Default file size limit is 100 MB.

Why this answer

Option B is correct because Power Automate has a file size limit (default 100 MB) for actions like 'Get file content'. Video files often exceed this limit. Option A is wrong because video files are supported.

Option C is wrong because parallel branches would not affect file size. Option D is wrong because Azure Blob Storage supports large files.

Full explanation →
353
Matchingmedium

Match each Power Automate trigger type to its description.

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

Concepts
Matches

Starts based on an event (e.g., new email)

Starts manually by a user action

Starts at a specified time or interval

A type of scheduled trigger repeating regularly

Starts from a button in a Power App

Why these pairings

Triggers define how a flow starts.

Full explanation →
354
MCQhard

A Power Automate flow uses the 'Apply to each' control to process a list of items. The flow runs but only processes the first 10 items. What is the most likely reason?

A.The 'Apply to each' control only processes the first 10 items by default.
B.The flow has a 'Terminate' action after the 10th item.
C.The list contains exactly 10 items.
D.The 'Apply to each' has a concurrency setting limiting the number of items processed.
AnswerD

Concurrency settings can limit iteration.

Why this answer

Option A is correct because Power Automate has a default concurrency limit for 'Apply to each' that can restrict processing; also, pagination limits may apply. Option B is wrong because the control processes sequentially. Option C is wrong because the 'Apply to each' does not have a built-in 10-item limit; concurrency settings affect parallelism.

Option D is wrong because the flow may process all items if configured properly.

Full explanation →
355
MCQmedium

A retail company uses Power Platform for inventory and sales apps. They have multiple environments: Development, Test, and Production. The Development environment is running low on storage capacity due to many test records. The admin needs to free up storage without affecting the Test and Production environments. The admin also wants to maintain data integrity for ongoing development. What should the admin do?

A.Reset the Development environment using the Admin Center.
B.Delete the Development environment and create a new one.
C.Increase the storage capacity of the Development environment by purchasing add-ons.
D.Manually delete all test records from the Dataverse database.
AnswerA

Resetting clears all data and customizations, freeing storage, and allows a fresh start.

Why this answer

The Development environment can be reset (wiped clean) using the Power Platform Admin Center. This removes all data and customizations, freeing storage. The admin can then import the latest solution from source control to restore necessary apps and flows without test data.

Full explanation →
356
MCQeasy

A company wants to create a custom copilot that answers employee questions about IT policies. The copilot must use existing SharePoint documents as a knowledge source. Which feature of Microsoft Copilot Studio should the company use?

A.Generative AI feature
B.Power Automate cloud flow
C.Copilot for Microsoft 365
D.Add a knowledge source
AnswerD

Copilot Studio allows adding SharePoint as a knowledge source to ground responses.

Why this answer

Option D is correct because the 'Add a knowledge source' feature in Microsoft Copilot Studio allows you to connect a copilot to existing SharePoint document libraries, enabling it to retrieve and answer questions based on the content of those documents. This is the direct mechanism for grounding a custom copilot with enterprise content without requiring additional development.

Exam trap

The trap here is that candidates often confuse the 'Generative AI feature' (which enables AI responses) with the specific mechanism to provide source data, or they mistakenly think Copilot for Microsoft 365 is a feature within Copilot Studio for adding knowledge sources, when it is a separate product.

How to eliminate wrong answers

Option A is wrong because the 'Generative AI feature' is a general capability of Copilot Studio that enables natural language responses, but it does not by itself connect to SharePoint documents as a knowledge source; it requires a configured knowledge source to ground its answers. Option B is wrong because Power Automate cloud flows are used for automating workflows and processes, not for directly adding a knowledge source to a copilot; they can be triggered by a copilot but do not serve as a document-based knowledge repository. Option C is wrong because Copilot for Microsoft 365 is a separate product that provides AI assistance across Microsoft 365 apps and is not a feature within Copilot Studio for building custom copilots; it cannot be used to add SharePoint documents as a knowledge source to a custom copilot.

Full explanation →
357
MCQmedium

A company wants to extend their existing copilot built with Copilot Studio to trigger a workflow when an employee requests time off. The workflow must create a record in a Dataverse table and send an approval email. What should the copilot developer use?

A.Embed a Power Apps canvas app
B.Use AI Builder to create a model
C.Configure the Dataverse connector directly
D.Add a Power Automate flow as a plugin
AnswerD

Power Automate flows can be called from Copilot Studio to automate workflows.

Why this answer

Option D is correct because Copilot Studio allows extending a copilot's capabilities by adding a Power Automate flow as a plugin. This enables the copilot to trigger a workflow that creates a record in a Dataverse table and sends an approval email, directly fulfilling the requirement without needing to embed an app or use AI Builder.

Exam trap

The trap here is that candidates may confuse using a Dataverse connector directly (Option C) with the correct method of invoking it through a Power Automate flow plugin, as the connector alone cannot be triggered by a copilot topic without an intermediary flow.

How to eliminate wrong answers

Option A is wrong because embedding a Power Apps canvas app would provide a custom user interface but does not directly trigger a workflow to create a Dataverse record and send an approval email; it would require additional integration. Option B is wrong because AI Builder is used to create predictive models (e.g., form processing, object detection) and is not designed to orchestrate multi-step workflows like creating records and sending emails. Option C is wrong because configuring the Dataverse connector directly is not a standalone action within Copilot Studio; connectors are used within flows or apps, and the copilot itself cannot directly invoke a connector without a plugin or flow.

Full explanation →
358
MCQhard

You need to design a Power Automate flow that sends an approval request to a manager when an employee submits a leave request in SharePoint. The flow should check if the manager is on leave and, if so, escalate to the next-level manager. What is the best approach to implement this escalation logic?

A.Use a 'Condition' action to check if the manager is on leave, then if true, send the request to the next-level manager.
B.Use an 'Apply to each' action to iterate over an array of managers.
C.Use a 'Scope' action to group the escalation steps.
D.Use parallel branches to send the request to both the manager and next-level manager simultaneously.
AnswerA

Condition action provides branching logic.

Why this answer

Option A is correct because a 'Condition' action allows checking manager status and escalating. Option B is wrong because parallel branches do not handle sequential escalation. Option C is wrong because 'Apply to each' is for iterating over a list, not checking a single manager.

Option D is wrong because 'Scope' is for grouping actions, not conditional logic.

Full explanation →
359
MCQhard

Refer to the exhibit. You are deploying a Power Pages site using an ARM template. After deployment, you find that the portal uses local authentication, but you need it to use Microsoft Entra ID. What is the most likely reason the authentication provider is not set correctly?

A.The portal URL must be changed to use Microsoft Entra ID.
B.The 'authentication' property should be 'identityProviders' with the correct configuration.
C.The portal location must be in a region that supports Microsoft Entra ID.
D.The portal only supports local authentication when deployed via ARM.
AnswerB

The correct property for configuring authentication providers in ARM is 'identityProviders'.

Why this answer

The exhibit shows an ARM template with the 'authentication' property set to 'Local'. However, the correct property for configuring identity providers in ARM templates for Power Pages is 'identityProviders', not 'authentication'. Additionally, the API version '2022-03-01-preview' may not support the full configuration.

The most likely reason is that the template uses an incorrect property name. Option A is incorrect because local authentication is not the only option. Option C is incorrect because the portal URL does not affect authentication.

Option D is incorrect because the location is not relevant.

Full explanation →
360
MCQeasy

A user reports that they cannot create a new Power App in the default environment. The administrator checks that the user has a Power Apps license, but the user still cannot create apps. What is the most likely cause?

A.The user does not have a Power Apps license
B.The user does not have a mobile device
C.The environment is not enabled for app creation
D.The user is using an unsupported browser
AnswerC

Environment settings control who can create apps.

Why this answer

If the environment is not enabled for app creation, users cannot create apps even with a license. Option A is wrong because the user has a license. Option B is wrong because browser issues would not prevent creation entirely.

Option D is wrong because mobile access is not required for creation.

Full explanation →
361
MCQmedium

An organization wants to manage all Power Platform environments from a single pane of glass, including capacity monitoring and assignment of user roles. Which tool should they use?

A.Microsoft 365 admin center
B.Microsoft Intune
C.Power Platform admin center
D.Azure portal
AnswerC

The Power Platform admin center is the dedicated tool for managing environments, capacity, and roles.

Why this answer

The Power Platform admin center (admin.powerplatform.microsoft.com) is the dedicated management portal for all Power Platform environments, providing a single pane of glass for tasks such as capacity monitoring (storage usage per environment), environment lifecycle management, and assignment of user roles via Data Loss Prevention (DLP) policies and environment security roles. It centralizes administration across Power Apps, Power Automate, Power Virtual Agents, and Dataverse, which aligns directly with the organization's requirement.

Exam trap

The trap here is that candidates often confuse the Microsoft 365 admin center (which handles user licensing and service settings) with the Power Platform admin center, assuming all admin tasks are centralized in one portal, but the PL-900 exam specifically tests that Power Platform environment management requires the dedicated admin center.

How to eliminate wrong answers

Option A is wrong because the Microsoft 365 admin center manages user licenses, Microsoft 365 services (Exchange, SharePoint, Teams), and tenant-level settings, but it does not provide granular capacity monitoring or environment-specific role assignment for Power Platform environments. Option B is wrong because Microsoft Intune is a mobile device management (MDM) and mobile application management (MAM) tool focused on device compliance, app protection policies, and conditional access, not on managing Power Platform environments or capacity. Option D is wrong because the Azure portal manages Azure resources (VMs, storage accounts, Azure Active Directory) and does not include the Power Platform environment management features like capacity monitoring or environment role assignment, which are specific to the Power Platform admin center.

Full explanation →
362
MCQeasy

A user reports that a Power Automate flow stopped working after a co-owner modified the flow. The user is the original owner. What is the most likely reason for the failure?

A.The flow requires manual approval to run
B.The user lost ownership of the flow
C.The co-owner changed the connection references used by the flow
D.The co-owner deleted the user's permissions
AnswerC

Changed connections may break the flow if the new connections are not valid for the original owner.

Why this answer

Option B is correct because if the co-owner changed the connection references, the flow may lose access to required data sources or services. Option A is wrong because the original owner still retains ownership. Option C is wrong because co-owners can modify flows.

Option D is wrong because flow runs do not require manual approval unless configured.

Full explanation →
363
MCQmedium

A Power Pages site needs to display data from a Dataverse table only to authenticated users with a specific role. The data includes sensitive personal information. What is the best approach to secure the data?

A.Write a custom JavaScript to check user roles and hide the data.
B.Disable anonymous access and allow all authenticated users.
C.Configure column-level security in Dataverse to restrict the columns.
D.Set the page permission to 'Authenticated Users' and use a web role to grant access.
AnswerD

Web roles allow granular control over who sees data.

Why this answer

Power Pages uses web roles to control access to pages and data. Column-level permissions are not available, and custom code is insecure. Disabling anonymous access alone doesn't restrict by role.

Full explanation →
364
MCQeasy

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

A.Use Dataverse as the data source and a Model-driven app
B.Use Excel stored on OneDrive and a Canvas app
C.Use SQL Server as the data source and a Canvas app
D.Use a SharePoint list as the data source and a Canvas app
AnswerD

Correct: SharePoint is included with many Microsoft 365 subscriptions and is easy to manage.

Why this answer

Option A is correct because SharePoint lists are easy to set up, no extra licensing, and can be used with Canvas apps. Option B is wrong because Dataverse requires additional licensing. Option C is wrong because SQL Server requires infrastructure.

Option D is wrong because Excel is not suitable for multi-user concurrent access.

Full explanation →
365
MCQhard

A Power Apps app uses a canvas and connects to multiple data sources. Users complain that the app loads slowly. What is the best practice to improve performance?

A.Use the 'ClearCollect' function to cache data in a collection
B.Add more screens to distribute the load
C.Increase the timeout settings
D.Use a single data source
AnswerA

Collections cache data locally, reducing repeated queries.

Why this answer

Option A is correct because the ClearCollect function allows you to cache data from external sources into a local collection within the app. This reduces the number of round trips to the data source during user interactions, significantly improving load and response times by minimizing network latency and data source throttling.

Exam trap

The trap here is that candidates may think adding more screens distributes the workload, but in Power Apps, each screen loads independently and can trigger separate data source calls, worsening performance rather than improving it.

How to eliminate wrong answers

Option B is wrong because adding more screens increases the app's memory footprint and can actually degrade performance, as each screen may trigger additional data requests. Option C is wrong because increasing timeout settings does not address the root cause of slow data retrieval; it only allows the app to wait longer for a response, potentially masking performance issues. Option D is wrong because using a single data source is not always feasible and does not inherently improve performance; the bottleneck is often the number of queries, not the number of sources.

Full explanation →
366
MCQeasy

A company wants to empower its field service technicians to report issues and submit photos from their mobile devices without writing any code. Which Microsoft Power Platform capability should they use?

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

Power Apps allows building custom mobile apps with low code.

Why this answer

Power Apps is the correct choice because it enables the creation of custom mobile apps with minimal code, allowing field service technicians to report issues and submit photos through a tailored interface. With Power Apps, you can build a canvas app that connects to data sources like SharePoint or Dataverse, providing a no-code solution for mobile data entry and image capture.

Exam trap

The trap here is that candidates often confuse Power Automate (for automating workflows) with Power Apps (for building user interfaces), mistakenly thinking automation alone can handle mobile data entry and photo uploads without a dedicated app front-end.

How to eliminate wrong answers

Option B is wrong because Power Virtual Agents is designed for creating conversational chatbots, not for building mobile data-entry forms with photo submission capabilities. Option C is wrong because Power Automate focuses on workflow automation and process orchestration, not on providing a user interface for technicians to input data or upload images. Option D is wrong because Power BI is a business analytics and visualization tool, not a platform for building interactive mobile apps for data collection.

Full explanation →
367
MCQhard

Refer to the exhibit. A Power Automate cloud flow is configured to move files in a SharePoint document library based on approval status. The flow triggers when a file is created in the 'Pending' folder. However, when a file is uploaded to the 'Pending' folder, the flow does not trigger. What is the most likely cause?

A.The flow is configured to trigger on file creation in the root of the document library, not the 'Pending' folder
B.The condition expression is incorrect, causing the flow to fail silently
C.The flow uses a 'When a file is created' trigger, but the file is being modified, not created
D.The flow requires a Power Automate per user plan
AnswerA

The trigger might not be scoped to the folder if the folder path is not correctly specified or if the trigger uses a different scope.

Why this answer

The most likely cause is that the flow trigger is configured to monitor the root of the SharePoint document library rather than the specific 'Pending' folder. Power Automate's 'When a file is created' trigger requires explicit folder path selection; if the trigger is set to the library root, it will not fire for files created in subfolders unless the trigger is configured with the folder path pointing to 'Pending'. This is a common misconfiguration when the trigger scope is not narrowed to the intended folder.

Exam trap

The trap here is that candidates mistakenly think the 'When a file is created' trigger automatically monitors all subfolders, when in fact it only monitors the exact folder path specified in the trigger configuration.

How to eliminate wrong answers

Option B is wrong because a condition expression error would not prevent the flow from triggering; it would cause the flow to run but fail at the condition step, not silently skip execution. Option C is wrong because the trigger is 'When a file is created', and uploading a new file to the 'Pending' folder is a creation event, not a modification; the issue is not the event type but the trigger's folder scope. Option D is wrong because a Power Automate per user plan is not required for basic SharePoint triggers; standard Microsoft 365 licenses include sufficient Power Automate rights for this scenario, and licensing issues would typically produce an error message, not a silent failure to trigger.

Full explanation →
368
MCQhard

An organization uses Power Automate flows that connect to Microsoft Teams and SharePoint. They want to ensure that if a flow is accidentally deleted, it can be recovered within 30 days. What should they do?

A.Store the flow in a solution and export it regularly.
B.Enable version history for the flow.
C.Configure a backup policy in the Power Platform admin center.
D.No action needed; deleted flows are automatically retained in the recycle bin for 30 days.
AnswerD

Power Automate preserves deleted flows in the recycle bin for 30 days.

Why this answer

Option A is correct because deleted flows are retained in the recycle bin for 30 days. Option B is wrong because backup policy is for Dataverse, not flows. Option C is wrong because solutions do not protect against deletion.

Option D is wrong because version history is for changes, not deletion recovery.

Full explanation →
369
Multi-Selecthard

A company deploys a model-driven app that uses a custom table 'Project' with a status choice column. The app includes a business rule that shows a warning message when the status is set to 'Completed' but the 'End Date' is blank. The business rule works on the main form but not when records are updated via a Power Automate flow. Which THREE actions should the administrator take to enforce the rule regardless of update method?

Select 3 answers
A.Use a synchronous plug-in that runs on the Update message of the Project table.
B.Add a custom API step in the Power Automate flow to validate the End Date before updating.
C.Configure an asynchronous workflow that runs after the update.
D.Create a real-time workflow on the Project table to validate on update.
E.Modify the business rule to run on all forms.
AnswersA, B, D

Synchronous plug-ins run on the server and can enforce validation.

Why this answer

Option A is correct because a synchronous plug-in runs on the Update message of the Project table, executing immediately within the database transaction. This ensures the validation logic (checking that End Date is not blank when Status is 'Completed') is enforced regardless of the update method, including Power Automate flows, which bypass client-side business rules.

Exam trap

The trap here is that candidates assume business rules apply to all update methods, but they are client-side only and do not execute during server-side operations like Power Automate flows or API calls.

Full explanation →
370
MCQhard

You are the Power Platform administrator for Contoso Ltd., a retail company with 500 employees. The company uses Microsoft 365 and has recently adopted Power Platform. The IT department manages a Power Apps canvas app used by the sales team to track customer interactions. The app connects to a Microsoft Dataverse table named 'Customer Interactions' with columns: CustomerID (text), InteractionDate (date), Notes (text), and SalesPerson (text). The app was working fine for three months, but starting last week, users report that the app loads slowly, sometimes timing out, and the 'Customer Interactions' table shows duplicate records. Upon investigation, you find that the app uses a 'Patch' function to create records, and the 'OnStart' property loads all records from the table using 'Filter(Customer Interactions, SalesPerson = User().FullName)' to show only the current user's records. The Dataverse table has grown to 50,000 rows. Additionally, some users have accidentally created multiple submissions by double-clicking the submit button. You need to resolve the performance and duplicate issues with minimal disruption. What should you do?

A.Replace the 'Patch' function with 'Collect' in the app and use the 'Distinct' function to remove duplicates from the table every night via a Power Automate flow.
B.Increase the 'Data row limit' for the 'Customer Interactions' table in the app settings to 500 and add a 'Remove duplicates' step in the app's 'OnStart'.
C.Remove the 'Filter' from 'OnStart' and load all records into a collection, then use 'Filter' on the collection to show current user's records.
D.Modify the 'Submit' button to set its 'DisplayMode' to 'Disabled' after the first click to prevent double submission, and change the 'OnStart' filter to delegate by ensuring the 'SalesPerson' column is indexed in Dataverse and using 'Filter(Customer Interactions, SalesPerson = User().FullName)' with delegation enabled.
AnswerD

This directly addresses both issues: disabling the button prevents duplicates, and delegated filtering improves performance by only loading relevant records.

Why this answer

Option D is correct because it addresses both performance and duplicate issues directly. Disabling the submit button after the first click prevents double submissions, a common cause of duplicates in canvas apps. Indexing the SalesPerson column in Dataverse ensures the Filter function delegates, meaning the query runs on the server side and only returns relevant rows, drastically reducing data transfer and load times compared to pulling all 50,000 rows client-side.

Exam trap

The trap here is that candidates often think loading all data into a collection (Option C) or using a nightly cleanup flow (Option A) is acceptable, but they miss that delegation and preventing duplicates at the source are the correct, minimal-disruption solutions for performance and data integrity.

How to eliminate wrong answers

Option A is wrong because using Collect to replace Patch does not solve the delegation or performance issue; Collect still loads all rows client-side, and running a nightly Power Automate flow to remove duplicates is a reactive workaround that does not prevent the root cause of double submissions. Option B is wrong because increasing the Data row limit to 500 does not help when the table has 50,000 rows; the app would still need to load all rows to apply the filter, and adding a 'Remove duplicates' step in OnStart does not prevent duplicates from being created. Option C is wrong because loading all records into a collection in OnStart defeats delegation entirely; the app would still retrieve all 50,000 rows over the network, causing the same slow load and timeout issues.

Full explanation →
371
MCQeasy

A company wants to automatically send an email notification when a new file is added to a SharePoint document library. Which type of trigger should be used in Power Automate?

A.A condition
B.A trigger
C.A connector
D.An action
AnswerB

A trigger initiates the flow based on an event.

Why this answer

The correct answer is A because a trigger starts the flow when an event occurs, such as a new file being added. Option B is a service, not a trigger. Option C is an action, not a trigger.

Option D is a connector, not a trigger.

Full explanation →
372
MCQeasy

A user wants to build an app that allows field technicians to view work orders and capture photos offline. Which type of Power App should be chosen?

A.Power Pages site with offline access.
B.AI Builder model embedded in a canvas app.
C.Model-driven app because it natively supports offline.
D.Canvas app with offline capability enabled.
AnswerD

Canvas apps support offline data and photo capture via the mobile app.

Why this answer

Canvas apps can be enabled for offline use with the mobile app. Option B is wrong because model-driven apps have limited offline capability. Option C is wrong because Power Pages are public websites.

Option D is wrong because AI Builder is not an app type.

Full explanation →
373
MCQhard

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

A.The email is sent from a shared mailbox.
B.The 'Auto-track' setting in Outlook is disabled.
C.Server-side synchronization is not configured to track sent emails.
D.The timeline control is not added to the form.
AnswerC

Server-side sync must be enabled for email tracking in Dataverse.

Why this answer

Option D is correct because server-side synchronization must be configured to track emails sent from the app; otherwise, they may not appear in the timeline. Option A is wrong because auto-track in Outlook is for incoming emails. Option B is wrong because the timeline control itself does not need configuration.

Option C is wrong because Exchange integration is required but the specific setting is server-side sync.

Full explanation →
374
MCQeasy

A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?

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

Power Automate enables workflow automation, including sending follow-up emails based on triggers like new customer interactions.

Why this answer

Power Automate is the correct choice because it enables the sales team to create automated workflows that trigger follow-up emails based on customer interactions, such as when a new contact is added or a meeting ends. It integrates with common data sources like Dynamics 365, SharePoint, or Outlook, and uses prebuilt connectors to send emails without any custom code.

Exam trap

The trap here is that candidates may confuse Power Automate with Power Apps, thinking that building a custom app is necessary for automation, but Power Automate is specifically designed for workflow automation and integration without custom development.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating workflows or sending emails. Option B is wrong because Power Apps is used to build custom applications with low-code interfaces, but it does not natively handle automated email triggers or workflow orchestration without additional components like Power Automate. Option C is wrong because Power Virtual Agents is designed for creating conversational chatbots, not for automating backend processes like sending follow-up emails based on customer interactions.

Full explanation →
375
Multi-Selecteasy

Which TWO scenarios are suitable for using a scheduled cloud flow in Power Automate?

Select 2 answers
A.Creating a file in SharePoint whenever a new file is uploaded to a OneDrive folder
B.Backing up a database to a cloud storage every night at midnight
C.Sending an approval request to a manager when a new expense report is submitted
D.Sending a welcome email to a new user immediately after they sign up
E.Generating a daily report of all new sales orders every morning at 8 AM
AnswersB, E

Scheduled flows can be configured to run at a specific time each night.

Why this answer

Scheduled cloud flows run on a recurring schedule, making them ideal for time-based automation like nightly backups or daily report generation. Option B triggers at a specific time (midnight) without requiring an external event, which matches the scheduled flow pattern exactly.

Exam trap

Microsoft often tests the distinction between trigger types—candidates confuse event-driven triggers (e.g., 'When a file is created') with scheduled triggers, leading them to select options like A or C for scheduled flows.

Full explanation →
Page 4

Page 5 of 14

Page 6

All pages

1234567891011121314

Practice PL-900 by domain

Target a specific domain to shore up weak areas.

Identify foundational components of Power PlatformDemonstrate capabilities of Power BIDescribe complementary Microsoft Power Platform solutionsDemonstrate the capabilities of Power AutomateDescribe the business value of Microsoft Power PlatformManage the Microsoft Power Platform environmentIdentify foundational components of Microsoft Power PlatformDemonstrate the capabilities of Power BIDemonstrate the capabilities of Power AppsDemonstrate the capabilities of Microsoft Copilot StudioDemonstrate the capabilities of Power Pages
See all domains with question counts →