Knowledge + Practice

CCNA Power Platform Business Value Questions

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

Practice these questions Exam hub All questions

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

Model-driven apps include pre-built entities for sales processes.

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.

Practice this question →

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 can create automated workflows triggered by SharePoint list changes.

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.

Practice this question →

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 is designed for creating external-facing websites with low-code.

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.

Practice this question →

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

This describes the core benefit of automating common questions.

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.

Practice this question →

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 can automate the entire process without manual intervention.

Why this answer

Option A is correct because 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.

Practice this question →

6

MCQhard

An administrator creates the DLP policy shown above. Which of the following actions will be blocked?

A.Creating a flow that uses SharePoint and Salesforce

B.Using Power Apps with Dataverse

C.Creating a flow that uses Dataverse and SQL Server

D.Using Power BI with SQL Server

AnswerA

SharePoint is blocked, so this flow is not allowed.

Why this answer

Option A is correct because the DLP policy shown blocks the SharePoint connector, and creating a flow that uses both SharePoint and Salesforce would involve the SharePoint connector, which is prohibited by the policy. DLP policies in Power Platform restrict specific connectors from being used together in the same app or flow, and since SharePoint is blocked, any flow that includes it is prevented from being created or run.

Exam trap

The trap here is that candidates may assume DLP policies only block specific data-sharing combinations between connectors, but in reality, blocking a connector entirely prevents its use in any app or flow, regardless of the other connectors involved.

How to eliminate wrong answers

Option B is wrong because using Power Apps with Dataverse does not involve the SharePoint connector, and Dataverse is not blocked by the policy, so this action is allowed. Option C is wrong because creating a flow that uses Dataverse and SQL Server does not include the SharePoint connector, and both Dataverse and SQL Server are not blocked by the policy, so this action is allowed. Option D is wrong because using Power BI with SQL Server does not involve the SharePoint connector, and SQL Server is not blocked by the policy, so this action is allowed.

Practice this question →

7

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 handles varied layouts with AI.

Why this answer

Option C is correct because 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.

Practice this question →

8

Multi-Selecteasy

Which TWO of the following are advantages of using Power BI dashboards over Power BI reports?

Select 2 answers

A.Dashboards can show data from multiple reports on one page.

B.Dashboards allow users to drill down into details.

C.Dashboards support natural language queries (Q&A).

D.Dashboards can be exported to PDF.

AnswersA, C

Dashboards can combine visuals from different reports.

Why this answer

Option A is correct because Power BI dashboards are designed to consolidate tiles from multiple reports and datasets onto a single page, providing a unified view of key metrics without requiring users to navigate between separate report pages. This cross-report aggregation is a core advantage of dashboards over reports, which are limited to a single dataset per report.

Exam trap

The trap here is that candidates often confuse the interactive capabilities of reports (like drill-down and export) with the consolidated, high-level view provided by dashboards, leading them to incorrectly select options B or D as advantages of dashboards.

Practice this question →

9

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 allow real-time data push and dashboard updates.

Why this answer

Option B is correct because 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.

Practice this question →

10

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 tools speed up development.

Why this answer

Power Platform reduces development time and enables business users to solve problems directly. It does not require heavy IT involvement for every change, and it is not limited to large enterprises.

Practice this question →

11

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

Enables secure data transfer between on-premises data sources and Power BI for live dashboards.

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.

Practice this question →

12

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

Copilot Studio enables creation of custom copilots with escalation capabilities.

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.

Practice this question →

13

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 and provides row-level security.

Why this answer

Microsoft Dataverse provides secure data storage with role-based security, allowing administrators to control access to tables and records using security roles, teams, and business units. This ensures that users only see and interact with data they are authorized to access, which is fundamental for enterprise compliance and data governance.

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.

Practice this question →

14

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 is a no-code tool for automating workflows.

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.

Practice this question →

15

MCQmedium

Refer to the exhibit. You are building a Power BI report to analyze sales performance. You create a measure named 'Total Sales' using the DAX expression shown. However, the measure returns a value that is much higher than expected. What is the most likely issue?

A.The Sales table lacks a relationship to the Date table, causing incorrect time-based calculations.

B.The measure is using SUMX without an appropriate filter context, leading to incorrect row iteration.

C.The measure is being filtered by a disconnected slicer, causing overfiltering.

D.The measure should use DISTINCTCOUNT instead of SUMX to count sales.

AnswerB

SUMX iterates the Sales table; if the model has a many-to-many relationship or missing filters, it may sum incorrectly.

Why this answer

Option B is correct because the DAX expression shown uses SUMX, which iterates over each row of the Sales table and sums the product of Quantity and Price. Without an appropriate filter context (e.g., from a Date table or slicer), SUMX may aggregate over the entire table, including rows that should be excluded, leading to a much higher total than expected. The issue is not a missing relationship but rather the lack of a proper filter context to restrict the rows being iterated.

Exam trap

The trap here is that candidates often assume a missing relationship (Option A) is the cause of incorrect totals, but the real issue is that SUMX without a filter context iterates over all rows, producing an inflated value, while a missing relationship would typically cause blanks or errors in time-intelligence functions, not a higher sum.

How to eliminate wrong answers

Option A is wrong because a missing relationship between the Sales table and the Date table would typically cause time-intelligence functions to fail or return blanks, not a much higher value; the measure would still sum correctly over the Sales table. Option C is wrong because a disconnected slicer does not affect the measure unless it is explicitly used in the filter context; overfiltering would reduce the value, not increase it. Option D is wrong because DISTINCTCOUNT counts unique values, not sums, and would not produce a higher total; the measure is intended to sum sales, not count distinct sales.

Practice this question →

16

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

Approval workflows are a common Power Automate scenario.

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.

Practice this question →

17

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 builds apps quickly with low-code.

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.

Practice this question →

18

MCQhard

A multinational corporation uses Power Platform extensively. They have multiple Dataverse environments for development, test, and production. The security team requires that all solution changes be tracked, and deployment must follow a controlled process with approval gates. They also need to ensure that sensitive data in production cannot be exported to development. Which combination of Power Platform capabilities should they implement?

A.Power BI, Managed Environments, and Solution History

B.Managed Environments, Solution History, and DLP policies

C.Solution History, AI Builder, and DLP policies

D.Managed Environments, Copilot Studio, and DLP policies

AnswerB

Managed Environments provides governance, Solution History tracks changes, DLP policies prevent data export.

Why this answer

Managed Environments provides governance features like deployment pipelines and data policies. Solution History tracks changes. Data Loss Prevention (DLP) policies can block data export from production.

Option A is incomplete; Copilot Studio is not relevant. Option C is incorrect because AI Builder is not needed. Option D is incorrect because Power BI does not provide solution tracking.

Practice this question →

19

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 define which connectors are allowed or blocked in an environment.

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.

Practice this question →

20

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 is a low-code platform for building custom apps.

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.

Practice this question →

21

MCQeasy

A non-profit organization needs to collect feedback from event attendees via a form that automatically populates a SharePoint list. Which Power Platform component should they use?

A.Power Virtual Agents

B.Power Automate

C.Power BI

D.Power Apps (canvas app)

AnswerD

Canvas apps can create custom forms and connect to SharePoint.

Why this answer

A canvas app in Power Apps can be built to collect feedback from event attendees and, using its built-in SharePoint connector, automatically write responses to a SharePoint list. This directly meets the requirement of a custom form that populates a SharePoint list without additional workflow logic.

Exam trap

The trap here is that candidates often confuse Power Automate (which can automate list population) with the form-building component itself, but the question specifically asks for the component to 'collect feedback via a form,' which is the primary function of Power Apps, not Power Automate.

How to eliminate wrong answers

Option A is wrong because Power Virtual Agents is for creating conversational chatbots, not for building data-collection forms that populate SharePoint lists. Option B is wrong because Power Automate is an automation workflow tool, not a form-building interface; while it could process form submissions, the question asks for the component to collect feedback via a form, which is the role of Power Apps. Option C is wrong because Power BI is a business analytics and visualization tool, not a form or data-entry application.

Practice this question →

22

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

Security roles with RLS can restrict data per user/region.

Why this answer

Dataverse security roles can be configured with row-level security to restrict data access by region. This is a native capability of Dataverse.

Practice this question →

23

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

Power BI excels at creating interactive dashboards.

Why this answer

Option A is correct because Power BI's core value is transforming raw data into interactive, visual dashboards that allow users to explore trends, drill down into details, and share insights across the organization. This capability directly supports business analytics by making data accessible and actionable without requiring technical expertise.

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.

Practice this question →

24

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 extracts data, Power Automate processes workflow, Dataverse stores data.

Why this answer

Option B is correct because 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.

Practice this question →

25

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

This is a primary benefit.

Why this answer

Option A is correct because Microsoft Power Platform provides low-code/no-code tools like Power Apps, Power Automate, and Power BI that allow citizen developers—users without formal programming training—to build applications, automate workflows, and create data visualizations using drag-and-drop interfaces and simple logic. This democratizes solution creation by reducing the technical barrier to entry.

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.

Practice this question →

26

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

Email send is not a synchronous approval; need an approval action.

Why this answer

Option B is correct because 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.

Practice this question →

27

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

CMK encrypts data at rest with a key the organization controls.

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.

Practice this question →

28

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 allows non-developers to build custom apps with low-code.

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.

Practice this question →

29

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 automatically updates the dataset from SharePoint Excel files.

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.

Practice this question →

30

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 can automate email sending based on triggers.

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.

Practice this question →

31

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

Power Apps enables low-code app creation.

Why this answer

Power Platform includes low-code app development (Power Apps), workflow automation (Power Automate), and data analytics (Power BI). Custom AI model training is via AI Builder, not a separate component, and it does not replace all coding.

Practice this question →

32

MCQhard

Your organization uses Microsoft Power Platform to manage customer support tickets. The current process: when a ticket is created in Dataverse, a Power Automate flow sends an email to the support team. The team then updates the ticket status manually in a Power Apps canvas app. However, the team often forgets to update the status, leading to delayed responses. The manager wants an automated solution that sends a reminder if the status is not changed within 24 hours. Additionally, if the status is not changed within 48 hours, the ticket should be escalated to the manager. You need to design a solution using Power Automate and Power Apps. Which approach should you take?

A.Modify the Power Apps app to include a reminder notification using the notify function after 24 hours.

B.Create two scheduled Power Automate flows: one runs daily to check tickets older than 24 hours and send reminder; another runs daily to check tickets older than 48 hours and escalate.

C.Create one Power Automate flow with a recurrence trigger every hour. Check tickets older than 24 hours and send reminder; if also older than 48 hours, escalate. Add condition to avoid duplicate actions.

D.Create a single Power Automate flow triggered when a ticket is created. Add a 24-hour delay then check status; if not updated, send reminder and wait another 24 hours then escalate.

AnswerB

Scheduled flows can check conditions and perform actions on multiple tickets.

Why this answer

Option C is correct. Using two separate scheduled flows allows checking at specific intervals and performing actions based on conditions. Option A is wrong because a single trigger flow would run once, not repeatedly.

Option B is wrong because Power Apps reminders require user action. Option D is wrong because a single flow with a delay would only run once, not multiple times.

Practice this question →

33

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

Option A is correct because 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.

Practice this question →

34

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 can analyze sentiment in text.

Why this answer

Option A is correct because AI Builder includes a prebuilt sentiment analysis model that analyzes text and returns sentiment scores (positive, negative, neutral, or mixed) using natural language processing (NLP). This capability allows Power Apps and Power Automate to assess customer feedback, social media posts, or survey responses without requiring custom machine learning expertise.

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.

Practice this question →

35

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

Option B is correct because 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.

Practice this question →

36

MCQmedium

A retail company uses Power Apps to manage inventory. The app allows store managers to scan barcodes and update stock levels in real time. The company wants to extend this capability to suppliers so they can view stock levels but not modify them. Which Power Platform component should be used to create the supplier-facing interface?

A.Power Apps portals

B.Power BI dashboard

C.Canvas app

D.Power Automate

AnswerA

Power Apps portals enable external users to interact with data through a secure website.

Why this answer

Power Apps portals (now part of Power Pages) allow external users, such as suppliers, to access data through a low-code, authenticated website without requiring a Power Apps license or internal network access. This enables suppliers to view stock levels via a browser-based interface while preventing any modification, as permissions can be set to read-only. Canvas apps, by contrast, are designed for internal users and require a license or guest access in Azure AD, making portals the correct choice for external, unauthenticated or lightly authenticated scenarios.

Exam trap

The trap here is that candidates confuse a canvas app’s ability to share with external users (via guest access) with a purpose-built external-facing portal, forgetting that canvas apps require licensing and are not designed for anonymous or lightly authenticated external access without complex Azure AD setup.

How to eliminate wrong answers

Option B is wrong because a Power BI dashboard is a visualization and analytics tool, not an interactive interface for external users to view and query live stock data; it cannot provide per-user read-only data entry or form-based views. Option C is wrong because a canvas app requires each external user to have a Power Apps license (or be added as a guest in Azure AD with appropriate licensing), and it is typically run on a mobile device or within the same tenant, not as a publicly accessible website. Option D is wrong because Power Automate is an automation workflow engine, not a user-facing interface; it cannot present a UI for suppliers to browse stock levels.

Practice this question →

37

Matchingmedium

Match each Microsoft Dataverse security concept to its definition.

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

Concepts

Matches

Set of privileges assigned to users

Permission to perform an action on a table

Group sharing access without owning records

Group that owns records and can share them

Logical grouping of users and data

Why these pairings

Security in Dataverse is role-based.

Practice this question →

38

MCQmedium

A company wants to build a custom app to track inventory across multiple warehouses. The app must use existing data from a SQL Server database and provide real-time updates. Which Power Platform component should they use to connect the app to the data source?

A.Power Apps with a connector

B.Microsoft Dataverse

C.Power BI

D.Power Automate

AnswerA

Power Apps uses connectors to connect to various data sources including SQL Server.

Why this answer

Option A is correct because Power Apps connectors provide pre-built integration with SQL Server, enabling the app to read and write data directly from the existing database. This allows real-time updates by using the SQL Server connector, which supports live queries and triggers without requiring data migration.

Exam trap

The trap here is that candidates often confuse Dataverse as the only data source for Power Apps, but connectors allow direct integration with existing SQL Server databases without migration.

How to eliminate wrong answers

Option B is wrong because Microsoft Dataverse is a cloud-based data platform that would require importing or replicating the SQL Server data, not directly connecting to the existing database. Option C is wrong because Power BI is an analytics and visualization tool, not an app-building platform, and it cannot serve as the data source for a custom app. Option D is wrong because Power Automate is an automation workflow tool that can trigger actions but cannot itself host or connect an app to a data source for real-time updates.

Practice this question →

39

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 can trigger on Dataverse record creation and perform actions like sending emails.

Why this answer

Option A is correct because Power Automate can trigger on record creation and send emails. Option B is wrong because Power Apps is for building apps. Option C is wrong because Power BI is for analytics.

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

Practice this question →

40

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

Correct: it calculates the sum for the year before the selected one.

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.

Practice this question →

41

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 app, Power Automate sends reminders, Power BI creates the dashboard.

Why this answer

Option D is correct because 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.

Practice this question →

42

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 can trigger on opportunity status change and send email via connector.

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.

Practice this question →

43

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 can automate sending donation receipts and update donor records.

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.

Practice this question →

44

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 provides interactive dashboards and reports for data analysis.

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.

Practice this question →

45

Multi-Selecthard

Which THREE are benefits of using Dataverse as the data platform for Power Platform solutions?

Select 3 answers

A.Full relational database capabilities with T-SQL support

B.Built-in role-based security and auditing

C.Supports AI Builder models directly

D.Free unlimited storage for all data types

E.Integration with Dynamics 365 applications

AnswersB, C, E

Dataverse includes role-based security and auditing out-of-the-box.

Why this answer

Option B is correct because Dataverse provides built-in role-based security that allows administrators to control access at the row, field, and table levels using security roles, and it includes automatic auditing to track data changes. This is a core benefit for enterprise compliance and data governance within Power Platform solutions.

Exam trap

The trap here is that candidates may confuse Dataverse's relational capabilities with full SQL Server functionality, or assume that Microsoft offers unlimited storage as a platform benefit, when in reality storage is a licensed, metered resource.

Practice this question →

46

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

Power Automate can process existing records and apply the rule logic.

Why this answer

Option C is correct because 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.

Practice this question →

47

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 assigns text to predefined categories like 'AppFeedback'.

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.

Practice this question →

48

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

Column name mismatch causes LookUp to return blank.

Why this answer

Option D is correct because 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.

Practice this question →

49

MCQeasy

A university wants to create a system for students to register for extracurricular activities. The system should allow students to view available activities, sign up, and receive confirmation emails. Staff should be able to manage activities and view attendance reports. The university has Power Platform licenses but limited IT resources. Which solution should they implement?

A.AI Builder and Power Automate to process registrations

B.Power Automate for everything, with SharePoint lists for data storage

C.Power Apps (model-driven) for staff, Power Apps (canvas) for students, Power Automate for emails, and Power BI for reports

D.Power Pages for students, Power Automate for emails, and Power BI for reports

AnswerC

This combination covers all requirements with low-code tools.

Why this answer

Power Apps (model-driven) can be used by staff to manage activities, and a canvas app (or portal) can be used by students. Power Automate sends confirmation emails. Power BI can generate attendance reports.

Option B is incorrect because Power Pages is an alternative but more complex. Option C is incomplete without Power Apps. Option D is incorrect because AI Builder is not needed.

Practice this question →

50

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 map user input to topics.

Why this answer

Trigger phrases are the phrases that activate a specific topic in a Copilot Studio bot.

Practice this question →

51

MCQeasy

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

A.Power BI

B.Power Apps

C.Power Automate

D.Power Virtual Agents

AnswerC

Power Automate enables automated workflows between apps and services, like sending emails on lead creation.

Why this answer

Power Automate is the correct component because it is designed to create automated workflows that trigger actions based on events, such as sending follow-up emails when a lead is created in Dynamics 365 Sales. It integrates directly with Dynamics 365 via connectors, allowing you to define a trigger (e.g., 'When a lead is created') and an action (e.g., 'Send an email') without custom code.

Exam trap

The trap here is that candidates may confuse Power Automate with Power Apps, thinking that building a custom app is required to send automated emails, when in fact Power Automate handles event-driven automation without any user interface.

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 email workflows. Option B is wrong because Power Apps is a low-code platform for building custom applications, not for creating automated email sequences triggered by data events. Option D is wrong because Power Virtual Agents is used to build conversational chatbots, not to automate backend email processes.

Practice this question →

52

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.

Practice this question →

53

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 and staged imports are the standard ALM practice.

Why this answer

Option B is correct because 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.

Practice this question →

54

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

Delegation filters are processed server-side, reducing data load.

Why this answer

Option B is correct because 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.

Practice this question →

55

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 can automate the reorder process when called from Power Apps.

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.

Practice this question →

56

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 automates workflows like sending emails.

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.

Practice this question →

57

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

Portal users need specific entity permissions to read records; by default, they may not have access.

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.

Practice this question →

58

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 prevent unauthorized data sharing.

Why this answer

Option B is correct because Data Loss Prevention (DLP) policies are a core governance feature in Power Platform that allow administrators to classify connectors as Business or Non-Business, preventing data from flowing between prohibited groups. This protects sensitive data from being inadvertently shared across services like SharePoint and third-party APIs, which is essential for enterprise compliance and security.

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.

Practice this question →

59

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 allows creating chatbots without coding.

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.

Practice this question →

60

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

Security roles define user permissions at the table and record level in Dataverse.

Why this answer

Dataverse security roles control access to tables and records. Column-level security can be used for sensitive fields. Power Platform admin center manages environments but not fine-grained data access.

SharePoint permissions are irrelevant.

Practice this question →

61

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 low-code chatbot builder.

Why this answer

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

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

Practice this question →

62

MCQhard

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

A.Data Loss Prevention (DLP) policies

B.Customer-managed encryption key (CMK) and Audit logging

C.Power Apps business rules

D.Microsoft Entra ID Conditional Access policies

AnswerB

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

63

MCQeasy

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

A.Power Automate

B.Power Apps

C.Power Virtual Agents

D.Power BI

AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

64

MCQhard

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

A.Microsoft Dataverse

B.Office 365 Users

C.SQL Server

D.SharePoint

AnswerA

The connection ID 'shared_commondataservice' corresponds to Dataverse.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

65

Multi-Selecteasy

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

Select 2 answers

A.It can only be used with Microsoft 365 data.

B.It requires professional developers to write all code.

C.It provides integration with Microsoft 365 and Azure services.

D.It is primarily a data analytics tool.

E.It enables citizen developers to create apps and automate workflows without extensive coding.

AnswersC, E

Power Platform integrates deeply with Microsoft ecosystem.

Why this answer

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

Exam trap

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

Practice this question →

66

MCQeasy

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

A.Microsoft Lists

B.Power Automate

C.Power BI

D.Power Virtual Agents

AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

67

MCQeasy

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

A.Power Apps

B.Power Virtual Agents

C.Power Automate

D.Power BI

AnswerA

Power Apps allows building custom mobile apps with low code.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

68

MCQhard

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

A.The flow is configured to trigger on file creation in the root of the document library, not the 'Pending' folder

B.The condition expression is incorrect, causing the flow to fail silently

C.The flow uses a 'When a file is created' trigger, but the file is being modified, not created

D.The flow requires a Power Automate per user plan

AnswerA

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

69

MCQeasy

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

A.Power BI

B.Power Apps

C.Power Virtual Agents

D.Power Automate

AnswerD

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

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Practice this question →

70

Multi-Selectmedium

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

Select 3 answers

A.Power BI

B.Power Virtual Agents

C.Microsoft 365

D.Power Apps

E.Power Automate

AnswersA, D, E

Core component for analytics.

Why this answer

Power BI is a core component of Microsoft Power Platform because it provides data visualization and business intelligence capabilities, enabling users to create interactive reports and dashboards from various data sources. It integrates seamlessly with Power Apps and Power Automate to embed analytics into custom applications and automate data-driven workflows.

Exam trap

The trap here is that candidates often confuse Microsoft 365 (a separate suite) as part of Power Platform, or mistakenly include Power Virtual Agents as a core component when it is actually an AI builder tool, not one of the four foundational pillars.

Practice this question →

71

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

RLS restricts data access per user or role.

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.

Practice this question →

72

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 is the correct tool for automating approval workflows.

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

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

Practice this question →

73

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 creates chatbots with minimal code.

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.

Practice this question →

74

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 a core component for automation.

Why this answer

Power Automate is a core component of Microsoft Power Platform because it provides low-code workflow automation capabilities that integrate seamlessly with other Power Platform services like Power Apps and Power BI. It enables users to create automated workflows across hundreds of connectors without writing code, directly supporting the platform's goal of empowering citizen developers.

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.

Practice this question →

75

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 allow integration with many Microsoft services.

Why this answer

Option A is correct because Microsoft Power Platform is designed with native connectors and deep integration with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL). This allows business users to automate workflows and build apps that directly leverage existing Microsoft cloud investments without custom coding or third-party middleware.

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.

Practice this question →

Page 1 of 3 · 179 questions totalNext →

Ready to test yourself?

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

Start 20-question session