CCNA Power Platform Business Value Questions — Page 2 of 3

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

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.

Practice this question →

MCQmedium

A sales team uses Power BI dashboards to track quarterly revenue. They notice that the data in the dashboard is not updating as expected. The data source is a SharePoint list. What should the administrator check first?

A.Check the scheduled refresh settings in the Power BI dataset.

B.Install the on-premises data gateway.

C.Verify that all sales team members have edit permissions on the SharePoint list.

D.Ensure that the SharePoint list has no hidden columns.

AnswerA

Power BI datasets refresh on a schedule configured in the dataset settings, so stale SharePoint data usually means the refresh schedule is disabled, misconfigured, or failing. Checking that schedule first satisfies the scenario's requirement to identify why dashboard data is not updating.

Why this answer

Power BI datasets connected to SharePoint lists require a scheduled refresh to update the dashboard with the latest data from the list. If the refresh is not configured or fails, the dashboard will display stale data. The administrator should first check the scheduled refresh settings in the Power BI service to ensure it is enabled and running successfully.

Exam trap

The trap here is that candidates might assume the issue is related to permissions or data structure (options C or D) rather than recognizing that Power BI dashboards do not automatically refresh cloud data sources without a configured schedule.

How to eliminate wrong answers

Option B is wrong because an on-premises data gateway is only needed when connecting to on-premises data sources (e.g., SQL Server on a local network), not to SharePoint Online, which is a cloud service. Option C is wrong because edit permissions on the SharePoint list are not required for Power BI to read data; read permissions are sufficient, and the issue is about data freshness, not access. Option D is wrong because hidden columns in a SharePoint list do not affect Power BI's ability to refresh or display data; they are simply not included in the dataset unless explicitly added.

Practice this question →

MCQhard

Refer to the exhibit. A Power Automate flow runs hourly to retrieve new accounts from Dataverse. However, it sometimes misses records created at the exact hour boundary. What is the most likely reason?

A.The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs.

B.The accounts table has a security filter that hides records from the flow owner.

C.The API connection to Dataverse is not authenticated properly.

D.The filter query uses utcNow() which may not be precise across time zones.

AnswerA

A recurring schedule trigger only queries at fixed intervals, so records created between executions are absent until the next run. This explains the missed hour-boundary records, unlike an event-driven Dataverse trigger that fires on creation.

Why this answer

The flow is configured to run on a recurring schedule (e.g., every hour), not as an instant trigger on record creation. When a record is created at the exact boundary between two scheduled runs, it may not be captured by the previous run (which already completed) and may not yet exist when the next run begins, especially if the flow uses a filter query based on a timestamp. This is a classic limitation of scheduled polling compared to event-driven triggers like 'When a row is added, modified, or deleted' in Dataverse.

Exam trap

The trap here is that candidates often assume utcNow() is the cause of the issue, but the real problem is the fundamental difference between scheduled polling and event-driven triggers in Power Automate.

How to eliminate wrong answers

Option B is wrong because a security filter on the accounts table would consistently hide records from the flow owner, not cause intermittent misses at hour boundaries. Option C is wrong because an authentication issue would cause the flow to fail entirely on every run, not selectively miss records at specific times. Option D is wrong because utcNow() is time-zone agnostic and returns the current UTC time; the precision issue is not about time zones but about the polling interval missing records created between runs.

Practice this question →

Multi-Selectmedium

Which TWO benefits does Power Platform offer to organizations? (Choose two.)

Select 2 answers

A.Provides seamless integration with Microsoft 365 and Azure

B.Enables citizen developers to build apps with minimal coding

C.Is free for all users with an Office 365 license

D.Eliminates the need for any custom development

AnswersA, B

Power Platform connectors natively surface Microsoft 365 services such as SharePoint and Teams, plus Azure services like Logic Apps and Functions. This shared identity and data fabric satisfies the integration benefit, letting organisations reuse existing Microsoft investments rather than building bespoke links.

Why this answer

Option A is correct because Power Platform connectors natively integrate with Microsoft 365 services (SharePoint, Teams, Outlook, Dataverse) and Azure services (Azure Functions, Logic Apps, API Management, Azure AD), allowing apps and flows to use existing identity, data, and cloud resources without custom middleware. Option B is correct because Power Apps, Power Automate, and Power Virtual Agents provide low-code/no-code visual designers, prebuilt templates, and drag-and-drop components that let citizen developers (business users outside IT) create solutions with minimal or no traditional programming. Option C is not correct because Power Platform requires standalone Power Apps/Power Automate per-user or per-app licenses; an Office 365 license alone does not grant full Power Platform capabilities beyond limited seeded rights.

Option D is not correct because Power Platform augments rather than eliminates custom development—complex scenarios still require pro-code extensions, custom connectors, plug-ins, or Azure services.

Exam trap

The trap here is that candidates assume Power Platform is entirely free with Office 365 or that it completely replaces custom development, but Microsoft explicitly requires additional licensing for premium features and encourages hybrid solutions where custom code handles edge cases.

Practice this question →

MCQmedium

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

A.Create a canvas app in Power Apps

B.Use Power Automate to generate a mobile app

C.Build a custom iOS app using Swift and Xcode

D.Create a model-driven app in Power Apps

AnswerA

Canvas apps provide drag-and-drop screens and native Dataverse connectors, so technicians get mobile work-order views and updates with minimal coding. This directly satisfies the constraint of minimising development effort, unlike model-driven or custom-code approaches that demand more configuration or developer skill.

Why this answer

Canvas apps in Power Apps are designed for rapid, low-code development with drag-and-drop UI and direct Dataverse connectivity, making them the fastest path to a mobile-friendly work order app. They can be published to Power Apps mobile and run on iOS and Android without native development.

Exam trap

PL-900 often tests the distinction between canvas and model-driven apps — candidates must recognize that canvas apps minimize effort for custom mobile UIs, while model-driven apps are better for complex, data-centric processes.

How to eliminate wrong answers

Option B is wrong because Power Automate is a workflow automation service, not an app builder — it cannot generate a mobile UI. Option C is wrong because building a native Swift app requires significant development effort, which contradicts the goal of minimizing effort. Option D is wrong because model-driven apps are optimized for complex data models and desktop-style forms, and they require more setup (sitemap, forms, views) than a canvas app for a simple field technician scenario.

Practice this question →

Multi-Selectmedium

Which Power Platform component can be used to create and deploy a chatbot?

Select 1 answer

A.Power Automate

B.Power BI

C.Power Apps

D.Copilot Studio

E.AI Builder

AnswersD

Copilot Studio creates and deploys chatbots, satisfying the stem's requirement. It provides a low-code canvas for conversational topics, generative answers, and channel publishing, letting makers build bots that connect to Power Platform and external data without custom code.

Why this answer

Copilot Studio (formerly Power Virtual Agents) is the dedicated Power Platform component for creating and deploying chatbots using a no-code graphical interface. It allows you to design conversational topics, trigger flows, and publish the bot to channels like Microsoft Teams or websites without writing code. AI Builder provides AI models that can be integrated into a chatbot solution but cannot create or deploy a standalone chatbot.

Exam trap

The trap is that candidates may mistake AI Builder for a chatbot builder because it offers AI capabilities that can enhance chatbots, but it is not a standalone chatbot creation tool.

Practice this question →

MCQmedium

A financial services firm wants to automate a monthly approval process. When a department submits a request in a SharePoint list, the request must be routed to the correct approver based on the department name, and the approver must respond by email. The company wants to minimize custom development. Which Power Platform service should the firm use?

A.Power Automate

B.Power Virtual Agents

C.Power BI

D.Power Apps

AnswerA

Power Automate is the workflow automation service in the Power Platform. It can trigger when a SharePoint item is created, use a condition or switch to route by department, and send approval requests through the Approvals connector. This matches the requirement to automate routing and email-based approval with minimal custom code.

Why this answer

Power Automate provides the connectors and logic needed to trigger on a SharePoint item, branch by department, and send approval requests that approvers can act on directly from email. It is the Power Platform service purpose-built for workflow automation with minimal development. The other services handle app creation, reporting, or chat, none of which automate the approval routing described.

Exam trap

The trap here is focusing on the SharePoint submission and assuming an app is needed, when the essential requirement is automated routing and email approval handled by a flow.

Practice this question →

MCQeasy

A marketing team wants to create a mobile app that allows field representatives to quickly log customer visits, capture photos, and view recent interactions. The team has limited coding experience and wants to use a drag-and-drop interface. Which Power Platform component should they use?

A.Power Apps

B.Power BI

C.Power Automate

D.Power Virtual Agents

AnswerA

Power Apps provides a drag-and-drop designer to build custom business apps for web and mobile. It supports data entry forms, camera integration, and connections to data sources like SharePoint or Dataverse. This allows field representatives to log visits, capture photos, and view interactions without writing code, perfectly matching the team's needs and skill level.

Why this answer

Power Apps is the low-code development platform in the Microsoft Power Platform, enabling users to create custom apps with a drag-and-drop interface. It supports mobile scenarios, camera controls, and integration with various data sources, making it ideal for field representatives to log visits and capture photos. The other components are not designed for building custom data entry apps.

Exam trap

The trap here is underestimating Power Apps' mobile capabilities, assuming that custom app development always requires professional coding.

Practice this question →

Multi-Selecteasy

Which TWO are examples of using AI Builder within Power Platform? (Select TWO)

Select 2 answers

A.Setting up a Power Automate trigger when a new email arrives.

B.Extracting text from scanned invoices using prebuilt models.

C.Designing a custom screen in a Power Apps canvas app.

D.Creating a Power BI dashboard to visualize sales data.

E.Identifying objects in images using a custom object detection model.

AnswersB, E

AI Builder's form processing extracts text.

Why this answer

AI Builder provides prebuilt models that can extract text and data from scanned invoices without requiring custom machine learning expertise. This capability integrates directly into Power Automate and Power Apps, enabling automated processing of invoice data within the Power Platform.

Exam trap

The trap here is that candidates confuse general Power Platform features (like triggers, screen design, or dashboards) with AI Builder's specific role of providing prebuilt and custom AI models, leading them to select options that are valid Power Platform capabilities but not AI Builder examples.

Practice this question →

MCQmedium

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

A.The app has too many Power Automate flows

B.The Dataverse environment is in a different region

C.The app uses Microsoft Entra ID for authentication

D.The app contains large images that are not optimized

AnswerD

Large, unoptimised images inflate the app's payload, so each mobile screen must download and render far more data than necessary over constrained bandwidth. Since the stem's constraint is slow loading specifically on mobile devices, image weight is the dominant factor; desktop connections mask it. Optimising or compressing those assets directly reduces load time.

Why this answer

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

Exam trap

The trap here is that candidates often confuse server-side latency (e.g., Dataverse region) with client-side resource loading, assuming any performance issue must be related to data or authentication rather than the app's static assets.

How to eliminate wrong answers

Option A is wrong because Power Automate flows run asynchronously and do not block the initial loading of a Power Apps canvas app; they are triggered by events and do not affect startup performance. Option B is wrong while a Dataverse environment in a different region can increase latency for data queries, it does not cause the app itself to load slowly on the device—app loading is primarily a client-side operation. Option C is wrong because Microsoft Entra ID authentication is a standard, lightweight token-based process that adds negligible overhead to app startup; it is not a common cause of slow loading.

Practice this question →

MCQmedium

A non-profit organization wants to automate the process of sending thank-you emails to donors after a donation is recorded in a SharePoint list. Which Power Platform tool should they use?

A.Power Apps

B.Power Virtual Agents

C.Power Automate

D.Power BI

AnswerC

Power Automate triggers on the SharePoint list item creation event and runs an automated cloud flow that sends the thank-you email via an Outlook connector. This delivers the event-driven automation the non-profit needs without manual intervention.

Why this answer

Power Automate is the correct tool because it is designed to create automated workflows that trigger actions based on events, such as a new item being added to a SharePoint list. In this scenario, a Power Automate flow can be configured to run automatically when a donation is recorded, then send a thank-you email via an email connector (e.g., Outlook or SMTP). This directly addresses the need for process automation without manual intervention.

Exam trap

The trap here is that candidates often confuse Power Apps (which can display data and trigger flows) with Power Automate, forgetting that Power Automate is the dedicated tool for event-driven automation without requiring a custom app interface.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom apps (canvas or model-driven) that require user interaction, not for automating backend workflows like sending emails. Option B is wrong because Power Virtual Agents is used to create conversational chatbots for customer service or Q&A, not for triggering automated email actions based on data changes. Option D is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for executing automated processes or sending emails.

Practice this question →

MCQeasy

A mid-sized logistics company wants to give its drivers a mobile app to log delivery confirmations and capture customer signatures. The company has no professional developers and wants to build the app quickly using a drag-and-drop interface. Which Microsoft Power Platform service should they use?

A.Power Virtual Agents

B.Power BI

C.Power Apps

D.Power Automate

AnswerC

Power Apps provides a low-code, drag-and-drop canvas for building mobile and web apps without professional development. It supports offline data capture, signature controls, and integration with Dataverse or other data sources, making it the right fit for a driver-facing delivery confirmation app built rapidly by non-developers.

Why this answer

Power Apps is the low-code application development service in the Microsoft Power Platform. It enables non-developers to assemble mobile and web apps with drag-and-drop controls, connect to data sources, and include features like signature capture and offline use. The other services focus on automation, analytics, or chatbots, none of which deliver an interactive driver-facing app.

Exam trap

The trap here is assuming that any Power Platform service can build a mobile data-entry app, when only Power Apps provides the low-code UI design surface for that purpose.

Practice this question →

MCQmedium

A retail chain uses Power BI to analyze sales data from multiple stores. The data is stored in an Azure SQL Database. The company wants to give store managers access to a dashboard that shows their store's sales compared to the company average. However, store managers should not see other stores' data. The company also wants to automate the process of sending a weekly sales report to regional managers via email. The regional managers need to see aggregated data for their region. You need to implement a solution using Power Platform components. What should you do?

A.Create a Power Automate flow that runs a SQL query and sends the results via email, and give store managers access to the Azure SQL Database directly.

B.Create separate Power BI dashboards for each store and each region, and manually share them.

C.Create a Power BI dataset with RLS to filter by store, publish a dashboard, and use a scheduled Power Automate flow to email a paginated report to regional managers.

D.Use Power Apps to build a custom dashboard for each store, and use Power Automate to email reports.

AnswerC

Row-level security on the dataset filters each store manager to their own store's rows, while the scheduled Power Automate flow delivers a paginated report containing regional aggregates to regional managers. This satisfies both the per-store isolation and automated regional email requirements.

Why this answer

It uses Power BI Row-Level Security (RLS) to restrict store managers to only their store's data while allowing regional managers to see aggregated data via a paginated report. The scheduled Power Automate flow automates the weekly email delivery, meeting both security and automation requirements without manual intervention.

Exam trap

The trap here is that candidates often confuse Power BI dashboards with paginated reports, assuming a standard dashboard can be emailed directly, but Power BI requires a paginated report or a subscription feature for scheduled email delivery, and RLS is the only secure way to enforce per-store data isolation without duplicating datasets.

How to eliminate wrong answers

Option A is wrong because giving store managers direct access to the Azure SQL Database bypasses Power BI's RLS and exposes all stores' data, violating the requirement to restrict visibility. Option B is wrong because manually creating and sharing separate dashboards for each store and region is not scalable and fails to automate the weekly email report to regional managers. Option D is wrong because Power Apps custom dashboards are not designed for ad-hoc data exploration and aggregation like Power BI, and the solution does not address the need for a dashboard that compares store sales to company averages.

Practice this question →

MCQmedium

A mid-sized logistics company wants to replace its manual, paper-based expense approval process with a digital workflow. The IT team wants to minimize custom development and leverage built-in connectors to services like Outlook, SharePoint, and Dynamics 365. Which Power Platform component should they use to automate the approval process?

A.Power BI

B.Power Automate

C.Power Apps

D.Power Virtual Agents

AnswerB

Power Automate is designed to create automated workflows between services using connectors. It can trigger on events like a new file in SharePoint or an email in Outlook, and then route approval requests, send notifications, and update records. This directly addresses the need to replace manual approvals with a digital, connector-based process without custom code.

Why this answer

Power Automate is the service within the Microsoft Power Platform specifically built for automating workflows across applications and services. It provides hundreds of connectors, including Outlook, SharePoint, and Dynamics 365, enabling the logistics company to digitize the expense approval process without writing code. The other components serve different purposes: Power Apps for app development, Power BI for analytics, and Power Virtual Agents for chatbots.

Exam trap

The trap here is confusing the roles of Power Apps and Power Automate, assuming that building an app is necessary for any process automation.

Practice this question →

Drag & Dropmedium

Drag and drop the steps to configure a Power Virtual Agents chatbot in the correct order.

Drag or tap steps into the slots.

Steps

Order

1Step 1

2Step 2

3Step 3

4Step 4

Why this order

The correct sequence for configuring a Power Virtual Agents chatbot is: first create the bot, then define topics to handle user intents, add nodes to each topic to define the conversation flow, test the bot in the test pane to verify behavior, and finally publish the bot to make it available to users. Publishing before testing risks deploying unresolved issues.

Practice this question →

100

MCQmedium

A manufacturing company wants to give shop-floor supervisors a way to report equipment issues from a tablet. Supervisors are not programmers, and the company wants the solution to use a governed data service with role-based security so that only authorized staff can view sensitive maintenance records. Which Power Platform component should the company use to build the issue-reporting app?

A.Power Apps

B.Power Pages

C.Power BI

D.Power Automate

AnswerA

Power Apps is the Power Platform service for building canvas and model-driven applications with a low-code designer. It supports tablet layouts, connects to Dataverse for governed storage with role-based security, and lets non-programmers create the issue-reporting experience. This matches the requirement for an internal app built by business users against a secured data service.

Why this answer

Power Apps is the appropriate component because it provides a low-code app designer for tablet-friendly interfaces and integrates with Dataverse, which supplies governed storage and role-based security. Supervisors can report issues through the app, and authorized staff can be granted access through security roles. Power BI, Power Pages, and Power Automate serve analytics, external websites, and automation respectively, not internal app creation.

Exam trap

The trap here is selecting Power Pages for an internal tablet app because it also supports forms, when Power Pages is intended for external-facing websites and Power Apps is the internal app builder.

Practice this question →

101

MCQhard

A financial services firm wants to ensure that its Power Platform solutions comply with industry regulations. They need to monitor which users are creating apps, enforce data loss prevention policies, and manage environments. Which Power Platform capability should they use?

A.Power BI

B.Power Platform admin center

C.Power Apps

D.Power Automate

AnswerB

The Power Platform admin center provides a unified portal for administrators to manage environments, view analytics, set data loss prevention (DLP) policies, and monitor user activities. It allows the firm to enforce compliance, govern app creation, and manage the lifecycle of Power Platform resources, directly addressing the regulatory requirements.

Why this answer

The Power Platform admin center is the dedicated administrative portal for managing Power Platform environments, setting data loss prevention policies, and monitoring usage. It provides the governance and compliance features necessary for the financial services firm to meet regulatory requirements. The other components are for building solutions, not for administration.

Exam trap

The trap here is assuming that any Power Platform component can be used for administration, overlooking the specialized admin center.

Practice this question →

102

MCQeasy

A manufacturing company wants to give its shop-floor supervisors a way to report equipment issues from a tablet, with no coding. The solution must work on a touch screen and use a SharePoint list as the data source. Which Power Platform service should the company use?

A.Power Automate

B.Power BI

C.Power Apps

D.Power Virtual Agents

AnswerC

Power Apps is the low-code application development service in the Microsoft Power Platform. It provides a canvas app designer where makers can drag controls, connect directly to a SharePoint list, and publish a touch-friendly app to tablets. This directly satisfies the requirement of a no-code, touch-screen issue reporting solution backed by SharePoint data.

Why this answer

The requirement is a no-code app for tablet data entry, and Power Apps is the Power Platform service designed for building such apps. It connects natively to SharePoint lists and supports touch controls, letting supervisors submit equipment issues directly. The other services handle automation, analytics, or conversational bots, none of which provide the required form-based data capture experience.

Exam trap

The trap here is assuming that any Power Platform tool can collect structured data, when only Power Apps is built for creating a touch-friendly data entry app on SharePoint.

Practice this question →

103

MCQmedium

A retail company wants to reduce the time store managers spend on manual inventory reporting. Currently, managers use paper forms and email to submit daily stock counts, which then need to be manually entered into a central system. This process is error-prone and delays replenishment. The company wants a solution that automates data entry, provides real-time dashboards, and allows managers to submit reports from their phones without installing any software on the phones. Which combination of Microsoft Power Platform tools should the company use?

A.Power Automate only

B.Power Apps only

C.Power Apps, Power Automate, and Power BI

D.Power BI only

AnswerC

Power Apps delivers a phone browser-based canvas app requiring no installation, Power Automate replaces manual entry by writing counts into the central system, and Power BI supplies real-time dashboards. Together they satisfy automation, dashboards and no-install mobile submission.

Why this answer

The scenario requires a combination of Power Apps (for mobile-friendly report submission without installing software), Power Automate (to automate data entry into the central system), and Power BI (to provide real-time dashboards). Power Apps alone cannot automate data entry or provide dashboards; Power Automate alone cannot provide a mobile input interface or dashboards; Power BI alone cannot capture data or automate workflows. Only the trio covers all requirements: mobile input, automated processing, and real-time visualization.

Exam trap

The trap here is that candidates think a single tool can cover all requirements, but the question explicitly demands three distinct capabilities (mobile input, automation, dashboards) that map to three separate Power Platform components, not one or two.

How to eliminate wrong answers

Option A is wrong because Power Automate only handles workflow automation but cannot provide a mobile-friendly input form or real-time dashboards. Option B is wrong because Power Apps only provides the mobile input interface but cannot automate data entry into the central system or generate dashboards. Option D is wrong because Power BI only provides dashboards but cannot capture inventory submissions from phones or automate data entry.

Practice this question →

104

MCQeasy

A small retail chain wants to analyze sales data from its point-of-sale system and create interactive dashboards that show trends by store and product category. The company has business analysts who are familiar with Excel but not with programming. Which Power Platform service should the company use?

A.Power BI

B.Power Virtual Agents

C.Power Automate

D.Power Apps

AnswerA

Power BI is the business analytics service in the Power Platform. It connects to data sources, lets analysts build interactive reports and dashboards with a drag-and-drop experience similar to Excel, and supports sharing across the organization. This matches the retail chain's need to analyze sales data and visualize trends by store and category without programming.

Why this answer

Power BI is designed for business analysts to connect to data, model it, and build interactive reports and dashboards. Its familiar, Excel-like authoring experience lowers the learning curve for users without programming skills. By using Power BI, the retail chain can analyze point-of-sale data and visualize trends by store and product category, which is exactly the analytical outcome described.

Exam trap

The trap here is assuming that any Power Platform service can visualize data, when interactive dashboards and trend analysis are specifically the domain of Power BI.

Practice this question →

105

MCQeasy

Your organization wants to allow employees to submit help desk tickets through a mobile app. The solution must be low-code and integrate with Microsoft Teams. Which Microsoft Power Platform component should you use?

A.Power Apps

B.Power Virtual Agents

C.Power Automate

D.Power BI

AnswerA

Power Apps is the low-code component for building interactive apps, including mobile ones, and its Teams integration lets employees submit tickets inside Teams. This satisfies both the low-code and Microsoft Teams constraints in the scenario.

Why this answer

Power Apps is the correct component because it enables the creation of custom mobile apps with low-code development, allowing employees to submit help desk tickets directly from their mobile devices. It integrates natively with Microsoft Teams through the Power Apps app in Teams, enabling users to access and submit tickets without leaving the Teams interface. This aligns with the requirement for a low-code solution that works within the Teams ecosystem.

Exam trap

The trap here is that candidates often confuse Power Automate (automation) with Power Apps (app creation), assuming any integration with Teams must involve a workflow, but the question specifically asks for a component to build the mobile app itself, not the backend automation.

How to eliminate wrong answers

Option B is wrong because Power Virtual Agents is designed for building conversational chatbots, not for creating custom mobile apps; it could handle ticket submission via chat but does not provide a mobile app interface. Option C is wrong because Power Automate is an automation and workflow tool, not an app-building platform; while it can trigger actions like sending notifications, it cannot create the mobile app UI for ticket submission. Option D is wrong because Power BI is a data visualization and analytics tool, not a platform for building custom applications or forms; it cannot be used to submit help desk tickets.

Practice this question →

106

MCQmedium

A company wants to reduce manual data entry by automatically extracting information from invoices and updating a SharePoint list. Which combination of Power Platform components should they use?

A.Power BI and Power Virtual Agents

B.Power Apps and Power Automate

C.Power Automate and AI Builder

D.Power Apps and Power BI

AnswerC

AI Builder's form processing extracts invoice fields, and Power Automate triggers on receipt, passes the document to the model, then writes extracted values into SharePoint. This satisfies the requirement to remove manual data entry by combining document extraction with automated list updates.

Why this answer

AI Builder provides prebuilt invoice processing models that can extract key fields (e.g., invoice number, date, total) from documents, and Power Automate can trigger a flow to write that extracted data directly into a SharePoint list. This combination eliminates manual data entry by automating the extraction and storage pipeline.

Exam trap

The trap here is that candidates often assume Power Apps is needed for any data entry scenario, but in this case the automation is purely backend (no user interface required), so Power Automate combined with AI Builder is the correct and minimal solution.

How to eliminate wrong answers

Option A is wrong because Power BI is a data visualization and analytics tool, not a data extraction or automation tool, and Power Virtual Agents is for building conversational chatbots, not for processing invoices. Option B is wrong because Power Apps alone cannot extract data from invoices; it requires AI Builder or another OCR service to perform the extraction, and while Power Automate can orchestrate the flow, the combination lacks the AI extraction capability. Option D is wrong because Power BI is for reporting and analytics, not for data extraction or automation, and Power Apps cannot extract invoice data without an AI service.

Practice this question →

107

MCQmedium

A marketing department wants to create a custom portal where external partners can submit project proposals and track their status. Which Power Platform product should they use?

A.Power Automate

B.Power Apps portal (now Power Pages)

C.Power Virtual Agents

D.Power BI

AnswerB

Power Pages (formerly Power Apps portals) provides an external-facing website with Dataverse-backed forms and lists, letting partners authenticate and submit proposals while tracking status. Internal app builders like canvas apps cannot serve anonymous or external partner audiences.

Why this answer

Power Apps portals (now Power Pages) is the correct choice because it enables organizations to create low-code, externally facing websites that allow external users—such as partners—to sign in, submit project proposals, and track their status. It integrates with Microsoft Dataverse to store and manage the proposal data, and supports role-based access control to ensure partners only see their own submissions.

Exam trap

The trap here is that candidates often confuse Power Automate's ability to handle form submissions (e.g., via Microsoft Forms or SharePoint) with the need for a dedicated external-facing portal, overlooking that Power Pages is the only option that provides a customizable, authenticated website for external users.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool that orchestrates processes (e.g., sending approval emails) but does not provide a user-facing portal for external partners to submit or track data. Option C is wrong because Power Virtual Agents is designed for building conversational AI chatbots, not for creating custom web portals with data submission and tracking capabilities. Option D is wrong because Power BI is a business analytics and visualization platform; it can display proposal status dashboards but cannot serve as an interactive submission portal for external users.

Practice this question →

108

MCQmedium

A company has a legacy on-premises SQL Server database and wants to integrate it with a Power App without moving data to the cloud. Which connector should they use?

A.SQL Server connector directly

B.Power Automate on-premises agent

C.Dataverse

D.On-premises data gateway with SQL Server connector

AnswerD

The on-premises data gateway creates an outbound channel from Power Platform to on-premises resources, so the SQL Server connector queries the legacy database in place. No data migration to the cloud is required, satisfying the stated constraint.

Why this answer

The On-premises data gateway acts as a secure bridge between cloud services like Power Apps and on-premises data sources such as SQL Server. When combined with the SQL Server connector, it allows live queries and updates to the on-premises database without requiring data migration to the cloud, fulfilling the requirement to keep data on-premises.

Exam trap

The trap here is that candidates often confuse the On-premises data gateway with the Power Automate on-premises agent, mistakenly thinking the agent can serve as a general data connector, when in fact it is only for desktop flow automation.

How to eliminate wrong answers

Option A is wrong because the SQL Server connector alone cannot directly access an on-premises SQL Server from the cloud; it requires a gateway to traverse the firewall and network boundaries. Option B is wrong because Power Automate on-premises agent is a specific component for robotic process automation (RPA) and desktop flows, not for connecting Power Apps to on-premises SQL Server databases. Option C is wrong because Dataverse is a cloud-based data storage service that would require moving data to the cloud, which contradicts the requirement to keep data on-premises.

Practice this question →

109

MCQeasy

A sales team wants to quickly create a mobile app to track customer visits without writing code. Which Microsoft Power Platform component should they use?

A.Power Automate

B.Power Virtual Agents

C.Power Apps

D.Power BI

AnswerC

Power Apps provides a drag-and-drop canvas and model-driven designer for building mobile apps without code, publishing to phones for field use. This directly satisfies the sales team's requirement to track customer visits quickly with no programming.

Why this answer

Power Apps is the correct choice because it enables users to build custom mobile apps with a low-code or no-code approach, specifically designed for creating data-driven applications like a customer visit tracker. The sales team can connect to data sources (e.g., Dataverse, SharePoint, or Excel) and design a mobile-friendly interface without writing any code, making it ideal for quickly tracking customer visits.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps because both are low-code tools, but Power Automate is for automating workflows (e.g., sending an email after a visit), not for building the app interface itself.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for creating flows between apps and services, not for building mobile app interfaces or tracking customer visits directly. Option B is wrong because Power Virtual Agents is used to create conversational AI chatbots, not for building a mobile app to track visits. Option D is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for building interactive mobile applications.

Practice this question →

110

MCQmedium

Refer to the exhibit. A Power BI dashboard is configured with the shown data sources. The dashboard fails to refresh automatically. What is the most likely cause?

A.The refresh frequency is set to daily, which is too infrequent

B.The Excel file is stored in an unsupported location

C.The SQL Server data source requires an on-premises data gateway

D.The dashboard uses two data sources, but only one is allowed

AnswerC

On-premises SQL Server cannot be reached directly by the Power BI cloud service, so refreshes fail until an on-premises data gateway bridges the two. This satisfies the exhibit's hybrid connectivity constraint; cloud-only sources would refresh without a gateway, but local SQL Server requires one.

Why this answer

The dashboard refreshes automatically but fails. The data sources shown are an Excel file stored on SharePoint (supported, no gateway needed) and an on-premises SQL Server (server name indicates on-premises). For Power BI service to access on-premises data, an on-premises data gateway must be installed and configured.

Without it, the SQL Server connection will fail during refresh. Options A and D are incorrect because daily frequency and using two data sources are not issues. Option B is incorrect because SharePoint is a supported location for Excel files.

Therefore, the most likely cause is that the SQL Server data source requires an on-premises data gateway.

Practice this question →

111

MCQhard

A hospital wants to build a chatbot that answers patients' frequently asked questions about visiting hours, parking, and insurance, and then hands off to a live agent when the bot cannot answer. The hospital wants to minimize development effort and integrate with its existing website. Which Power Platform service should the hospital use?

A.Power Apps

B.Power Virtual Agents

C.Power Automate

D.Power BI

AnswerB

Power Virtual Agents is the Power Platform service for building chatbots with a graphical authoring experience. It supports topics, entities, and variables to answer FAQs, and it can hand off to a live agent through integration with Omnichannel for Customer Service or a custom handoff. This matches the hospital's need for a low-effort, website-integrated chatbot.

Why this answer

Power Virtual Agents is purpose-built for creating conversational bots without extensive coding. It can answer common patient questions through authored topics and can escalate to a human agent when needed. Because it can be published to a website and integrates with handoff mechanisms, it directly addresses the hospital's requirements for FAQ handling and live agent transfer with minimal development effort.

Exam trap

The trap here is assuming that a data-focused service like Power BI can handle conversational FAQs, when chatbot authoring and agent handoff belong to Power Virtual Agents.

Practice this question →

112

MCQmedium

A company uses Power Automate to process purchase orders. After a recent update, the flow fails intermittently with a '429 Too Many Requests' error. What is the most likely cause?

A.The flow uses an expired connector authentication.

B.The flow is running an outdated version.

C.The flow is exceeding Power Platform service protection limits.

D.The data source is temporarily unavailable.

AnswerC

HTTP 429 signals throttling, not a malformed expression or expired connection. Power Automate applies per-connection and per-flow service protection limits, so bursts of purchase-order runs exceeding those request thresholds cause intermittent failures until the retry window resets.

Why this answer

The '429 Too Many Requests' error is an HTTP status code indicating rate limiting. In Power Automate, this occurs when a flow exceeds the Power Platform service protection limits, which are designed to prevent resource overconsumption. These limits include API request caps (e.g., 30 requests per 60 seconds per connection) and daily invocation quotas (e.g., 5,000 requests per day for a per-user plan).

The error is not related to authentication expiry, outdated flow versions, or data source availability.

Exam trap

The trap here is that candidates confuse '429 Too Many Requests' with authentication or connectivity issues, but the exam specifically tests knowledge of Power Platform service protection limits as a distinct throttling mechanism.

How to eliminate wrong answers

Option A is wrong because an expired connector authentication would produce a '401 Unauthorized' or '403 Forbidden' error, not a '429 Too Many Requests' error. Option B is wrong because an outdated flow version does not cause HTTP 429 errors; flow versions affect feature availability but not API rate limits. Option D is wrong because a temporarily unavailable data source would return a '503 Service Unavailable' or connection timeout error, not a rate-limiting 429 response.

Practice this question →

113

MCQeasy

A small business owner wants to create a customer loyalty program. They want customers to earn points for purchases and redeem them for discounts. The owner has no coding experience and a limited budget. They need a mobile-friendly app for customers to check points and a backend to manage points and redemptions. What should they use?

A.Power BI, Power Automate, and Dataverse

B.Power Apps, Power Automate, and Dataverse

C.Power Apps, AI Builder, and Dataverse

D.Power Pages, Power Automate, and SharePoint

AnswerB

Power Apps delivers the mobile-friendly customer interface with no coding, Power Automate handles points and redemption logic, and Dataverse stores the loyalty data relationally. Together they satisfy the no-code, low-budget constraint whilst providing both app and backend.

Why this answer

Power Apps allows building a mobile-friendly app without coding, Power Automate handles workflow automation for points and redemptions, and Dataverse provides a secure and scalable backend data store. This combination meets the requirements of no coding, limited budget, and mobile app with backend management.

Exam trap

PL-900 often tests the confusion between Power BI (analytics) and Power Apps (app development), or between Power Pages (websites) and Power Apps (mobile apps), leading candidates to choose incorrect components.

How to eliminate wrong answers

Option A is wrong because Power BI is for analytics and visualization, not for building a customer-facing app or managing transactional data. Option C is wrong because AI Builder adds AI capabilities but is unnecessary for a simple loyalty program and may increase cost and complexity. Option D is wrong because Power Pages is for external-facing websites, not mobile apps, and SharePoint may not provide the necessary relational data structure and automation for a loyalty program.

Practice this question →

114

MCQeasy

A sales team wants to automate lead assignment based on region without writing code. Which Microsoft Power Platform component should they use?

A.Power Apps

B.Power BI

C.Power Automate

D.Power Virtual Agents

AnswerC

Power Automate provides no-code cloud flows that trigger on record creation and route leads by region, satisfying the requirement to automate assignment without writing code. Its connectors and conditions handle the regional logic declaratively, unlike canvas apps or dashboards.

Why this answer

Power Automate is the correct choice because it enables users to create automated workflows that can assign leads based on region using conditional logic and data from sources like Dynamics 365 or SharePoint, all without writing code. It provides prebuilt connectors and triggers (e.g., 'When a lead is created') to automate business processes seamlessly.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking that building an app is required to automate lead assignment, but Power Automate handles the workflow logic independently without a custom user interface.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom apps, not for automating workflows or lead assignment logic. Option B is wrong because Power BI is a business analytics tool for data visualization and reporting, not for triggering automated actions like lead routing. Option D is wrong because Power Virtual Agents is designed for creating conversational chatbots, not for backend process automation or rule-based lead assignment.

Practice this question →

115

MCQmedium

A regional health clinic chain wants to reduce the time staff spend manually copying patient intake details from paper forms into its electronic records system. The IT team has no developers available and wants a solution that non-technical clinical staff can build and maintain themselves. The solution must capture the form data, store it in a structured cloud table, and notify the records team automatically. Which combination of Power Platform services should the clinic use?

A.Microsoft Dataverse, Power BI, and Power Pages

B.Power Automate, AI Builder, and Power BI

C.Power BI, Power Virtual Agents, and Power Pages

D.Power Apps, Microsoft Dataverse, and Power Automate

AnswerD

This combination covers all requirements natively: Power Apps provides the low-code intake app clinical staff can build, Dataverse supplies the structured cloud table for patient details, and Power Automate delivers the automatic notification to the records team. No traditional development is required, and all three services share the same connector model, so the clinic's non-technical staff can maintain the solution end to end.

Why this answer

The clinic needs three capabilities: a low-code way to capture intake data, structured cloud storage, and an automated notification. Power Apps delivers the buildable interface, Microsoft Dataverse provides the governed relational table that non-developers can extend, and Power Automate handles the trigger-based notification. The other combinations substitute analytics, chatbot, or portal services that do not fulfill the capture-store-notify chain.

Exam trap

The trap here is assuming any three Power Platform services can be combined interchangeably, when only the app-plus-Dataverse-plus-automation trio actually covers data capture, structured storage, and notification.

Practice this question →

116

MCQmedium

A financial services firm needs to create a compliance dashboard for regulators. The dashboard must display real-time data from multiple sources, including on-premises SQL Server and Dataverse. The firm requires interactive visualizations and the ability to drill down to transaction details. They also need to ensure that sensitive data is masked for certain users. Which Power Platform components should they use?

A.Power Automate, AI Builder, and Power BI

B.Power BI, on-premises data gateway, and Dataverse

C.Copilot Studio, Power BI, and Dataverse

D.Power Apps, Dataverse, and Power Automate

AnswerB

Power BI provides dashboards with RLS, gateway connects to on-premises SQL, Dataverse is another data source.

Why this answer

The scenario requires real-time data from on-premises SQL Server and Dataverse, which necessitates an on-premises data gateway for live connectivity. Power BI provides the interactive visualizations and drill-down capabilities, while Dataverse serves as the unified data source for compliance data. The combination of these components enables real-time dashboards with role-based security for data masking.

Exam trap

The trap here is that candidates often confuse Power Automate or Power Apps as dashboard tools, but the question specifically requires interactive visualizations and drill-downs, which are core Power BI capabilities, not automation or app-building features.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool, not a data visualization or dashboard component, and AI Builder is for AI model integration, not real-time data masking or drill-downs. Option C is wrong because Copilot Studio is designed for building conversational AI bots, not for creating compliance dashboards or handling data masking. Option D is wrong because Power Apps is for building custom applications, not for interactive visualizations or drill-down analytics, and Power Automate does not provide dashboard capabilities.

Practice this question →

117

MCQeasy

A nonprofit organization needs to track donations and volunteers using a custom app without writing code. Which Power Platform tool should they use?

A.Power BI

B.Power Pages

C.Power Automate

D.Power Apps

AnswerD

Power Apps provides a low-code canvas and model-driven designer, letting the nonprofit build a custom donation and volunteer tracking app through drag-and-drop controls and connectors. No traditional coding is required, directly meeting the no-code custom app constraint.

Why this answer

Power Apps is Microsoft's low-code/no-code application development platform, letting makers build canvas or model-driven apps with drag-and-drop controls, connectors to Dataverse/SharePoint/SQL, and no traditional programming. For a nonprofit tracking donations and volunteers, Power Apps provides the data-entry forms, views, and business logic needed without writing code. Power BI, Power Pages, and Power Automate serve analytics, external websites, and workflow automation respectively—not custom app creation.

Exam trap

PL-900 often tests the boundary between the four Power Platform pillars—candidates pick Power Automate or Power Pages because the scenario mentions 'tracking' or 'volunteers,' but only Power Apps is the app-building tool.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool for dashboards and reports, not a platform for building data-entry applications. Option B is wrong because Power Pages is for building secure, externally facing business websites (portals) with Dataverse, not internal tracking apps. Option C is wrong because Power Automate is a workflow/RPA engine that automates actions between services; it can support an app but cannot itself be the custom app the nonprofit needs.

Practice this question →

118

MCQhard

An organization plans to deploy a Power Platform solution that uses Dataverse as the data source. They need to ensure that users can only see records from their own department. What should they implement?

A.Power Automate to filter records

B.Audit logging

C.Column-level security profiles

D.Business units and security roles with team-based access

AnswerD

Business units partition users and records by department, while security roles grant read, write, and delete privileges at that scope. Team-based ownership then shares records within the department, restricting visibility so users see only their own department's data.

Why this answer

Business units and security roles with team-based access are the correct implementation because Dataverse uses a hierarchical security model where business units define the organizational structure and security roles control record-level permissions. By configuring business units per department and assigning users to teams within those units, you can enforce that users only see records belonging to their own department through record ownership and sharing rules.

Exam trap

The trap here is that candidates confuse column-level security (which controls field visibility) with record-level security (which controls row visibility), leading them to choose option C when the requirement is about seeing entire records from their own department.

How to eliminate wrong answers

Option A is wrong because Power Automate is an automation tool, not a data access control mechanism; filtering records via a flow would be inefficient, bypass security model enforcement, and could be circumvented by direct API queries. Option B is wrong because audit logging tracks who accessed or modified records but does not restrict visibility; it is a monitoring feature, not a permission control. Option C is wrong because column-level security profiles restrict access to specific columns (fields) within a record, not to entire records; they cannot limit which rows a user sees based on department.

Practice this question →

119

Multi-Selecteasy

Which TWO of the following are benefits of using Microsoft Power Platform for business users?

Select 2 answers

A.Reduced dependency on IT for simple solutions.

B.Citizen developers can build apps without writing code.

C.Ability to use custom code in production environments.

D.Automatic generation of revenue from builds.

AnswersA, B

Power Platform's low-code makers build apps, flows and dashboards themselves, so routine business solutions no longer queue behind IT development backlogs. This reduces dependency on IT for simple solutions while IT retains governance through environments and DLP policies.

Why this answer

Option A is correct because Power Platform's low-code/no-code tools (Power Apps, Power Automate, Power BI, Power Virtual Agents) let business users create simple apps, flows, and reports themselves, reducing the backlog and dependency on IT for routine solutions. Option B is correct because citizen developers can use drag-and-drop designers, prebuilt connectors, and templates to build apps and automations without writing traditional code. Option C is not a benefit specific to Power Platform for business users; custom code (e.g., plug-ins, Azure Functions, PCF controls) is typically a pro-dev capability and is not the primary advantage for citizen developers.

Option D is incorrect because Power Platform is a development and automation tool, not a mechanism that automatically generates revenue from builds.

Exam trap

PL-900 often tests the misconception that Power Platform is a revenue-generating tool or that custom code is its main benefit, when the real value is no-code empowerment and reduced IT dependency.

Practice this question →

120

MCQmedium

Refer to the exhibit. A Power Apps app uses Dataverse with the defined table and roles. An employee reports that they can see all assets in the app, but they should only see assets assigned to them. What is the most likely reason?

A.The Employee security role has 'Read' permission set to 'Organization' scope instead of 'User'

B.The Asset table does not have a relationship to the User table

C.The employee is not the owner of the asset records

D.The app is not configured to filter records based on the current user

AnswerA

The Employee role grants Read at Organization scope, which lets the user view every asset record regardless of ownership. Changing that privilege to User scope restricts visibility to records they own or are shared, matching the requirement to see only assigned assets.

Why this answer

The Employee security role's 'Read' permission is set to 'Organization' scope, which allows the employee to see all asset records in the Dataverse table. To restrict visibility to only assets assigned to the employee, the 'Read' permission should be set to 'User' scope, which limits record access to those the user owns or is assigned to. This is a common misconfiguration in Dataverse role-based security that directly causes the reported issue.

Exam trap

The trap here is that candidates often assume the app must explicitly filter records (Option D) or that a table relationship is needed (Option B), when in fact Dataverse's built-in security role scopes handle record-level visibility automatically without custom app logic.

How to eliminate wrong answers

Option B is wrong because a relationship between the Asset table and the User table is not required for row-level security; Dataverse uses security roles and ownership to control record visibility, not table relationships. Option C is wrong because the employee not being the owner of the asset records is the symptom, not the root cause; the underlying issue is that the security role's 'Read' scope is too permissive (Organization), which overrides ownership-based filtering. Option D is wrong because the app itself does not need to filter records based on the current user if the Dataverse security role is correctly configured with 'User' scope; the platform enforces the scope automatically at the data layer.

Practice this question →

121

Multi-Selecthard

Which THREE components are part of Microsoft Power Platform? (Choose three.)

Select 3 answers

A.Power BI

B.Power Automate

C.Dynamics 365

D.Microsoft Copilot Studio

E.Power Apps

AnswersA, B, E

Power BI belongs to Microsoft Power Platform, satisfying the stem's requirement for a genuine platform component. It delivers business analytics and interactive reporting, sharing the platform's common connector and Dataverse foundations with Power Apps, Power Automate and Power Pages. This confirms it as one of the three correct selections.

Why this answer

Power BI (A) is a core Power Platform component, providing business analytics and interactive dashboards that connect to data sources and publish reports. Power Automate (B) is also part of the platform, delivering workflow and robotic process automation across services via triggers, actions, and connectors. Power Apps (E) is the third core component, enabling low-code/no-code canvas, model-driven, and portal app development on top of Dataverse and other connectors.

Dynamics 365 (C) is a separate family of business applications that integrates with Power Platform but is not itself one of its components. Microsoft Copilot Studio (D) is a conversational AI/agent-building tool that extends the platform ecosystem but is not counted among the three core Power Platform components.

Exam trap

Candidates often mistakenly include Dynamics 365 or Microsoft Copilot Studio as core components. However, the PL-900 exam defines the core components as Power BI, Power Apps, and Power Automate. Dynamics 365 is a separate application built on Power Platform, and Copilot Studio is an AI tool that can integrate but is not a core component.

Practice this question →

122

MCQeasy

A marketing department wants to create a dashboard that shows real-time social media sentiment analysis. Which Power Platform tool should they use?

A.Power Automate

B.Power BI

C.Power Apps

D.Copilot Studio

AnswerB

Power BI connects to streaming datasets and renders sentiment data visually in real time, satisfying the live dashboard requirement. Power Apps builds transactional interfaces and Power Automate orchestrates workflows; neither provides the analytical visualisation layer the marketing department needs.

Why this answer

Power BI is the correct tool because it is designed for data visualization and real-time analytics, including the ability to connect to social media APIs (e.g., Twitter, Facebook) via built-in connectors or custom streaming datasets to display sentiment analysis dashboards. It supports real-time data refresh through DirectQuery or streaming datasets, making it ideal for monitoring live social media sentiment.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger actions based on sentiment (e.g., send an alert) with the dashboarding and visualization capabilities required for the question, leading them to choose Power Automate instead of Power BI.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for triggering actions (e.g., sending emails, posting messages) based on events, not for building interactive dashboards or performing real-time sentiment analysis. Option C is wrong because Power Apps is a low-code application development platform for building custom apps with forms and logic, not for creating data visualizations or dashboards with live streaming data. Option D is wrong because Copilot Studio is used to create custom copilots (AI-powered conversational agents) and does not provide dashboarding or real-time analytics capabilities for social media sentiment.

Practice this question →

123

MCQmedium

A customer support manager wants to deploy a chatbot on the company website to answer common questions about products and services. The chatbot should be able to understand natural language and escalate to a human agent if needed. Which Power Platform component should they use?

A.Power Apps

B.Power Virtual Agents

C.Power BI

D.Power Automate

AnswerB

Power Virtual Agents is a no-code chatbot development tool that uses natural language understanding to interact with users. It can be deployed on websites and other channels, and it supports escalation to human agents via integration with Power Automate or Dynamics 365. This directly meets the requirement for a customer-facing chatbot.

Why this answer

Power Virtual Agents is the Microsoft Power Platform service designed for building conversational chatbots without code. It uses natural language understanding to interpret user questions and can be integrated with Power Automate to escalate to human agents or perform backend actions. This makes it the ideal choice for deploying a customer support chatbot on a website.

Exam trap

The trap here is confusing Power Virtual Agents with Power Apps, assuming that any app-building tool can create a chatbot.

Practice this question →

124

MCQhard

A company has multiple Power Platform environments: Development, Test, and Production. They want to ensure that changes to a Power Automate cloud flow are validated before reaching production. Which approach should they use?

A.Use solution-aware flows and managed properties in Dev, then import to Test, and finally to Production after testing.

B.Edit the flow directly in the Production environment.

C.Create a new flow in Production based on a copy of the Dev flow.

D.Export the flow as a ZIP file from Dev and import to Production.

AnswerA

Solutions enable ALM with validation at each stage.

Why this answer

Solution-aware flows support managed properties and allow for structured application lifecycle management (ALM). By exporting the solution from Dev as a managed solution and importing it into Test for validation, then into Production, the company ensures that changes are validated at each stage. This approach prevents direct edits in production and maintains version control.

Exam trap

The trap here is that candidates may think exporting a ZIP file (Option D) is sufficient for ALM, but they overlook the critical need for a Test environment to validate changes before production deployment.

How to eliminate wrong answers

Option B is wrong because editing the flow directly in Production bypasses all validation and testing, violating ALM best practices and risking disruption to live processes. Option C is wrong because creating a new flow in Production based on a copy of the Dev flow does not enforce a controlled, staged deployment; it introduces manual steps and lacks the managed solution packaging that ensures dependencies and component integrity. Option D is wrong because exporting a flow as a ZIP file from Dev and importing directly to Production skips the Test environment, missing the validation step and potentially introducing untested changes into production.

Practice this question →

125

MCQhard

A retail company uses Power BI to analyze sales data. They want to allow store managers to view their own store's sales but not other stores. Which Power BI feature should they implement?

A.Power Apps embedding

B.Row-level security (RLS)

C.Power Automate flows to filter data

D.Microsoft Copilot Studio

AnswerB

Row-level security filters data by the signed-in user's identity, so each store manager sees only rows matching their own store. This directly satisfies the requirement to restrict visibility per store without duplicating datasets or building separate reports.

Why this answer

Row-level security (RLS) in Power BI allows you to restrict data access for specific users based on roles and filters. By defining a role that filters sales data by store ID and assigning store managers to that role, each manager can only see their own store's sales, meeting the requirement without duplicating reports or data.

Exam trap

The trap here is that candidates often confuse data filtering in Power Automate (which operates on triggers and actions) with the declarative, role-based filtering of RLS, or they mistakenly think embedding tools like Power Apps can enforce security, when in fact RLS is the only native Power BI feature for row-level data access control.

How to eliminate wrong answers

Option A is wrong because Power Apps embedding is a method to integrate custom apps into Power BI reports, not a data security feature for filtering rows per user. Option C is wrong because Power Automate flows automate workflows and can filter data in downstream systems, but they cannot enforce dynamic, user-based row-level security within a Power BI dataset or report. Option D is wrong because Microsoft Copilot Studio is a conversational AI tool for building chatbots, not a data access control mechanism for Power BI.

Practice this question →

126

MCQeasy

A sales team needs a dashboard showing real-time sales data from multiple sources to identify trends. Which Power Platform component is best suited for this?

A.Power Apps

B.Power BI

C.Power Pages

D.Power Automate

AnswerB

Power BI connects to multiple data sources and refreshes visuals automatically, giving the sales team a single real-time dashboard for trend analysis. Its aggregation and visualisation engine satisfies the cross-source, live-data constraint that Power Apps or Power Automate cannot.

Why this answer

Power BI is the correct choice because it is designed specifically for data visualization and business intelligence, enabling users to create interactive dashboards that combine real-time data from multiple sources. Its ability to connect to various data streams (e.g., SQL databases, Excel, cloud services) and update visuals automatically makes it ideal for identifying sales trends as they happen.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to display data with Power BI's dedicated dashboarding and real-time analytics capabilities, overlooking that Power Apps is for app logic, not multi-source data aggregation and trend visualization.

How to eliminate wrong answers

Option A (Power Apps) is wrong because it is a low-code platform for building custom applications, not for aggregating and visualizing real-time data from multiple sources in a dashboard. Option C (Power Pages) is wrong because it is used to create external-facing websites, not for internal dashboards or real-time data analytics. Option D (Power Automate) is wrong because it focuses on workflow automation and process orchestration, not on data visualization or dashboard creation.

Practice this question →

127

MCQmedium

A company wants to build a custom app for field technicians to log maintenance reports offline and sync when connected. Which Power Platform component should be used?

A.Power Apps

B.Power Pages

C.Power Automate

D.Power BI

AnswerA

Power Apps delivers the canvas app that field technicians use to capture maintenance reports, with offline capability through the mobile player caching data locally and syncing to Dataverse once connectivity returns. This directly satisfies the stem's offline logging and later synchronisation requirement, unlike components lacking a mobile data-entry surface.

Why this answer

Power Apps is the correct component because it allows building custom canvas or model-driven apps that can run offline on mobile devices using the Power Apps mobile app. Field technicians can log maintenance reports without connectivity, and the app automatically syncs data to Dataverse or other data sources when a network connection is restored, leveraging the offline-first capability.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger actions on data sync with the actual app-building requirement, or mistakenly think Power Pages can deliver offline mobile experiences when it is strictly a web portal solution.

How to eliminate wrong answers

Option B (Power Pages) is wrong because Power Pages is designed for creating external-facing websites, not offline-capable mobile apps for field technicians. Option C (Power Automate) is wrong because it is a workflow automation tool for orchestrating processes and integrations, not a platform for building custom user interfaces or offline data entry apps. Option D (Power BI) is wrong because it is a business analytics and visualization tool, not an app-building platform; it cannot capture offline maintenance reports or sync data.

Practice this question →

128

MCQeasy

A non-profit organization needs to generate weekly donation reports from multiple data sources and share them with stakeholders via email. Which Power Platform tool should they use to create the report?

A.Power Automate

B.Power BI

C.Power Apps

D.Power Virtual Agents

AnswerB

Power BI connects to multiple data sources, models donations, and schedules refreshed reports distributed by email subscription to stakeholders. This satisfies the weekly, multi-source reporting requirement, whereas Power Apps and Power Automate do not deliver analytical reporting.

Why this answer

Power BI is the correct tool because it is designed specifically for data visualization and reporting. It can connect to multiple data sources, transform and model the data, and create interactive reports. These reports can then be scheduled to refresh and be shared with stakeholders via email using Power BI's subscription feature or by integrating with Power Automate.

Exam trap

The trap here is that candidates confuse Power Automate's ability to send emails with the requirement to create a report, overlooking that Power Automate cannot generate visual data reports—it only triggers actions based on data.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool, not a reporting tool; while it can send emails, it cannot create or render visual reports from multiple data sources. Option C is wrong because Power Apps is used to build custom applications with a user interface, not to generate analytical reports or dashboards. Option D is wrong because Power Virtual Agents is a chatbot creation service for conversational AI, completely unrelated to data reporting or email distribution.

Practice this question →

129

MCQeasy

A non-profit organization wants to create a simple app for volunteers to log their hours and submit expenses. The app should be easy to build and require minimal coding. Which Power Platform tool should they use?

A.Power Pages

B.Power BI

C.Power Apps canvas app

D.Power Automate

AnswerC

Canvas apps provide a drag-and-drop designer with Excel-like formulas, so volunteers' hour and expense logging needs minimal coding. This directly satisfies the stem's ease-of-build and low-code constraints, unlike model-driven apps, which require Dataverse data modelling and offer less layout freedom.

Why this answer

Power Apps canvas app is the correct choice because it allows non-developers to quickly build a custom, low-code app for data entry tasks like logging volunteer hours and submitting expenses. Canvas apps start from a blank canvas or a template, enabling drag-and-drop design with minimal coding, and can connect directly to data sources like SharePoint or Dataverse for storing records.

Exam trap

The trap here is that candidates often confuse Power Automate (a workflow tool) with Power Apps (an app builder), mistakenly thinking automation alone can replace a user interface for data entry.

How to eliminate wrong answers

Option A is wrong because Power Pages is designed for creating external-facing websites (e.g., public portals), not for building a simple data-entry app for internal volunteers. Option B is wrong because Power BI is a business analytics and visualization tool, not an app builder for data entry or expense submission. Option D is wrong because Power Automate is a workflow automation tool for orchestrating processes and notifications, not for creating a user interface where volunteers can log hours and expenses.

Practice this question →

130

Multi-Selectmedium

Which THREE of the following are capabilities of Microsoft Copilot in Power Platform?

Select 3 answers

A.Design complex custom code components.

B.Create a Power App from a description.

C.Automatically deploy apps to production environments.

D.Suggest steps to build a Power Automate flow.

E.Generate Power Fx formulas based on natural language.

AnswersB, D, E

Copilot in Power Apps generates a working app from a natural-language description, scaffolding screens, controls and data connections. This satisfies the stem's capability question by naming a genuine Copilot feature rather than a manual authoring task.

Why this answer

Option B is correct because Microsoft Copilot in Power Apps allows makers to describe an app in natural language and have Copilot generate the app's structure, including screens, controls, and data connections. Option D is correct because Copilot in Power Automate can suggest the steps and actions needed to build a flow from a natural-language description of the desired automation. Option E is correct because Copilot can generate Power Fx formulas from natural-language prompts, helping makers write expressions for controls and logic.

Option A is not a Copilot capability, since designing complex custom code components requires professional developer tools such as the Power Apps Component Framework (PCF) CLI, not Copilot. Option C is not a Copilot capability, because deployment to production environments is handled through solutions, pipelines, and Power Platform administration rather than Copilot automation.

Exam trap

The trap here is that candidates may confuse Copilot's app creation and flow suggestion capabilities with deployment automation or custom component development, which are separate features managed by ALM tools and PCF, respectively.

Practice this question →

131

MCQmedium

Refer to the exhibit. A Power Automate environment has two flows. Flow1 triggers on item creation and sends an email then updates the item. Flow2 triggers on email arrival, creates an item, and sends an approval. If an email arrives that triggers Flow2, and Flow2's first action creates an item, will Flow1 also trigger?

A.No, because Flow2 runs in a separate context.

B.Yes, but only if both flows are in the same solution.

C.Yes, because the item creation will trigger Flow1.

D.No, because triggers are disabled during flow runs.

AnswerC

Creating an item in SharePoint or Dataverse fires the same connector trigger Flow1 listens on, regardless of which flow performed the write. Flow2's first action therefore satisfies Flow1's trigger condition, so Flow1 runs and sends its email, then updates the item — the cascade the stem asks about.

Why this answer

Flow1 triggers on item creation, so when Flow2's first action creates an item, that creation event fires the trigger for Flow1. Power Automate allows multiple flows to respond to the same event independently, so Flow1 will execute as a separate instance. This is why option C is correct.

Exam trap

The trap here is that candidates assume flows run in isolation or that triggers are disabled during execution, but Power Automate processes events asynchronously and independently, allowing multiple flows to trigger from the same event.

How to eliminate wrong answers

Option A is wrong because Power Automate flows do not run in isolated contexts; they share the same environment and can trigger each other based on events. Option B is wrong because solution membership is irrelevant for event-driven triggers; flows in different solutions can still trigger each other if they listen to the same event. Option D is wrong because triggers are not disabled during flow runs; Power Automate processes events asynchronously, so a running flow does not block other flows from starting.

Practice this question →

132

MCQmedium

A marketing department receives hundreds of leads each day from a web form. A staff member manually copies each lead into a Microsoft Excel workbook and emails a confirmation to the lead. The department wants to eliminate the manual steps and ensure every lead is recorded and acknowledged within minutes. Which Microsoft Power Platform service should they use?

A.Power BI

B.Power Apps

C.Power Automate

D.Power Virtual Agents

AnswerC

Power Automate is built to automate repetitive tasks by connecting services with triggers and actions. It can trigger when a new web form response arrives, write the lead to Excel or another data store, and send a confirmation email automatically. This directly removes the manual copying and emailing steps described.

Why this answer

Power Automate is the workflow automation service in Power Platform. It can use a trigger such as a new Microsoft Forms response or an HTTP request, then perform actions like adding a row to Excel and sending an Outlook email. This eliminates manual copying and ensures timely acknowledgements.

The other services are for app building, analytics, or chatbots and do not provide unattended cross-service automation.

Exam trap

The trap here is thinking that Power Apps can automate background tasks, when it only provides interactive user interfaces and requires a user to initiate actions.

Practice this question →

133

MCQeasy

A company wants to automate the approval process for purchase orders. Managers should receive an email with a link to approve or reject. Which Power Platform component is best suited?

A.Power Apps

B.Microsoft Copilot Studio

C.Power Automate

D.Power BI

AnswerC

Power Automate builds event-driven cloud flows that trigger on purchase order creation, route an approval request by email, and branch on the manager's approve or reject response — satisfying the requirement for an emailed link plus automated decision handling without custom code.

Why this answer

Power Automate is the correct choice because it is designed specifically for workflow automation, including approval processes. It can trigger an email to managers with an approval link and handle the response (approve/reject) without manual intervention, making it ideal for automating purchase order approvals.

Exam trap

The trap here is that candidates may confuse Power Apps (for building the approval interface) with the automation engine, but Power Automate is the dedicated service for orchestrating the approval workflow and sending the email notification.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code app development platform for building custom user interfaces, not for automating backend workflows or sending approval emails. Option B is wrong because Microsoft Copilot Studio is used for creating conversational AI bots and copilots, not for orchestrating approval workflows or sending emails with action links. Option D is wrong because Power BI is a business analytics tool for data visualization and reporting, not for automating processes or managing approvals.

Practice this question →

134

MCQmedium

Your company has a Power BI dashboard that displays sales data from a SQL Server database hosted on-premises. The dashboard is used by the sales team to monitor daily performance. Recently, the dashboard has been showing stale data. The data is supposed to refresh every night at 2:00 AM. You have confirmed that the SQL Server database is updated with new data each night. However, the Power BI dataset refresh fails. You need to ensure that the dashboard shows up-to-date data every morning. What should you do?

A.Disable scheduled refresh and manually refresh the dataset every morning.

B.Install and configure an on-premises data gateway and assign it to the dataset.

C.Change the data source to an Excel file stored in SharePoint Online.

D.Republish the Power BI report from Power BI Desktop.

AnswerB

An on-premises data gateway brokers the refresh connection between the Power BI service and the internal SQL Server, which is unreachable directly from the cloud; assigning it to the dataset lets the 2:00 AM refresh succeed.

Why this answer

An on-premises data gateway is required to bridge the connection between Power BI (a cloud service) and an on-premises SQL Server database. Since the dataset refresh fails despite the database being updated, the gateway is either missing or misconfigured. Installing and configuring the gateway allows the scheduled refresh to access the on-premises data source securely, ensuring the dashboard displays up-to-date data each morning.

Exam trap

The trap here is that candidates may think republishing the report (Option D) will fix the refresh issue, but they overlook that the scheduled refresh relies on a persistent gateway connection, not the report file itself.

How to eliminate wrong answers

Option A is wrong because disabling scheduled refresh and manually refreshing the dataset is not a sustainable solution for daily updates and does not address the root cause of the refresh failure. Option C is wrong because changing the data source to an Excel file in SharePoint Online avoids the on-premises connectivity issue but is a workaround that may not meet the company's data requirements and could introduce new data freshness or security concerns. Option D is wrong because republishing the Power BI report from Power BI Desktop does not fix the underlying connectivity problem; it only re-uploads the report without resolving the gateway or refresh failure.

Practice this question →

135

MCQhard

Refer to the exhibit. You are analyzing a Power Automate flow definition. The flow is intended to create a new user record in Dataverse and send an email notification when manually triggered or daily at 8 AM. However, when the flow runs on its schedule, it fails because the trigger output 'name' is empty. What is the most likely cause?

A.The action 'CreateRecord' has an invalid entity name 'Users'.

B.The schedule trigger does not provide a 'name' field in its outputs, causing the expression to fail.

C.The flow is configured to run only on manual trigger, ignoring the schedule.

D.The flow does not have permission to create records in Dataverse.

AnswerB

The Recurrence trigger emits only timestamp-based outputs such as start time, so no 'name' token exists at runtime. Referencing that dynamic content therefore resolves to empty on scheduled runs, while the manual trigger supplies it.

Why this answer

A scheduled trigger in Power Automate does not include a 'name' field in its outputs, whereas a manual trigger (e.g., Power Apps or button) typically does. When the flow runs on its daily 8 AM schedule, the expression referencing trigger outputs 'name' evaluates to empty, causing the subsequent actions to fail. This is a common mismatch between trigger types and expected output schemas.

Exam trap

The PL-900 exam often tests the misconception that all triggers provide identical output schemas, leading candidates to overlook that scheduled triggers lack user-provided fields like 'name'.

How to eliminate wrong answers

Option A is wrong because 'Users' is a valid system entity name in Dataverse (the table is named 'User'), and the action would not fail due to an invalid entity name unless the table was custom and misspelled. Option C is wrong because the flow definition explicitly includes both a manual trigger and a scheduled trigger (daily at 8 AM), so the schedule is not ignored; the issue is the missing 'name' field from the schedule trigger. Option D is wrong because the flow failing due to an empty 'name' field occurs before any Dataverse permission check; permission errors would produce a different error (e.g., 'Access denied' or 'Principal does not have privilege').

Practice this question →

136

MCQhard

You are a Power Platform administrator. A user reports that a Power Automate flow that connects to SharePoint Online fails intermittently with a '403 Forbidden' error. The flow uses a service principal with application permissions. What is the most likely cause?

A.The flow is exceeding the SharePoint Online API throttling limits.

B.The service principal has been disabled in Microsoft Entra ID.

C.SharePoint Online is experiencing a service outage.

D.The service principal lacks the necessary SharePoint API permissions or admin consent.

AnswerD

Service principals authenticate as applications, so they need SharePoint application permissions such as Sites.FullControl.All granted with tenant admin consent. Missing permissions or absent consent produce intermittent 403 Forbidden responses when the flow calls the SharePoint API.

Why this answer

A 403 Forbidden error specifically indicates that the server understood the request but refuses to authorize it. Since the flow uses a service principal with application permissions, the most likely cause is that the service principal lacks the necessary SharePoint API permissions or that admin consent has not been granted for those permissions. Without proper permissions or consent, SharePoint Online rejects the request regardless of authentication validity.

Exam trap

The trap here is that candidates confuse 403 Forbidden (authorization failure) with 401 Unauthorized (authentication failure) or throttling errors, leading them to incorrectly select throttling or service outage options.

How to eliminate wrong answers

Option A is wrong because a 403 Forbidden error is an authorization failure, not a throttling limit; exceeding API throttling limits would return a 429 Too Many Requests error, not 403. Option B is wrong because if the service principal were disabled in Microsoft Entra ID, the authentication would fail with a 401 Unauthorized error, not a 403 Forbidden. Option C is wrong because a SharePoint Online service outage would typically result in 503 Service Unavailable or 500 Internal Server Error responses, not a 403 Forbidden.

Practice this question →

137

Multi-Selecthard

Which TWO of the following scenarios are best suited for Power Automate's cloud flows?

Select 2 answers

A.Automating approval processes in SharePoint.

B.Sending a welcome email when a new user is added to Microsoft Entra ID.

C.Moving files from an on-premises server to a cloud storage.

D.Automating data entry from a legacy desktop application.

AnswersA, B

Cloud flows run server-side on triggers and schedules, so a SharePoint item event can initiate approval requests, route them to approvers, and record outcomes without any user's device being active. This satisfies the requirement for unattended, automated approval handling.

Why this answer

Option A is correct because SharePoint is a first-class cloud connector in Power Automate, and approval processes are a canonical cloud flow scenario: a flow can trigger on an item being created or modified in a SharePoint list or library and use the Approvals connector to route the request to approvers, all without any on-premises infrastructure. Option B is correct because Microsoft Entra ID (Azure AD) exposes a native cloud connector, so a flow can trigger on events such as 'When a new user is created' and immediately send a welcome email via Outlook/Office 365 Outlook — a purely cloud-to-cloud integration with no gateway required. Option C is not the best fit because moving files from an on-premises server requires the on-premises data gateway (or a desktop flow), which is a hybrid scenario rather than a native cloud flow.

Option D is not the best fit because automating data entry in a legacy desktop application requires UI automation, which is the domain of Power Automate desktop flows (RPA), not cloud flows.

Exam trap

The trap here is that candidates often confuse cloud flows with desktop flows (RPA), assuming cloud flows can handle on-premises file moves or legacy app automation, but the PL-900 exam tests the distinction that cloud flows are API-driven and require connectors, while desktop flows handle UI-based and on-premises tasks.

Practice this question →

138

MCQeasy

Your company wants to analyze sales data from multiple sources and create interactive dashboards. The solution must be cloud-based and require minimal IT support. Which Power Platform component should you use?

A.Power BI

B.Power Apps

C.Power Automate

D.Power Virtual Agents

AnswerA

Power BI is the cloud-hosted analytics service that connects to multiple data sources, models the data, and publishes interactive dashboards with self-service authoring. This satisfies the cloud-based, minimal-IT-support constraints for analysing sales data and building dashboards.

Why this answer

Power BI is the correct choice because it is a cloud-based business analytics service that enables you to connect to multiple data sources, transform and model the data, and create interactive dashboards and reports. It requires minimal IT support through its self-service capabilities, allowing business analysts to build visualizations without deep technical expertise.

Exam trap

The trap here is that candidates may confuse Power BI with Power Apps because both involve data, but Power Apps is for building apps, not for interactive data analysis and dashboards.

How to eliminate wrong answers

Option B (Power Apps) is wrong because it is a low-code platform for building custom applications, not for analyzing sales data or creating interactive dashboards. Option C (Power Automate) is wrong because it focuses on workflow automation and process orchestration, not on data visualization and analytics. Option D (Power Virtual Agents) is wrong because it is designed for creating conversational AI chatbots, not for data analysis or dashboard creation.

Practice this question →

139

MCQhard

An organization is deploying Power Apps to external customers for a self-service portal. They need to ensure that customer data is isolated from internal employee data. What is the best approach?

A.Use Data Loss Prevention (DLP) policies in the same environment

B.Add external customers as B2B guests in the same environment

C.Create separate environments for internal and external users

D.Use the same environment with security role-based access

AnswerC

Separate environments give each audience its own Dataverse instance, security roles and data boundaries, so external customers cannot access internal employee records. This isolation satisfies the requirement to keep customer data segregated from internal data.

Why this answer

Creating separate environments for internal and external users provides full tenant-level isolation of customer data from employee data. Each environment in Power Platform has its own databases, security settings, and data storage, ensuring that external customers cannot access internal resources even if security roles are misconfigured.

Exam trap

The trap here is that candidates often confuse security roles and DLP policies with true data isolation, assuming that permissions or data loss prevention rules can achieve the same level of separation as dedicated environments, but only separate environments provide the required physical and logical data boundaries.

How to eliminate wrong answers

Option A is wrong because DLP policies control data movement between connectors and prevent data exfiltration, but they do not isolate data within the same environment; internal and external users would still share the same database. Option B is wrong because adding external customers as B2B guests in the same environment still places them in the same Common Data Service (Dataverse) instance, meaning data is not physically isolated and could be exposed through misconfigured security roles. Option D is wrong because using the same environment with security role-based access relies solely on permissions to separate data, which is insufficient for strict data isolation requirements; it does not provide the physical or logical separation needed for compliance and security best practices.

Practice this question →

140

MCQhard

A global manufacturing company uses Microsoft Power Platform to manage its equipment maintenance processes. The company has over 10,000 maintenance technicians worldwide who use a Power Apps mobile app to report equipment issues and log repairs. The app connects to a common data service (Dataverse) that stores all maintenance records. Recently, the company experienced a data breach where a malicious user exploited a vulnerability in the app to access and delete maintenance records from multiple high-value machines. The security team traced the issue to the app's permissions model: the app was using a single service account with elevated privileges to perform all data operations. The company now wants to redesign the app's security to follow the principle of least privilege while maintaining usability for technicians. The technicians need to view their assigned work orders, create new issue reports, and update the status of their own repairs, but they should not be able to delete records or access records from other regions. Which approach should the company take?

A.Replace the Power Apps app with a Power Automate flow that technicians trigger via email to submit and update records.

B.Configure each technician's individual user account with a basic user role in Dataverse, and remove the service account.

C.Implement row-level security in Dataverse to restrict technicians to their own records and region, assign appropriate role-based access (create, read, update, no delete), and use individual user accounts.

D.Create a separate Power Apps app for each region, each with its own service account that has restricted permissions to that region's data.

AnswerC

Row-level security in Dataverse filters records per user, so technicians see only their own and their region's rows, while role-based privileges grant create, read and update but withhold delete. Individual accounts replace the shared elevated service account, directly satisfying least privilege without breaking technician workflows.

Why this answer

It applies the principle of least privilege by using individual user accounts with Dataverse role-based security and row-level security (RLS). This ensures each technician can only create, read, and update their own assigned records within their region, while explicitly denying delete permissions. This approach eliminates the shared, over-privileged service account and enforces granular data isolation.

Exam trap

The trap here is that candidates may think creating separate apps or using basic roles is sufficient, but they overlook the need for both row-level security and individual user accounts to enforce least privilege and data isolation across regions.

How to eliminate wrong answers

Option A is wrong because replacing the app with a Power Automate flow triggered via email does not address the underlying permission model; it still requires a secure data access method and introduces usability friction without solving the privilege escalation issue. Option B is wrong because assigning only a basic user role without row-level security would allow technicians to view and potentially modify records from other regions, violating the requirement for regional data isolation. Option D is wrong because creating separate apps per region with individual service accounts still relies on shared service accounts, which violates the principle of least privilege and does not prevent a compromised account from accessing all data in that region.

Practice this question →

141

MCQeasy

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

A.Power BI

B.Power Automate

C.Power Apps

D.Copilot Studio

AnswerD

Copilot Studio builds conversational chatbots with no-code topics, so staff can publish a bot answering store hours and return policy questions without developer effort. It satisfies the small business's need for a low-skill, self-service assistant rather than custom code or analytics tooling.

Why this answer

Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Exam trap

The trap here is that candidates may confuse Power Apps (custom app builder) or Power Automate (workflow automation) with chatbot creation, but only Copilot Studio provides the conversational AI capabilities needed for this use case.

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 building chatbots. Option B is wrong because Power Automate is a workflow automation tool that connects apps and services to automate repetitive tasks, but it does not provide a conversational interface for answering customer questions. Option C is wrong because Power Apps is a low-code platform for building custom business applications with forms and data connections, not for creating chatbots.

Practice this question →

142

MCQeasy

Your organization wants to create a public-facing website where customers can submit support requests. The website should be built with minimal custom code and integrate with Dataverse. Which Power Platform component should you use?

A.Power Pages

B.Power BI

C.Power Apps

D.Power Automate

AnswerA

Power Pages provides a low-code, external-facing portal that authenticates and stores customer submissions directly in Dataverse, satisfying the public website and minimal custom code constraints. Unlike model-driven apps, which require internal licensing, or canvas apps, which lack anonymous public access, Power Pages is purpose-built for external users.

Why this answer

Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform for creating public-facing websites that integrate directly with Dataverse. It enables external customers to submit support requests without custom code, leveraging built-in authentication, form components, and Dataverse data binding.

Exam trap

The trap here is that candidates may confuse Power Apps (which also uses Dataverse) with Power Pages, not realizing that Power Apps requires user authentication and is not designed for anonymous public-facing websites, whereas Power Pages is explicitly built for external portals.

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 building public-facing websites with form submission capabilities. Option C is wrong because Power Apps is designed for building custom business applications (canvas or model-driven) for internal or authenticated users, not for creating public-facing websites accessible to anonymous customers. Option D is wrong because Power Automate is an automation platform for creating workflows and process automations, not a website builder; it can be used to process submissions but cannot serve as the front-end website itself.

Practice this question →

143

MCQmedium

A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?

A.The app has too many controls per screen

B.The app uses a non-delegable query on a large data source

C.The app uses too many screens

D.The app has complex formulas in OnStart

AnswerB

Non-delegable queries force Power Apps to pull the full dataset to the client before filtering, so a large data source causes slow loads. Delegation pushes filtering to the source; the constraint here is the non-delegable operation combined with data volume.

Why this answer

The most likely cause of slow loading in a Power Apps inventory management app is a non-delegable query on a large data source. When a query cannot be delegated, Power Apps retrieves all records from the data source to the client device, then filters locally, causing significant performance degradation with large datasets. This is a common issue when using functions like `Filter` with unsupported operators or columns on large tables.

Exam trap

The trap here is that candidates often assume too many controls or screens cause slowness, but the PL-900 exam specifically tests the concept of delegation as the primary performance bottleneck when dealing with large data sources in Power Apps.

How to eliminate wrong answers

Option A is wrong because having many controls per screen primarily affects rendering and responsiveness during app use, not initial load time; the load time is dominated by data retrieval and formula execution. Option C is wrong because the number of screens does not directly impact load time, as screens are loaded on demand unless preloaded, and the app loads only the first screen initially. Option D is wrong because complex formulas in OnStart can slow down app startup, but the most likely cause for a slow-loading app connected to a large data source is a non-delegable query, which forces all data to be transferred before any filtering.

Practice this question →

144

MCQhard

A healthcare organization uses Power Apps to manage patient intake forms. The app is built on Dataverse and includes a field for medical record number (MRN) that must be unique. The app currently uses a text input, but duplicate MRNs have been entered. What is the best way to enforce uniqueness at the data layer?

A.Create a Dataverse alternate key on the MRN field

B.Use a Power Automate flow to check for duplicates after submission

C.Configure a business rule on the MRN field

D.Add a validation rule in the app to check for duplicates before submitting

AnswerA

An alternate key applies a database-level uniqueness constraint on the MRN column, so Dataverse rejects any duplicate value on save regardless of which app or user performs the insert. This enforces uniqueness at the data layer itself, not merely in the canvas app's validation logic.

Why this answer

A Dataverse alternate key enforces uniqueness at the database level, preventing duplicate MRN values from being saved regardless of how data enters the system. This is the only option that operates at the data layer, ensuring integrity even if the app, a flow, or an external integration submits a record. Alternate keys are indexed and validated by Dataverse before commit, making them the proper solution for unique field constraints.

Exam trap

The trap here is that candidates confuse client-side validation (business rules, app validation) with data-layer enforcement, assuming any uniqueness check in the app or a flow is sufficient, but only alternate keys (or unique constraints) guarantee integrity at the database level.

How to eliminate wrong answers

Option B is wrong because a Power Automate flow runs after submission, meaning duplicates can already be committed before the flow checks—this is a reactive, not preventive, approach and does not enforce uniqueness at the data layer. Option C is wrong because a business rule operates on the client side (in a model-driven app form) and cannot enforce uniqueness at the database level; it only provides UI-level validation and can be bypassed by direct API calls or bulk imports. Option D is wrong because a validation rule in the app (canvas or model-driven) runs only within the app client and can be circumvented by direct data operations, such as Dataverse API calls or data imports, so it does not guarantee data-layer uniqueness.

Practice this question →

145

Multi-Selectmedium

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

Select 2 answers

A.It reduces development time compared to traditional coding.

B.It can be used offline without any connectivity.

C.It requires no coding skills for any scenario.

D.It integrates easily with Microsoft 365 and Azure services.

E.It only works with Microsoft data sources.

AnswersA, D

Low-code development with Microsoft Power Platform lets makers assemble apps, flows and connectors visually, cutting build time against hand-written code. This directly satisfies the stem's automation benefit: faster delivery of business processes without a professional developer, since prebuilt connectors and templates remove most bespoke coding effort.

Why this answer

Option A is correct because Power Platform's low-code/no-code designers (Power Apps Studio, Power Automate's visual designer, and prebuilt connectors) let makers assemble apps and flows with drag-and-drop components and formulas instead of writing full custom code, which shortens delivery time versus traditional development. Option D is correct because Power Platform is natively integrated with Microsoft 365 (SharePoint, Teams, Outlook, Dataverse) and Azure services (Azure Functions, Logic Apps, Azure AD, API Management), so connectors and identity/data services work out of the box. Option B is not a general benefit: Power Apps and Power Automate are cloud services that normally require connectivity, and offline use is limited to specific Power Apps mobile offline scenarios, not the platform as a whole.

Option C is inaccurate because advanced scenarios (custom connectors, plug-ins, PCF controls, complex expressions) do require coding or scripting skills. Option E is false because Power Platform supports hundreds of non-Microsoft connectors (Salesforce, SAP, SQL Server, Twitter/X, Dropbox, etc.), not only Microsoft data sources.

Exam trap

The trap here is that candidates may assume 'low-code' means 'no-code for all scenarios' (Option C) or that Power Platform is limited to Microsoft ecosystems (Option E), but the exam tests the understanding that low-code reduces but does not eliminate coding needs, and that the platform is designed for broad interoperability.

Practice this question →

146

MCQmedium

A company wants to use AI to automatically categorize customer support tickets based on their description. Which Power Platform AI capability should they use?

A.Power Automate with a regular expression

B.AI Builder category classification model

C.Power Virtual Agents (now Copilot Studio)

D.Power BI AI visuals

AnswerB

AI Builder's category classification model trains on labelled ticket examples and predicts a category from free-text descriptions, matching the requirement to categorise support tickets automatically. It is purpose-built for text classification, unlike form processing or object detection.

Why this answer

AI Builder's category classification model is specifically designed to automatically categorize text into predefined categories, making it ideal for routing support tickets based on their description. This prebuilt AI model uses natural language processing to analyze the text and assign the most relevant category without requiring custom machine learning expertise.

Exam trap

The trap here is that candidates often confuse AI Builder's category classification with simple pattern matching (Option A) or assume any AI-related tool like Power Virtual Agents can perform categorization, but only AI Builder provides a dedicated, no-code classification model for text data.

How to eliminate wrong answers

Option A is wrong because Power Automate with a regular expression can only match exact patterns or keywords, not understand the semantic meaning of a ticket description; it cannot perform true categorization based on context. Option C is wrong because Power Virtual Agents (now Copilot Studio) is designed for building conversational chatbots, not for categorizing existing text data; it lacks a built-in classification model for ticket routing. Option D is wrong because Power BI AI visuals are used for analyzing and visualizing data trends, not for categorizing individual text records; they cannot process real-time ticket descriptions to assign categories.

Practice this question →

147

Multi-Selecthard

A global organization wants to standardize expense reporting across subsidiaries using Power Platform. They require integration with Microsoft Entra ID for identity and must ensure data residency compliance. Which TWO capabilities should they use?

Select 2 answers

A.AI Builder

B.Power BI dashboards

C.Dataverse environments with specific regions

D.Copilot Studio

E.Data Loss Prevention (DLP) policies

AnswersC, E

Dataverse environments can be created in specific geographic regions.

Why this answer

Dataverse environments can be created in specific geographic regions to ensure data residency compliance by storing data at rest within that region. Integration with Microsoft Entra ID is inherent to Dataverse, which uses Entra ID as its identity provider for authentication and authorization, meeting the requirement for standardized identity management across subsidiaries. Additionally, Data Loss Prevention (DLP) policies enforce data residency by restricting data sharing across connectors and preventing data from leaving the designated region, ensuring compliance with regulatory requirements.

Exam trap

The PL-900 exam often tests the misconception that Power BI or AI Builder are responsible for compliance features, when in fact data residency is enforced at the Dataverse environment level and identity is handled by Entra ID, not by analytics or AI tools.

Practice this question →

148

MCQmedium

A company has a legacy on-premises SQL Server database and wants to build a Power BI report that refreshes daily. However, the database is behind a firewall. What should they use to securely access the data?

A.Power Automate with SQL connector

B.An on-premises data gateway

C.Microsoft Dataverse

D.A VPN connection to the database

AnswerB

An on-premises data gateway installs inside the corporate network, letting Power BI cloud services query the firewalled SQL Server without exposing it to inbound internet traffic. It satisfies the daily refresh requirement by relaying scheduled refresh requests securely outbound, authenticated through Microsoft Entra ID, so the legacy database stays protected behind the firewall.

Why this answer

An on-premises data gateway is the correct solution because it acts as a secure bridge between on-premises data sources (like SQL Server behind a firewall) and cloud services such as Power BI. The gateway encrypts data in transit and allows scheduled refresh without opening inbound ports in the firewall, using outbound connections to Azure Service Bus.

Exam trap

The trap here is that candidates often confuse a VPN or direct connector (like Power Automate) as sufficient for firewall traversal, but the PL-900 exam specifically tests the on-premises data gateway as the only secure, supported method for scheduled Power BI refresh from behind a firewall.

How to eliminate wrong answers

Option A is wrong because Power Automate with SQL connector is designed for real-time or event-driven workflows, not for scheduled data refresh in Power BI reports; it also cannot bypass a firewall without a gateway. Option C is wrong because Microsoft Dataverse is a cloud-based data storage service, not a connectivity tool for on-premises databases; it does not provide a secure bridge to SQL Server behind a firewall. Option D is wrong because a VPN connection to the database would require opening inbound ports and managing complex network configurations, which is less secure and more cumbersome than the dedicated, outbound-only on-premises data gateway.

Practice this question →

149

Multi-Selecteasy

A manufacturing company wants to use Power Platform to improve operational efficiency. Which TWO benefits of using Microsoft Power Platform are most relevant?

Select 2 answers

A.Replace the need for any third-party software

B.Automate hardware inventory management

C.Build custom apps without extensive coding

D.Eliminate the need for user authentication

E.Automate business processes and workflows

AnswersC, E

Power Apps enables citizen developers to build custom business applications using low-code drag-and-drop tools and prebuilt connectors, reducing reliance on professional developers. This satisfies the stem's operational-efficiency benefit by accelerating app delivery and cutting development costs, letting manufacturing staff digitise processes quickly without extensive coding expertise.

Why this answer

Option C is correct because Power Apps provides a low-code/no-code development environment with drag-and-drop designers, prebuilt connectors, and Power Fx formulas, letting the manufacturing company build custom apps without extensive coding. Option E is correct because Power Automate enables the automation of business processes and workflows through cloud flows, approvals, and connectors to services like Dynamics 365 and SharePoint, directly improving operational efficiency. The unmarked options do not belong: Power Platform does not replace all third-party software (A), hardware inventory management is a specific use case rather than a general benefit and typically requires additional tooling (B), and Power Platform relies on Microsoft Entra ID authentication rather than eliminating it (D).

Exam trap

The trap here is that candidates often confuse 'automating hardware inventory management' (a specific IT task) with the broader business process automation capability of Power Platform, leading them to incorrectly select Option B instead of recognizing that Power Platform's strength lies in automating workflows and building custom apps, not in replacing dedicated inventory management tools.

Practice this question →

150

MCQeasy

A business analyst wants to create a real-time dashboard showing sales performance from Dynamics 365 Sales data. Which tool should they use?

A.Power Apps

B.Power BI

C.Power Pages

D.Power Automate

AnswerB

Power BI's Dynamics 365 connector and scheduled refresh pull sales data into interactive dashboards, satisfying the real-time sales performance requirement. Its visualisation layer surfaces trends that the analyst needs, which Dataverse alone does not provide.

Why this answer

Power BI is the correct tool for creating real-time dashboards because it is designed specifically for data visualization and business intelligence. It can connect directly to Dynamics 365 Sales data via the Dataverse connector or direct query mode, enabling live, interactive dashboards that refresh automatically as data changes.

Exam trap

The trap here is that candidates may confuse Power Apps' ability to display data in a gallery or chart with the dedicated real-time dashboarding and analytics capabilities of Power BI, leading them to select Power Apps for a visualization task.

How to eliminate wrong answers

Option A is wrong because Power Apps is a low-code platform for building custom applications, not for creating real-time dashboards or data visualizations. Option C is wrong because Power Pages is used to build external-facing websites, not for internal dashboards or analytics. Option D is wrong because Power Automate is an automation tool for workflows and processes, not for visualizing or analyzing data in a dashboard format.

Practice this question →