Knowledge + Practice

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

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

Take a mock exam Exam hub

Page 5 of 10

301

MCQeasy

A marketing team wants to create a public Power Pages site to showcase upcoming events. They need to update event details frequently without developer assistance. What is the recommended approach?

A.Hardcode the event details in the page source.

B.Store events in a Dataverse table and use a list component to display them.

C.Use a SharePoint list and connect it to the portal.

D.Edit the Liquid template each time an event changes.

AnswerB

Dataverse provides structured storage with a list component that renders records on the page, so marketers edit rows directly without developer involvement. This satisfies the frequent-update requirement while keeping the public site's event content maintainable by non-technical staff.

Why this answer

Power Pages integrates natively with Microsoft Dataverse, and list components can display Dataverse table records on a page. Storing event details in a Dataverse table lets marketing staff update records through model-driven apps or Power Apps without touching the portal's code, satisfying the no-developer requirement.

Exam trap

PL-900 often tests the misconception that SharePoint is the default data source for Power Pages — candidates familiar with SharePoint may pick it, but Dataverse is the native, recommended integration.

How to eliminate wrong answers

Option A is wrong because hardcoding event details in page source requires developer intervention for every update and is not maintainable. Option C is wrong because while SharePoint lists can be used as data sources in some Power Platform contexts, Power Pages' native and recommended data source is Dataverse; SharePoint integration adds complexity and is not the primary supported pattern for Power Pages lists. Option D is wrong because editing Liquid templates manually is a developer task and defeats the goal of frequent, no-code updates.

Full explanation →

302

MCQeasy

A company wants to automate the approval process for purchase orders. Which Power Platform component should they use?

A.Power BI

B.Power Virtual Agents

C.Power Apps

D.Power Automate

AnswerD

Power Automate provides approval workflows with built-in connectors and approval actions, routing purchase orders to the right approvers automatically. This directly satisfies the automation requirement, replacing manual email-based approvals with a governed, auditable flow triggered by the purchase order record.

Why this answer

Power Automate is the correct component because it is designed to automate workflows, including approval processes for purchase orders. It can trigger actions based on events, route documents for approval, and integrate with various data sources, making it ideal for streamlining business processes like purchase order approvals.

Exam trap

The PL-900 exam often tests the distinction between building an app (Power Apps) and automating a process (Power Automate), leading candidates to mistakenly choose Power Apps because they think an approval 'app' is needed, when the actual requirement is workflow automation.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating approval workflows. Option B is wrong because Power Virtual Agents is used to build conversational AI chatbots, not to automate backend approval processes. Option C is wrong because Power Apps is a low-code platform for building custom applications, but it does not natively handle workflow automation or approval routing; that requires Power Automate or a separate workflow engine.

Full explanation →

303

MCQhard

You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?

A.Switch action with cases for each range

B.Apply to each with a condition inside

C.Condition action with nested conditions

D.Parallel branches for both approval paths

AnswerC

Nested conditions let the flow first test whether the expense exceeds $5,000, then apply a second condition for the $1,000-$5,000 band. This branching satisfies the three-tier approval requirement, routing to both approvers, manager only, or none.

Why this answer

The Condition action in Power Automate supports nested conditions, allowing you to evaluate the expense amount in a hierarchical manner: first check if it exceeds $5,000 (requiring both manager and finance director approval), then within the 'No' branch, check if it's between $1,000 and $5,000 (requiring only manager approval), and finally handle the under $1,000 case. This structure directly mirrors the decision tree described in the requirements. The Condition action is the native control for if-then-else logic in Power Automate, and nesting provides the necessary multi-level branching without unnecessary complexity.

Exam trap

PL-900 often tests the misconception that Switch is suitable for range-based conditions, but Switch only works with discrete values; candidates must recognize that nested Condition actions are required for multi-level if-then-else logic.

How to eliminate wrong answers

Option A is wrong because a Switch action is designed for discrete value matching (e.g., exact strings or numbers) and cannot efficiently handle range-based conditions like 'greater than $5,000' or 'between $1,000 and $5,000' without creating many cases, which is impractical and error-prone. Option B is wrong because Apply to each is used for iterating over a collection, not for conditional branching; placing a condition inside would require an array to loop over, which is not present in this scenario. Option D is wrong because Parallel branches execute simultaneously and are used for independent tasks, not for mutually exclusive approval paths based on a single expense amount; they would cause both approval processes to run regardless of the amount.

Full explanation →

304

MCQhard

Refer to the exhibit. This Power Automate flow is triggered manually via HTTP request. The action 'Send_approval_email' sends an email. What is a potential issue with this flow design?

A.The manual trigger cannot be used for HTTP requests.

B.The authentication parameter is missing.

C.The flow does not include an approval action, only an email notification.

D.The email action uses deprecated parameters.

AnswerC

The 'Send_approval_email' action only notifies recipients; it does not itself capture a decision. Without a dedicated approval action such as 'Start and wait for an approval', the flow cannot receive or act on a response, so the design lacks the actual approval mechanism the process requires.

Why this answer

The flow is named 'Send_approval_email' and the question states it sends an email, but the design only performs a notification action rather than using Power Automate's dedicated Approvals connector (Start and wait for an approval). Without an approval action, the flow cannot capture an approve/reject decision or branch on the outcome, so it fails to fulfill its stated purpose. The HTTP request trigger is valid, authentication is a separate concern, and the email action is not deprecated.

Exam trap

PL-900 often tests whether candidates recognize that sending an email is not the same as requesting an approval — the Approvals connector is a distinct, purpose-built action, and naming a flow 'Send_approval_email' does not make it an approval flow.

How to eliminate wrong answers

Option A is wrong because Power Automate's 'When an HTTP request is received' trigger explicitly supports manual HTTP invocation and is a standard trigger type. Option B is wrong because while authentication on HTTP triggers is a best practice, the question's core design flaw is the missing approval action, not authentication. Option D is wrong because the standard 'Send an email' action is current and not deprecated; deprecation is not the issue here.

Full explanation →

305

MCQhard

A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?

A.Use a Power Apps component framework (PCF) control to trigger an email.

B.Create a Power Automate flow with a trigger 'When a record is updated' and condition on status change.

C.Add a button on the form that runs a Power Automate flow on demand.

D.Create a business rule that sends an email when the status is updated.

AnswerB

A Power Automate flow triggered by 'When a record is updated' fires server-side on the Dataverse table, and a condition comparing the prior and new status values detects the transition to 'Resolved'. This satisfies the automatic email requirement without user interaction.

Why this answer

To automatically send an email when a record's status changes to 'Resolved', the best approach is to create a Power Automate flow with a trigger 'When a record is updated' and a condition that checks if the status field changed to 'Resolved'. This provides a no-code, automated solution that runs in the background.

Exam trap

PL-900 often tests the capabilities of business rules versus Power Automate; candidates may think business rules can send emails, but they cannot.

How to eliminate wrong answers

Option A is wrong because PCF controls are for custom UI components, not for triggering backend automation like sending emails. Option C is wrong because a button requires manual user action, whereas the requirement is automatic. Option D is wrong because business rules cannot send emails; they can only set field values, show messages, or set requirements.

Full explanation →

306

MCQmedium

A facilities team built a copilot in Microsoft Copilot Studio that answers questions about building access policies. The knowledge is stored in a public Microsoft SharePoint site. Users report the copilot returns generic answers instead of citing the policy documents. The maker confirmed the SharePoint URL is added as a knowledge source. What should the maker verify first?

A.That the copilot's authentication mode is set to no authentication.

B.That the copilot is published to the correct Microsoft Teams channel.

C.That the SharePoint site is published and the copilot's knowledge source is enabled and indexed.

D.That the SharePoint site uses a custom theme with the correct branding.

AnswerC

Generative answers rely on enabled, successfully indexed knowledge sources. If the SharePoint source is disabled or indexing failed, the copilot falls back to generic model responses. Verifying that the source is enabled and indexed directly addresses the symptom of generic answers despite a configured URL. This is the first diagnostic step before changing topics or authentication settings.

Why this answer

When a copilot returns generic answers despite a configured SharePoint knowledge source, the most likely cause is that the source is disabled or has not finished indexing. Generative answers require an enabled, indexed source to retrieve and cite content. Confirming enablement and index status is the correct first diagnostic action before altering channels, themes, or authentication.

Exam trap

The trap here is assuming a configured URL is automatically an active knowledge source, when the source must also be enabled and successfully indexed.

Full explanation →

307

MCQeasy

A user wants to build a chatbot to answer common IT support questions, such as password reset and software installation steps. Which Power Platform tool should they use?

A.Power Apps

B.Power Automate

C.Power BI

D.Power Virtual Agents

AnswerD

Power Virtual Agents builds conversational chatbots through a guided, no-code authoring canvas, handling password reset and software installation queries via topics and trigger phrases. It meets the IT support self-service requirement without custom development or Azure Bot Service configuration.

Why this answer

Power Virtual Agents (D) is the correct tool because it is specifically designed to create conversational AI chatbots without requiring coding. It enables users to build a bot that can handle common IT support queries like password resets and software installation steps by defining topics, trigger phrases, and dialog flows, integrating with backend systems via Power Automate or connectors.

Exam trap

The trap here is that candidates may confuse Power Virtual Agents with Power Automate, thinking a chatbot requires workflow automation, but Power Automate handles backend processes, not the conversational front-end itself.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating chatbots. Option B is wrong because Power Automate is a workflow automation tool for orchestrating processes and integrating services, not for building conversational interfaces. Option C is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for chatbot development.

Full explanation →

308

MCQeasy

A user wants to create a flow that runs when a specific button is clicked in a mobile app. Which type of flow should be used?

A.Instant flow

B.Business process flow

C.Scheduled flow

D.Automated flow

AnswerA

Instant flows are triggered manually by the user, including from a button in the Power Automate mobile app. This matches the requirement for on-demand execution when a specific button is clicked, unlike automated or scheduled flows that run without direct user initiation.

Why this answer

An instant flow is triggered manually by a user action, such as clicking a button in a mobile app, and runs on demand. Power Automate provides a mobile app where users can trigger instant flows with a button, making it the correct flow type for this requirement. Instant flows are designed for manual initiation, unlike automated or scheduled flows.

Exam trap

PL-900 often tests the distinction between instant, automated, and scheduled flows, so candidates must recognize that a button click in a mobile app is a manual trigger, which defines an instant flow.

How to eliminate wrong answers

Option B is wrong because a business process flow is a model-driven app feature that guides users through stages of a business process, not a flow triggered by a button in the mobile app. Option C is wrong because a scheduled flow runs automatically at a specified time or recurrence, not on a button click. Option D is wrong because an automated flow is triggered by an event such as a new email or file creation, not by a manual button press.

Full explanation →

309

MCQhard

You are designing a model-driven app for a sales team. The app must show related opportunities on an account form using a subgrid. The subgrid should only display open opportunities. Which configuration should you apply?

A.Add a subgrid and select a view that filters for status equals 'Open'

B.Use a business rule to hide closed opportunities

C.Set a calculated field to mark opportunities as open

D.Create a workflow to remove closed opportunities from the subgrid

AnswerA

A subgrid can bind to a saved view, and that view's filter criteria control which records appear. Filtering on the opportunity status field to 'Open' satisfies the requirement that only open opportunities display, without extra code or JavaScript. The subgrid then renders exactly the filtered dataset on the account form.

Why this answer

To display only open opportunities in a subgrid, you should select a view that filters for status equals 'Open'. This ensures that the subgrid shows only the relevant records. The view can be a system view or a custom view with the appropriate filter.

Exam trap

PL-900 often tests the configuration of subgrids and views, and candidates may think that business rules or workflows can filter subgrid data, but only views control what is displayed.

How to eliminate wrong answers

Option B is wrong because business rules are used to enforce logic on forms, not to filter subgrid data. Option C is wrong because a calculated field cannot control which records appear in a subgrid; it only computes values. Option D is wrong because a workflow cannot dynamically remove records from a subgrid; it can update records but not filter the display.

Full explanation →

310

Multi-Selectmedium

Which THREE of the following are core components of Microsoft Power Platform? (Select three.)

Select 3 answers

A.Power Automate

B.Azure Logic Apps

C.Dynamics 365

D.Power BI

E.Power Apps

AnswersA, D, E

Power Automate is one of the three core components of Microsoft Power Platform, alongside Power Apps and Power BI. It supplies the workflow and process-automation layer, letting users build automated flows that connect services and trigger actions without custom code.

Why this answer

Power Automate (A) is a core Power Platform component, providing workflow automation and RPA capabilities (cloud flows and desktop flows) that connect services via connectors. Power BI (D) is also a core component, delivering business analytics, interactive dashboards, and reports over data from many sources. Power Apps (E) is the third core component, enabling low-code/no-code app development with canvas, model-driven, and portal apps.

Azure Logic Apps (B) is a separate Azure service for integration workflows, not part of Power Platform, and Dynamics 365 (C) is a family of business applications that can integrate with Power Platform but is not one of its core components.

Exam trap

The trap here is that candidates often confuse Azure Logic Apps with Power Automate because both offer workflow automation, but the PL-900 exam specifically tests that Logic Apps is an Azure service, not a Power Platform core component.

Full explanation →

311

MCQeasy

A company wants to allow external users to access a Power Pages site without requiring them to sign in. Which authentication setting should be configured?

A.Configure Microsoft Entra ID as the identity provider

B.Set up local authentication with username and password

C.Enable anonymous access in the site settings

D.Create a web role that grants access to everyone

AnswerC

Enabling anonymous access in the site settings removes the authentication requirement entirely, letting external users browse the Power Pages site without signing in. This directly satisfies the stem's constraint of access without credentials, unlike Microsoft Entra ID options that would force sign-in.

Why this answer

Enabling anonymous access in the site settings allows users to browse the Power Pages site without signing in. Option A is incorrect because configuring Microsoft Entra ID as the identity provider requires authentication. Option B is incorrect because local authentication also requires sign-in.

Option D is incorrect because creating a web role for everyone still requires authentication; web roles are for authorization after authentication.

Full explanation →

312

MCQeasy

Which Power Platform component provides a low-code platform to build custom business applications that can be embedded in Microsoft Teams?

A.Power BI

B.Power Apps

C.Power Virtual Agents

D.Power Automate

AnswerB

Power Apps provides a low-code canvas and model-driven designer for building custom business applications, and its apps can be surfaced as tabs and personal apps inside Microsoft Teams, meeting the embedding requirement without bespoke code.

Why this answer

Power Apps is the correct answer because it is the low-code platform within Microsoft Power Platform specifically designed for building custom business applications. These apps can be directly embedded into Microsoft Teams via the 'Power Apps' tab or personal app, allowing users to interact with the app without leaving the Teams interface.

Exam trap

The trap here is that candidates may confuse Power Automate (automation) or Power BI (analytics) with app building, but only Power Apps provides the low-code application development capability required for custom business apps in Teams.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not an application builder; it creates reports and dashboards, not custom business apps. Option C is wrong because Power Virtual Agents is a chatbot service for creating conversational AI agents, not for building custom business applications. Option D is wrong because Power Automate is a workflow automation service for creating automated processes between apps and services, not for building custom business applications.

Full explanation →

313

Multi-Selectmedium

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

Select 2 answers

A.Provides seamless integration with Microsoft 365 and Azure services.

B.Only works with on-premises data sources.

C.Eliminates the need for any manual data entry.

D.Requires extensive programming knowledge to build solutions.

E.Enables rapid development and deployment of custom applications.

AnswersA, E

Power Platform connectors surface Microsoft 365 data and Azure services directly within apps and flows, so makers reuse existing identities, data and logic rather than building bespoke integrations, which is the integration benefit cited for business process automation.

Why this answer

Option A is correct because Power Platform is natively built into the Microsoft ecosystem, offering out-of-the-box connectors to Microsoft 365 services (SharePoint, Teams, Outlook, Dataverse) and Azure services (Azure Functions, Logic Apps, Service Bus), which lets makers integrate existing enterprise data and identity without custom middleware. Option E is correct because low-code/no-code tools such as Power Apps, Power Automate, and Power Virtual Agents allow citizen developers and pro developers to build, test, and publish apps and flows in hours or days rather than weeks, accelerating delivery of custom business solutions. Option B is incorrect because Power Platform supports hundreds of cloud and on-premises connectors via the on-premises data gateway, so it is not limited to on-premises sources.

Option C is incorrect because automation can reduce manual entry but cannot universally eliminate it, since human input, approvals, and exception handling are often still required. Option D is incorrect because Power Platform is explicitly a low-code platform, so extensive programming knowledge is not a prerequisite for building solutions.

Exam trap

The trap here is that candidates may assume Power Platform is limited to on-premises or cloud-only (Option B) or that it completely eliminates manual work (Option C), but the exam tests the understanding that it supports both environments and reduces—not eliminates—manual data entry.

Full explanation →

314

Multi-Selecteasy

Which TWO capabilities are provided by Power Automate flows?

Select 2 answers

A.Automate tasks in cloud services like SharePoint and Outlook

B.Design relational databases for analytics

C.Manage user permissions in Microsoft Entra ID

D.Create desktop-based automation for legacy systems

E.Build custom user interfaces for mobile apps

AnswersA, D

Cloud flows connect to services such as SharePoint and Outlook through connectors, automating tasks and approvals without on-premises infrastructure. This satisfies the capability of automating cloud-service tasks, distinct from desktop flows that drive local applications.

Why this answer

Power Automate provides cloud flows that connect to services such as SharePoint and Outlook to automate tasks like triggering a flow when a file is added or sending an email automatically, so option A is correct. It also provides desktop flows (formerly UI flows) through Power Automate Desktop, which use robotic process automation (RPA) to interact with legacy systems that lack APIs, so option D is correct. Option B is not a Power Automate capability because relational database design for analytics is handled by tools like Azure SQL Database, Microsoft Fabric, or Power BI data modeling.

Option C is incorrect because managing user permissions in Microsoft Entra ID is done through the Entra admin center, Microsoft Graph, or PowerShell, not Power Automate flows. Option E is incorrect because building custom mobile app user interfaces is the role of Power Apps, not Power Automate.

Exam trap

PL-900 often tests whether candidates confuse Power Automate with Power Apps or Dataverse, leading them to pick options about UI building or database design that belong to other Power Platform components.

Full explanation →

315

MCQmedium

A company wants to give external partners a secure, branded website where they can view and update order information stored in Dataverse. Partners should sign in with their own credentials, and the company wants to control which records each partner can see. Which Power Platform capability should the company use?

A.A model-driven app with a custom site map

B.A Power Automate approval flow

C.A canvas app shared with guest users

D.Power Pages

AnswerD

Power Pages is designed to create external-facing websites that surface Dataverse data to users outside the organization. It supports authentication with external identities, branding, and table permissions that control which records each partner can access. This directly matches the requirement for a secure, branded partner portal backed by Dataverse.

Why this answer

Power Pages provides the external-facing website capability with authentication, branding, and Dataverse table permissions needed to give partners controlled access to order data. It is the Power Platform component purpose-built for external users, unlike canvas or model-driven apps, which target internal audiences, or automation flows, which do not present a web interface.

Exam trap

The trap here is assuming that sharing an internal app with guest accounts creates a proper partner portal, when external-facing sites with record-level permissions are the domain of Power Pages.

Full explanation →

316

MCQeasy

You need to design a Power Automate flow that sends a welcome email to a new user immediately after their account is created in Microsoft Entra ID. Which trigger should you use?

A.When a user is removed

B.When a group is added

C.When a user is updated

D.When a user is added

AnswerD

The 'When a user is added' trigger fires on Microsoft Entra ID user-creation events, satisfying the requirement to send the welcome email immediately after account creation. It is the native Entra ID connector trigger designed for this event.

Why this answer

'When a user is added' triggers when a new user is created. Option A is wrong because it triggers when a user is deleted, not created. Option B is wrong because it triggers when a group is added, not a user.

Option C is wrong because it triggers when a user is updated, not created.

Full explanation →

317

Multi-Selecteasy

Which TWO scenarios are appropriate for using Power Automate? (Choose two.)

Select 2 answers

A.Creating a dashboard to visualize sales trends

B.Copying files from one SharePoint folder to another when a new file is added

C.Building a custom user interface for data entry

D.Sending an approval request when a new expense report is submitted

AnswersB, D

A SharePoint trigger firing when a file is added, followed by a copy action to another folder, is classic event-driven automation with no human interaction. This matches Power Automate's core purpose: connecting services and moving data automatically, satisfying the scenario's file-transfer requirement without manual intervention.

Why this answer

Option B is correct because Power Automate is a workflow automation service that can use a SharePoint trigger such as 'When a file is created in a folder' to automatically copy the new file to another SharePoint folder, which is a classic event-driven automation scenario. Option D is correct because Power Automate natively supports approval workflows via the Approvals connector, so when a new expense report is submitted it can trigger an approval request and route it to the appropriate approver. Option A is not appropriate because dashboards for visualizing sales trends are built with Power BI, not Power Automate.

Option C is not appropriate because building a custom data-entry user interface is done with Power Apps, whereas Power Automate handles background process automation rather than UI creation.

Exam trap

The trap here is that candidates confuse Power Automate with Power BI or Power Apps, mistakenly selecting options that involve visualization or UI creation, when the exam specifically tests the ability to identify automation scenarios that rely on event-driven triggers and actions.

Full explanation →

318

Multi-Selecthard

A logistics company is using Microsoft Copilot Studio to build a copilot that helps dispatchers track shipments. The company wants to use generative answers to respond to natural language questions about shipping policies. Which TWO actions must the company take to enable generative answers for this copilot? (Choose two.)

Select 2 answers

A.Create a custom entity for shipping terms and map it to the knowledge source.

B.Publish the copilot to Microsoft Teams to activate generative answers.

C.Configure a Power Automate flow to retrieve answers from an external database.

D.Enable the generative answers option in the copilot's settings or in a specific topic.

E.Add at least one knowledge source, such as a SharePoint site or a website, to the copilot.

AnswersD, E

Generative answers must be explicitly enabled, either at the copilot level or within a topic that uses the generative answers node. This setting allows the copilot to use AI to synthesize responses from the knowledge sources. Without enabling it, the copilot will not generate answers even if knowledge sources exist. Therefore, this action is required to meet the scenario's goal.

Why this answer

To use generative answers in Copilot Studio, you must add at least one knowledge source containing the information the copilot will draw from, and you must enable generative answers in the copilot's settings or within a topic. These two actions are essential. Other actions like creating custom entities, adding a Power Automate flow, or publishing to a channel are not required to enable the feature.

Exam trap

The trap here is thinking that publishing the copilot or adding custom entities enables generative answers, when the actual requirements are a knowledge source and enabling the feature in settings.

Full explanation →

319

MCQhard

A Power Pages site uses a custom Liquid template to display a list of upcoming events. The events are stored in a Dataverse table with a date field. The template should only show events that occur in the future. Which Liquid filter or condition is most appropriate?

A.Use the 'where' filter with a date comparison.

B.Use the 'date' filter to format dates and then compare strings.

C.Use an 'if' condition inside the 'for' loop to compare event date to current date.

D.Use the 'group_by' filter to group events by date and then select future ones.

AnswerC

Liquid has no date-comparison filter that evaluates against the current time, so the loop must test each event's date field against today's date using an 'if' condition. This excludes past events from the rendered list.

Why this answer

Liquid does not have a built-in date-comparison filter that can evaluate 'is this date in the future' against the current time, so the reliable approach is to iterate the events with a for loop and use an if condition to compare each event's date to the current date (e.g., using 'now' or a date captured at render time). This filters the collection at render time and only outputs future events.

Exam trap

PL-900 often tests the limits of Liquid filters — candidates assume 'where' can do date comparisons like a SQL WHERE clause, but Liquid's 'where' only does simple equality/matching, so the correct answer is the explicit if condition inside the loop.

How to eliminate wrong answers

Option A is wrong because the 'where' filter in Liquid compares attribute values for equality or simple matching; it does not natively perform date arithmetic or compare a date field against the current date. Option B is wrong because the 'date' filter only formats a date into a string — comparing formatted strings lexicographically is fragile and breaks across formats, time zones, and locales. Option D is wrong because 'group_by' groups items by a shared attribute value; it does not filter by date and then select future ones, so it does not meet the requirement.

Full explanation →

320

MCQeasy

A retail company uses Power Pages to host a customer portal where users can view their order history and return items. The portal uses Dataverse for data storage and Microsoft Entra ID (formerly Azure AD) for authentication. The company wants to add a chatbot on the portal to answer common questions about returns and shipping. The chatbot should be able to look up order details from Dataverse when the user is authenticated. You need to implement this with minimal custom development. What should you do?

A.Create a chatbot in Microsoft Copilot Studio, connect it to Dataverse, and embed it into the Power Pages site using the chatbot component.

B.Build a custom chat interface using Power Apps and Power Automate to respond to queries.

C.Use QnA Maker to create a knowledge base from FAQ documents and embed it as a web chat control.

D.Develop a custom Azure Bot Service bot using the Bot Framework SDK and integrate it with Dataverse.

AnswerA

Copilot Studio provides a prebuilt chatbot authoring environment with a native Dataverse connector and a Power Pages embed component. This satisfies the minimal custom development constraint while letting the authenticated bot query order data directly from Dataverse.

Why this answer

Microsoft Copilot Studio (formerly Power Virtual Agents) provides a low-code chatbot builder that natively integrates with Dataverse and can be embedded into Power Pages using the chatbot component. It supports authenticated user context, so the bot can query Dataverse for order details without custom code, meeting the 'minimal custom development' requirement.

Exam trap

PL-900 often tests the difference between low-code Copilot Studio and pro-code Azure Bot Service — candidates pick the custom bot for 'flexibility' but miss the 'minimal custom development' requirement.

How to eliminate wrong answers

Option B is wrong because building a custom chat interface with Power Apps and Power Automate requires significant custom development and does not provide a native Power Pages chatbot component. Option C is wrong because QnA Maker (now part of Azure AI Language) only answers from a static knowledge base and cannot look up live order details from Dataverse. Option D is wrong because developing a custom Azure Bot Service bot with the Bot Framework SDK requires substantial pro-code development and manual Dataverse integration.

Full explanation →

321

MCQhard

A global professional services firm has business units in several countries. Each unit wants to build its own Power Platform solutions, but the central IT team must ensure that data cannot flow between certain regions and that makers only use approved connectors. The firm also wants to standardize reusable components and monitor usage across all units. Which combination of Power Platform governance features should the firm implement?

A.Azure Policy assignments and Azure Blueprints for each region

B.Microsoft Entra ID conditional access policies and Microsoft Purview sensitivity labels

C.Environments with data loss prevention policies, plus the Center of Excellence toolkit

D.Power BI workspaces with row-level security and Microsoft 365 retention labels

AnswerC

Environments provide isolation boundaries so each business unit's data and solutions remain separate, and data loss prevention policies classify connectors as business, non-business, or blocked to prevent unauthorized data flow. The Center of Excellence toolkit adds inventory, usage analytics, and component standards. Together they deliver the regional isolation, connector control, and monitoring the firm requires.

Why this answer

Environments create the regional and business-unit isolation the firm needs, and data loss prevention policies enforce which connectors can be combined, preventing data from flowing between blocked services. The Center of Excellence toolkit provides inventory, analytics, and standards for reusable components across all units. Identity, analytics, and Azure resource policies address different layers and do not deliver Power Platform maker and connector governance.

Exam trap

The trap here is assuming that Azure Policy or identity controls govern Power Platform, when platform governance is enforced through environments, data loss prevention policies, and the Center of Excellence toolkit.

Full explanation →

322

MCQeasy

You are creating a flow that should run only when a button is pressed in a mobile app. The flow will send an email to a manager with the current location of the user. Which type of flow should you create?

A.Instant cloud flow

B.Scheduled cloud flow

C.Automated cloud flow

D.Desktop flow

AnswerA

An instant cloud flow is triggered manually by user action, such as tapping a button in the Power Automate mobile app. This satisfies the requirement that the flow runs only when a button is pressed, unlike automated or scheduled flows that trigger without direct user input.

Why this answer

An instant cloud flow is triggered manually by a user action, such as pressing a button in a mobile app. It runs immediately upon trigger and is ideal for scenarios where the flow should execute on demand, like sending an email with the current location. This matches the requirement exactly.

Exam trap

PL-900 often tests the distinction between instant, scheduled, and automated flows, and candidates may confuse 'automated' with 'instant' because both can be triggered by events, but only instant flows are manually triggered.

How to eliminate wrong answers

Option B is wrong because a scheduled cloud flow runs automatically at specified times, not when a button is pressed. Option C is wrong because an automated cloud flow is triggered by an event (e.g., when a record is created), not by a manual button press. Option D is wrong because a desktop flow (formerly UI flow) automates interactions with desktop applications and is not triggered by a mobile app button; it is typically used for robotic process automation on a desktop.

Full explanation →

323

MCQmedium

A company uses Power BI to visualize sales data from Dynamics 365. The sales team needs to see real-time updates when a deal is closed. Which Power Platform component should be used to trigger a notification when a deal is won?

A.Power BI real-time dashboard

B.Copilot Studio chatbot

C.Power Automate flow

D.Power Apps canvas app

AnswerC

Power Automate flows connect to Dynamics 365 triggers, so a 'record won' event fires the flow immediately and pushes a notification to the sales team, satisfying the real-time update requirement that Power BI's scheduled refresh cannot meet.

Why this answer

Power Automate can trigger a flow when a deal is won in Dynamics 365 (e.g., using the 'When a record is updated' trigger filtered to the 'Close Date' field or status change to 'Won'). The flow can then send a real-time notification (e.g., email, Teams message, or push notification) to the sales team, meeting the requirement for immediate updates without manual intervention.

Exam trap

The trap here is that candidates often confuse Power BI's real-time dashboard capability (which can refresh data every few seconds) with the ability to trigger notifications, but Power BI lacks event-driven automation—only Power Automate can initiate actions based on a record change.

How to eliminate wrong answers

Option A is wrong because Power BI real-time dashboards display data visualizations that refresh automatically, but they cannot trigger notifications or send alerts based on a specific event like a deal being won; they are passive reporting tools. Option B is wrong because Copilot Studio chatbots provide conversational AI interactions but lack native event-driven triggers to monitor Dynamics 365 records and send notifications upon status changes; they require an external trigger (e.g., Power Automate) to initiate actions. Option D is wrong because Power Apps canvas apps are custom user interfaces for data entry or display, but they cannot autonomously monitor database changes and push notifications; they rely on Power Automate or other services for event-driven alerts.

Full explanation →

324

MCQhard

A team is building a customer service solution using Power Apps and Dataverse. They need to ensure that customer data is synchronized with Dynamics 365 Customer Service. Which approach should they use?

A.Use Dataverse as the data store and connect both Power Apps and Dynamics 365 to it

B.Build a custom connector to transfer data between Power Apps and Dynamics 365

C.Implement a third-party middleware solution

D.Export data from Dynamics 365 and import it into Power Apps periodically

AnswerA

Dataverse provides a shared native data platform, so Power Apps and Dynamics 365 Customer Service read and write the same tables without custom synchronisation logic. This satisfies the stem's requirement for synchronised customer data, since both applications operate directly on one authoritative store rather than exchanging copies.

Why this answer

Dataverse is the native data platform underlying both Power Apps and Dynamics 365 Customer Service. By using Dataverse as the shared data store, both applications read and write the same tables (e.g., Account, Contact, Case) in real time, eliminating synchronization latency and duplication. This is the recommended architecture for integrating Power Apps with Dynamics 365.

Exam trap

PL-900 often tests whether candidates understand that Dataverse is the shared foundation of Power Platform and Dynamics 365 — the trap is choosing a custom integration when the native shared data store already solves the problem.

How to eliminate wrong answers

Option B is wrong because building a custom connector to transfer data implies a point-to-point integration that duplicates data and introduces sync delays, whereas Dataverse already provides a shared data layer. Option C is wrong because third-party middleware adds cost, complexity, and latency when the native Dataverse integration is available and supported. Option D is wrong because periodic export/import creates stale data, is not real-time, and is an anti-pattern for systems that must stay synchronized.

Full explanation →

325

MCQeasy

You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?

A.Search(SharePointList, User().Email, "Email")

B.Filter(SharePointList, Email = CurrentUser.Email)

C.Filter(SharePointList, Email = User().Email)

D.Lookup(SharePointList, Email = User().Email)

AnswerC

Filter with User().Email satisfies the requirement to filter SharePoint records by the signed-in user's email. User() returns the current user's profile, including Email, resolved at runtime from the authenticated session — here Microsoft Entra ID credentials — so the gallery's Items property returns only rows matching that address.

Why this answer

The User() function returns a record with the current user's details, including Email. Option A is incorrect because the Search function is used for searching text across multiple columns, not for filtering by exact match. Option B is incorrect because CurrentUser is not a valid function; the correct syntax is User().Email.

Option D is incorrect because Lookup returns a single record, not a filtered set of records.

Full explanation →

326

MCQeasy

You need to automatically send an email notification when a new file is added to a SharePoint document library. Which trigger should you use in a Power Automate cloud flow?

A.When a file is deleted

B.When a file is modified

C.When a file is created

D.When a file is created or modified

AnswerC

The SharePoint 'When a file is created' trigger fires whenever a new item appears in the specified document library. This directly satisfies the requirement to send an email notification automatically upon file addition, without polling or manual checks.

Why this answer

The 'When a file is created' trigger is designed to start a flow when a new file appears in a SharePoint library. Option A is wrong because 'When a file is deleted' triggers on file removal, not creation. Option B is wrong because 'When a file is modified' triggers on updates, not new files.

Option D is wrong because 'When a file is created or modified' includes modification events, which are not required for the specified requirement.

Full explanation →

327

MCQeasy

A real estate agency wants to provide a portal where tenants can submit maintenance requests online. The portal should allow tenants to track the status of their requests. The agency staff should be able to update the status and assign work orders to contractors. The agency uses Microsoft 365 and has Power Platform licenses. What should they use?

A.Power Apps canvas app for tenants and Power Apps model-driven app for staff

B.AI Builder and Power Automate to process requests

C.Power BI dashboard for tenants to view status and Power Apps for staff

D.Power Pages for tenants, Dataverse for storage, Power Automate for notifications, and Power Apps model-driven app for staff

AnswerD

Power Pages provides the external tenant-facing portal, Dataverse stores requests and work orders relationally, Power Automate sends status notifications, and a model-driven app gives staff a forms-and-views interface over the same Dataverse tables, satisfying tracking and assignment requirements within existing licences.

Why this answer

It uses Power Pages to create an external-facing portal for tenants to submit and track maintenance requests, Dataverse as the underlying data store for all request data, Power Automate to send notifications (e.g., status updates), and a Power Apps model-driven app for staff to manage requests and assign work orders. This combination provides a secure, low-code solution that leverages the existing Microsoft 365 and Power Platform licenses.

Exam trap

The trap here is that candidates often confuse Power Apps canvas apps (for internal users) with Power Pages (for external users), and overlook that Dataverse is the required common data platform for both the portal and the staff app.

How to eliminate wrong answers

Option A is wrong because a Power Apps canvas app for tenants would require each tenant to have a Power Apps license or be part of the same tenant, which is not practical for external users; Power Pages is designed for external-facing portals. Option B is wrong because AI Builder is not needed for simple request tracking and status updates, and Power Automate alone cannot provide a user interface for tenants to submit and track requests. Option C is wrong because Power BI is a reporting tool, not a portal for tenants to submit requests or track status interactively; it also lacks the ability for tenants to create new records.

Full explanation →

328

MCQeasy

Which Power Platform component allows users to create automated workflows between apps and services?

A.Power Automate

B.Power BI

C.Power Virtual Agents

D.Power Apps

AnswerA

Power Automate provides cloud flows that trigger on events and execute actions across connectors, delivering the automated workflows between apps and services the stem requires. Unlike Power Apps, which builds user interfaces, or Power BI, which visualises data, it orchestrates multi-step processes without code.

Why this answer

Power Automate is the correct answer because it is the Power Platform component specifically designed to create automated workflows between apps and services. It enables users to build flows that trigger actions across hundreds of connectors, such as sending an email when a new SharePoint item is added, without writing code.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking both can automate workflows, but Power Apps is for building user interfaces and logic within an app, not for cross-service automation.

How to eliminate wrong answers

Option B is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating workflows. Option C is wrong because Power Virtual Agents is used to create conversational AI chatbots, not to build automated workflows between apps and services. Option D is wrong because Power Apps is a low-code platform for building custom applications, not for creating automated workflows.

Full explanation →

329

Matchingmedium

Match each Common Data Service (Dataverse) term to its description.

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

Concepts

Matches

Logical structure that stores data

Field that holds a specific type of data

Individual record in a table

Link between tables

Container for apps, flows, and data

Why these pairings

The correct matches are Entity with 'container for records' and Attribute with 'field in an entity'. Common confusions include swapping Entity with Attribute and Relationship with Solution.

Full explanation →

330

MCQmedium

Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?

A.Business rule

B.Form scripting

C.Workflow process

D.Power Automate flow

AnswerA

A business rule runs client-side on the form, evaluating the Amount column and conditionally showing or hiding the Approved field when Amount exceeds 1000. This delivers the conditional visibility requirement without custom code or JavaScript.

Why this answer

Business rules in Power Apps model-driven apps are server-side/client-side logic components that can show, hide, enable, disable, or set field values based on conditions without writing code. They support conditional visibility tied to another field's value (e.g., show Approved only when Amount > 1000), and they run on both the form and the Dataverse layer. This makes them the correct no-code feature for the described requirement.

Exam trap

PL-900 often tests the distinction between declarative business rules and code-based form scripting, tricking candidates into choosing JavaScript when the requirement is a simple conditional visibility that business rules handle natively.

How to eliminate wrong answers

Option B is wrong because form scripting (JavaScript web resources) is a code-based approach used for complex client-side logic, not the recommended no-code feature for simple conditional field visibility. Option C is wrong because a workflow process is an asynchronous or synchronous background automation that operates on Dataverse records, not on real-time form field visibility. Option D is wrong because Power Automate flows are external cloud automations triggered by events or schedules and cannot dynamically show/hide fields on a model-driven form.

Full explanation →

331

MCQmedium

A developer is creating a custom control using Power Apps Component Framework (PCF). After importing the solution, the control appears but does not show any data. What is the most likely issue based on the exhibit?

A.The display-name-key is missing a translation

B.The version number is incorrect

C.The control requires a dataset property but only a text property is defined

D.The namespace is misspelled

AnswerC

PCF controls bind to explicit property types declared in the manifest. A dataset property supplies a collection of records; a text property supplies a single string. With only a text property defined, the control receives no records to render, so the gallery stays empty despite loading successfully.

Why this answer

The 'abilities' section indicates the control expects a dataset, but the only property defined is a single line of text. The control likely needs a dataset property to receive data. The version, namespace, and display key are not causing data issues.

Full explanation →

332

MCQhard

A healthcare organization wants to build a chatbot that answers common patient questions about clinic hours, insurance accepted, and appointment preparation. The bot must be embeddable on the organization's website and support escalation to a live agent when it cannot answer. The organization has no AI development team. Which Microsoft Power Platform service should they use?

A.Power Automate

B.Power Apps

C.Power Virtual Agents

D.AI Builder

AnswerC

Power Virtual Agents is a no-code chatbot builder that lets subject matter experts create conversational bots with topics, trigger phrases, and responses. It supports embedding on websites and can hand off to a live agent through integration with Omnichannel for Customer Service, matching the requirement without needing an AI development team.

Why this answer

Power Virtual Agents enables no-code chatbot creation with topics, trigger phrases, and responses, and it can be published to websites and other channels. It supports handoff to live agents via integration with Dynamics 365 Customer Service or Omnichannel. AI Builder, Power Apps, and Power Automate serve different purposes and do not deliver a conversational bot with escalation out of the box.

Exam trap

The trap here is confusing AI Builder with Power Virtual Agents, assuming that any AI-related service can build a chatbot, when only Power Virtual Agents provides conversational authoring and channel deployment.

Full explanation →

333

Multi-Selectmedium

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

Select 3 answers

A.Text recognition (OCR) from images and PDFs.

B.Custom machine learning model training from scratch.

C.Object detection in images.

D.Form processing to extract data from documents.

E.Building custom user interfaces for mobile apps.

AnswersA, C, D

AI Builder's prebuilt text recognition model extracts printed and handwritten text from images and PDFs using optical character recognition, requiring no custom training. This directly satisfies the stem's demand for a genuine AI Builder capability, since document processing is one of its core prebuilt model categories alongside form processing and prediction.

Why this answer

Option A is correct because AI Builder provides a prebuilt text recognition (OCR) capability that extracts printed or handwritten text from images and PDF documents. Option C is correct because AI Builder includes prebuilt object detection models that identify and locate objects within images. Option D is correct because AI Builder offers form processing models that extract structured data such as key-value pairs and tables from documents like invoices and receipts.

Option B is not correct because AI Builder is designed for prebuilt and customizable prebuilt models, not for training custom machine learning models entirely from scratch. Option E is not correct because building custom user interfaces for mobile apps is a Power Apps capability, not an AI Builder capability.

Exam trap

The trap here is that candidates may confuse AI Builder's ability to train custom models (which is limited to specific templates) with full custom machine learning model development from scratch, which is not supported.

Full explanation →

334

MCQmedium

A maker is building a copilot with Microsoft Copilot Studio that must answer questions about product warranties. The warranty information is stored in a SharePoint Online list that is updated weekly. The copilot must always provide the most current information without requiring manual retraining. What should the maker do?

A.Export the SharePoint list to a CSV file and upload it as a manual knowledge source.

B.Use the 'Search and summarize' node with a Bing Custom Search instance that indexes the SharePoint list.

C.Use the 'Create generative answers' node and add the SharePoint list as a knowledge source.

D.Create a Power Automate flow that queries the SharePoint list and returns the answer as a variable in a topic.

AnswerC

The 'Create generative answers' node in Copilot Studio allows the copilot to use external knowledge sources, including SharePoint lists, to generate responses. When the SharePoint list is updated, the copilot retrieves the latest data dynamically, ensuring current information without manual retraining. This is the intended method for integrating dynamic knowledge.

Why this answer

The 'Create generative answers' node is specifically designed to allow the copilot to use configured knowledge sources, such as SharePoint, to generate answers dynamically. When the SharePoint list is updated, the copilot queries the live data, so users always get the latest information. This eliminates the need for manual retraining or re-uploading content, meeting the requirement efficiently.

Exam trap

The trap here is confusing generative answers with manual knowledge uploads; only generative answers with a live SharePoint source automatically reflect updates.

Full explanation →

335

MCQmedium

A government agency needs to modernize a paper-based permit approval process. The solution must enforce strict access control, provide an audit trail, and allow citizens to submit applications online. The agency uses Microsoft 365 and has a Power Platform license. Which approach should they take?

A.Use Power Automate with AI Builder to process paper forms and store in SharePoint

B.Build a Power Apps model-driven app for internal staff and a canvas app for citizens

C.Use Power BI to create a dashboard and Power Automate for approvals

D.Use Power Pages for citizen submissions, Dataverse for storage, and Power Automate for approvals

AnswerD

Power Pages provides authenticated citizen-facing submission with Microsoft Entra ID access control, Dataverse stores records with full audit history, and Power Automate enforces the approval workflow. Together these meet the strict access, audit trail and online submission constraints.

Why this answer

It combines Power Pages for external citizen-facing submission portals, Dataverse for secure, auditable data storage with role-based access control, and Power Automate for automated approval workflows. This architecture meets all requirements: strict access control (Dataverse roles), audit trail (Dataverse change tracking and auditing), and online citizen submissions (Power Pages).

Exam trap

The trap here is that candidates often assume Power Apps canvas apps can serve as an external citizen portal, but they require internal user licenses and cannot be accessed anonymously, whereas Power Pages is specifically designed for external-facing, authenticated self-service portals.

How to eliminate wrong answers

Option A is wrong because AI Builder for paper forms does not address the need for online citizen submissions or provide a built-in audit trail; SharePoint lacks the granular access control and auditing capabilities of Dataverse. Option B is wrong because a model-driven app for staff and a canvas app for citizens still requires a separate data source and does not inherently provide a secure external submission portal; Power Apps canvas apps are not designed for anonymous external user access without additional licensing and configuration. Option C is wrong because Power BI is a visualization tool, not a submission or storage platform, and Power Automate alone cannot enforce strict access control or provide a persistent audit trail without a backing data store like Dataverse.

Full explanation →

336

MCQeasy

A company wants to enable employees to ask questions about HR policies using a conversational interface. The system should be built with minimal code. Which Power Platform capability should they use?

A.Power BI

B.Power Apps

C.Power Automate

D.Microsoft Copilot Studio

AnswerD

Microsoft Copilot Studio builds conversational chatbots that answer natural-language questions, satisfying the minimal-code constraint. It provides a low-code graphical authoring canvas with prebuilt generative-answer capabilities, so HR policy queries can be handled without custom development. Unlike canvas apps or Power Automate flows, it is purpose-built for conversational interfaces.

Why this answer

Microsoft Copilot Studio (D) is the correct choice because it enables the creation of conversational AI agents with minimal code, specifically designed for building chatbots that can answer HR policy questions. It integrates with Power Platform and uses prebuilt templates and natural language understanding to handle employee queries without requiring extensive development.

Exam trap

The trap here is that candidates may confuse Power Apps' low-code app-building capability with conversational interfaces, but Power Apps is designed for form-based and canvas apps, not for natural language dialog flows like those built with Copilot Studio.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for data visualization and reporting, not for building conversational interfaces. Option B is wrong because Power Apps is a low-code platform for building custom applications with user interfaces and logic, but it is not optimized for conversational AI or chatbot creation without significant additional components. Option C is wrong because Power Automate is a workflow automation tool for orchestrating processes and integrations, not for creating conversational agents that understand natural language.

Full explanation →

337

Multi-Selecthard

Which THREE of the following are true about model-driven apps? (Choose THREE.)

Select 3 answers

A.They require custom formulas for business logic

B.They have built-in role-based security

C.They are built on top of Microsoft Dataverse

D.They are responsive and work on multiple devices

E.They can only be used on web browsers

AnswersB, C, D

Model-driven apps inherit Dataverse's role-based security model, so access to tables, records and commands is governed by security roles assigned to users or teams. This built-in enforcement distinguishes them from canvas apps, which require manually configured data-source permissions.

Why this answer

Option B is correct because model-driven apps inherit the role-based security model of Microsoft Dataverse, where access is governed by security roles, teams, business units, and record-level sharing rather than custom code. Option C is correct because model-driven apps are built directly on Microsoft Dataverse, using its tables, relationships, and metadata to define the app's data model and behavior. Option D is correct because model-driven apps use the Unified Interface, which is responsive and adapts to different screen sizes, so they work across desktop, tablet, and mobile devices.

Option A is incorrect because model-driven apps rely on declarative configuration such as business rules, workflows, and Power Automate flows rather than custom formulas for business logic. Option E is incorrect because model-driven apps are also available through the Power Apps mobile app on iOS and Android, not only in web browsers.

Full explanation →

338

MCQmedium

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

A.Hierarchy

B.Drill-through

C.Bookmarks

D.Slicers

AnswerA

A hierarchy groups related fields into drill-down levels, such as Year, Quarter and Month, letting users navigate from year to quarter to month within one visual. This matches the required drill-down behaviour without separate reports.

Why this answer

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

Exam trap

The trap here is that candidates often confuse drill-down (hierarchy-based expansion within a visual) with drill-through (page-level navigation), leading them to select drill-through when the question explicitly asks for drilling down from year to quarter to month.

How to eliminate wrong answers

Option B is wrong because drill-through is used to navigate from one report page to another filtered by a specific data point, not to drill down within a single visual across hierarchical levels. Option C is wrong because bookmarks capture a specific state of a report page (e.g., filters, slicers, visual selections) for navigation or storytelling, but they do not create a hierarchical drill-down path. Option D is wrong because slicers are visual filters that allow users to filter data by selecting values, but they do not provide a drill-down capability from year to quarter to month within a chart.

Full explanation →

339

MCQmedium

You are building a canvas app for a field service team. Technicians need to open the app on a phone, capture a photo of damaged equipment, and attach that photo to a work order record stored in Microsoft Dataverse. You add a Camera control and a Form control bound to the Work Order table. What should you configure to store the captured image with the work order record?

A.Add the Camera control's Photo property to a data card in the Form control that is bound to an image or file column on the Work Orders table.

B.Set the Camera control's OnSelect property to Patch the Work Orders table with the Camera control's Photo value.

C.Enable the Camera control's UseMobileCamera property and connect the app to a Power Automate flow that reads the device gallery.

D.Set the Camera control's StreamRate property to a value greater than zero and rely on automatic Dataverse synchronization.

AnswerA

Form controls bind individual controls to columns through data cards. Placing the camera's Photo property inside a data card mapped to an image or file column on the Work Orders table lets the form's SubmitForm write the captured image to that column on the currently selected record, which is exactly what attaching a photo to a work order requires.

Why this answer

A Form control persists data through data cards, each mapped to a specific column, and SubmitForm writes the current values to Dataverse. Putting the Camera control's Photo output inside a data card bound to an image or file column means the captured image travels with the record when the technician submits the form. Actions like streaming video or cloud flows do not persist the image to the work order.

Exam trap

The trap here is assuming a camera can push data to Dataverse on its own, when the image must be routed through a form data card or an explicit write function.

Full explanation →

340

Multi-Selectmedium

A company is evaluating the business value of Microsoft Power Platform. They want to understand which capabilities are provided by the platform to support digital transformation. Which two benefits are core value propositions of Microsoft Power Platform? (Choose two.)

Select 2 answers

A.Guarantee that all business processes will be fully automated without human intervention.

B.Enable citizen developers to build apps and automations with low-code tools.

C.Provide a unified platform that connects data and services across Microsoft and third-party systems.

D.Replace the need for professional developers entirely in enterprise software projects.

E.Provide only on-premises deployment with no cloud capabilities.

AnswersB, C

Power Platform is designed to democratize app and automation creation through low-code tools like Power Apps and Power Automate. This empowers business users, often called citizen developers, to solve problems without deep programming skills, which is a core business value and a key enabler of digital transformation across organizations.

Why this answer

Power Platform delivers value by enabling citizen developers through low-code tools and by unifying data and services across Microsoft and third-party systems via connectors and Dataverse. These two benefits drive faster solution delivery and break down data silos. The other options overstate the platform by claiming it replaces professional developers, guarantees full automation, or is on-premises only, none of which reflect its actual capabilities.

Exam trap

The trap here is assuming Power Platform eliminates professional developers or guarantees full automation, when it actually augments developers and automates selected processes while still requiring human judgment.

Full explanation →

341

Multi-Selecthard

You are designing a copilot in Microsoft Copilot Studio for an internal help desk. The copilot must greet users, answer common questions from an internal SharePoint site, and let users open a support ticket only when they are signed in. Which TWO configuration steps are required? (Choose two.)

Select 2 answers

A.Disable generative answers so the copilot only uses authored topics.

B.Enable authentication for the copilot so users sign in before accessing restricted capabilities.

C.Publish the copilot to the Microsoft Teams channel only.

D.Add the internal SharePoint site as a knowledge source for the copilot.

E.Create a scheduled cloud flow that runs every hour to refresh help desk content.

AnswersB, D

Authentication ensures the copilot knows who the user is and can gate capabilities such as ticket creation. In Copilot Studio, enabling authentication with a supported identity provider lets the copilot require sign-in, which is necessary to restrict ticket creation to authenticated users and to personalize or secure actions.

Why this answer

The two necessary steps are enabling authentication so only signed-in users can open tickets, and adding the internal SharePoint site as a knowledge source so the copilot can answer common questions from that content. Publishing channels and scheduled flows do not provide authentication gating or knowledge grounding, and disabling generative answers would remove the desired question-answering capability.

Exam trap

The trap here is assuming that publishing to an internal channel like Teams automatically secures capabilities, when authentication must be explicitly enabled to gate actions such as ticket creation.

Full explanation →

342

MCQeasy

A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?

A.Create a canvas app from the Excel file

B.Use Power Pages to display the Excel file

C.Create a model-driven app using Dataverse

D.Use Power Automate to create a mobile app

AnswerA

Canvas apps bind directly to an Excel workbook stored in OneDrive as a tabular data source, letting the maker design screens and controls over that table. This suits a simple personal expense tracker without needing Dataverse or a data model.

Why this answer

A canvas app can be created directly from an Excel file stored in OneDrive using the Power Apps 'Start from data' option. This generates a three-screen app (browse, detail, edit) that connects to the Excel table via the OneDrive for Business connector, making it ideal for simple personal expense tracking without requiring Dataverse or custom development.

Exam trap

The trap here is confusing Power Automate's mobile app trigger (e.g., button in Power Automate mobile) with the ability to build a full mobile app interface, leading candidates to choose D instead of recognizing that only canvas apps provide a user-facing UI from Excel.

How to eliminate wrong answers

Option B is wrong because Power Pages is designed for external-facing websites with authentication and complex data sources, not for creating a simple personal app from an Excel file. Option C is wrong because model-driven apps require Dataverse, which is overkill for a single Excel file and demands a premium license and structured data modeling. Option D is wrong because Power Automate is an automation platform, not an app-building tool; it cannot create a mobile app interface—it can only trigger flows or generate notifications.

Full explanation →

343

MCQmedium

A company uses a Power App to track inventory. The app displays a gallery of items filtered by a dropdown. When the user selects 'Electronics', the gallery shows all electronics items. However, after the user clears the dropdown, the gallery remains empty. What is the most likely reason?

A.The dropdown's AllowEmptySelection property is set to false

B.The data source requires a refresh after clearing selection

C.The gallery's Items property uses a filter that references Dropdown.Selected.Value, and when the dropdown is cleared, the filter returns blank

D.The app's OnStart property is clearing the data source

AnswerC

Clearing the dropdown sets Dropdown.Selected to blank, so Dropdown.Selected.Value returns nothing. The Filter expression then matches no records, leaving the gallery empty. The Items property must handle the blank case, typically via an If or Coalesce wrapper.

Why this answer

When the dropdown is cleared, Dropdown.Selected.Value becomes blank. The gallery's Items property uses a filter that references this value, so the filter returns blank (no items), causing the gallery to be empty. Option A is incorrect because AllowEmptySelection set to false would prevent clearing, not cause emptiness after clearing.

Option B is incorrect because the data source does not require a refresh; the issue is the filter logic. Option D is incorrect because OnStart is not involved in the clearing behavior.

Full explanation →

344

Multi-Selectmedium

You are designing a model-driven app for a claims department. The team needs a consistent, form-based experience driven by Microsoft Dataverse tables. Which two capabilities should you expect from a model-driven app? (Choose two.)

Select 2 answers

A.Pixel-perfect control positioning using X and Y coordinates on a blank canvas.

B.Forms and views that are generated from Dataverse table metadata and can be customized in the app designer.

C.Sitemap-driven navigation that organizes tables and views into a defined app structure.

D.A built-in Camera control that captures images and stores them as local files before submission.

E.Direct use of an Excel workbook on a user's local drive as the primary data source without Dataverse.

AnswersB, C

Because model-driven apps are metadata-driven, forms and views are created from the table definitions and then tailored in the modern app designer or classic form editor. This is central to the claims scenario, where a consistent data-first experience matters more than bespoke screen design, and it is a core model-driven capability.

Why this answer

Model-driven apps are metadata-driven: you define Dataverse tables, then compose forms, views, and a sitemap to produce structured navigation for a business process. These two capabilities match the claims team's need for a consistent, form-based experience. Pixel positioning, camera controls, and local Excel files belong to canvas apps or other tools and are not model-driven features.

Exam trap

The trap here is conflating canvas app design freedom, such as pixel positioning and camera controls, with the metadata-driven structure that defines model-driven apps.

Full explanation →

345

MCQmedium

A financial services firm wants to give its analysts a single, governed place to store business data that can be used across Power Apps, Power Automate, and Power BI. The firm needs built-in security roles, business rules, and the ability to model relationships between tables. Which Microsoft Power Platform component should they use?

A.Azure SQL Database

B.Microsoft Dataverse

C.SharePoint lists

D.Power BI dataflows

AnswerB

Dataverse is the underlying data platform for Power Platform, providing tables, relationships, security roles, and business rules. It is designed to be shared across Power Apps, Power Automate, and Power BI, so analysts get a governed, consistent data layer with role-based access and logic enforcement, exactly matching the stated requirements.

Why this answer

Microsoft Dataverse is the native data service for Power Platform, offering tables, relationships, column types, security roles, and business rules. It is directly consumable by Power Apps, Power Automate, Power BI, and Power Virtual Agents, so it serves as a single governed source of truth. The other options are data storage or transformation tools but do not deliver the integrated security and logic features described.

Exam trap

The trap here is equating any structured data store, such as SharePoint or Azure SQL, with Dataverse, when only Dataverse provides built-in Power Platform security roles and business rules.

Full explanation →

346

MCQmedium

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

A.Append Queries

B.Merge Queries

C.Pivot Column

D.Group By

AnswerB

Merge Queries performs a join on a shared key, combining columns from both tables side by side using ProductID as the matching column. Append would stack rows instead, which does not combine the tables on a common column.

Why this answer

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

Exam trap

The trap here is that candidates confuse Append (stacking rows) with Merge (joining columns), often choosing Append because they think 'combining' always means adding rows, not realizing the requirement is to align data horizontally on a shared key.

How to eliminate wrong answers

Option A is wrong because Append Queries stacks rows from two tables on top of each other, requiring identical column structures, and does not combine data based on a common column. Option C is wrong because Pivot Column transforms unique values from a column into new columns, aggregating data, not merging two separate tables on a key. Option D is wrong because Group By aggregates rows based on a column, creating summary statistics, and does not combine data from two different tables.

Full explanation →

347

Multi-Selectmedium

Which THREE actions can be performed in the Power Query Editor?

Select 3 answers

A.Create measures

B.Change data types

C.Merge queries

D.Remove columns

E.Create relationships between tables

AnswersB, C, D

Power Query Editor provides a data type selector on the Transform tab and column headers, letting you convert text, numbers, dates and so on. Changing data types is a core transformation step, satisfying the question's requirement for actions performed in that editor.

Why this answer

In the Power Query Editor, option B (Change data types) is correct because the Transform and Add Column tabs provide data type commands (e.g., Text, Whole Number, Date) that let you convert a column's type as part of shaping the data. Option C (Merge queries) is correct because the Home tab's Merge Queries feature performs a join between two queries using a common column, similar to a SQL JOIN. Option D (Remove columns) is correct because the Home tab offers Remove Columns and Remove Other Columns to drop unneeded fields during transformation.

Option A (Create measures) is not available in Power Query Editor; DAX measures are created in the Power BI report/Data view or in a Power Pivot model. Option E (Create relationships between tables) is also not done in Power Query Editor; relationships are defined in the model view (Power BI) or the Data Model (Excel Power Pivot).

Exam trap

The trap here is that candidates confuse the Power Query Editor's data transformation role with the data modeling and DAX capabilities of Power BI Desktop, leading them to incorrectly select options like creating measures or relationships.

Full explanation →

348

MCQhard

A financial analyst creates a Power BI report to compare quarterly revenue across years. The data has a 'Date' column and a 'Revenue' column. The analyst wants to display year-over-year growth for each quarter. Which visual and configuration would best achieve this?

A.Line chart with date hierarchy and revenue, adding year-over-year trend line

B.Matrix visual with years as columns, quarters as rows, and a measure for YoY growth

C.Stacked bar chart with quarters on axis and revenue as values, using year as legend

D.Scatter plot with revenue on both axes and date as detail

AnswerB

A matrix visual places years as columns and quarters as rows, creating the grid needed for period comparison, while a YoY growth measure calculates the change against the prior year. Together they display year-over-year growth per quarter as required.

Why this answer

A Matrix visual allows you to place years as columns and quarters as rows, then define a DAX measure for year-over-year (YoY) growth (e.g., (Current Year Revenue - Previous Year Revenue) / Previous Year Revenue). This directly compares each quarter’s revenue across years in a structured, tabular format, which is the most effective way to display YoY growth for each quarter.

Exam trap

The trap here is that candidates often choose a chart option (like a line chart with trend lines) thinking it visually shows growth, but the question specifically asks for displaying year-over-year growth for each quarter, which requires a tabular or matrix format to show exact percentage changes per quarter across years.

How to eliminate wrong answers

Option A is wrong because a line chart with a date hierarchy and a year-over-year trend line does not inherently calculate or display the exact YoY growth percentage for each quarter; it only shows a trend line that may misrepresent quarterly comparisons. Option C is wrong because a stacked bar chart with quarters on the axis and year as legend shows the composition of revenue by year within each quarter, not the growth rate between years. Option D is wrong because a scatter plot with revenue on both axes and date as detail does not provide a clear comparison of quarterly revenue across years; it would plot revenue against itself, which is meaningless for YoY growth analysis.

Full explanation →

349

MCQeasy

A company wants to provide a self-service portal where customers can check their order status. Which Power Platform tool is best suited for this?

A.Power Pages

B.Power Automate

C.Power BI

D.Power Apps

AnswerA

Power Pages delivers externally facing, low-code websites with built-in identity management through Microsoft Entra ID, letting customers authenticate and view their own order records via Dataverse permissions. This directly satisfies the self-service portal requirement, unlike canvas apps or model-driven apps, which target internal makers and licensed organisational users rather than anonymous external customers.

Why this answer

Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform designed specifically for creating external-facing websites. It allows customers to log in and view their order status without requiring internal system access, making it ideal for self-service portals.

Exam trap

The trap here is that candidates often confuse Power Apps (which can be shared externally with guest users) with Power Pages, but Power Apps requires users to have a license or be invited as guests, whereas Power Pages is purpose-built for anonymous or authenticated external access without requiring internal licenses.

How to eliminate wrong answers

Option B is wrong because Power Automate is a workflow automation tool for creating automated processes between apps and services, not for building customer-facing web portals. Option C is wrong because Power BI is a business analytics and visualization tool used for dashboards and reports, not for providing interactive customer self-service interfaces. Option D is wrong because Power Apps is primarily for building custom internal business applications (canvas or model-driven) that run on mobile or web, but it lacks the native public-facing website capabilities and authentication features that Power Pages provides for external users.

Full explanation →

350

MCQmedium

An organization uses Power Apps portals to allow external customers to submit support tickets. The portal uses Microsoft Entra ID for authentication. The security team wants to require multi-factor authentication (MFA) for external portal users. What is the best approach?

A.Create a Conditional Access policy in Microsoft Entra ID that requires MFA for the portal application

B.Enable MFA for all Microsoft Entra ID users

C.Use a third-party identity provider that supports MFA

D.Configure MFA in the Power Apps portal authentication settings

AnswerA

A Conditional Access policy in Microsoft Entra ID enforces MFA at the identity provider for the portal application, covering all external users regardless of client. Configuring MFA per-app or per-user would not scale or satisfy the requirement to require MFA for external portal users.

Why this answer

Conditional Access in Microsoft Entra ID is the supported, centralized mechanism to require MFA for a specific application such as a Power Apps portal. By scoping the policy to the portal enterprise application and setting the grant control to 'Require multi-factor authentication', external users authenticating via Entra ID are challenged for MFA without affecting other apps. This is the recommended approach because portal authentication is delegated to Entra ID, so MFA must be enforced at the identity provider layer.

Exam trap

PL-900 often tests the misconception that MFA can be configured directly inside Power Apps portal settings — in reality, MFA is always enforced by the identity provider via Conditional Access or security defaults.

How to eliminate wrong answers

Option B is wrong because enabling MFA for all Entra ID users is overly broad and would impact internal users and unrelated applications, not just the portal. Option C is wrong because introducing a third-party IdP adds unnecessary complexity and cost when Entra ID already supports MFA natively for the portal. Option D is wrong because Power Apps portals do not have a native MFA configuration setting — authentication and MFA are governed by the underlying identity provider (Entra ID, AD FS, or a social IdP), not by portal settings.

Full explanation →

351

MCQeasy

You need to design a flow that runs when a new response is submitted in Microsoft Forms. The flow should send an email to the respondent with a summary of their answers. Which trigger should you use?

A.When a new response is submitted

B.When a response is viewed

C.When a response is edited

D.When a response is modified

AnswerA

The Microsoft Forms 'When a new response is submitted' trigger fires each time a respondent completes the form, providing the response ID needed to retrieve answers. This satisfies the requirement to email a summary to the respondent.

Why this answer

The correct trigger is 'When a new response is submitted' because the flow needs to run immediately after a new response is submitted. Option B, 'When a response is viewed', triggers when someone views the response. Option C, 'When a response is edited', triggers when the response is edited.

Option D, 'When a response is modified', triggers when the response is modified (which includes edits or other changes). Only the 'When a new response is submitted' trigger fires on initial submission, which is required to send the summary email to the respondent.

Full explanation →

352

MCQmedium

You need to design a solution that sends a notification to a manager when an employee submits a time-off request in a SharePoint list. Which Power Platform component should you use?

A.Power Virtual Agents

B.Power Apps

C.Power Automate

D.Power BI

AnswerC

Power Automate provides event-driven cloud flows that trigger when a SharePoint list item is created, satisfying the notification requirement. Its SharePoint connector and approval/notification actions let the flow identify the manager and dispatch an email or Teams message automatically, without code. This directly meets the stem's constraint of notifying a manager upon submission.

Why this answer

Power Automate is the correct component because it is designed to create automated workflows that trigger on events, such as when an item is created or modified in a SharePoint list. In this scenario, you would configure a Power Automate flow with a SharePoint 'When an item is created' trigger to send an email notification to the manager, without requiring manual intervention or custom code.

Exam trap

The trap here is that candidates may confuse Power Apps (which can display notifications within an app) with the ability to send automated external notifications, but Power Automate is the dedicated workflow engine for such event-driven tasks.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is a chatbot-building tool for conversational AI, not for automating backend workflows like sending notifications based on SharePoint list changes. Option B is wrong because Power Apps is used to build custom user interfaces and apps, not to automate event-driven notifications; it would require additional components like Power Automate to handle the notification logic. Option D is wrong because Power BI is a data visualization and analytics tool, not a workflow automation platform; it cannot trigger actions such as sending emails based on list item changes.

Full explanation →

353

MCQeasy

An organization uses Power Automate flows that connect to Microsoft Dataverse and SharePoint. The administrator needs to ensure that only specific connectors can be used together. What should they configure?

A.Enable solution component isolation

B.Configure a Data Loss Prevention (DLP) policy

C.Create an environment security group

D.Turn on auditing for the environment

AnswerB

A Data Loss Prevention policy defines connector groups and blocks combinations spanning them, so Dataverse and SharePoint connectors can be restricted to permitted groupings. This satisfies the stem's constraint by enforcing which connectors may be used together within the environment.

Why this answer

Data Loss Prevention (DLP) policies in the Power Platform allow administrators to classify connectors into Business, Non-Business, and Blocked groups, and to define which connectors can be used together within a single flow or app. This directly enforces the requirement that only specific connectors can be combined, preventing data from flowing between incompatible services such as Dataverse and a personal social media connector.

Exam trap

PL-900 often tests the confusion between governance controls (DLP) and access controls (security groups), causing candidates to pick environment security groups when the requirement is about restricting connector combinations.

How to eliminate wrong answers

Option A is wrong because solution component isolation relates to ALM and moving components between environments, not to restricting connector combinations. Option C is wrong because an environment security group controls which users can access an environment, not which connectors can be combined. Option D is wrong because auditing only records activity for compliance and investigation; it does not restrict or govern connector usage.

Full explanation →

354

MCQeasy

A Power Platform administrator needs to monitor the usage of Power Apps and Power Automate across the organization to identify which environments have the highest adoption. Which built-in tool should the administrator use?

A.Power BI Desktop with the Power Platform connector.

B.Microsoft Purview Compliance Portal.

C.Microsoft 365 admin center Reports.

D.Power Platform admin center Analytics.

AnswerD

The Power Platform admin center provides built-in analytics dashboards that show usage metrics for Power Apps, Power Automate, and other services. Administrators can view adoption trends, active users, and environment-level usage. This tool is specifically designed for monitoring and reporting, making it the correct choice for identifying high-adoption environments.

Why this answer

The Power Platform admin center includes built-in Analytics dashboards that provide usage data for Power Apps and Power Automate. These dashboards show metrics such as active users, app launches, and flow runs, and can be filtered by environment. This is the most direct and built-in method for an administrator to monitor adoption across environments without additional tools or configuration.

Exam trap

The trap here is assuming that Microsoft 365 admin center or Purview includes Power Platform usage analytics, but those tools focus on other services and compliance, not Power Platform adoption.

Full explanation →

355

Multi-Selectmedium

A retail company uses Power Platform to manage customer feedback. They want to analyze sentiment and trigger alerts for negative reviews. Which THREE components should they use together?

Select 3 answers

A.Copilot Studio

B.Power Apps

C.Power Automate

D.Power BI

E.AI Builder

AnswersB, C, E

Power Apps can capture and display feedback.

Why this answer

Power Apps is correct because it provides the user interface for customers to submit feedback and for staff to view sentiment analysis results. It serves as the front-end application that collects and displays data, making it an essential component for managing customer feedback interactively.

Exam trap

The trap here is that candidates may think Copilot Studio is needed for sentiment analysis, but AI Builder provides the prebuilt sentiment model, while Copilot Studio is for conversational AI, not data analysis or automation.

Full explanation →

356

MCQmedium

A large enterprise needs to enforce that data from a Power App connected to Salesforce cannot be shared with a connector that connects to a non-approved cloud service. What should they configure?

A.Data policies in Microsoft 365 compliance center

B.Data Loss Prevention (DLP) policy in Power Platform admin center

C.Azure Active Directory Conditional Access

D.Connector sharing settings in Power Apps

AnswerB

DLP policies classify connectors into business, non-business and blocked groups, preventing data crossing between them. Placing Salesforce and the unapproved cloud connector in different groups blocks that combination, satisfying the requirement to stop data sharing.

Why this answer

Data Loss Prevention (DLP) policies in the Power Platform admin center allow administrators to classify connectors as Business or Non-Business, and block data sharing between them. By placing the Salesforce connector in the Business group and the non-approved cloud service connector in the Non-Business group, the enterprise prevents data flow between the two, enforcing the required restriction.

Exam trap

The trap here is that candidates confuse DLP policies in Power Platform with broader Microsoft 365 compliance policies, but the question specifically targets connector-level data sharing, which is only controlled by Power Platform DLP policies.

How to eliminate wrong answers

Option A is wrong because Microsoft 365 compliance center data policies govern data lifecycle and retention in Microsoft 365 services, not connector-level data sharing in Power Apps. Option C is wrong because Azure Active Directory Conditional Access controls user authentication and device access, not data flow between connectors in Power Platform. Option D is wrong because connector sharing settings in Power Apps only control who can use a connector, not what data can be shared between connectors.

Full explanation →

357

MCQeasy

A regional logistics company wants to modernize its shipment tracking without hiring additional software developers. The company needs a low-code platform that lets business analysts build a mobile app for drivers to update delivery status, connect that app to a cloud data source, and add automated notifications when a delivery is delayed. Which Microsoft offering should the company adopt?

A.Microsoft Dynamics 365 Supply Chain Management

B.Microsoft Azure App Service

C.Microsoft 365 Apps for enterprise

D.Microsoft Power Platform

AnswerD

Power Platform unifies Power Apps for building the driver app, Power Automate for delay notifications, and Dataverse or connectors for the cloud data source. It is designed specifically for low-code business solutions, so analysts can deliver the shipment tracking modernization without a dedicated development team. This directly matches every requirement in the scenario.

Why this answer

Microsoft Power Platform is the correct choice because it bundles low-code app development, workflow automation, and data connectivity into one business-user-friendly environment. The analysts can build the driver app with Power Apps, trigger notifications with Power Automate, and store or connect shipment data through standard connectors or Dataverse, satisfying all stated requirements without professional developers.

Exam trap

The trap here is assuming that any Microsoft 365 or Azure service can substitute for a low-code platform, when only Power Platform provides the combined app, automation, and data capabilities for business analysts.

Full explanation →

358

MCQmedium

A company uses a canvas app to collect customer feedback. The app stores data in Microsoft Dataverse. Users report that some submissions are not saved when the app loses internet connection. How should the app be modified to prevent data loss?

A.Use a SharePoint list instead of Dataverse

B.Reduce the number of controls on the form

C.Increase the data row limit in Dataverse

D.Enable offline capability in the app settings

AnswerD

Enabling offline capability lets the canvas app cache submissions locally and sync them to Microsoft Dataverse once connectivity returns, directly addressing the intermittent-connection constraint in the stem. Without it, writes fail silently during outages. This is the only option that preserves data across disconnections rather than merely warning users or retrying after failure.

Why this answer

Enabling offline capability with a local cache allows data to be saved locally and synced when online. Reducing controls or increasing data limit won't solve offline loss.

Full explanation →

359

MCQeasy

An organization needs to create a custom app that displays data from Dynamics 365 Sales and allows users to update records. The app should automatically generate a responsive UI based on the data model. Which type of app should they build?

A.Model-driven app

B.Canvas app

C.Power Automate

D.Power Pages

AnswerA

Model-driven apps generate a responsive UI directly from the Dataverse data model, so no manual layout is needed. Because Dynamics 365 Sales stores its records in Dataverse, the app can display and update those records natively, satisfying the automatic UI generation requirement.

Why this answer

A model-driven app is the correct choice because it automatically generates a responsive UI based on the underlying data model (e.g., Dynamics 365 Sales entities like Account, Contact, Opportunity). It provides built-in forms, views, and business process flows that allow users to view and update records without manual UI design, aligning with the requirement for automatic UI generation and data update capabilities.

Exam trap

The trap here is that candidates often confuse canvas apps (which require manual UI design) with model-driven apps (which auto-generate UI from data), leading them to choose canvas apps because they think 'custom app' means full control over the interface, ignoring the 'automatically generate a responsive UI' requirement.

How to eliminate wrong answers

Option B (Canvas app) is wrong because it requires manual design of the user interface from scratch, not automatically generating a responsive UI based on the data model. Option C (Power Automate) is wrong because it is a workflow automation tool, not an app for displaying and updating records with a UI. Option D (Power Pages) is wrong because it is designed for external-facing websites, not for internal custom apps that interact with Dynamics 365 Sales data and require automatic UI generation from the data model.

Full explanation →

360

MCQmedium

You are designing a Power Pages site for a university to allow students to view their grades. Each student should only see their own records in the Grades table. The Grades table has a lookup column to the Contacts table. What table permission configuration should you use?

A.Set the table permission scope to 'Global' and restrict using a view.

B.Set the table permission scope to 'Contact' and assign the permission to the student web role.

C.Create a separate web role for each student.

D.Use a Power Automate flow to filter records.

AnswerB

Setting the table permission scope to 'Contact' restricts each student to records linked to their own contact via the Grades lookup column, so they see only their own grades. Assigning it to the student web role applies that restriction to authenticated students.

Why this answer

Contact scope restricts records where the Contact lookup matches the logged-in user's contact.

Full explanation →

361

MCQmedium

A user built a canvas app that uses a SharePoint list. When they add the app to a Teams channel, some users cannot see the data. The app works fine when opened directly from Power Apps. What is the most likely cause?

A.The users do not have Power Apps licenses assigned

B.The app uses a deprecated connector

C.The users do not have permissions to the underlying SharePoint list

D.The SharePoint connector requires a Premium license in Teams

AnswerC

Canvas apps connected to SharePoint inherit the list's item-level permissions; users lacking SharePoint list access see no data even though the app itself is shared. This explains why direct Power Apps access works but Teams access fails.

Why this answer

The most likely cause is that users do not have permissions to the underlying SharePoint list. When the app is accessed via Teams, the app runs in the context of the user, and SharePoint permissions are enforced. Even though the app works when opened directly from Power Apps (if the user has permissions), adding it to a Teams channel may expose users who lack access to the list.

Option A is incorrect because licenses are per user and not specific to Teams; if users have Power Apps licenses, they can use the app. Option B is incorrect because the app works outside Teams, so the connector is not deprecated. Option D is incorrect because the SharePoint connector does not require a Premium license in Teams.

Full explanation →

362

MCQhard

A Power App uses a Patch function to update a Dataverse table. The app runs into delegation warnings for large datasets. Which approach best resolves delegation warnings while maintaining functionality?

A.Increase the data row limit in the app settings

B.Switch the data source to SharePoint for better delegation support

C.Avoid using delegable functions to reduce complexity

D.Use delegable functions such as Filter and LookUp to retrieve only necessary records before performing updates

AnswerD

Delegation warnings arise when operations cannot be translated into Dataverse queries. Using delegable functions such as Filter and LookUp pushes record selection to the server, so only the required rows return and updates proceed without client-side limits.

Why this answer

Using delegable functions like Filter and LookUp allows the app to process only the necessary subset of records from Dataverse, avoiding delegation warnings by keeping data operations within the server's capacity. Option A is wrong because increasing the data row limit only changes the number of records fetched, but does not resolve delegation warnings; it may even exacerbate performance issues. Option B is wrong because switching to SharePoint does not inherently fix delegation problems—SharePoint has different delegation limits and may still trigger warnings.

Option C is wrong because avoiding delegable functions would likely make delegation warnings worse, as non-delegable functions force the app to load all data locally.

Full explanation →

363

MCQmedium

A marketing team needs to analyze customer feedback from surveys and social media. They want to use AI to extract sentiment and key topics. Which capability should they use?

A.Microsoft Copilot Studio

B.Power BI natural language queries

C.Power Automate

D.AI Builder

AnswerD

AI Builder supplies prebuilt sentiment analysis and key phrase extraction models that process text without custom machine-learning code. This satisfies the marketing team's need to derive sentiment and topics from survey and social media text, integrating directly into Power Apps and Power Automate flows.

Why this answer

AI Builder is Microsoft Power Platform's prebuilt and custom AI capability that includes sentiment analysis and key phrase extraction models, which can be invoked from Power Apps, Power Automate, or Power Virtual Agents. It is purpose-built to extract sentiment and topics from unstructured text such as survey responses and social media posts. This directly matches the marketing team's requirement without needing custom ML code.

Exam trap

PL-900 often tests whether candidates can distinguish AI Builder (AI model execution) from Power Automate (workflow orchestration) and Power BI (visualization) — the trap is picking the tool that 'sounds' analytical rather than the one that actually performs the AI inference.

How to eliminate wrong answers

Option A is wrong because Microsoft Copilot Studio is used to build conversational chatbots and copilots, not to perform sentiment or topic extraction on bulk text data. Option B is wrong because Power BI natural language queries (Q&A) let users ask questions about existing datasets in natural language; they do not themselves perform AI sentiment or topic extraction on raw feedback text. Option C is wrong because Power Automate is a workflow automation tool that can orchestrate actions but does not natively provide sentiment analysis or key phrase extraction — it would need to call AI Builder or another AI service to do so.

Full explanation →

364

MCQhard

You are a Power BI administrator for a large retail company. The company has a Power BI workspace that contains a dashboard named 'Sales Overview'. The dashboard is shared with the sales team. Recently, users have reported that the dashboard is loading slowly, and some visuals show 'Data is not available' errors. The dashboard uses a DirectQuery connection to an on-premises SQL Server database. The database team confirms that the server is not under heavy load. You need to troubleshoot and resolve the issue. What should you do first?

A.Check the on-premises data gateway performance and logs for errors

B.Replace the DirectQuery connection with an Import connection

C.Ask the database team to add more indexes to the SQL Server tables

D.Increase the scheduled refresh frequency to every 15 minutes

AnswerA

DirectQuery routes every visual query through the on-premises data gateway, so gateway latency or errors produce slow loads and 'Data is not available' messages even when the SQL Server itself is healthy. Checking gateway performance and logs isolates the failing hop first.

Why this answer

The on-premises data gateway is the critical bridge between Power BI and the on-premises SQL Server when using DirectQuery. Slow loading and 'Data is not available' errors often stem from gateway performance issues, connectivity problems, or errors logged by the gateway service. Checking the gateway logs and performance metrics is the first logical troubleshooting step before making architectural changes.

Exam trap

The trap here is that candidates assume the issue is database-side (indexes or load) or try to change the connection mode (Import) without first verifying the gateway, which is the most common point of failure in hybrid Power BI deployments.

How to eliminate wrong answers

Option B is wrong because replacing DirectQuery with Import would change the data architecture entirely, requiring a full data refresh and potentially breaking real-time reporting needs; it is a drastic solution, not a first troubleshooting step. Option C is wrong because the database team confirmed the server is not under heavy load, so adding indexes would not address the reported symptoms and is a premature optimization. Option D is wrong because scheduled refresh frequency is irrelevant for DirectQuery connections, which query the source live and do not use scheduled refreshes; increasing refresh frequency would have no effect on DirectQuery performance.

Full explanation →

365

MCQmedium

A retail company uses Microsoft Copilot Studio to build an internal copilot that helps store managers reorder low-stock items. The reorder process is implemented as a Power Automate cloud flow named 'Submit Reorder'. The copilot must collect an item number and quantity from the manager and then run the flow. Which Copilot Studio action should you add to the topic to run the flow?

A.Call an action, selecting the 'Submit Reorder' cloud flow.

B.Enable the 'Generate responses' setting so the copilot can infer when to run the flow.

C.Create a new entity named 'Submit Reorder' and map it to the item number variable.

D.Add a Redirect node that sends the user to the Power Automate portal to run the flow manually.

AnswerA

Copilot Studio exposes Power Automate cloud flows as actions that can be invoked from within a topic. Selecting the 'Submit Reorder' flow as a call an action step runs the flow during the conversation and returns its outputs to the copilot. Inputs collected earlier, such as item number and quantity, can be mapped into the flow's parameters, making this the correct way to execute the reorder process.

Why this answer

Power Automate cloud flows are surfaced in Copilot Studio as actions, and a topic can invoke them with a call an action step. This lets the copilot pass collected inputs such as item number and quantity into the flow and return results to the conversation. Redirects, entities, and generative response settings do not execute cloud flows.

Exam trap

The trap here is assuming that enabling generative responses or creating a similarly named entity will cause the flow to run, when the flow must be explicitly invoked as an action.

Full explanation →

366

MCQhard

Refer to the exhibit. You are reviewing an ARM template that creates a Power Platform environment. The deployment fails with an error stating that the 'Microsoft.PowerApps/environments' resource type is not supported in the current subscription. What is the most likely reason?

A.The Microsoft.PowerApps resource provider is not registered in the subscription.

B.The environment name parameter contains invalid characters.

C.The environmentSku 'Production' is not a valid SKU.

D.The location parameter is set to an unsupported region.

AnswerA

ARM deployments require the target resource provider to be registered in the subscription before its resource types can be created. Registering Microsoft.PowerApps resolves the unsupported resource type error, since the provider namespace is otherwise unavailable to the deployment.

Why this answer

The error 'resource type is not supported in the current subscription' indicates that the Azure Resource Manager (ARM) deployment cannot find the Microsoft.PowerApps resource provider. This provider must be explicitly registered at the subscription level before any Power Platform environment resources can be created via ARM templates. Without registration, ARM rejects the resource type as unsupported, regardless of other template parameters.

Exam trap

The PL-900 exam often tests the distinction between resource provider registration errors and parameter validation errors, trapping candidates who focus on template syntax or SKU values instead of the underlying Azure subscription configuration.

How to eliminate wrong answers

Option B is wrong because invalid characters in the environment name would cause a validation error (e.g., 'InvalidResourceName'), not a 'resource type not supported' error. Option C is wrong because 'Production' is a valid environment SKU for Power Platform environments; the error is about the resource provider, not the SKU value. Option D is wrong because an unsupported region would produce a location-specific error (e.g., 'The provided location is not supported'), not a resource type registration error.

Full explanation →

367

Multi-Selecteasy

Which TWO of the following are valid environment types in Power Platform?

Select 2 answers

A.Development

B.Production

C.Sandbox

D.Trial

E.Preview

AnswersB, C

Production is a standard environment type.

Why this answer

Production and Sandbox are both valid environment types in Power Platform. Production environments are intended for live, end-user applications and data, while Sandbox environments are isolated, non-production environments used for development, testing, and training. Both support the full set of Power Platform capabilities, including Dataverse, Power Apps, Power Automate, and Power Virtual Agents.

Exam trap

The trap here is that candidates often confuse 'Development' as a separate environment type, but Power Platform only uses Production, Sandbox, Trial, and Preview as environment types, with Sandbox serving the development role.

Full explanation →

368

MCQmedium

A financial analyst needs to create a Power Automate cloud flow that runs when a new response is submitted in a Microsoft Forms survey. The flow must then post the respondent's email address and the survey score to a Microsoft Teams channel. Which trigger should the analyst use?

A.When an item is created – SharePoint

B.When a new email arrives – Office 365 Outlook

C.When a record is created – Microsoft Dataverse

D.When a new response is submitted – Microsoft Forms

AnswerD

This trigger is specifically designed to fire when a new response is submitted to a Microsoft Forms survey. It provides the response ID, which can then be used with the 'Get response details' action to retrieve the respondent's email and answers. This is the correct starting point for any flow that reacts to form submissions and needs to process the response data.

Why this answer

The Microsoft Forms connector includes a trigger that fires immediately when a new response is submitted. It returns a response ID that can be used with the 'Get response details' action to fetch the respondent's email and answers. This direct integration ensures the flow processes the exact response data without relying on indirect methods like emails or SharePoint lists.

Other triggers are unrelated to form submissions and would require additional setup.

Exam trap

The trap here is assuming that form responses are stored in SharePoint or Dataverse by default, leading to the wrong trigger; the native Microsoft Forms trigger is the correct and simplest choice.

Full explanation →

369

MCQmedium

You need to create a flow that runs on the first day of every month and sends a summary email of all new SharePoint list items added in the previous month. The email should be sent to the sales team. Which type of flow should you create?

A.Business process flow

B.Desktop flow

C.Scheduled cloud flow

D.Automated cloud flow

AnswerC

A scheduled cloud flow uses a Recurrence trigger, which supports monthly intervals and specific days, satisfying the first-day-of-every-month requirement. A Get items action with an ODATA date filter then retrieves only the previous month's SharePoint list items for the summary email.

Why this answer

A scheduled cloud flow can run on a recurring schedule (e.g., first day of month) and includes actions to query SharePoint and send email. Automated flows trigger on events, not schedules. Desktop flows are for desktop automation.

Business process flows guide users through stages.

Full explanation →

370

MCQeasy

You need to create a Power Automate flow that runs every Monday at 9 AM to update a SharePoint list. Which trigger should you use?

A.When an item is created

B.Power Apps button

C.Schedule - Recurrence

D.When a new email arrives

AnswerC

The Recurrence trigger accepts a schedule configuration, so setting it to weekly on Monday at 09:00 satisfies the stated timing requirement. It fires automatically without user interaction, unlike event-based SharePoint triggers that respond only to item changes.

Why this answer

The correct trigger for a flow that runs on a schedule (every Monday at 9 AM) is the 'Schedule - Recurrence' trigger. Option A ('When an item is created') is an event-based trigger that runs when an item is added to a list, not on a schedule. Option B ('Power Apps button') is a manual trigger that requires user interaction.

Option D ('When a new email arrives') is an event-based trigger that runs when an email arrives. Therefore, only option C meets the requirement.

Full explanation →

371

MCQeasy

A sales team wants to automate follow-up emails after a lead is created in Dynamics 365 Sales. Which Power Platform component should they use?

A.Power BI

B.Power Automate

C.Power Apps

D.Microsoft Copilot Studio

AnswerB

Power Automate triggers on the Dynamics 365 lead-creation event and executes the follow-up email action automatically, satisfying the automation requirement without manual intervention. Unlike Power Apps, which builds interactive interfaces, or Power BI, which visualises data, it provides event-driven workflow orchestration across connectors.

Why this answer

Power Automate is the correct choice because it is designed to create automated workflows that trigger actions based on events, such as sending a follow-up email when a new lead is created in Dynamics 365 Sales. It uses connectors to integrate with Dynamics 365 and email services, enabling a no-code automation that runs without manual intervention.

Exam trap

The trap here is that candidates confuse Power Automate with Power Apps, assuming that building a custom app is required to send emails, when in fact Power Automate is the dedicated tool for event-driven automation without a user interface.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and analytics tool, not a workflow automation platform; it cannot send emails or trigger actions based on lead creation. Option C is wrong because Power Apps is used to build custom applications with user interfaces, not to automate backend processes like sending emails; it lacks built-in triggers for event-driven actions. Option D is wrong because Microsoft Copilot Studio is designed for creating conversational AI agents (chatbots), not for automating email sequences based on CRM events.

Full explanation →

372

MCQeasy

A user wants to automate sending a welcome email to new users added to Microsoft Entra ID. Which Power Automate trigger should they use?

A.When a new email arrives

B.When a row is added, modified or deleted in Dataverse

C.When a user is added to Azure AD

D.When a file is created in SharePoint

AnswerC

The Microsoft Entra ID connector's trigger fires when a user account is created in the directory, which is exactly the event the welcome email must respond to. It satisfies the requirement to automate email on new user creation.

Why this answer

Power Automate includes a native Microsoft Entra ID (Azure AD) connector with the trigger 'When a user is added to Azure AD' (also surfaced as 'When a user is created' in some versions). This trigger fires when a new user object is created in the tenant, making it the correct choice for automating a welcome email to new users. The other triggers are tied to different services (email, Dataverse, SharePoint) and would not fire on user creation.

Exam trap

The trap is picking a trigger that sounds related (e.g., 'When a new email arrives') instead of the one tied to the actual event source — always match the trigger's service to the event you want to detect.

How to eliminate wrong answers

Option A is wrong because 'When a new email arrives' triggers on incoming mail, not on user provisioning — it would fire for every email, not for new users. Option B is wrong because 'When a row is added, modified or deleted in Dataverse' is specific to Dataverse tables and would not detect Entra ID user creation unless a custom sync existed. Option D is wrong because 'When a file is created in SharePoint' fires on file events, not on directory user creation.

Full explanation →

373

Multi-Selecthard

Which THREE components are part of a Power Automate cloud flow?

Select 3 answers

A.Action

B.Connector

C.Business process flow

D.Power Apps

E.Trigger

AnswersA, B, E

An action is a discrete operation performed after the trigger, such as creating a record or sending a message. It is a core building block of a cloud flow definition, satisfying the question's requirement for a flow component.

Why this answer

A Power Automate cloud flow is built from three core components: a Trigger (option E), which defines the event that starts the flow (such as a new email, a scheduled recurrence, or an HTTP request); an Action (option A), which is each step that performs work after the trigger (for example, sending a Teams message, creating a SharePoint item, or calling a connector operation); and a Connector (option B), which is the API wrapper that exposes the underlying service's triggers and actions to the flow. These three elements are exactly what the flow designer composes into the definition that runs in the Power Automate service. Business process flow (option C) is a different Power Platform feature used in Dynamics 365/model-driven apps for guiding users through stages, not a component of a cloud flow, and Power Apps (option D) is a separate app-building service rather than a building block inside a flow.

Full explanation →

374

MCQmedium

Your company wants to use AI to analyze customer feedback from surveys and identify common themes. The solution should be built using Microsoft Power Platform. Which capability should you use?

A.Power Virtual Agents with a topic

B.AI Builder

C.Power BI with natural language queries

D.Power Automate with a custom connector

AnswerB

AI Builder supplies prebuilt and custom AI models, including text classification and sentiment analysis, that can be invoked from Power Apps and Power Automate. It analyses survey feedback text and surfaces recurring themes without bespoke machine-learning development.

Why this answer

AI Builder in Microsoft Power Platform provides prebuilt AI models, including sentiment analysis and text classification, which can analyze customer feedback from surveys to identify common themes. It integrates with Power Apps and Power Automate, enabling no-code AI capabilities.

Exam trap

PL-900 often tests the confusion between AI Builder and Power BI; AI Builder is for AI capabilities, while Power BI is for analytics and visualization.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is for building chatbots, not analyzing feedback. Option C is wrong because Power BI with natural language queries is for data visualization and querying, not for AI-driven theme identification. Option D is wrong because Power Automate with a custom connector is for workflow automation, not for AI analysis.

Full explanation →

375

MCQmedium

An organization uses Power Automate to approve expense reports. Managers want to approve via Microsoft Teams. Which connector should be used?

A.Office 365 Outlook

B.Dataverse

C.Microsoft Teams

D.SharePoint

AnswerC

The Microsoft Teams connector exposes actions that post adaptive cards and approval requests directly into Teams channels or chats, letting managers approve expense reports without leaving Teams. This satisfies the stated requirement to approve via Microsoft Teams rather than email or the Power Automate mobile app.

Why this answer

The Microsoft Teams connector is the correct choice because it enables Power Automate flows to interact directly with Microsoft Teams, allowing managers to approve expense reports through Teams messages, adaptive cards, or chat-based approvals without leaving the Teams interface.

Exam trap

The trap here is that candidates often confuse the SharePoint connector (which can store expense reports) with the Teams connector (which handles the approval interaction), forgetting that the approval action itself must be performed through a communication channel like Teams, not the storage platform.

How to eliminate wrong answers

Option A is wrong because the Office 365 Outlook connector is designed for email and calendar operations, not for sending or receiving approvals within Microsoft Teams channels or chats. Option B is wrong because Dataverse is a data storage and management service (formerly Common Data Service) that does not provide direct integration with Teams approval workflows; it stores data but does not trigger or handle approval actions in Teams. Option D is wrong because SharePoint is a document and content management platform; while it can store expense reports and trigger flows, it lacks the native Teams messaging and approval card capabilities needed for managers to approve directly in Teams.

Full explanation →

Page 5 of 10

All pages

1 2 3 4 5 6 7 8 9 10

Practice PL-900 by domain

Target a specific domain to shore up weak areas.

Demonstrate the capabilities of Power Apps Demonstrate the capabilities of Power Automate Describe the business value of Microsoft Power Platform Manage the Microsoft Power Platform environment Demonstrate the capabilities of Microsoft Copilot Studio

See all domains with question counts →