Courseiva

CCNA Power Platform Business Value Questions

75 of 156 questions · Page 1/3 · Power Platform Business Value topic · Answers revealed

1
MCQeasy

A sales manager wants to track leads and opportunities without custom development. Which Power Platform component should they use?

A.Power BI
B.Power Virtual Agents
C.Power Apps (model-driven app)
D.Power Automate
AnswerC

Power Apps model-driven apps suit this scenario because they build on Microsoft Dataverse tables, letting the sales manager track leads and opportunities using prebuilt entities and relationships — no custom development required. This directly satisfies the stem's constraint of avoiding code while delivering structured, data-driven sales tracking.

Why this answer

A model-driven app in Power Apps is designed for data-centric business processes like lead and opportunity tracking, providing out-of-the-box tables, forms, and views without custom development. It leverages the Dataverse to store and manage structured data, making it ideal for a sales manager to track leads and opportunities through a pre-configured, customizable interface.

Exam trap

The trap here is that candidates often confuse Power Automate (workflow automation) with the application layer needed for data entry and tracking, but Power Automate lacks the user interface and data storage capabilities required for managing leads and opportunities directly.

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 interactive data-entry applications to track leads and opportunities. Option B is wrong because Power Virtual Agents is used to create conversational chatbots, not for managing structured sales data or business processes. Option D is wrong because Power Automate is an automation tool for creating workflows and processes, not a full application platform for tracking leads and opportunities with a user interface.

2
MCQeasy

A sales team uses a SharePoint list to track leads. They want to automatically send an email notification when a lead's status changes to 'Closed Won'. Which Power Platform component should they use?

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

Power Automate provides event-driven cloud flows triggered by SharePoint list item modifications. A flow configured with the "When an item is modified" trigger and a condition checking Status equals 'Closed Won' then invokes the Outlook "Send an email" action, satisfying the automatic notification requirement without manual intervention.

Why this answer

Power Automate is the correct choice because it is designed to create automated workflows that trigger on events, such as a change in a SharePoint list item. When a lead's status changes to 'Closed Won', a Power Automate flow can use the 'When an item is modified' trigger, check the status value, and then send an email via the 'Send an email' action (e.g., using Office 365 Outlook). This directly addresses the requirement for automatic notification without manual intervention.

Exam trap

The trap here is that candidates may confuse Power Apps (which can build apps with logic) with Power Automate (the dedicated automation engine), but Power Automate is the correct component for trigger-based, no-code workflows that do not require a user interface.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics tool for data visualization and reporting, not for creating event-driven workflows or sending email notifications. Option C is wrong because Power Apps is a low-code platform for building custom applications (canvas or model-driven apps), which can include logic but is not the native tool for automating a simple trigger-based email; it would require embedding Power Automate or custom code. Option D is wrong because Microsoft Copilot Studio is used to build conversational AI chatbots and copilots, not for automating SharePoint list-based email notifications.

3
MCQeasy

A nonprofit organization wants to create a public website to accept donations without writing code. Which Power Platform component should they use?

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

Power Pages provides low-code, externally facing websites with built-in forms, authentication and Dataverse integration, so donations can be captured without writing code. It satisfies the public website requirement, unlike model-driven apps, which are internal, or canvas apps, which lack anonymous public hosting.

Why this answer

Power Pages is the correct choice because it enables users to create low-code, externally facing websites that can securely accept payments and donations without writing custom code. It provides built-in templates, data integration with Dataverse, and supports anonymous access for public users, making it ideal for a nonprofit's donation portal.

Exam trap

The trap here is that candidates often confuse Power Apps (which builds authenticated internal apps) with Power Pages (which builds public-facing websites), failing to recognize that Power Pages is the only component designed for anonymous external access and web hosting.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not a website builder; it cannot host public web pages or accept donations. Option B is wrong because Power Automate is a workflow automation service that can trigger actions like sending confirmation emails, but it cannot create a public-facing website or accept donations directly. Option C is wrong because Power Apps is designed for building custom business applications (canvas or model-driven) that require user authentication and are not intended for public anonymous access; it lacks native web hosting capabilities for external users.

4
MCQmedium

Your organization uses Microsoft Copilot Studio to create a chatbot that answers HR questions. What is the primary business value of this approach?

A.It creates custom apps for HR processes.
B.It reduces the need for a human resources department.
C.It provides data analytics on HR metrics.
D.It automates routine inquiries, allowing HR to focus on strategic tasks.
AnswerD

Copilot Studio deflects repetitive HR questions through conversational topics, so staff receive immediate answers while HR personnel redirect effort to strategic work. Automating routine inquiries is the primary business value, cutting ticket volume and response times.

Why this answer

The primary business value of using Microsoft Copilot Studio to create an HR chatbot is that it automates routine inquiries (e.g., leave balances, policy lookups), freeing HR staff to focus on strategic tasks like talent management and employee engagement. This aligns with the core Power Platform value of empowering users to build low-code solutions that improve operational efficiency without requiring custom app development or replacing human expertise.

Exam trap

The trap here is that candidates confuse the purpose of Copilot Studio (chatbot creation) with Power Apps (custom app creation) or Power BI (analytics), leading them to pick Option A or C, while Option B is an extreme overstatement that ignores the human element in HR.

How to eliminate wrong answers

Option A is wrong because Copilot Studio creates conversational AI chatbots, not custom apps; custom apps are built with Power Apps, not Copilot Studio. Option B is wrong because the chatbot augments, not replaces, the HR department—human judgment is still needed for complex cases, compliance, and strategic decisions. Option C is wrong because while the chatbot can surface data, it does not provide data analytics on HR metrics; analytics is the domain of Power BI, not Copilot Studio.

5
MCQeasy

A small marketing team wants to automate the process of capturing leads from their website into a Dataverse table. Currently, the website sends an email notification when a lead submits a form, and a team member manually enters the data into a Power Apps app. The team wants to eliminate manual data entry. They also want to automatically send a confirmation email to the lead and create a task in Microsoft To Do for the sales representative to follow up. You need to recommend a Power Platform solution. What should you do?

A.Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.
B.Replace the website form with a Power Apps portal form, and use Power Automate for emails and tasks.
C.Use Microsoft Forms to collect leads, and Power Automate to add to Dataverse and send emails.
D.Create a Power Apps app on the website to capture leads, and use Power Automate to send emails and create tasks.
AnswerA

Power Automate's email trigger parses the notification, writes to Dataverse, sends the confirmation, and creates the To Do task in one flow, eliminating manual entry. It satisfies all three stated requirements without custom code or a new app.

Why this answer

It directly addresses the requirement to eliminate manual data entry by using Power Automate to monitor the website's email inbox (via a trigger like 'When a new email arrives'), parse the lead data from the email body or attachments, add it to a Dataverse table, send a confirmation email, and create a task in Microsoft To Do. This solution automates the entire workflow without requiring changes to the existing website form or manual intervention.

Exam trap

The trap here is that candidates may assume the website form must be replaced or modified (options B, C, D) rather than realizing that Power Automate can directly consume existing email notifications from the website without any changes to the website itself.

How to eliminate wrong answers

Option B is wrong because replacing the website form with a Power Apps portal form requires significant development effort and changes to the existing website, which is unnecessary when the current form already sends email notifications that can be automated. Option C is wrong because Microsoft Forms does not integrate directly with the existing website form; it would require replacing the form and does not address the requirement to capture leads from the current website form. Option D is wrong because embedding a Power Apps app on the website to capture leads still requires manual data entry into the app, and the goal is to eliminate manual entry entirely, not just move it to a different interface.

6
MCQhard

An organization uses Power Automate to process invoices from email attachments. Some invoices are processed incorrectly because the flow fails to parse PDFs with non-standard layouts. What should the administrator do to improve accuracy?

A.Increase the flow run frequency to every minute.
B.Add a condition to route non-parsed invoices for manual approval.
C.Use AI Builder to create a custom document processing model.
D.Change the trigger to a manual button in Power Apps.
AnswerC

AI Builder's custom document processing model learns your invoice layouts from labelled samples, so it extracts fields from non-standard PDFs that the built-in parser cannot handle, directly addressing the parsing accuracy failure in the flow.

Why this answer

AI Builder provides prebuilt and custom document processing models that use optical character recognition (OCR) and machine learning to extract data from PDFs with non-standard layouts. This directly addresses the root cause—parsing failures due to layout variability—by training the model on sample invoices to handle diverse formats, unlike static parsing logic.

Exam trap

The trap here is that candidates confuse operational fixes (like increasing frequency or adding manual routing) with a true AI-driven solution, overlooking that AI Builder is the only option that directly addresses the root cause of layout variability in document parsing.

How to eliminate wrong answers

Option A is wrong because increasing the flow run frequency to every minute does not improve parsing accuracy; it only retries the same flawed logic more often, wasting resources. Option B is wrong because routing non-parsed invoices for manual approval is a workaround that reduces automation benefits and does not fix the underlying parsing failure; it merely escalates the problem. Option D is wrong because changing the trigger to a manual button in Power Apps shifts the initiation method but does not alter the flow's inability to parse non-standard PDFs; the same parsing logic still fails.

7
MCQmedium

A retail company uses Power BI to monitor sales performance. They notice that the report data refreshes only once daily, but business users need near-real-time insights. What should they recommend?

A.Export the data to Excel for manual updates.
B.Configure a streaming dataset in Power BI.
C.Create a Power Automate flow to refresh the dataset every minute.
D.Increase the scheduled refresh frequency to every 15 minutes.
AnswerB

Streaming datasets push data into Power BI as events arrive, bypassing the scheduled refresh cycle entirely. This satisfies the near-real-time requirement, whereas import-mode datasets refresh only at configured intervals and cannot deliver the low-latency insights business users need.

Why this answer

Streaming datasets in Power BI are designed for real-time or near-real-time data ingestion, allowing dashboards to update continuously as new data arrives. This directly addresses the requirement for near-real-time insights without relying on scheduled refreshes.

Exam trap

The trap here is that candidates may confuse scheduled refresh frequency with real-time streaming, assuming that increasing the refresh interval (Option D) or using automation (Option C) can achieve near-real-time updates, when in fact Power BI's architecture requires a streaming dataset for sub-minute data ingestion.

How to eliminate wrong answers

Option A is wrong because exporting data to Excel for manual updates is a static, offline approach that cannot provide near-real-time insights and introduces human latency. Option C is wrong because Power Automate flows can trigger dataset refreshes, but Power BI datasets (non-streaming) have a maximum refresh frequency of 30 minutes (or 8 per day for shared capacity), and refreshing every minute is not supported; streaming datasets are the correct mechanism for sub-minute updates. Option D is wrong because increasing scheduled refresh frequency to every 15 minutes still relies on a pull-based model and is limited by Power BI's maximum of 48 refreshes per day (every 30 minutes) on shared capacity, and it cannot achieve true near-real-time updates.

8
Multi-Selectmedium

Which TWO benefits does using Microsoft Power Platform provide to an organization?

Select 2 answers
A.Reduces the time needed to build business applications.
B.Eliminates the need for any security governance.
C.Only benefits large enterprises with extensive IT resources.
D.Empowers business users to automate their own processes.
E.Requires dedicated IT teams for every modification.
AnswersA, D

Low-code drag-and-drop authoring with prebuilt connectors and templates removes much of the bespoke development effort, so business applications reach production far sooner than traditional coding projects. This directly satisfies the stem's requirement for a benefit that reduces application build time.

Why this answer

Option A is correct because Power Platform's low-code/no-code approach with prebuilt connectors, templates, and drag-and-drop designers (Power Apps, Power Automate) dramatically shortens the development lifecycle compared to traditional custom coding. Option D is correct because Power Platform is explicitly designed for citizen developers, letting business users build apps, flows, and dashboards themselves using tools like Power Apps and Power Automate, reducing dependency on IT backlogs. Option B is wrong because Power Platform still requires security governance via tools such as Data Loss Prevention (DLP) policies, Microsoft Dataverse security roles, and environment management.

Option C is wrong because Power Platform scales from small businesses to large enterprises, not only large ones. Option E is wrong because the platform's self-service model reduces, rather than requires, dedicated IT involvement for every change.

Exam trap

PL-900 often tests the misconception that Power Platform eliminates the need for IT or security governance, when in fact it shifts IT's role to governance and enablement rather than hands-on development for every solution.

9
MCQhard

A hospital uses Power BI to monitor patient wait times. The data source is an on-premises SQL Server database. To ensure real-time reporting, what should the hospital deploy?

A.Azure Data Factory
B.Power BI Report Server
C.On-premises data gateway
D.Power BI Desktop
AnswerC

An on-premises data gateway brokers queries between Power BI cloud services and the internal SQL Server, enabling scheduled or near real-time refresh without exposing the database directly. It satisfies the real-time reporting constraint while keeping the data source on-premises.

Why this answer

The on-premises data gateway (Option C) is the correct choice because it acts as a bridge between Power BI in the cloud and the on-premises SQL Server database, enabling real-time or near-real-time data refreshes for dashboards. Without this gateway, Power BI cannot directly connect to on-premises data sources, making it impossible to achieve real-time reporting from the hospital's local database.

Exam trap

The trap here is that candidates often confuse the on-premises data gateway with Power BI Report Server, mistakenly thinking an on-premises server is needed for on-premises data, when in fact the gateway enables cloud-based Power BI to securely access on-premises data sources in real time.

How to eliminate wrong answers

Option A is wrong because Azure Data Factory is an ETL and data orchestration service used for moving and transforming data at scale, not for enabling real-time connectivity between Power BI and an on-premises SQL Server. Option B is wrong because Power BI Report Server is an on-premises solution for hosting and sharing Power BI reports, but it does not provide the live connection bridge needed for real-time reporting from a cloud-based Power BI service to an on-premises database. Option D is wrong because Power BI Desktop is a client authoring tool for creating reports and data models, not a connectivity component for real-time data refresh in the Power BI service.

10
MCQhard

A company wants to build a custom copilot for internal IT support. The copilot should answer common questions and escalate to a human agent if needed. Which component should they use?

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

Microsoft Copilot Studio builds conversational copilots with generative answers and topic flows, and supports hand-off escalation to a live agent. This directly satisfies the requirement to answer common IT questions and escalate when needed, without custom code.

Why this answer

Microsoft Copilot Studio is the correct choice because it is specifically designed to build custom copilots (formerly Power Virtual Agents) that can handle conversational Q&A and seamlessly escalate to a human agent when the copilot cannot resolve the issue. This directly matches the requirement for an internal IT support copilot that answers common questions and escalates to a human agent.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to trigger actions from a copilot with being the copilot itself, but Power Automate is only a backend automation engine, not the conversational interface.

How to eliminate wrong answers

Option B (Power Automate) is wrong because it is a workflow automation tool for creating automated processes and integrations, not a conversational AI platform for building copilots. Option C (Power BI) is wrong because it is a business analytics and visualization tool for creating reports and dashboards, not for building interactive chatbots. Option D (Power Apps) is wrong because it is a low-code application development platform for building custom business apps, not for creating conversational copilots with escalation capabilities.

11
Multi-Selecthard

Which THREE capabilities are provided by Microsoft Dataverse? (Select three.)

Select 3 answers
A.Data storage with role-based security
B.Data integration with external systems
C.AI model building
D.Interactive dashboard creation
E.Business logic enforcement (workflows, plugins)
AnswersA, B, E

Dataverse stores data in tables and enforces role-based security at environment, table and column level, satisfying the storage-with-security capability. This lets organisations centralise business data while controlling exactly which users can read or modify each record.

Why this answer

Option A is correct because Microsoft Dataverse provides secure data storage with role-based security, including business units, security roles, and record-level sharing that control access to tables and rows. Option B is correct because Dataverse supports data integration with external systems through connectors, virtual tables, Dataflows, and the Dataverse Web API/OData endpoints, allowing data to flow in and out of external applications. Option E is correct because Dataverse enforces business logic via Power Automate flows, classic workflows, business rules, and plug-ins registered on table events, ensuring consistent processing at the platform level.

Option C is not correct because AI model building is primarily provided by Azure Machine Learning and AI Builder, not as a core Dataverse capability. Option D is not correct because interactive dashboard creation is a Power BI and model-driven app feature, not a capability delivered by Dataverse itself.

Exam trap

The trap here is that candidates confuse the capabilities of Dataverse with those of other Power Platform components, such as AI Builder for AI models or Power BI for dashboards, leading them to select options that are not core Dataverse features.

12
MCQeasy

An organization wants to empower employees to create simple automated workflows without writing code. Which Power Platform service should they use?

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

Power Automate provides low-code workflow automation through triggers and actions, letting employees build flows without programming. It directly satisfies the stem's no-code requirement, unlike Power Apps (app building) or Power BI (analytics). Its drag-and-drop designer and prebuilt connectors enable citizen developers to automate approvals, notifications and data movement.

Why this answer

Power Automate is the correct choice because it is specifically designed to enable users to create automated workflows between applications and services without writing code. It provides a low-code/no-code interface with triggers and actions, allowing employees to automate repetitive tasks such as approvals, notifications, and data synchronization.

Exam trap

The trap here is that candidates may confuse Power Apps (for building apps) with Power Automate (for building workflows), but the question specifically asks for 'automated workflows,' which is the core function of Power Automate, not app creation.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics service for visualizing data and creating reports, not for building automated workflows. Option B is wrong because Power Pages is used to create external-facing websites with low-code tools, not for automating processes. Option C is wrong because Power Apps is for building custom applications with a graphical interface, but it does not natively provide workflow automation capabilities like triggers and actions across multiple services.

13
Multi-Selecteasy

Which TWO are common use cases for Power Automate?

Select 2 answers
A.Automating approval workflows
B.Creating interactive dashboards
C.Managing user access to Microsoft 365
D.Building custom mobile applications
E.Sending notifications based on conditions
AnswersA, E

Automating approval workflows is a core Power Automate use case, satisfying the requirement for multi-step, human-in-the-loop processes. Approval actions pause a flow, route requests to designated approvers via Microsoft 365 or Microsoft Entra ID identities, and resume based on the response, removing manual chasing and email-based sign-off.

Why this answer

Power Automate is used for automating business processes and integrating apps. Building custom apps is Power Apps, creating dashboards is Power BI, and managing user identities is Microsoft Entra ID.

14
MCQeasy

A non-profit organization wants to digitize its volunteer sign-up process. They need a solution that can be built quickly without custom code. Which Microsoft Power Platform component should they use?

A.Power BI
B.Copilot Studio
C.Power Apps
D.Power Automate
AnswerC

Power Apps provides a low-code canvas and model-driven builder for creating forms and apps without custom development, so the non-profit can rapidly digitise volunteer sign-up. Dataverse or SharePoint can store submissions, meeting the no-code and speed constraints.

Why this answer

Power Apps is the correct choice because it enables rapid creation of custom apps with a low-code or no-code approach, allowing the non-profit to build a volunteer sign-up form and data submission interface without writing custom code. It directly addresses the need to digitize a manual process by providing a user-friendly canvas or model-driven app that can connect to data sources like SharePoint or Dataverse.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking that automation alone can handle user input, but Power Automate lacks a user interface for direct data entry, making Power Apps the only correct component for building a custom sign-up application.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and visualization tool, not an application builder; it cannot create interactive sign-up forms or capture user input. Option B is wrong because Copilot Studio is designed for building conversational AI agents and chatbots, not for creating data-entry applications like a volunteer sign-up process. Option D is wrong because Power Automate is a workflow automation tool that orchestrates processes and integrates services, but it lacks the user interface components needed for direct data input from volunteers.

15
MCQhard

An organization wants to enforce that all Power Apps in their tenant use only approved connectors and cannot connect to unmanaged data sources. What should they configure?

A.Conditional Access policies in Microsoft Entra ID
B.Environment security roles in Dataverse
C.Data Loss Prevention (DLP) policies in the Power Platform admin center
D.Connector Governance policy in Microsoft Purview
AnswerC

DLP policies in the Power Platform admin center classify connectors into Business, Non-Business and Blocked groups, then block combinations across those groups. This directly enforces the tenant-wide constraint that apps use only approved connectors and cannot reach unmanaged data sources.

Why this answer

Data Loss Prevention (DLP) policies in the Power Platform admin center are the correct tool to enforce which connectors can be used across Power Apps, Power Automate, and Power Virtual Agents. By classifying connectors as 'Business' or 'Blocked,' administrators can prevent apps from connecting to unmanaged or non-approved data sources, ensuring compliance with organizational data governance requirements.

Exam trap

The trap here is that candidates often confuse DLP policies with Conditional Access or security roles, assuming that access control or user permissions can restrict data source connectivity, when in fact DLP policies are the dedicated mechanism for governing connector usage in Power Platform.

How to eliminate wrong answers

Option A is wrong because Conditional Access policies in Microsoft Entra ID control authentication and access to applications based on user, device, or location conditions, not which connectors or data sources an app can use. Option B is wrong because Environment security roles in Dataverse manage user permissions within a specific environment (e.g., read, write, delete records), but they do not restrict which external connectors or data sources are allowed. Option D is wrong because Connector Governance policy in Microsoft Purview does not exist; Purview focuses on data cataloging, classification, and lineage, not on enforcing connector usage restrictions in Power Platform.

16
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

17
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

18
Multi-Selecteasy

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

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

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

Why this answer

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

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

Exam trap

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

19
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

20
Multi-Selecteasy

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

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

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

Why this answer

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

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

Exam trap

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

21
MCQmedium

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

22
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

23
MCQmedium

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

24
MCQmedium

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

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

Scheduled refresh lets the dataset connect to the Excel file on SharePoint and reload it automatically at defined times, removing manual intervention. The on-premises data gateway is only needed if the source sits behind a firewall, which SharePoint does not.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

25
MCQmedium

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

26
Multi-Selecthard

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

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

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

Why this answer

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

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

27
Multi-Selecteasy

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

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

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

Why this answer

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

Exam trap

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

28
Multi-Selecthard

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

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

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

Why this answer

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

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

Exam trap

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

29
MCQmedium

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

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

Escalation topics allow handoff to human agents.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

30
MCQmedium

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

31
MCQhard

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

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

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

Why this answer

The DAX measure uses the `SAMEPERIODLASTYEAR` function, which shifts the current filter context back by one year. When placed in a visual with a year slicer or axis, it returns the total sales for the same period in the previous year relative to the selected year. This is a standard time intelligence calculation for comparing year-over-year absolute values.

Exam trap

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

How to eliminate wrong answers

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

32
MCQeasy

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

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

Power Apps builds the volunteer hours entry app, Power Automate triggers the weekly reminder workflow for inactive volunteers, and Power BI renders the dashboard aggregating hours by project. Together they cover data capture, automation and reporting without dedicated IT staff.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

33
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

34
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

35
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for creating automated processes between apps and services, not for data analysis or interactive reporting. Option C is wrong because Power Apps is a low-code application development platform for building custom business apps, not for analyzing data or creating reports. Option D is wrong because Microsoft Copilot Studio is a tool for building custom copilots and AI assistants, not for data analysis or interactive reporting.

36
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

37
MCQhard

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

38
MCQeasy

In a Power Apps canvas app, the App.OnStart property contains the code above. The LookUp function returns blank for a user who exists in the Roles data source. What is the most likely cause?

A.The app needs to refresh the Roles data source first.
B.The Set function cannot store records.
C.The User() function is not available in Power Apps.
D.The Roles data source column name does not match 'UserEmail'.
AnswerD

LookUp matches the formula's column argument against the actual column logical name in the Roles data source. If that column is named differently from 'UserEmail', the lookup finds no matching record and returns blank even though the user exists.

Why this answer

The LookUp function in Power Apps relies on exact column name matching. If the Roles data source has a column named 'Email' or 'UserID' instead of 'UserEmail', the function will not find a match and will return blank, even if the user exists. This is a common schema mismatch issue in canvas apps.

Exam trap

The trap here is that candidates assume the LookUp function will automatically match any column containing the user's email, ignoring the exact column name requirement, or they confuse this with a data refresh or function availability issue.

How to eliminate wrong answers

Option A is wrong because the Roles data source is automatically loaded when the app starts; a manual refresh is not required unless the data source is explicitly configured to defer loading, which is not indicated. Option B is wrong because the Set function can store records, including the result of a LookUp, as long as the result is a valid data type (e.g., a record or blank). Option C is wrong because the User() function is fully available in Power Apps and returns the current user's email, name, and other details; it is a core function.

39
MCQeasy

Refer to the exhibit. You see a configuration snippet for a Microsoft Copilot Studio bot. What is the purpose of 'triggerPhrases'?

A.They define the bot's fallback behavior.
B.They identify which topics the bot should use when a user says those phrases.
C.They define the responses the bot will give.
D.They are used for analytics reporting.
AnswerB

Trigger phrases are matched against user utterances to route the conversation to the appropriate topic. When a user's wording aligns with a topic's trigger phrases, the bot invokes that topic, so they act as the routing mechanism rather than the response content.

Why this answer

In Microsoft Copilot Studio, trigger phrases are utterances that, when matched by the NLU model, route the conversation to the associated topic. They define the intent recognition for that topic, not the bot's fallback or responses. This allows the bot to understand user input and select the correct topic to handle.

Exam trap

PL-900 often tests the confusion between trigger phrases (intent recognition) and responses (message content), so candidates must remember that trigger phrases are for routing, not for defining what the bot says.

How to eliminate wrong answers

Option A is wrong because fallback behavior is configured separately, typically via the 'Fallback' topic or system fallback settings, not through trigger phrases. Option C is wrong because responses are defined within the topic's authoring canvas (message nodes), not by trigger phrases. Option D is wrong because analytics reporting is a separate feature that tracks usage and performance, not the purpose of trigger phrases.

40
MCQmedium

A company wants to enable its field service technicians to access customer records and update work orders from their mobile devices offline. Which Power Platform solution should they implement?

A.Power Pages website accessible from mobile browsers
B.Power Apps (model-driven) configured for offline use
C.Power BI dashboards embedded in a mobile app
D.Power Automate flows to sync data periodically
AnswerB

Model-driven Power Apps can be used offline, enabling technicians to view and edit data on their mobile devices.

Why this answer

Model-driven Power Apps natively support offline capabilities through the Dynamics 365 offline sync engine, which allows field service technicians to access customer records and update work orders without connectivity. When the device reconnects, changes are automatically synchronized with the Dataverse, ensuring data consistency. This makes it the correct choice for mobile offline scenarios.

Exam trap

The trap here is that candidates confuse 'offline access' with 'periodic sync' (Option D) or 'mobile browser access' (Option A), not realizing that only model-driven Power Apps provide a native offline runtime with full CRUD capabilities on mobile devices.

How to eliminate wrong answers

Option A is wrong because Power Pages is a low-code website builder for external-facing sites, not designed for offline mobile data entry or synchronization with Dataverse. Option C is wrong because Power BI is a data visualization and analytics tool, not an application for creating or updating transactional records like work orders. Option D is wrong because Power Automate flows can trigger syncs but do not provide a user interface for technicians to view or edit records offline; they are automation tools, not offline-capable apps.

41
MCQhard

A global company has multiple Power Platform environments (Dev, Test, Prod) and uses Application Lifecycle Management (ALM) with solutions. The administrator needs to ensure that only tested solutions are deployed to production. What is the recommended approach?

A.Share the solution from Dev to Test to Prod using sharing permissions.
B.Export the solution as managed from Dev, import to Test, then after validation, import to Prod.
C.Allow developers to make changes directly in the production environment.
D.Copy the Dataverse database from Dev to Prod directly.
AnswerB

Managed solutions are locked, so they cannot be edited directly in Test or Prod, enforcing that only validated artefacts flow through the pipeline. Exporting as managed from Dev and importing to Test for validation, then to Prod, satisfies the requirement that only tested solutions reach production.

Why this answer

Application Lifecycle Management (ALM) in Power Platform requires solutions to be exported as managed from a development environment, then imported into test for validation, and finally imported into production. This ensures that only tested, versioned components are deployed, preventing unvalidated changes from reaching production. Managed solutions also lock components in the target environment, preventing accidental modifications.

Exam trap

The trap here is that candidates confuse sharing permissions (which control user access) with solution deployment mechanisms, leading them to choose option A instead of understanding that managed exports are the only supported ALM method for promoting solutions across environments.

How to eliminate wrong answers

Option A is wrong because sharing permissions control user access to data and apps, not the deployment of solution components; sharing does not enforce versioning or testing gates. Option C is wrong because allowing direct changes in production bypasses all ALM processes, risks breaking live services, and violates governance best practices. Option D is wrong because copying the Dataverse database directly from Dev to Prod would overwrite production data and configurations, including untested changes, and is not a supported method for solution deployment.

42
MCQhard

Your organization has a Power Apps app that uses the Microsoft Dataverse connector. Users report that the app loads slowly. You review the app and find that it loads all records from a large table (over 500,000 rows) into a gallery. What is the best action to improve performance?

A.Increase the data row limit in the app settings.
B.Modify the gallery's Items property to use a delegable filter, such as Filter(Table, Condition).
C.Clear the app cache on the client devices.
D.Reduce the delegation limit in the environment settings.
AnswerB

Delegable filters translate into Dataverse queries executed server-side, so only matching rows return to the app instead of all 500,000. This satisfies the performance constraint by avoiding the non-delegable row limit that forces client-side processing of the full table.

Why this answer

Modifying the gallery's Items property to use a delegable filter (e.g., Filter(Table, Condition)) ensures that the query is processed server-side by Microsoft Dataverse, retrieving only the subset of records that match the condition. This avoids loading all 500,000+ rows into the client app, which is the root cause of the slow performance. Delegation allows Power Apps to offload data processing to the data source, significantly reducing network payload and client memory usage.

Exam trap

The trap here is that candidates often confuse client-side caching or row limits with the core delegation concept, mistakenly believing that increasing limits or clearing caches solves performance issues, when the real solution is to ensure queries are processed on the server via delegable filters.

How to eliminate wrong answers

Option A is wrong because increasing the data row limit in app settings would actually worsen performance by forcing the app to retrieve even more records from the large table, exacerbating the slow loading issue. Option C is wrong because clearing the app cache on client devices only removes locally stored temporary files; it does not address the fundamental problem of retrieving an excessive number of records from the server. Option D is wrong because reducing the delegation limit in environment settings would lower the maximum number of records that can be processed server-side, potentially causing the app to fall back to non-delegable queries and still retrieve all rows, or truncating data incorrectly.

43
Multi-Selectmedium

A company is evaluating the Microsoft Power Platform to streamline its operations. The IT director wants to understand which components are considered part of the Power Platform and provide specific capabilities. (Choose two.)

Select 2 answers
A.Microsoft Azure Machine Learning
B.Power BI
C.Power Automate
D.Microsoft Dynamics 365
E.Microsoft Power Platform Center of Excellence Toolkit
AnswersB, C

Power BI is a core component of the Microsoft Power Platform. It provides business analytics capabilities, allowing users to visualize data, create interactive reports, and share insights across the organization. It connects to various data sources and is used for data-driven decision-making, making it an integral part of the platform's offerings.

Why this answer

The Microsoft Power Platform consists of four key components: Power Apps for app development, Power Automate for workflow automation, Power BI for business analytics, and Power Virtual Agents for chatbots. Power BI and Power Automate are two of these core components, offering analytics and automation capabilities respectively. The other options are related but not part of the core platform.

Exam trap

The trap here is confusing related Microsoft services like Dynamics 365 or Azure Machine Learning with the core Power Platform components.

44
MCQmedium

A manufacturing company uses Power Apps to track inventory. They want to add a feature that automatically reorders stock when levels fall below a threshold. The solution must be low-code. Which Power Platform component should be integrated with Power Apps?

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

Power Automate supplies the event-driven workflow engine that Power Apps lacks natively. A flow triggered when the inventory record's quantity drops below the threshold can call the reorder action automatically, satisfying the low-code requirement without custom plug-ins or code.

Why this answer

Power Automate is the correct component because it provides low-code workflow automation that can monitor inventory levels in real time and trigger reorder actions when thresholds are breached. By integrating Power Automate with Power Apps, you can create a cloud flow that checks stock data from a data source (e.g., Dataverse or SQL) and automatically sends reorder notifications or creates purchase orders, all without writing traditional code.

Exam trap

The trap here is that candidates often confuse Power Automate with Power BI, thinking that a dashboard can automatically reorder stock, but Power BI is read-only and cannot trigger actions—only Power Automate can execute automated workflows.

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 triggering automated actions like reordering stock. Option B is wrong because Power Pages is used to build external-facing websites with low-code, not for backend process automation or event-driven workflows. Option C is wrong because Power Virtual Agents is designed for creating conversational chatbots, not for executing automated business logic such as inventory reorder triggers.

45
MCQeasy

A small business wants to automate sending a welcome email when a new customer is added to a CRM system. Which Power Platform service should they use?

A.Power Automate
B.Power Apps
C.Power BI
D.Copilot Studio
AnswerA

Power Automate provides event-driven cloud flows, so a trigger on new CRM customer record creation can automatically send the welcome email. This satisfies the automation requirement, unlike Power Apps, which builds apps, or Power BI, which only visualises data.

Why this answer

Power Automate is the correct service because it is designed to create automated workflows that trigger actions based on events, such as sending a welcome email when a new customer record is added to a CRM system. It uses connectors to integrate with CRM platforms (e.g., Dynamics 365, Salesforce) and email services (e.g., Office 365 Outlook) to execute the automation without manual intervention.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking that building an app is necessary to send an email, when in fact Power Automate handles event-driven automation without requiring a custom app interface.

How to eliminate wrong answers

Option B is wrong because Power Apps is a low-code platform for building custom applications, not for automating workflows or sending emails based on triggers. Option C is wrong because Power BI is a business analytics tool for data visualization and reporting, not for workflow automation or event-driven actions. Option D is wrong because Copilot Studio is used to create custom copilots and AI-powered conversational experiences, not for triggering automated email workflows from CRM events.

46
MCQhard

A company has a Power Apps portal for external partners to submit support tickets. Partners report that they cannot see the tickets they created. The portal uses Dataverse. What is the most likely cause?

A.The partners are using an unsupported browser.
B.Entity permissions for the ticket table are not configured for portal users.
C.The portal is not published to the external network.
D.The Dataverse environment is in maintenance mode.
AnswerB

Power Pages uses its own table permissions layered over Dataverse security roles; without a permission record granting the partner web role read access to the ticket table, portal users see nothing. Dataverse roles alone do not expose records to external portal identities.

Why this answer

In Power Apps portals, visibility of Dataverse records is governed by entity permissions, not by the portal being published or the browser used. When partners cannot see tickets they created, the most likely cause is that the entity permissions for the ticket table are not configured to grant 'Read' access to the appropriate portal web roles (e.g., 'Authenticated Users' or a custom role). Without these permissions, the portal cannot query and display the records, even though the data exists in Dataverse.

Exam trap

The trap here is that candidates may assume the issue is a network or browser problem, but the PL-900 exam specifically tests understanding that Power Apps portals rely on Dataverse security and entity permissions to control record visibility, not on portal publishing status or browser compatibility.

How to eliminate wrong answers

Option A is wrong because unsupported browsers typically cause rendering or functionality issues (e.g., JavaScript errors), not a complete inability to see records that were created; Dataverse and Power Apps portals support modern browsers like Chrome, Edge, and Firefox. Option C is wrong because if the portal were not published to the external network, partners would not be able to access the portal at all, not just fail to see tickets; the question states they can access the portal but cannot see tickets. Option D is wrong because maintenance mode in Dataverse prevents all operations (create, read, update, delete) across the environment, but partners can still create tickets, which indicates the environment is operational.

47
Multi-Selecthard

Which TWO of the following are best practices for managing Power Platform environments in an enterprise? (Choose two.)

Select 2 answers
A.Share all connectors and data sources with all users by default.
B.Implement Data Loss Prevention (DLP) policies to control data flow between connectors.
C.Disable auditing to improve performance.
D.Use a single environment for all development and production workloads.
E.Use separate environments for development, testing, and production.
AnswersB, E

DLP policies define which connectors may share data within a tenant, blocking combinations that could leak business data to consumer services. This satisfies the enterprise governance requirement by enforcing connector classification across environments and apps centrally.

Why this answer

Option B is correct because Data Loss Prevention (DLP) policies in the Power Platform Admin Center let administrators classify connectors into Business, Non-Business, and Blocked groups, preventing sensitive data from flowing between incompatible connectors and enforcing enterprise governance. Option E is correct because separating development, testing, and production into distinct environments isolates changes, supports managed solutions and deployment pipelines, and prevents unverified customizations from affecting live business data. Options A, C, and D are not best practices: sharing all connectors and data sources by default violates least-privilege and exposes sensitive data, disabling auditing removes the compliance and security trail needed for enterprise oversight, and using a single environment for all workloads mixes development and production, risking instability and data corruption.

Exam trap

The trap here is that candidates may think disabling auditing improves performance (Option C) or that a single environment simplifies management (Option D), but the PL-900 exam emphasizes governance, security, and ALM separation as core best practices.

48
MCQeasy

A non-technical employee wants to create a simple chatbot to answer common HR questions. Which Power Platform component should they use?

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

Power Virtual Agents lets non-technical staff build chatbots through a guided, no-code graphical interface, satisfying the stem's requirement for a simple HR Q&A bot without developer skills. It integrates with Microsoft Entra ID for authentication and connects to Power Automate flows, so the employee can extend answers to backend HR data later.

Why this answer

Power Virtual Agents (C) is the correct choice because it is a no-code, AI-driven chatbot service within Power Platform specifically designed for building conversational agents. It allows non-technical users to create, publish, and analyze chatbots using a graphical interface without writing code, making it ideal for handling common HR questions through predefined topics and natural language understanding.

Exam trap

The trap here is that candidates confuse Power Virtual Agents with Power Automate, assuming chatbots are just automated workflows, but Power Virtual Agents is specifically designed for conversational AI with built-in NLP, whereas Power Automate handles backend task automation.

How to eliminate wrong answers

Option A is wrong because Power BI is a business analytics and data visualization tool, not a chatbot builder; it focuses on creating reports and dashboards from data sources. Option B is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating conversational interfaces or chatbots. Option D is wrong because Power Automate is a workflow automation service for orchestrating repetitive tasks and processes across applications, not for building interactive chatbots that respond to user queries in real time.

49
MCQmedium

A healthcare provider needs to ensure that only authorized users can access patient data in a Power Apps app. The app uses Dataverse. What should the administrator configure?

A.Configure SharePoint permissions for the app
B.Set environment as restricted in Power Platform admin center
C.Use Microsoft Entra ID conditional access policies
D.Assign Dataverse security roles to users
AnswerD

Assigning Dataverse security roles grants users the precise privileges required to access patient records, satisfying the requirement that only authorised users reach the data. Security roles operate at the environment and table level, controlling create, read, update and delete permissions, so unauthorised users without an assigned role are denied access entirely.

Why this answer

Dataverse uses its own security model based on security roles, which define the privileges a user has on tables, records, and other resources. To ensure that only authorized users can access patient data in a Power Apps app that uses Dataverse, the administrator must assign appropriate Dataverse security roles to users. These roles control create, read, write, delete, and append privileges at the organization, business unit, parent-child business unit, and user levels.

Exam trap

PL-900 often tests the distinction between authentication (Entra ID conditional access) and authorization (Dataverse security roles) — candidates who pick conditional access confuse controlling who can sign in with controlling who can access specific data.

How to eliminate wrong answers

Option A is wrong because SharePoint permissions apply to SharePoint data, not Dataverse tables — the app uses Dataverse, so SharePoint permissions are irrelevant. Option B is wrong because setting the environment as restricted in the Power Platform admin center controls who can create environments and manage capacity, not who can access data within an app. Option C is wrong because Microsoft Entra ID conditional access policies control authentication and access to cloud apps at the sign-in level, but they do not control record-level or table-level access within Dataverse — a user who passes conditional access still needs a Dataverse security role to read patient data.

50
Multi-Selectmedium

A logistics company wants to improve its operations by using Microsoft Power Platform capabilities. The IT director asks which capabilities are provided by the Power Platform to enable business users to build solutions with less coding. (Choose two.)

Select 2 answers
A.Connect to hundreds of data sources through built-in connectors
B.Provision and manage virtual machines in Azure
C.Create automated workflows with a visual designer
D.Build responsive web applications by writing HTML, CSS, and JavaScript
E.Replace all existing line-of-business systems with a single database
AnswersA, C

The Power Platform includes a large library of connectors that let makers interact with services such as SharePoint, SQL Server, Dynamics 365, and third-party APIs without writing integration code. This capability is fundamental to low-code development because it removes the need to build custom data access layers, directly supporting the goal of enabling business users to create solutions quickly.

Why this answer

The Power Platform enables low-code solution building primarily through its extensive connector ecosystem and its visual workflow designer. Connectors let makers reach data and services without custom integration code, while the visual designer in Power Automate lets them automate processes without programming. Together these capabilities empower business users to deliver solutions faster, which is what the IT director is evaluating.

Exam trap

The trap here is equating low-code with any development activity, when the Power Platform's low-code value comes from connectors and visual designers rather than hand-written web code.

51
MCQmedium

Your company wants to create a chatbot that can answer employee questions about IT policies and escalate complex issues to a human agent. The chatbot should be built with minimal custom code. Which two Microsoft Power Platform components should you combine?

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

Power Virtual Agents provides a no-code graphical bot builder that handles conversational question-and-answer flows and supports hand-off to a human agent, satisfying the minimal-custom-code constraint. Combined with Power Automate for backend logic, it answers IT policy queries and escalates complex issues without bespoke development.

Why this answer

This is a multiple-select question requiring two components. Power Virtual Agents (A) is the correct choice because it provides a low-code, conversational AI platform specifically designed to build chatbots with minimal custom code, enabling the creation of a bot that answers IT policy questions. Power Automate (C) is correct because it can be used to escalate complex issues to a human agent by triggering workflows, such as sending an email or creating a ticket in a helpdesk system, without writing code.

Exam trap

The PL-900 exam often tests the distinction between low-code chatbot creation (Power Virtual Agents) and workflow automation (Power Automate) versus analytics (Power BI) or app building (Power Apps), leading candidates to mistakenly choose Power Apps for the chatbot or Power BI for escalation.

How to eliminate wrong answers

Option B (Power BI) is wrong because it is a business analytics tool for data visualization and reporting, not for building chatbots or automating escalation workflows. Option D (Power Apps) is wrong because it is a low-code platform for building custom applications (canvas or model-driven apps), not for creating conversational interfaces or automating escalation processes; while it could integrate with a chatbot, it is not the primary component for the described scenario.

52
MCQhard

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

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

Customer-managed encryption keys let the organisation control the key protecting Dataverse data at rest, while audit logging records every access to sensitive records. Together they satisfy both stated compliance constraints: encryption at rest under customer control and auditable access.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

53
MCQeasy

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

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

Power BI connects to multiple data sources and unifies them into semantic models, then publishes interactive dashboards the team can explore. This directly satisfies the manager's need to analyse combined sales data quickly and share live, interactive visualisations, unlike canvas apps or flow-based automation tools.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

54
Multi-Selectmedium

A financial services firm is evaluating Microsoft Power Platform to reduce manual work in its loan processing department. The IT governance team wants to understand which capabilities are native to the platform itself, rather than requiring separate third-party tools. Which two capabilities are provided by Microsoft Power Platform? (Choose two.)

Select 2 answers
A.Creating automated workflows that respond to events and approvals
B.Hosting virtual machines that run legacy loan processing software
C.Providing a relational database engine with built-in backup and disaster recovery
D.Delivering email, calendaring, and team chat as integrated productivity services
E.Building canvas and model-driven applications without writing code
AnswersA, E

Power Automate is a native Power Platform service for building cloud flows and desktop flows that trigger on events such as a new loan application or an approval decision. It integrates with hundreds of connectors, enabling the firm to route documents, send notifications, and enforce approval steps automatically, which is exactly the kind of manual-work reduction the department is seeking.

Why this answer

Microsoft Power Platform natively includes Power Apps for low-code canvas and model-driven applications and Power Automate for event-driven and approval-based workflows. These two capabilities directly address the loan processing department's need to replace manual steps. Database hosting, virtual machines, and productivity services belong to other Microsoft cloud offerings and are accessed through connectors rather than being platform-native features.

Exam trap

The trap here is treating every Microsoft cloud capability, such as virtual machines or email, as part of Power Platform, when the platform is specifically the low-code app, automation, analytics, and chatbot stack.

55
MCQmedium

A healthcare organization wants to automate patient appointment reminders and allow patients to ask common questions such as clinic hours and preparation instructions. The organization prefers a low-code approach and wants the chatbot to use existing knowledge articles. Which Power Platform service should the organization use?

A.Power Automate
B.Power Apps
C.Power Virtual Agents
D.AI Builder
AnswerC

Power Virtual Agents is the Power Platform service for building low-code chatbots. It can answer patient questions by drawing on knowledge sources and can be integrated with Power Automate to send appointment reminders. This aligns with the healthcare organization's need for a conversational interface that uses existing knowledge articles without custom coding.

Why this answer

Power Virtual Agents is the correct service because it is purpose-built for low-code conversational bots that can answer questions from knowledge sources and be extended with automation. The healthcare organization can publish the bot to a website or Teams channel and use Power Automate for reminder flows. AI Builder, Power Apps, and Power Automate provide supporting capabilities but not the chatbot authoring experience.

Exam trap

The trap here is choosing AI Builder because it contains the word AI, when AI Builder supplies models used within apps and flows and Power Virtual Agents is the service that builds the conversational bot.

56
Multi-Selecteasy

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

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

Native connectors let flows and apps consume Microsoft 365 data and Azure services without custom middleware, so existing investments extend into new solutions. This integration is a core business value, reducing duplication and accelerating delivery across the tenant.

Why this answer

Option C is correct because Power Platform connectors natively integrate with Microsoft 365 (SharePoint, Teams, Outlook, Dataverse) and Azure services (Azure Functions, Logic Apps, Service Bus, Azure SQL), letting solutions extend across the Microsoft cloud ecosystem. Option E is correct because Power Apps, Power Automate, and Power Virtual Agents use low-code/no-code designers, templates, and prebuilt connectors that let citizen developers build apps and automate workflows with minimal or no traditional programming. Option A is wrong because Power Platform supports hundreds of non-Microsoft connectors (SQL Server, Salesforce, SAP, Twitter, custom APIs), not just Microsoft 365 data.

Option B is wrong because professional developers are optional—pro-code extensibility (Power Fx, plug-ins, Azure Functions) exists, but it is not required for all solutions. Option D is wrong because Power BI is the analytics component; Power Platform's core value is app creation, automation, and virtual agents, not primarily data analytics.

Exam trap

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

57
MCQeasy

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

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

Power Apps provides a no-code canvas app builder, letting technicians capture text and photos through mobile-optimised interfaces without writing code. It directly satisfies the stem's constraint of code-free mobile data submission, unlike flow-based or dashboard-only tools.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

58
MCQhard

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

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

SharePoint triggers bind to a specific library path; if the trigger watches the root rather than the 'Pending' folder, uploads into that subfolder never fire it. Correcting the trigger's folder setting resolves the missing runs.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

59
MCQeasy

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

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

Power Automate triggers workflows from Dataverse record changes, so a new customer interaction can automatically send a follow-up email without code. This satisfies the no-custom-development constraint, whereas Power Apps would require building an app and Power BI only reports on data.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

60
Multi-Selectmedium

Which FOUR of the following are core components of Microsoft Power Platform?

Select 4 answers
A.Power BI
B.Power Virtual Agents
C.Microsoft 365
D.Power Apps
E.Power Automate
AnswersA, B, D, E

Power BI is a core Power Platform component, providing business analytics and interactive reporting over datasets, and is listed by Microsoft among the platform's four components with Power Apps, Power Automate and Power Virtual Agents.

Why this answer

Power BI (A) is a core Power Platform component because it provides the business analytics and interactive dashboard/reporting layer of the platform. Power Virtual Agents (B) is also a core component, offering a no-code/low-code way to build conversational chatbots. Power Apps (D) is a core component that enables rapid building of custom canvas, model-driven, and portal applications.

Power Automate (E) is a core component that provides workflow and robotic process automation across services and systems. Microsoft 365 (C) is not a Power Platform component; it is a separate productivity suite (Exchange Online, SharePoint, Teams, etc.) that Power Platform frequently integrates with, but it is not one of the platform's core components.

Exam trap

Candidates might assume only the original three (Power BI, Power Apps, Power Automate) are core components, but Power Virtual Agents is also a core component. The question explicitly asks for four, so ensure you select all four correct options.

61
MCQhard

A retail chain uses Power BI to analyze sales data from multiple stores. They want to enable store managers to see only their store's data. What feature should they use?

A.Power Pages permissions
B.Power Apps custom connector
C.Power BI row-level security (RLS)
D.Power Automate to filter data
AnswerC

Row-level security applies DAX filter expressions to a role, restricting each store manager's dataset rows to their own store while sharing one semantic model. This satisfies the stem's constraint of per-store data visibility without duplicating reports.

Why this answer

Row-level security (RLS) in Power BI restricts data access at the row level based on user roles and filters. By defining roles that filter sales data by store ID and assigning store managers to their respective roles, each manager will only see their own store's data when viewing reports. This is the native Power BI feature designed for this exact scenario.

Exam trap

The trap here is that candidates may confuse Power Automate's ability to filter data in a flow with persistent, role-based security enforcement in Power BI, overlooking that RLS is the dedicated feature for per-user data visibility in reports.

How to eliminate wrong answers

Option A is wrong because Power Pages permissions control access to external-facing websites and their content, not to Power BI datasets or reports. Option B is wrong because Power Apps custom connectors are used to connect to external APIs or services from within Power Apps, not to filter data in Power BI. Option D is wrong because Power Automate is an automation tool for workflows and does not provide persistent, role-based data filtering within Power BI reports; it could filter data in a flow but would not enforce security at the report level.

62
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

63
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

64
Multi-Selectmedium

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

Select 3 answers
A.Power Automate
B.Azure Logic Apps
C.Dynamics 365
D.Power BI
E.Power Apps
AnswersA, D, E

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

Why this answer

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

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

Exam trap

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

65
Multi-Selectmedium

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

Select 2 answers
A.Provides seamless integration with Microsoft 365 and Azure services.
B.Only works with on-premises data sources.
C.Eliminates the need for any manual data entry.
D.Requires extensive programming knowledge to build solutions.
E.Enables rapid development and deployment of custom applications.
AnswersA, E

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

Why this answer

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

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

Exam trap

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

66
Multi-Selecteasy

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

Select 2 answers
A.Creating a dashboard to visualize sales trends
B.Copying files from one SharePoint folder to another when a new file is added
C.Building a custom user interface for data entry
D.Sending an approval request when a new expense report is submitted
AnswersB, D

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

Why this answer

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

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

Exam trap

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

67
MCQhard

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

A.Azure Policy assignments and Azure Blueprints for each region
B.Microsoft Entra ID conditional access policies and Microsoft Purview sensitivity labels
C.Environments with data loss prevention policies, plus the Center of Excellence toolkit
D.Power BI workspaces with row-level security and Microsoft 365 retention labels
AnswerC

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

Why this answer

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

Exam trap

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

68
MCQmedium

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

A.Power BI real-time dashboard
B.Copilot Studio chatbot
C.Power Automate flow
D.Power Apps canvas app
AnswerC

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

69
MCQeasy

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

A.Power Apps canvas app for tenants and Power Apps model-driven app for staff
B.AI Builder and Power Automate to process requests
C.Power BI dashboard for tenants to view status and Power Apps for staff
D.Power Pages for tenants, Dataverse for storage, Power Automate for notifications, and Power Apps model-driven app for staff
AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

70
MCQhard

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

A.Power Automate
B.Power Apps
C.Power Virtual Agents
D.AI Builder
AnswerC

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

Why this answer

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

Exam trap

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

71
Multi-Selectmedium

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

Select 3 answers
A.Text recognition (OCR) from images and PDFs.
B.Custom machine learning model training from scratch.
C.Object detection in images.
D.Form processing to extract data from documents.
E.Building custom user interfaces for mobile apps.
AnswersA, C, D

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

Why this answer

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

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

Exam trap

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

72
MCQmedium

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

A.Use Power Automate with AI Builder to process paper forms and store in SharePoint
B.Build a Power Apps model-driven app for internal staff and a canvas app for citizens
C.Use Power BI to create a dashboard and Power Automate for approvals
D.Use Power Pages for citizen submissions, Dataverse for storage, and Power Automate for approvals
AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

73
MCQeasy

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

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

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

74
Multi-Selectmedium

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

Select 2 answers
A.Guarantee that all business processes will be fully automated without human intervention.
B.Enable citizen developers to build apps and automations with low-code tools.
C.Provide a unified platform that connects data and services across Microsoft and third-party systems.
D.Replace the need for professional developers entirely in enterprise software projects.
E.Provide only on-premises deployment with no cloud capabilities.
AnswersB, C

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

Why this answer

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

Exam trap

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

75
MCQmedium

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

A.Azure SQL Database
B.Microsoft Dataverse
C.SharePoint lists
D.Power BI dataflows
AnswerB

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

Why this answer

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

Exam trap

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

Page 1 of 3 · 156 questions totalNext →

Ready to test yourself?

Try a timed practice session using only Power Platform Business Value questions.