Courseiva

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

701 questions total · 10pages · All types, answers revealed

Page 1

Page 2 of 10

Page 3
76
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

Dataverse security roles grant privileges at the table and record level, and row-level security restricts each user to records matching their region. This satisfies the requirement that users in different regions see only their own regional data, unlike column-level or field-level controls.

Why this answer

Microsoft Dataverse supports row-level security through security roles, which can be combined with teams and business units to restrict records so users only see data relevant to their region. Security roles define privileges at the table level, and row-level filtering is achieved by assigning users to business units or teams that own the records. This is the native, supported way to enforce regional data isolation in Power Platform.

Exam trap

PL-900 often tests the confusion between app-level permissions and data-level security — candidates pick 'app permissions' thinking it controls data visibility, when Dataverse row-level security is the correct mechanism.

How to eliminate wrong answers

Option A is wrong because Power Apps app permissions control who can access the app itself, not which rows of data they can see within Dataverse. Option B is wrong because Power Automate conditional logic can branch workflows but does not enforce data visibility at the Dataverse row level. Option D is wrong because Power BI dashboard filters only affect visualization, not the underlying data access or security in Dataverse.

77
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

Interactive dashboards let users explore live data through charts, filters and drill-downs, satisfying the requirement to visualise data for business analytics. Unlike static reports, visuals refresh from the underlying semantic model, so decision-makers spot trends and outliers without exporting spreadsheets or requesting developer-built reports.

Why this answer

Option A is correct because Power BI's core strength is presenting data through interactive dashboards and reports, letting users slice, filter, and drill into visuals for business analytics. Option C is correct because Power BI includes AI-powered capabilities such as Quick Insights, natural-language Q&A, and AI visuals that automatically surface trends, outliers, and correlations in data. Option B is incorrect because automating code deployment is a DevOps/CI-CD function, not a Power BI analytics benefit.

Option D is incorrect because Power BI connects to hundreds of data sources (databases, files, cloud services, and more), not a single source. Option E is incorrect because building customer-service chatbots is a Power Virtual Agents or Azure Bot Service scenario, not a Power BI analytics benefit.

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.

78
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's document-processing model extracts policy number, date and amount from the PDFs; Power Automate orchestrates the trigger, conditional branch on the $5,000 threshold, approvals and notifications; Dataverse stores the structured claim records. All are low-code, meeting the stated constraint.

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.

79
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

Assigning the authenticated user to a web role grants the table permissions that role carries. Power Pages authorises form submissions through web roles, so the user must hold a role linked to the support ticket table's permissions.

Why this answer

Option C is correct because an authenticated user must be assigned a web role in Power Pages, since web roles are the mechanism that grants authenticated (and anonymous) users access to portal resources and are a prerequisite for any table access. Option E is correct because submitting a support ticket form creates a record in the Dataverse support ticket table, and table permissions (with the appropriate Create privilege) must be configured and associated with the user's web role to allow that record creation. Option A is incorrect because site settings control portal-wide configuration values and behavior, not user authorization to create records.

Option B is incorrect because content snippets store reusable content fragments and have nothing to do with record-level access. Option D is incorrect because page permissions govern whether a user can view a given web page, not whether the form's underlying table record can be created.

Exam trap

PL-900 often tests the confusion between page permissions and table permissions — candidates may think that granting access to the page is enough, but the underlying table permission is what actually allows the create operation.

80
MCQeasy

A small business owner wants to receive a push notification on their phone whenever a new high-priority email arrives in their Microsoft 365 Outlook inbox. They have no coding experience and want the simplest possible solution. What should they do?

A.Create a Power Automate cloud flow with the 'When a new email arrives (V3)' trigger and a 'Send me a mobile notification' action.
B.Create a scheduled cloud flow that runs every 15 minutes and sends an email summary of new messages.
C.Build a Power Apps canvas app that checks for new emails every minute and displays a banner.
D.Configure an Outlook inbox rule to forward all high-priority emails to an SMS gateway address.
AnswerA

This is correct because the Outlook trigger 'When a new email arrives (V3)' fires when a new email arrives, and the 'Send me a mobile notification' action delivers a push notification to the Power Automate mobile app. No code is needed; it is a standard cloud flow built in the browser or mobile app, matching the no-code requirement.

Why this answer

The event-driven Outlook trigger reacts to each new email, and the mobile notification action sends a push alert to the Power Automate app on the user's phone. This combination requires no code and directly fulfills the need for immediate notification. Scheduled or rule-based alternatives either introduce delay or fail to deliver a push notification.

Exam trap

The trap here is assuming that an Outlook inbox rule or a scheduled flow can deliver a real-time push notification, when only an event-driven flow with a notification action does that.

81
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

Analysing storage by entity identifies which custom tables consume the most capacity, letting the administrator delete genuinely unused ones. This frees quota directly without altering or removing components that active solutions depend on, satisfying the no-impact constraint.

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.

82
MCQeasy

A help desk technician needs to confirm which Power Platform environments are associated with a specific Microsoft Dataverse database and check the environment type and region for each. The technician has the Power Platform Administrator role. Where should the technician look?

A.The Environments list in the Power Platform admin center, opening the environment details pane
B.The Microsoft 365 admin center, Active users blade
C.The Capacity page in the Power Platform admin center
D.The Default environment's Solutions list in make.powerapps.com
AnswerA

The Environments page in the Power Platform admin center lists every environment with its type, region, and whether a Dataverse database is present. Opening an environment's details shows the database configuration and environment metadata, which is exactly what the technician needs to verify.

Why this answer

The Environments page in the Power Platform admin center is the authoritative inventory: it lists each environment with type, region, and database status, and the details pane exposes database configuration. A Power Platform Administrator can open it directly, making it the correct place to confirm which environments have Dataverse and to read environment metadata.

Exam trap

The trap here is confusing the Capacity page with the Environments page, since both are in the admin center but only one lists environment metadata.

83
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

Low-code and no-code tooling lets non-developers build apps, flows and dashboards using visual designers instead of programming. This removes the professional developer dependency, directly satisfying the citizen developer benefit of enabling business users to create working solutions themselves.

Why this answer

Option A is correct because the Power Platform's core value proposition for citizen developers is its low-code/no-code design: tools like Power Apps, Power Automate, and Power BI use drag-and-drop interfaces, visual designers, and Excel-like expressions so business users without formal programming training can build apps, flows, and reports. Option B is correct because the platform ships with hundreds of pre-built connectors (to SharePoint, Microsoft 365, Dynamics 365, SQL, and third-party services) and ready-made templates, which dramatically reduce the effort and expertise needed to integrate data and assemble a working solution. Option C is incorrect because requiring extensive coding knowledge is the opposite of a citizen-developer benefit; while pro developers can extend solutions with code, coding is not required.

Option D is incorrect because high-performance computing for complex algorithms is not a Power Platform strength or selling point; it is aimed at rapid business app automation, not HPC workloads. Option E is incorrect because the Power Platform is not limited to enterprise customers; it is available through various licensing plans, including individual and small-business offerings.

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.

84
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

Power Pages design studio provides the end-to-end environment for building and managing a site, covering page creation, styling, data binding and publishing within one interface. It directly satisfies the stem's "start to finish" constraint, unlike separate tools that handle only individual tasks such as data modelling or authentication through Microsoft Entra ID.

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.

85
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

The approval action must complete before the condition evaluates the response; without a configured "wait for approval" dependency, the flow proceeds immediately and the condition reads an empty or default outcome. This violates the stem's requirement that status updates only after manager approval, so the update never fires correctly.

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.

86
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 or tap steps into the slots.

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

Why this order

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

87
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

Customer Managed Key (CMK) encrypts Power Platform environment data at rest using a key the healthcare organisation controls and manages in its own key vault, satisfying the HIPAA requirement for protecting patient data at rest.

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.

88
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 the chatbot engine that Power Pages embeds, answering from a configured knowledge base and handing off to a human agent through escalation. This matches the requirement for knowledge-based responses plus escalation.

Why this answer

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

89
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 provides drag-and-drop page design with prebuilt form and list components bound to Dataverse, so the marketing team captures attendee information and stores it without writing code, meeting the no-code constraint in the stem.

Why this answer

Power Pages Studio is the low-code/no-code design surface for building external-facing websites, including public event registration pages, using drag-and-drop components, templates, and Dataverse-backed forms. It lets the marketing team capture attendee data directly into Dataverse without writing code, which matches the requirement exactly.

Exam trap

PL-900 often tests the misconception that any Power Platform tool can build a public website, when only Power Pages (via Power Pages Studio) provides anonymous external-user web pages with drag-and-drop design.

How to eliminate wrong answers

Option A is wrong because Power Automate cloud flows automate processes and integrations but do not provide a drag-and-drop public web page designer. Option C is wrong because Power Apps canvas apps are internal business apps, not public anonymous-access websites, and they require a Power Apps license for users. Option D is wrong because Power BI dashboards visualize data and cannot host a public registration form that writes to Dataverse.

90
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

Power Apps portals provide an external-facing web interface with anonymous or authenticated access, letting partners submit support tickets without a Microsoft Entra ID licence. Submissions write directly to Dataverse tables, satisfying the external-access and Dataverse storage constraints that model-driven or canvas apps, which require internal licensing, cannot meet.

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.

91
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 provides a low-code, drag-and-drop canvas for building custom business apps, letting non-developers assemble lead-tracking forms and follow-up workflows without writing code. It directly satisfies the sales team's need for a custom app despite their lack of coding experience.

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.

92
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.

93
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

A stale or broken SharePoint connection is the most common cause of intermittent save failures with generic errors. Verifying the connector's authentication and permissions directly addresses the data-write failure described in the stem before investigating formulas or app logic.

Why this answer

When a Power Apps app fails to save data to SharePoint and shows a generic error, the first thing to investigate is the connection to the SharePoint data source, because a broken or expired connection is the most common cause of save failures. Verifying the connection ensures the app can authenticate and communicate with SharePoint before investigating more complex issues like delegation or formulas.

Exam trap

PL-900 often tests the misconception that generic save errors are caused by formula syntax or delegation, when the first and most common cause is a broken or expired data source connection.

How to eliminate wrong answers

Option A is wrong because clearing browser cache and cookies is a client-side troubleshooting step that rarely fixes data save failures and is not the first thing to check for a data source connection issue. Option C is wrong because delegation affects query results for large lists, not the ability to save a single leave request; it is not the first thing to investigate for a save failure. Option D is wrong because syntax errors in formulas would typically cause the app to fail at design time or produce specific errors, not intermittent save failures; connection issues are more likely.

94
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 lets the dataset connect to the Excel file on SharePoint and reload it automatically at defined times, removing manual intervention. The on-premises data gateway is only needed if the source sits behind a firewall, which SharePoint does not.

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.

95
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 provides event-driven cloud flows, triggered when a form submission occurs, that execute actions such as sending email without manual intervention. This directly satisfies the stem's requirement for automatic welcome emails to new customers, unlike tools built for app creation, reporting or virtual agents.

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.

96
MCQmedium

A Power Platform administrator is setting up a new environment for a department. The department requires that data stored in the environment remain within a specific geographic region. The administrator creates the environment in the Europe region. Which additional step must the administrator take to ensure that all data, including backups, stays in that region?

A.Create a data loss prevention policy that blocks connectors outside the region.
B.Configure the environment's region during creation; no further action is required.
C.Enable the 'Data residency' setting in the Power Platform admin center.
D.Assign the environment to a security group that is restricted to users in that region.
AnswerB

When you create an environment in the Power Platform admin center, you select a region, and all data, including backups, is stored within that region's data centers. No additional setting is needed to enforce data residency. The region selection at creation is the definitive control, so the administrator's action of creating it in Europe already satisfies the requirement.

Why this answer

Data residency in Power Platform is determined by the region chosen when an environment is created. The environment's data, including backups, is stored in data centers within that region. No additional configuration is required to enforce this.

The administrator's creation of the environment in the Europe region already ensures that data remains in that geography, making other proposed steps unnecessary or ineffective.

Exam trap

The trap here is assuming that data residency requires a separate toggle or policy, when it is actually established solely by the environment's region at creation.

97
MCQmedium

A marketing coordinator creates a Power Automate cloud flow that sends a personalized email to each attendee of an event. The coordinator stores attendee names and email addresses in a Microsoft Excel table in OneDrive for Business. After the flow runs, the coordinator discovers the emails were sent to the wrong recipients. The flow uses an 'Apply to each' loop over the Excel rows. What is the most likely cause?

A.The email action references dynamic content from outside the loop instead of the current iteration's row.
B.The Excel connector cannot read tables in OneDrive for Business and returned cached data.
C.The flow's connection to Excel expired, so the loop reused the first row for all iterations.
D.The 'Apply to each' loop requires a Filter array action to sort rows before sending.
AnswerA

If the Send an email action inside the loop uses a dynamic content token captured from a step outside the loop, every iteration sends to the same address. The correct pattern is to reference the current item's properties from the 'Apply to each' output so each iteration uses its own row's email address.

Why this answer

In an 'Apply to each' loop, dynamic content must reference the current iteration's item. If the email action instead uses a token from an earlier step, that single value is reused for every recipient, producing misrouted emails. Binding the recipient field to the loop's current row properties resolves the issue.

Exam trap

The trap here is assuming the data source is at fault, when misrouted emails usually come from referencing the wrong dynamic content token.

98
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

The trigger's condition filters on Status = 'New', so Power Automate never fires for orders created with Status = 'Pending'. The condition must be edited to match the intended value before the flow can start.

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.

99
MCQeasy

A business analyst at a logistics company wants to create a Power Automate cloud flow that runs every weekday at 7:00 AM to post a summary of yesterday's deliveries to a Microsoft Teams channel. The analyst has no coding experience. Which trigger should they use to start the flow?

A.Manually trigger a flow
B.Recurrence
C.When a new email arrives
D.When an item is created
AnswerB

The Recurrence trigger schedules a flow to run at a specified interval, such as daily or weekly, and allows configuration of time zone and start time. For a weekday 7:00 AM run, the analyst sets frequency to Week and selects Monday through Friday, making it the correct no-code scheduling trigger here.

Why this answer

A scheduled flow that runs every weekday at a specific hour requires the Recurrence trigger, which is built into Power Automate and needs no code. Configuring it with a weekly frequency and selecting Monday through Friday produces the desired cadence, while the other triggers are event-driven and cannot enforce a fixed 7:00 AM start.

Exam trap

The trap here is assuming any trigger can be scheduled, when only the Recurrence trigger supports time-based execution.

100
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

Low-code application development lets makers build apps through visual designers and prebuilt connectors rather than hand-written code, directly satisfying the stem's digital-transformation requirement by accelerating delivery. Power Apps embodies this capability, enabling business users to create solutions without traditional programming, which reduces backlog and development cost across the organisation.

Why this answer

Power Platform delivers low-code application development through Power Apps (option B), which lets makers build canvas and model-driven apps with connectors and formulas instead of full custom code, directly supporting digital transformation. Workflow automation is provided by Power Automate (option D), enabling automated flows, approvals, and integration across hundreds of connectors to digitize business processes. Data analytics and visualization come from Power BI (option E), which turns data into interactive dashboards and reports for data-driven decisions.

Option A is incorrect because Power Platform consumes prebuilt AI models via AI Builder rather than training custom models from scratch, and option C is incorrect because Power Platform augments rather than replaces custom coding, still allowing pro-code extensibility.

101
MCQeasy

A marketing team uses Power Automate to post updates to a Microsoft Teams channel whenever a new item is added to a SharePoint list. The team wants to ensure that the flow can be triggered manually by any team member from the Power Automate mobile app. What should they add to the flow?

A.A 'Recurrence' trigger set to run every hour.
B.A 'Manually trigger a flow' trigger with a button input.
C.A 'When a file is created' SharePoint trigger.
D.A 'When an item is created' SharePoint trigger.
AnswerB

The 'Manually trigger a flow' trigger allows users to start the flow on demand from the Power Automate mobile app or web portal. By adding this trigger, any team member can run the flow manually. This satisfies the requirement for manual triggering. The trigger can include inputs, but a button input is not strictly necessary; however, it provides a simple way to initiate the flow. This is the correct approach for manual execution.

Why this answer

The 'Manually trigger a flow' trigger is designed for on-demand execution, allowing users to start the flow from the Power Automate mobile app or web interface. This directly enables any team member to trigger the flow manually, as required. Other triggers are event-based or scheduled and do not support manual initiation, making them unsuitable for this scenario.

Exam trap

The trap here is confusing event-based triggers, which run automatically, with manual triggers that require user initiation.

102
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

The Environment Admin role grants administrative rights scoped to specific environments, letting regional leads manage those environments without tenant-wide privileges. This directly satisfies the stem's constraint of delegating environment management while withholding full administrator access.

Why this answer

The Environment Admin role grants administrative rights scoped to a specific environment, allowing the user to manage that environment's settings, users, and resources without full tenant-wide admin privileges. This is the correct role for delegating environment management to regional leads.

Exam trap

PL-900 often tests the confusion between tenant-wide admin roles (Power Platform Administrator) and environment-scoped roles (Environment Admin), causing candidates to over-grant privileges.

How to eliminate wrong answers

Option B is wrong because the Dynamics 365 Administrator role is a tenant-level role tied to Dynamics 365 services, not a scoped environment delegation role. Option C is wrong because System Customizer is a Dataverse security role that allows customization of tables and forms within an environment, not administrative management of the environment itself. Option D is wrong because Power Platform Administrator is a tenant-wide role that grants full administrative rights across all environments, which exceeds the least-privilege requirement.

103
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

Exporting as managed strips the unmanaged customisation layer and locks the solution, so it can be imported cleanly into production and other environments. This satisfies the deployment requirement, since unmanaged solutions are intended only for development and cannot be reliably promoted.

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.

104
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

Two separate 'Send an email' actions sit inside the same condition branch, so both execute when rating 1 satisfies the branch, producing duplicate emails. Rating 2 follows a different path, explaining why only rating 1 duplicates.

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.

105
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.

106
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 in Microsoft Dataverse restricts individual column access by user or team, satisfying the requirement that only Premium Support agents view 'SLA Level'. Column permissions are granted through field security profiles, which override table-level privileges, so other roles retain access to the record yet cannot read or update that specific field.

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.

107
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 evaluate case attributes, such as category, against conditions you define and then route the case to a specified queue automatically. This directly satisfies the requirement to assign cases by category without manual intervention, unlike workflows or business rules, which cannot move records between queues.

Why this answer

Routing rule sets in Dynamics 365 model-driven apps automatically route cases to queues or users based on conditions like case category. They are specifically designed for this purpose, allowing you to define rules that evaluate case fields and assign to the appropriate queue.

Exam trap

PL-900 often tests the difference between routing rule sets and workflows, causing candidates to choose Workflow for automatic assignment when routing rules are the native, efficient solution.

How to eliminate wrong answers

Option A is wrong because Workflows can automate processes but are not specifically designed for queue routing; they require custom logic and are less efficient for this use case. Option B is wrong because SLA KPIs track service level agreements and do not handle case assignment. Option D is wrong because Business Process Flows guide users through stages of a process but do not automatically assign records to queues.

108
MCQmedium

A company uses Power Apps to manage field service inspections. Inspectors need to capture GPS coordinates, photos, and digital signatures while offline in remote areas with no internet connectivity. The app must sync data automatically when connectivity is restored. Which type of Power Apps app should the company build?

A.A model-driven app built on Microsoft Dataverse with a custom form for inspections.
B.A canvas app that connects to a SQL Server database through an on-premises data gateway.
C.A Power Apps portal that allows inspectors to submit inspection data through a web browser.
D.A canvas app with the built-in offline capability enabled and the data stored in Microsoft Dataverse.
AnswerD

Canvas apps support offline data access when the data source is Dataverse, and Power Apps Mobile automatically caches records and syncs changes when connectivity returns. This directly satisfies the need to capture GPS, photos, and signatures in remote areas without internet, then synchronize data later.

Why this answer

Canvas apps with Dataverse as the data source support offline use in Power Apps Mobile, automatically caching data and syncing changes when the device reconnects. This matches the requirement for remote inspections with GPS, photos, and signatures captured without internet. Model-driven apps, gateway-connected SQL, and portals all depend on live connectivity and cannot meet the offline sync need.

Exam trap

The trap here is assuming that any Dataverse-based app supports offline mode, when in fact offline capability is a canvas app feature tied to Dataverse and Power Apps Mobile.

109
MCQhard

A Power Apps maker has built a canvas app that uses a SQL Server database as its data source. The app is used by employees in the office and remote workers. Remote workers report that the app is slow when loading data. The maker suspects that the issue is related to data retrieval. Which action should the maker take to improve performance for remote users?

A.Enable delegation for the SQL Server data source
B.Configure an on-premises data gateway in the same region as the remote users
C.Use the OnStart property to cache data locally
D.Optimize queries to retrieve only necessary data
AnswerD

Optimizing queries to retrieve only necessary data reduces the amount of data transferred over the network, which directly improves performance for remote users who may have slower connections. This is a best practice for canvas apps connected to SQL Server.

Why this answer

Optimizing queries to retrieve only the required data minimizes network payload and processing time, which is especially beneficial for remote users with limited bandwidth. This approach is a fundamental performance tuning technique for canvas apps using SQL Server.

Exam trap

The trap here is focusing on infrastructure changes like gateway placement instead of query optimization, which is often the most effective fix for remote performance issues.

110
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.

111
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

An Instant trigger starts a cloud flow manually, either from the user's device or by selecting a Run button, satisfying the requirement for a valid trigger type. It contrasts with automated and scheduled triggers, which start without direct user initiation.

Why this answer

In Power Automate, Instant is a valid trigger type (option A): it starts a flow on demand via a manual action such as clicking a button, running from the mobile app, or invoking an HTTP request, and it is one of the three official trigger categories. Automated is also a valid trigger type (option C): it starts a flow automatically when a specified event occurs, such as a new item being added to SharePoint or a new email arriving in Outlook. The remaining options are not recognized Power Automate trigger types: Event (B) is not a trigger category (events are what automated triggers listen for), Manual (D) is not a distinct category since manual initiation falls under Instant, and Calendar (E) is not a trigger type (scheduled recurrence is configured via the Recurrence trigger, not a 'Calendar' category).

112
Multi-Selecthard

Which THREE components are part of a model-driven app? (Choose three.)

Select 3 answers
A.Forms
B.Views
C.Screens
D.Triggers
E.Sitemap
AnswersA, B, E

Forms are a core component of model-driven apps, rendering the data model for user interaction. They satisfy the stem's requirement by binding directly to Microsoft Dataverse tables, defining how records are displayed and edited. Alongside views and charts, forms constitute the standard interface building blocks generated from the underlying data structure.

Why this answer

In Power Apps, a model-driven app is composed of metadata-driven components rendered by the platform, and Forms (A) are one of them: they define the data-entry and display layout for a table's records, with types like Main, Quick Create, and Card forms. Views (B) are also core components, since they define how lists of records are filtered, sorted, and displayed in the app's grids. The Sitemap (E) is the component that defines the app's navigation structure, organizing tables, views, and other elements into areas, groups, and subareas shown in the app.

Screens (C) belong to canvas apps, where the maker drags-and-drops UI controls onto a blank canvas, not to model-driven apps. Triggers (D) are not a model-driven app component; event-driven logic in model-driven apps is implemented through business rules, workflows, plug-ins, or Power Automate, not a 'Triggers' building block.

Exam trap

A common pitfall is selecting 'Screens' because they are prominent in canvas apps, but model-driven apps use forms and views instead.

113
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 provides prebuilt sentiment analysis, evaluating text and returning positive, negative, neutral, or mixed scores. This satisfies the question's requirement for a genuine AI Builder capability, unlike non-AI Power Platform features such as connectors or standard flow actions.

Why this answer

AI Builder provides prebuilt AI models that can be consumed directly in Power Apps and Power Automate, and sentiment analysis (A) is one of its prebuilt text-analysis models, allowing flows and apps to classify text as positive, negative, or neutral without writing ML code. Object detection in images (C) is also a supported AI Builder model type, enabling detection and counting of objects in images for scenarios like inventory or quality checks. Form processing (D) is another core AI Builder capability, using document-processing models to extract key-value pairs and tables from forms such as invoices or receipts.

Option B is incorrect because AI Builder complements rather than replaces Azure Machine Learning, which remains the platform for advanced custom ML workloads. Option E is incorrect because AI Builder offers prebuilt and customizable models, not from-scratch machine learning model development, which is the domain of Azure Machine Learning or custom code.

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.

114
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.

115
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

The Dataverse 'When a row is added, modified, or deleted' trigger supports change type selection, letting one flow respond to create, update, or delete events. This satisfies the requirement for a trigger covering all three row operations on a Dataverse table.

Why this answer

Option B, "When a row is added, modified, or deleted," is correct because it is the Dataverse connector's combined change trigger that fires on create, update, or delete events against a specified table, letting a flow react to any of those data operations. Option E, "When a row is added," is correct because it is the Dataverse connector's dedicated trigger that fires only when a new row is created in a chosen table, which is exactly a Dataverse-based start condition. Option A is wrong because "When a new email arrives (Outlook)" is an Outlook connector trigger, not a Dataverse trigger.

Option C is wrong because "When a new file is created (SharePoint)" is a SharePoint connector trigger. Option D is wrong because "PowerApps button" is a manual trigger invoked from a Power Apps control, not a Dataverse table change trigger.

Exam trap

PL-900 often tests whether candidates can distinguish connector-specific triggers — the trap is picking Outlook or SharePoint triggers for a Dataverse scenario because the flow's outcome involves email or files, confusing the trigger source with the action target.

116
MCQeasy

A user wants to create a canvas app that displays a list of products from a SharePoint list and allows filtering by category. The user has no coding experience. Which approach should they use to build the app quickly?

A.Use Power Automate to generate a canvas app from a flow.
B.Create a model-driven app from the SharePoint list.
C.Use the 'Start with data' option and connect to the SharePoint list to auto-generate a three-screen app.
D.Start with a blank canvas app and manually add a gallery and filter controls.
AnswerC

The 'Start with data' option in Power Apps allows users to connect to a data source, such as a SharePoint list, and automatically generates a three-screen app with a gallery, detail screen, and edit screen. This requires no coding and provides a fully functional app that can be further customized. It is the fastest way to create a basic app for viewing and filtering data.

Why this answer

The 'Start with data' option is designed to quickly generate a canvas app from a data source like SharePoint. It automatically creates screens for browsing, viewing details, and editing records, which includes filtering capabilities. This requires no coding and is ideal for users with limited experience.

Other methods either require manual work or are not applicable to SharePoint data.

Exam trap

The trap here is overlooking the 'Start with data' feature and assuming that building from blank is necessary, when auto-generation is available.

117
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 supported transport for moving components such as custom connectors and environment variables between environments, since they cannot be modified in the target and preserve the solution's configuration. Exporting from development and importing into production satisfies the stated requirement.

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.

118
MCQhard

A company has a copilot built with Microsoft Copilot Studio that handles customer inquiries. The copilot uses a topic that calls a Power Automate flow to create a case in Dynamics 365. During testing, the maker notices that when the flow fails, the copilot ends the conversation without informing the user. The maker wants the copilot to display a friendly error message and offer to retry the case creation. What should the maker do?

A.In the topic, add a condition after the flow action to check the flow's status and branch to a message node with a retry option.
B.Enable the 'Continue on error' setting in the flow action within the topic.
C.Configure the Power Automate flow to send an email to the maker when it fails.
D.Modify the flow to include a 'Terminate' action with a custom error message.
AnswerA

After a flow action, the topic can evaluate the output or use error handling. By adding a condition that checks if the flow succeeded, the maker can direct the conversation to a message node that displays a friendly error and offers a retry. This directly addresses the requirement to inform the user and provide a retry path.

Why this answer

To handle flow failures gracefully, the maker should add a condition node after the flow action that checks whether the flow succeeded. If it failed, the conversation branches to a message node that displays a user-friendly error and presents a retry option, such as a question node asking if the user wants to try again. This ensures the user is informed and can attempt the action again without restarting the entire conversation.

Exam trap

The trap here is assuming that enabling 'Continue on error' or terminating the flow will automatically surface a user-friendly message, but only explicit topic branching provides that control.

119
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 triggers on Dataverse record creation and sends the welcome email through an email connector, requiring no manual step. This satisfies the requirement for a Microsoft Power Platform component that reacts automatically to new employee records, which Power Apps or Power BI cannot do.

Why this answer

Power Automate is the Microsoft Power Platform component purpose-built for workflow automation and event-driven triggers. A Dataverse table can be configured with a 'When a row is added' trigger, and the flow can then send an email using the Office 365 Outlook connector — exactly matching the requirement for automatic email on record creation.

Exam trap

PL-900 often tests the functional boundary between Power Platform components, so candidates confuse Power Apps (UI) with Power Automate (automation) and pick Power Apps for a background email trigger.

How to eliminate wrong answers

Option A is wrong because Power Apps is for building custom user interfaces and apps, not for background automation triggered by data events. Option B is wrong because Power BI is a business intelligence and visualization tool for reporting and dashboards, with no capability to send automated emails on record creation. Option D is wrong because Power Pages is for building external-facing websites and portals, not for internal workflow automation triggered by Dataverse events.

120
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 in Power Pages define table-level access for each web role, so assigning the Orders table permission to the authenticated customer role restricts records to the signed-in contact. This satisfies the stem's requirement that customers view only their own orders, since permissions scope access by the contact relationship rather than granting blanket table read.

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.

121
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

The measure uses time intelligence, shifting the selected filter context back one year via SAMEPERIODLASTYEAR or DATEADD, so it returns prior-year sales for the chosen period. That matches calculating total sales for the previous year relative to the selected year.

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.

122
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 volunteer hours entry app, Power Automate triggers the weekly reminder workflow for inactive volunteers, and Power BI renders the dashboard aggregating hours by project. Together they cover data capture, automation and reporting without dedicated IT staff.

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.

123
MCQhard

A company uses Dynamics 365 Sales and wants to automatically send a follow-up email to a customer when an opportunity is marked 'Closed Won'. They need a solution that requires no custom code. What should they use?

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

Power Automate provides a no-code trigger on the Dynamics 365 'Closed Won' opportunity event, then a send-email action — satisfying the zero-custom-code constraint. A cloud flow connects the Dataverse trigger directly to Outlook, so no plug-in or JavaScript is needed.

Why this answer

Power Automate is the correct choice because it provides a no-code workflow automation platform that can trigger a flow when an opportunity's status changes to 'Closed Won' in Dynamics 365 Sales. It uses a prebuilt connector to Dynamics 365 to send an email via the Office 365 Outlook connector, requiring no custom code or development effort.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, mistakenly thinking a custom app is needed to send the email, when in fact Power Automate's trigger-based workflow is the correct no-code solution for automated actions on record changes.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code application development platform for building custom apps, not for creating automated workflows or triggers based on record status changes. Option C is wrong because Power BI is a business analytics and visualization tool, not capable of triggering automated email actions. Option D is wrong because Power Virtual Agents is a chatbot creation platform that requires user interaction and cannot autonomously send follow-up emails based on record updates.

124
Multi-Selectmedium

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

Select 2 answers
A.Integration with Microsoft Dataverse
B.Use of formulas like If, Switch, Filter
C.Ability to use AI Builder models
D.Access to device capabilities like camera and GPS
E.Embedding a canvas app in a model-driven app
AnswersB, D

Canvas apps are built by writing Power Fx formulas directly on controls, so imperative expressions such as If, Switch and Filter drive behaviour. Model-driven apps instead rely on declarative metadata, business rules and JavaScript, so this formula authoring surface is unavailable there.

Why this answer

Option B is correct because canvas apps are built on Power Fx, a formula language that lets makers write expressions such as If, Switch, and Filter directly in property formulas, whereas model-driven apps rely on declarative configuration (forms, views, business rules) rather than a formula language. Option D is correct because canvas apps can call device and media capabilities through connectors and Power Fx functions (for example Camera, Location, and Barcode), giving them native access to hardware like the camera and GPS, while model-driven apps do not expose these device capabilities in the same way. Option A is incorrect because both canvas and model-driven apps can integrate with Microsoft Dataverse as their data source.

Option C is incorrect because AI Builder models can be consumed from both canvas apps and model-driven apps. Option E is incorrect because embedding a canvas app inside a model-driven app is supported, so it is not exclusive to canvas apps.

Exam trap

PL-900 often tests the differences between canvas and model-driven apps; candidates may think that features like AI Builder or Dataverse integration are exclusive to one type, but they are available in both.

125
MCQeasy

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

A.When a new email arrives (Outlook connector)
B.When a record is created (Dataverse connector)
C.When a file is created (SharePoint connector)
D.When a user is created (Microsoft Entra ID connector)
AnswerD

The Microsoft Entra ID connector's 'When a user is created' trigger fires on new account provisioning, supplying the profile attributes needed to personalise the welcome email. It satisfies the requirement to react specifically to user creation events.

Why this answer

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

Exam trap

PL-900 often tests the correct trigger for a given scenario, and candidates might confuse the Entra ID connector with other connectors like Office 365 Users or Dataverse, leading to incorrect trigger selection.

How to eliminate wrong answers

Option A is wrong because 'When a new email arrives' triggers on incoming emails, not user creation. Option B is wrong because 'When a record is created' in Dataverse triggers on new records in Dataverse tables, not Entra ID user creation. Option C is wrong because 'When a file is created' in SharePoint triggers on file creation in SharePoint, not user creation.

126
MCQmedium

A company uses Power BI to visualize sales data from Dynamics 365 Sales. A new policy requires that all data must be stored in the US region only. The Power BI tenant is currently in the default region (home region). What should the admin do to comply with the policy?

A.Change the Microsoft Entra ID location to US
B.Apply a data classification label to restrict storage
C.Set the workspace region to US in Power BI settings
D.Provision Power BI Premium capacity in the US region
AnswerD

Premium capacity can be assigned to a specific region, enforcing data residency.

Why this answer

Provisioning Power BI Premium capacity in the US region and assigning workspaces to that capacity enforces data residency in the US. Option A is incorrect because Microsoft Entra ID location does not control Power BI data storage. Option B is incorrect because data classification labels do not enforce physical data location.

Option C is incorrect because setting the workspace region is only available with Premium capacity, but without Premium capacity, the workspace region defaults to the tenant home region and cannot be changed.

127
MCQmedium

A Power Automate flow uses a 'When an item is created' trigger on a SharePoint list. After moving the list to a different site, the flow no longer triggers. What is the most likely reason?

A.The trigger still references the old site and list ID.
B.The trigger does not support cross-site operations.
C.The flow was disabled during the move.
D.The SharePoint connector requires re-authentication.
AnswerA

Moving a SharePoint list changes its site and list identifiers. The trigger stores the original site URL and list GUID, so it polls a location that no longer exists and never fires for new items.

Why this answer

The 'When an item is created' trigger is bound to the original site URL and list ID. Moving the list to a different site does not automatically update the trigger's connection, so the flow continues to listen for changes on the old location and fails to trigger for the new one. Option B is incorrect because the trigger can work across sites if updated; the issue is the stale reference.

Option C is incorrect because the flow is not automatically disabled during the move. Option D is incorrect because re-authentication is not related to the change in location.

128
MCQeasy

A maker has built a copilot in Microsoft Copilot Studio that answers questions about company benefits. Before releasing it to employees, the maker wants to test the conversation and see how the copilot responds to different questions. What should the maker use?

A.The Microsoft 365 admin center's service health dashboard.
B.The test chat pane in Microsoft Copilot Studio.
C.The Dataverse table editor for the copilot's conversation transcripts.
D.The Power Platform admin center's environment analytics.
AnswerB

The test chat pane is the built-in tool in Microsoft Copilot Studio for trying out a copilot during authoring. It lets the maker type messages and see responses, including which topics are triggered and how variables are set. This is the intended way to test conversation behavior before publishing.

Why this answer

The test chat pane in Microsoft Copilot Studio is the built-in environment for trying out a copilot while authoring. It allows the maker to type messages, observe responses, and verify topic triggering and variable behavior before publishing. Admin centers and Dataverse table editors do not provide interactive conversation testing.

Exam trap

The trap here is confusing administrative monitoring tools, such as the Power Platform admin center, with the authoring test experience inside Copilot Studio.

129
MCQmedium

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

A.Power BI
B.AI Builder
C.Power Automate
D.Common Data Service
AnswerB

AI Builder provides prebuilt models, including invoice processing, that extract structured fields such as vendor, total and date from uploaded documents. It integrates directly into Power Apps, satisfying the requirement for automatic invoice data extraction without custom machine-learning code.

Why this answer

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

Exam trap

The trap here is that candidates confuse Power Automate's ability to orchestrate actions with AI Builder's actual AI processing capability, leading them to select Power Automate because they think 'automation' implies AI extraction.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not a data extraction or AI model service; it cannot extract information from invoices. Option C is wrong because Power Automate is a workflow automation platform that can trigger actions based on AI Builder results but does not itself perform AI-based extraction. Option D is wrong because Common Data Service (now Microsoft Dataverse) is a data storage and management platform, not an AI service; it can store extracted data but cannot perform the extraction.

130
MCQmedium

You are designing a canvas app for field service technicians. The app must capture photos of equipment and store them with the service record. Which control and data source combination is most suitable?

A.Camera control with Microsoft Dataverse
B.Add media control with Excel Online
C.Attachments control with SharePoint list
D.Image control with SharePoint list
AnswerA

The Camera control captures photos directly on the technician's device, and Microsoft Dataverse stores the image as a file column linked to the service record. This satisfies the requirement to persist photos alongside structured service data in one transactional store.

Why this answer

The Camera control in Power Apps captures photos directly from the device camera, and Microsoft Dataverse provides a secure, scalable data store with native support for image columns and relationships to service records. This combination is ideal for field service technicians who need to attach photos to structured service data with offline and security capabilities.

Exam trap

PL-900 often tests whether candidates confuse display controls (Image) with capture controls (Camera) and underestimate Dataverse's suitability for structured, secure field data.

How to eliminate wrong answers

Option B is wrong because the Add media control is used to upload existing media files, not capture photos, and Excel Online lacks robust relational data modeling and image storage for service records. Option C is wrong because the Attachments control works with SharePoint lists but is less integrated for camera capture and Dataverse offers better security, offline, and relationship features for field service. Option D is wrong because the Image control only displays images; it cannot capture photos, and SharePoint lists are not the optimal data source for structured service records compared to Dataverse.

131
MCQhard

A power user is designing a canvas app for inventory management. The app has a gallery that displays products. The user wants to filter the gallery to show only products with stock less than 10. Which formula should the user use in the Items property of the gallery?

A.LookUp(Products, Stock < 10)
B.Filter(Products, Stock < 10)
C.Sort(Products, Stock)
D.Search(Products, "10", "Stock")
AnswerB

The Filter function evaluates each record against the condition Stock < 10, returning only matching products to the gallery's Items property. This is the standard Power Fx approach for restricting displayed rows in a canvas app gallery based on a numeric column value.

Why this answer

The Filter function in Power Apps applies a condition to show only records where Stock < 10. Option A is wrong because LookUp returns a single record, not a filtered collection. Option C is wrong because Sort changes the order but does not filter.

Option D is wrong because Search is for text search, not numeric comparison.

132
MCQhard

A company has a Power Automate flow that uses a premium connector (e.g., SQL Server). Several users report that the flow fails with a '401 Unauthorized' error. The flow uses a service principal for authentication. What is the most likely cause?

A.The SQL Server connection string is incorrect.
B.The flow is not in the default environment.
C.The flow is exceeding API rate limits.
D.The service principal's certificate has expired.
AnswerD

An expired certificate breaks the service principal's client credential, so Microsoft Entra ID rejects the token request and the connector returns 401 Unauthorized. This directly satisfies the stem's authentication-failure constraint: the flow authenticates as a service principal, whose certificate-based secret must remain valid for token issuance to succeed.

Why this answer

Service principal certificates have expiration dates. When the certificate expires, authentication fails with a '401 Unauthorized' error. Option A is incorrect because a wrong connection string would produce a different error (e.g., 'Cannot connect to SQL Server').

Option B is irrelevant as the environment does not affect authentication. Option C is incorrect because rate limits cause '429 Too Many Requests', not 401.

133
MCQmedium

A support team uses a copilot built with Microsoft Copilot Studio to handle password reset requests. The copilot must collect the user's employee ID and then call an existing Power Automate cloud flow that performs the reset. The maker wants the copilot to pass the employee ID to the flow and return the result to the user. What should the maker configure in the copilot topic?

A.Add a condition node that checks whether the employee ID matches a pattern, then publish the copilot to Microsoft Teams.
B.Add a generative answers node that uses the employee ID as a knowledge source and lets the flow run automatically.
C.Add a question node for the employee ID, then add a call an action node that invokes the cloud flow and maps the employee ID variable to the flow input.
D.Add an HTTP request node that calls the Power Automate flow's trigger URL directly with the employee ID.
AnswerC

A question node captures the employee ID into a variable. The call an action node in Copilot Studio can invoke a Power Automate cloud flow and map that variable to the flow's input parameter. This allows the copilot to pass the employee ID, run the reset, and use the flow's output in the conversation.

Why this answer

The maker should use a question node to collect the employee ID and a call an action node to invoke the Power Automate cloud flow, mapping the variable to the flow input. This is the supported pattern for passing data from a copilot to a flow and returning results. Condition nodes, HTTP requests, and generative answers do not provide the same integrated flow invocation.

Exam trap

The trap here is assuming that any node that can call an external endpoint, such as an HTTP request, is equivalent to the built-in call an action integration for Power Automate flows.

134
MCQeasy

A non-profit organization wants to automate donation receipt emails and track donor engagement. Which Microsoft Power Platform tool should they use?

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

Power Automate provides event-driven flows that trigger on a new donation record, then send receipt emails and log donor interactions automatically. Its connectors to Microsoft 365 and Dynamics 365 satisfy both the notification and engagement-tracking requirements without custom code.

Why this answer

Power Automate is the correct tool because it enables the non-profit to create automated workflows that can trigger donation receipt emails when a new donation is recorded, and it can also update donor engagement metrics in a connected data source like Dataverse or SharePoint. This directly addresses the need for automating email notifications and tracking engagement without manual intervention.

Exam trap

The trap here is that candidates may confuse Power Automate with Power Apps, thinking that building a custom app is necessary to send emails, when in fact Power Automate is the dedicated tool for workflow automation and does not require a user interface to function.

How to eliminate wrong answers

Option B (Power Virtual Agents) is wrong because it is designed for building conversational AI chatbots, not for automating email workflows or tracking donor data. Option C (Power BI) is wrong because it is a data visualization and analytics tool, not an automation platform; it can report on donor engagement but cannot send emails or trigger actions. Option D (Power Apps) is wrong because it is used to build custom applications with user interfaces, not to automate backend processes like sending emails or updating records based on events.

135
Multi-Selecthard

Which THREE are common uses of connectors in Power Automate? (Choose three.)

Select 3 answers
A.Build a custom user interface
B.Create a record in Dataverse
C.Post a message to Microsoft Teams
D.Create a real-time dashboard
E.Send an email when a new record is created
AnswersB, C, E

Common data operation.

Why this answer

Connectors in Power Automate provide pre-built actions and triggers to interact with external services. The Dataverse connector includes a 'Create a new record' action, enabling automated creation of rows in Dataverse tables without custom code, directly from a flow.

Exam trap

The trap here is that candidates may confuse connectors with other Power Platform components, mistakenly thinking connectors can build UIs (Power Apps) or create dashboards (Power BI), when connectors are strictly for integration and automation.

136
MCQeasy

A retail company wants to analyze sales data from multiple stores and create interactive reports for regional managers. Which Power Platform component should they use?

A.Power Automate
B.Power BI
C.Power Apps
D.Microsoft Copilot Studio
AnswerB

Power BI delivers interactive dashboards and reports with visualisations, filtering, and drill-down across aggregated data sources. It satisfies the multi-store analysis requirement, letting regional managers explore sales figures by store, region, and period without building custom applications.

Why this answer

Power BI is the correct choice because it is Microsoft's business analytics service designed for visualizing data and sharing interactive reports. The scenario requires analyzing sales data from multiple stores and creating interactive reports for regional managers, which aligns directly with Power BI's core capabilities of data integration, interactive dashboards, and report sharing.

Exam trap

The trap here is that candidates often confuse Power BI with Power Apps, thinking that building an app is necessary for data interaction, when Power BI is specifically designed for data analysis and interactive reporting without requiring custom app development.

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 data analysis or interactive reporting. Option C is wrong because Power Apps is a low-code application development platform for building custom business apps, not for analyzing data or creating reports. Option D is wrong because Microsoft Copilot Studio is a tool for building custom copilots and AI assistants, not for data analysis or interactive reporting.

137
MCQhard

A maker is testing a Copilot Studio copilot that answers questions about travel expense policy. During testing, the copilot responds to 'What is the meal allowance?' with a generic reply instead of the policy value, even though the policy is in an uploaded file knowledge source. The maker wants to understand why the copilot did not use the uploaded document. Which factor most likely explains the behavior?

A.The copilot's generative answers orchestration may not have matched the question to the uploaded content, or the file source is not enabled for generative answers.
B.The copilot's theme colors do not match the company brand, causing the file to be ignored.
C.The copilot is published to a channel that does not support file uploads from users.
D.The maker did not write a custom topic with trigger phrases for every possible expense question.
AnswerA

Generative answers depend on the orchestration matching the user question to indexed content and on the knowledge source being enabled for generative answers. If the uploaded file is not enabled or the question phrasing does not retrieve the passage, the copilot falls back to a generic response. This is the most likely explanation for the observed behavior.

Why this answer

The most likely cause is a retrieval or enablement issue with the uploaded file knowledge source. Generative answers must have the source enabled and the orchestration must successfully match the question to indexed content. If either condition fails, the copilot produces a generic response.

Branding, channel upload support, and missing per-question topics do not govern whether an uploaded document is used.

Exam trap

The trap here is assuming generative answers always read every configured source, when retrieval depends on the source being enabled and the question matching indexed content.

138
MCQeasy

A sales team wants to receive a Microsoft Teams message whenever a new high-priority lead is created in Dynamics 365 Sales. They need to build this automation with the least effort. What should they use?

A.A Power Apps canvas app that queries Dynamics 365 and sends an email via Office 365 Outlook.
B.A Power BI dashboard that refreshes on a schedule and shows new leads.
C.A model-driven app business rule that posts a Teams message when a lead is created.
D.A Power Automate cloud flow with the Dynamics 365 'When a record is created' trigger and a Microsoft Teams 'Post message in a chat or channel' action.
AnswerD

This is correct because the Dynamics 365 connector provides a 'When a record is created' trigger that fires when a new lead record is created, and the Microsoft Teams connector offers a 'Post message in a chat or channel' action to notify the team. This combination directly meets the requirement with minimal configuration, using built-in connectors and no custom code.

Why this answer

The requirement is to automatically notify a team in Microsoft Teams when a new high-priority lead is created in Dynamics 365 Sales. Power Automate cloud flows are designed for exactly this kind of event-driven integration. The Dynamics 365 trigger detects the new record, and the Teams action posts the message.

No custom code or manual intervention is needed, making it the most efficient solution.

Exam trap

The trap here is assuming that a Power Apps app or a business rule can automatically send external notifications, when those tools are not event-driven integration services.

139
Drag & Dropmedium

Drag and drop the steps to set up a Microsoft Dataverse environment in the correct order.

Drag or tap steps into the slots.

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

Why this order

The admin center is used to create environments, specifying type, region, name, and database.

140
MCQmedium

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

A.Convert UTC to each time zone using Power Fx formulas
B.Store times in UTC and let Power Apps handle conversion automatically
C.Store local time in the database based on user's location
D.Use a Power Automate flow to convert time zones
AnswerB

Dataverse stores DateTime values in UTC, and Power Apps converts them to the signed-in user's local time zone for display and back to UTC on save. Storing UTC and relying on this automatic conversion satisfies the requirement to show each global sales user their own local time.

Why this answer

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

Exam trap

The trap is thinking that manual conversion or storing local time is necessary; candidates often overlook that Dataverse and Power Apps automatically handle UTC-to-local conversion when the correct behavior is set, and manual conversion introduces bugs.

How to eliminate wrong answers

Option A is wrong because manually converting UTC to each time zone using Power Fx formulas is error-prone, does not account for daylight saving time changes, and duplicates logic across the app. Option C is wrong because storing local time in the database based on user's location leads to data inconsistency, makes reporting across time zones difficult, and breaks when users travel or change time zones. Option D is wrong because using a Power Automate flow to convert time zones adds unnecessary complexity and latency, and the platform already handles conversion automatically.

141
Drag & Dropmedium

Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.

Drag or tap steps into the slots.

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

Why this order

The correct sequence for creating a Power BI report from a Dataverse table is to first connect to the Dataverse source, then load the data into Power BI, then build visuals (like charts and tables), and finally publish the report to the Power BI service for sharing. This order ensures a logical workflow where each step depends on the previous one.

142
MCQhard

A company has a Power Automate cloud flow that processes invoices. The flow uses a condition to check if the invoice amount is greater than $10,000. If true, it sends an approval request to the finance manager. The flow is not sending approval requests for some invoices that exceed $10,000. What is the most likely cause?

A.The flow's trigger is set to run only on weekdays, and some invoices are created on weekends.
B.The condition is using the 'is greater than' operator, but the invoice amount field is stored as text.
C.The approval action is inside an 'Apply to each' loop that is not iterating over all invoices.
D.The approval action is configured to send to a user who is out of office.
AnswerB

If the invoice amount is stored as text, the 'is greater than' comparison may perform a string comparison instead of a numeric one. For example, the string '9000' would be considered greater than '10000' because '9' is greater than '1' lexicographically. This would cause incorrect evaluations, leading to missed approvals for amounts over $10,000. Converting the field to a number before comparison resolves the issue.

Why this answer

The most likely cause is a data type mismatch in the condition. If the invoice amount is stored as text, the 'is greater than' comparison uses lexicographic ordering, causing incorrect results. For example, '9000' is considered greater than '10000'.

Converting the field to a numeric type or using a numeric function in the condition ensures accurate comparison. Other options would cause different symptoms, such as no runs at all or all approvals failing.

Exam trap

The trap here is assuming that the 'is greater than' operator always performs numeric comparison, but it depends on the data type of the operands.

143
MCQhard

A manufacturing company uses a copilot built with Microsoft Copilot Studio to help technicians report equipment faults. When a technician confirms a fault, the copilot must create a work order in the company's field service system and return the new work order number to the technician in the same conversation. The field service system exposes a REST API. Which approach should a maker use?

A.Add the field service system as a knowledge source and let generative answers create the work order
B.Configure an authentication provider so the technician signs in with their field service credentials before confirming the fault
C.Use a message node that instructs the technician to open the field service portal and create the work order manually
D.Call a Power Automate cloud flow from a topic and return the work order number as a variable to the conversation
AnswerD

Microsoft Copilot Studio topics can invoke a Power Automate cloud flow as an action. The flow calls the field service REST API, creates the work order, and returns the work order number to the copilot as an output variable. The topic can then display that variable to the technician within the same conversation, meeting both requirements.

Why this answer

Creating a record in an external system requires an action, and in Microsoft Copilot Studio the standard no-code bridge to a REST API is a Power Automate cloud flow invoked from a topic. The flow performs the write and returns the work order number, which the topic stores as a variable and presents to the technician. Knowledge, manual instructions, and authentication alone cannot create the record or return its identifier.

Exam trap

The trap here is assuming that adding a system as a knowledge source lets the copilot perform transactions, when knowledge sources only supply read-only content for answers.

144
MCQhard

A company has configured the copilot as shown in the exhibit. Users report that the copilot is not answering questions about HR policies that were updated in the SharePoint site today. What is the most likely cause?

A.The public website refresh is set to daily
B.Authentication is not properly configured
C.The knowledge source refresh interval is set to weekly
D.Generative AI is disabled
AnswerC

Copilot answers from indexed SharePoint content, and a weekly refresh interval means today's HR policy updates have not yet been crawled into the index. Shortening the refresh interval, or triggering reindexing, makes the new content answerable.

Why this answer

The copilot's knowledge source refresh interval is set to weekly, meaning it only re-indexes the SharePoint site every seven days. Since the HR policies were updated today, the copilot is still using the stale, pre-update content and cannot answer questions about the new policies until the next scheduled refresh occurs.

Exam trap

The trap here is that candidates confuse the refresh interval setting with authentication or AI enablement, assuming that any failure to answer new content must be a permissions or AI feature issue, rather than recognizing that the copilot simply hasn't re-indexed the updated source yet.

How to eliminate wrong answers

Option A is wrong because the public website refresh setting controls how often the copilot re-indexes a public website, not a SharePoint site; the exhibit shows a SharePoint knowledge source, so this setting is irrelevant. Option B is wrong because authentication configuration affects user sign-in and data access permissions, not the frequency of content indexing; if authentication were misconfigured, users would likely see access errors, not a lack of updated answers. Option D is wrong because disabling generative AI would prevent the copilot from generating any responses at all, not just from answering about today's updates; users would report no answers to any questions, not just HR policy questions.

145
MCQeasy

A company wants to build a Power Pages site that allows external partners to submit project proposals. The proposals should be stored in Dataverse. What is the first step to create the necessary data structure?

A.Create a Power Automate flow to collect data
B.Create a SharePoint list
C.Create a custom table in Dataverse
D.Create an Excel file in OneDrive
AnswerC

Dataverse requires a table before any data can be stored, so creating a custom table for project proposals establishes the schema the site will bind to. This satisfies the first-step requirement of building the necessary data structure.

Why this answer

Power Pages sites store data in Dataverse, so the first step is to create the custom table (entity) in Dataverse that will hold the project proposals. Once the table exists, you can build forms, views, and permissions in Power Pages that bind to it. Creating the data structure precedes any flow, list, or file-based storage.

Exam trap

The trap is jumping to automation (Power Automate) or a familiar storage tool (SharePoint/Excel) instead of recognizing that Power Pages is natively backed by Dataverse and the data structure must be created there first.

How to eliminate wrong answers

Option A is wrong because a Power Automate flow orchestrates actions but does not define the data structure; you still need a table to store proposals. Option B is wrong because SharePoint lists are a different data store and the requirement explicitly says proposals should be stored in Dataverse. Option D is wrong because an Excel file in OneDrive is not Dataverse and does not provide the relational, security, and Power Pages integration that Dataverse offers.

146
MCQeasy

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

A.Reduce the number of fields in the SharePoint list.
B.Instruct managers to use a wired network connection instead of Wi-Fi.
C.Implement a custom API to handle updates.
D.Migrate the app to use a Microsoft Dataverse database.
AnswerD

Microsoft Dataverse provides a relational, indexed backend with delegation and server-side query processing, unlike the canvas app's current data source which struggles under concurrent load. Migrating removes the timeout bottleneck when multiple store managers update stock simultaneously.

Why this answer

Migrating the canvas app to use Microsoft Dataverse improves performance because Dataverse is a relational, transactional data store designed for high-concurrency access, unlike SharePoint lists which have throttling limits and are not optimized for frequent simultaneous updates. Dataverse provides built-in indexing, delegation, and scalability that reduce load times and prevent timeouts when multiple managers use the app concurrently. This directly addresses the root cause of the slowdown: the underlying data platform's limitations.

Exam trap

PL-900 often tests the misconception that SharePoint is always sufficient for Power Apps data storage, when in fact high-concurrency or performance-sensitive apps require Dataverse.

How to eliminate wrong answers

Option A is wrong because reducing the number of fields in a SharePoint list may slightly reduce payload size but does not solve the fundamental concurrency and throttling issues that cause timeouts under simultaneous use. Option B is wrong because instructing managers to use wired connections addresses only client-side network latency and does not fix the server-side data platform bottleneck. Option C is wrong because implementing a custom API adds complexity and does not replace the need for a scalable data store; it may even introduce new performance issues if not properly designed.

147
MCQeasy

You need to create a flow that runs every hour and checks if any new files have been added to a SharePoint document library. Which trigger type should you use?

A.Compose
B.When an item is created
C.Recurrence
D.Power Apps button
AnswerC

The Recurrence trigger fires at fixed intervals, such as every hour, then the flow queries SharePoint for newly added files. This satisfies the hourly schedule requirement, since event-based triggers cannot guarantee a regular time interval.

Why this answer

The Recurrence trigger is the correct choice because it initiates a flow on a fixed schedule (e.g., every hour) regardless of any events occurring in SharePoint. This trigger is ideal for polling scenarios where you need to periodically check for new files, as it runs autonomously without requiring an external event.

Exam trap

The trap here is that candidates often confuse event-driven triggers (like 'When an item is created') with schedule-based triggers, assuming that a trigger that reacts to new items can also run on a timer, but in Power Automate, triggers are mutually exclusive—they either respond to events or run on a schedule, not both.

How to eliminate wrong answers

Option A is wrong because Compose is an action, not a trigger; it is used to combine or transform data within a flow, not to start one. Option B is wrong because 'When an item is created' is an event-driven trigger that fires immediately when a new file is added to SharePoint, but it does not run on a recurring schedule—it would execute once per new file, not every hour. Option D is wrong because a Power Apps button trigger requires manual user interaction from within a Power Apps application, making it unsuitable for an automated hourly check.

148
MCQmedium

A Power Automate flow uses an approval action. The approver can choose 'Approve', 'Reject', or 'Reassign'. The flow needs to send a different email based on the approver's choice. Which action should be used after the approval?

A.Apply to each
B.Parallel branch
C.Do until
D.Condition
AnswerD

The approval action returns an outcome value, and a Condition action evaluates that value to branch the flow, sending a distinct email for each of the three responses. This satisfies the requirement to route different emails based on the approver's choice.

Why this answer

The Condition action in Power Automate evaluates the output of the approval action (e.g., the 'outcome' field) and routes the flow down different branches based on whether the approver selected 'Approve', 'Reject', or 'Reassign'. This is the correct choice because it directly maps the three possible approval outcomes to distinct email actions using conditional logic.

Exam trap

The trap here is that candidates often confuse iterative or parallel constructs (Apply to each, Parallel branch) with conditional branching, failing to recognize that only Condition (or Switch) can evaluate the discrete outcome of an approval action to send different emails.

How to eliminate wrong answers

Option A is wrong because 'Apply to each' iterates over an array of items (e.g., a list of emails) and is not designed to evaluate a single approval outcome to branch logic. Option B is wrong because 'Parallel branch' runs multiple actions simultaneously without any conditional evaluation—it cannot choose one path based on the approver's choice. Option C is wrong because 'Do until' repeats actions until a condition becomes true (e.g., waiting for an approval to complete), but it does not provide branching logic to send different emails after the approval is decided.

149
MCQhard

A company's Power Platform environment has a Dataverse table with a business rule that sets the 'Status' field to 'Expired' when 'EndDate' is in the past. However, the rule does not apply retroactively. How can the administrator enforce the rule for existing records?

A.Manually update the records using Excel import.
B.Create a calculated field that computes the status.
C.Create a Power Automate flow that runs on existing records and updates the status.
D.Modify the business rule to run on load for all records.
AnswerC

A Power Automate flow can query the Dataverse table, evaluate each record's EndDate against the current date, and update Status accordingly. This applies the rule retroactively to existing rows, which the table's business rule cannot do on its own.

Why this answer

Business rules in Dataverse do not apply retroactively to existing records; they only trigger on new or updated records. A Power Automate flow can be configured to query all existing records where 'EndDate' is in the past and 'Status' is not 'Expired', then update the 'Status' field accordingly. This provides a scalable, automated solution without manual intervention.

Exam trap

The trap here is that candidates assume business rules can be made retroactive by modifying their trigger conditions, but business rules in Dataverse are inherently form-based and cannot apply to existing records without an external automation tool like Power Automate.

How to eliminate wrong answers

Option A is wrong because manually updating records via Excel import is error-prone, time-consuming, and does not leverage the platform's automation capabilities; it also bypasses the business rule logic entirely. Option B is wrong because a calculated field computes a value based on other fields but cannot update the 'Status' field directly—calculated fields are read-only and cannot trigger business rules or workflows. Option D is wrong because business rules cannot be configured to 'run on load' for all records; they only execute on form load for new or updated records, not retroactively on existing data.

150
MCQhard

Refer to the exhibit. A Power Automate flow uses the 'Microsoft Forms' connector with this output. Which AI Builder model should be used to categorize this feedback as 'AppFeedback'?

A.Language detection
B.Category classification
C.Sentiment analysis
D.Entity extraction
AnswerB

Category classification trains on labelled text examples to assign predefined tags, so free-text form responses can be sorted into buckets such as 'AppFeedback'. Text recognition and form processing handle extraction, not sentiment or topic assignment.

Why this answer

The 'Category classification' AI Builder model is designed to assign predefined categories to text, such as classifying feedback as 'AppFeedback'. This model uses a custom trained classifier to map input text to specific labels, making it the correct choice for categorizing form responses into distinct categories like 'AppFeedback'.

Exam trap

The trap here is that candidates confuse 'category classification' with 'sentiment analysis' because both involve analyzing text, but sentiment analysis only evaluates emotional polarity, not predefined categorical labels.

How to eliminate wrong answers

Option A is wrong because 'Language detection' identifies the language of the text (e.g., English, Spanish), not its category or topic. Option C is wrong because 'Sentiment analysis' measures emotional tone (positive, negative, neutral), not categorical classification. Option D is wrong because 'Entity extraction' identifies and extracts specific data points like names, dates, or locations from text, but does not assign the entire text to a predefined category.

Page 1

Page 2 of 10

Page 3

All pages