Courseiva

Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 451–525

976 questions total · 14pages · All types, answers revealed

Take a mock examExam hub
Page 6

Page 7 of 14

Page 8
451
MCQeasy

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

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

Power Pages allows anonymous external access, model-driven app for staff, Dataverse for data, Power Automate for notifications.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
452
MCQeasy

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

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

Power Automate automates workflows.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
453
Matchingmedium

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

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

Concepts
Matches

Logical structure that stores data

Field that holds a specific type of data

Individual record in a table

Link between tables

Container for apps, flows, and data

Why these pairings

These are fundamental Dataverse concepts.

Full explanation →
454
MCQmedium

You are creating a canvas app for expense reporting. The app must allow managers to approve or reject expenses using a dropdown. Which control should you use for the approval action?

A.Radio button
B.Dropdown
C.Text input
D.Slider
AnswerB

Dropdown works well for a short list of options.

Why this answer

Option B is correct because a dropdown is ideal for selecting from a short list. Option A is wrong because radio buttons are better for 2-3 options. Option C is wrong because text input is for free text.

Option D is wrong because slider is for numeric ranges.

Full explanation →
455
MCQmedium

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

A.Business rule
B.Form scripting
C.Workflow process
D.Power Automate flow
AnswerA

Business rules can conditionally show fields.

Why this answer

Option D is correct because business rules can show/hide fields based on conditions without code. Option A is wrong because form scripts require JavaScript. Option B is wrong because workflows are for backend processes.

Option C is wrong because Power Automate flows are for automation, not form behavior.

Full explanation →
456
MCQhard

A healthcare organization is developing a Power Apps model-driven app for patient case management. The app uses Microsoft Dataverse as the data source and includes a custom table named 'Patient Cases' with columns: Patient Name, Case Type (choice: Consultation, Procedure, Follow-up), Assigned Doctor, Status (choice: New, In Progress, Completed), and Priority (choice: Low, Medium, High, Critical). The organization requires that when a case is created with Priority = 'Critical', an immediate notification must be sent to the Assigned Doctor via Microsoft Teams and the case must be automatically escalated to the manager if not resolved within 4 hours. Additionally, the app must use a Copilot to summarize patient history when a case is opened. The security team mandates that only doctors and managers can view cases assigned to them, and that all data access must be audited. Which combination of features should you implement to meet all requirements with minimal custom development?

A.Implement JavaScript in the form to call Power Automate for notifications, use owner teams to restrict access, add a custom Copilot page, and enable auditing via Power Apps settings.
B.Use a Dataverse business process flow to trigger Power Automate flows for notifications and escalation, configure field-level security profiles to restrict data access, enable Copilot in the model-driven app to summarize patient history, and enable audit logging on the Patient Cases table.
C.Design a Power Automate flow triggered on case creation that sends Teams notifications and waits for 4 hours before escalation, use sharing permissions to control access, and embed a Copilot AI Builder component.
D.Create business rules to send email notifications and set escalation timers, use role-based security for data access, add a Copilot chat control, and rely on Dataverse default auditing.
AnswerB

All requirements are met with minimal custom development.

Why this answer

Option A is correct because it uses out-of-the-box Dataverse business process flows to trigger Power Automate for notifications and escalation, field-level security for data access, Copilot configured in the model-driven app for summarization, and audit logging enabled in Dataverse. Option B fails because business rules cannot trigger notifications or escalations. Option C uses client-side scripting which is more custom development and less maintainable.

Option D uses Power Automate for everything but misses Copilot integration and audit logging.

Full explanation →
457
MCQhard

A company uses Power Platform with Microsoft Dataverse. The administrator notices that a user can create a new environment without approval. The company wants to enforce a process where all environment creation requires administrator approval. What should the administrator configure?

A.Configure a Data Loss Prevention (DLP) policy
B.Disable the 'Create personal productivity environments' setting in the Power Platform admin center
C.Set a conditional access policy in Microsoft Entra ID
D.Reduce the tenant-level environment capacity limits
AnswerB

Disabling this setting prevents users from creating environments without administrator action.

Why this answer

Option D is correct because disabling the 'Create personal productivity environments' setting in the Power Platform admin center prevents users from creating environments, requiring them to request administrator creation. Option A is wrong because environment capacity limits do not require approval for creation. Option B is wrong because DLP policies do not control environment creation.

Option C is wrong because Microsoft Entra ID conditional access policies control authentication, not environment creation.

Full explanation →
458
MCQmedium

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

A.The display-name-key is missing a translation
B.The version number is incorrect
C.The control requires a dataset property but only a text property is defined
D.The namespace is misspelled
AnswerC

Correct: The control expects data but no dataset property is configured.

Why this answer

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

Full explanation →
459
MCQmedium

A Power Pages site allows external vendors to register and submit invoices. The site uses Microsoft Entra ID for authentication. Recently, some vendors reported they cannot log in and receive an error about insufficient permissions. What is the most likely cause?

A.The identity provider for the site is not configured.
B.The vendors have not been invited as guest users in the Microsoft Entra ID tenant.
C.The site's cookie settings block third-party authentication.
D.The vendors do not have a Power Pages license.
AnswerB

Guest users must be added to the tenant to authenticate.

Why this answer

Option B is correct because when using Microsoft Entra ID, the vendor must be invited as a guest user in the tenant, and if not, they will get an access error. Option A is wrong because the issue is about authentication, not licensing. Option C is wrong because cookies are not the primary issue.

Option D is wrong because the identity provider is configured.

Full explanation →
460
Multi-Selectmedium

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

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

AI Builder can recognize text using OCR.

Why this answer

Option A is correct because AI Builder includes a prebuilt model for text recognition (OCR) that can extract printed and handwritten text from images and PDFs. This capability is part of the AI Builder category of prebuilt models, which are ready to use without requiring custom training.

Exam trap

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

Full explanation →
461
MCQmedium

Refer to the exhibit. A Power BI developer imported the JSON data into a Power BI data model. When creating a report, they notice that the 'Sales' table does not display the product name. What is the most likely cause?

A.No relationship is defined between the tables.
B.The Sales table and Product table are from different data sources.
C.The 'ProductName' column is missing from the Product table.
D.The relationship between Sales and Product tables is not active or is misconfigured.
AnswerD

The relationship must be active and correctly set to retrieve related product names.

Why this answer

Option D is correct because the most likely cause is that the relationship between the Sales and Product tables is either inactive or misconfigured. In Power BI, even when a relationship exists, if it is set to inactive (e.g., using a bidirectional filter or a different cardinality), the report will not automatically propagate the ProductName from the Product table to the Sales table. This prevents the product name from displaying in the report, even though the data is present in the model.

Exam trap

The trap here is that candidates often assume any defined relationship automatically works for all visuals, but Power BI requires the relationship to be active (solid line) for implicit measures and visual filters to propagate correctly, and inactive relationships are a common source of missing data in reports.

How to eliminate wrong answers

Option A is wrong because if no relationship were defined, Power BI would not allow any cross-filtering between tables, but the question states the Sales table exists and the issue is specifically with the product name not displaying, implying a relationship likely exists but is not functioning correctly. Option B is wrong because Power BI can combine data from different sources (e.g., SQL Server and Excel) into a single data model without issue, as long as relationships are properly defined; the source origin does not inherently prevent a column from displaying. Option C is wrong because if the ProductName column were missing from the Product table, the column would not appear in the field list at all, but the question implies the column exists (the developer expects it to display), so the problem is with the relationship, not the column's existence.

Full explanation →
462
MCQmedium

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

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

Power Pages handles external submissions, Dataverse provides audit and security, Power Automate manages approvals.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
463
MCQeasy

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

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

Copilot Studio enables building no-code chatbots.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
464
Multi-Selecthard

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

Select 3 answers
A.They require custom formulas for business logic
B.They have built-in role-based security
C.They are built on top of Microsoft Dataverse
D.They are responsive and work on multiple devices
E.They can only be used on web browsers
AnswersB, C, D

Security is enforced through Dataverse roles.

Why this answer

Options A, C, and E are correct. Model-driven apps are responsive, built on Dataverse, and use role-based security. Option B is incorrect because they do not support custom formulas like Canvas apps.

Option D is incorrect because they are available for web and mobile (not just web).

Full explanation →
465
MCQmedium

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

A.Hierarchy
B.Drill-through
C.Bookmarks
D.Slicers
AnswerA

Hierarchy allows users to drill down from year to quarter to month in a visual.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
466
MCQeasy

A Power Automate flow sends an approval request to a user's manager. The flow uses the 'Get manager' action from the Office 365 Users connector. The flow runs successfully but the approval is never received by the manager. What is the most likely reason?

A.The Office 365 Users connector is not properly configured.
B.The approval action is configured to use the Teams channel instead of email.
C.The manager does not have a valid email mailbox.
D.The manager's user profile is missing in Microsoft Entra ID.
AnswerC

Approval emails require a valid mailbox.

Why this answer

Option B is correct because the 'Get manager' action returns the manager's email address, but if the manager's mailbox is not enabled (e.g., a distribution group or shared mailbox), the approval email will not be delivered. Option A is wrong because the flow succeeds so the manager is found. Option C is wrong because approvals are sent via email.

Option D is wrong because the flow uses the correct connector.

Full explanation →
467
MCQhard

You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

A.Configure field-level security to hide the Doctor field.
B.Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.
C.Create a team with all doctors and share the app with the team.
D.Use hierarchy security to limit access based on the Doctor field.
AnswerB

Record-level security can restrict access to records where the user is the owner or a related user.

Why this answer

Option D is correct because record-level security can be configured to restrict access to records where the doctor is the owner or related user. Option A: Sharing the app does not restrict data visibility. Option B: Field-level security hides fields but does not filter records.

Option C: Hierarchy security is for manager-subordinate relationships, not for this scenario.

Full explanation →
468
MCQhard

Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?

A.Configure duplicate detection rules in Dataverse and use the 'Create a new record' action with duplicate detection enabled.
B.Use the 'Compose' action to check for duplicates before creation.
C.Use the 'Update a record' action instead of 'Create a new record' to update existing records.
D.Use the 'Delete a record' action before creating a new one.
AnswerA

This prevents creation of duplicates.

Why this answer

Option A is correct because configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because using 'Update a record' requires an existing record. Option C is wrong because 'Delete a record' is not relevant.

Option D is wrong because the 'Compose' action does not create records.

Full explanation →
469
MCQeasy

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

A.Create a canvas app from the Excel file
B.Use Power Pages to display the Excel file
C.Create a model-driven app using Dataverse
D.Use Power Automate to create a mobile app
AnswerA

Correct: Canvas apps can use Excel as a data source.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
470
MCQhard

A Power Automate flow uses the 'Parse JSON' action to process incoming webhook data. The flow fails with the error 'Invalid JSON' when the webhook sends data. You review the sample payload used to generate the schema and notice the webhook sometimes includes additional optional fields. What is the most likely cause?

A.The generated schema does not account for all possible fields.
B.The flow is trying to parse the JSON before receiving it.
C.The webhook is not sending a valid JSON payload.
D.The JSON contains a nested object that is not defined.
AnswerA

Extra fields cause schema mismatch.

Why this answer

Option B is correct because the 'Parse JSON' action uses a schema generated from a sample payload. If the schema does not include optional fields, the action will fail when those fields are present. Option A is wrong because the webhook is sending data.

Option C is wrong because the flow action is to parse, not to create. Option D is wrong because the error is 'Invalid JSON' not a missing property.

Full explanation →
471
MCQmedium

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

A.The dropdown's AllowEmptySelection property is set to false
B.The data source requires a refresh after clearing selection
C.The gallery's Items property uses a filter that references Dropdown.Selected.Value, and when the dropdown is cleared, the filter returns blank
D.The app's OnStart property is clearing the data source
AnswerC

When no selection, Dropdown.Selected.Value is blank, filter returns no items

Why this answer

Option A is correct because if the filter uses Dropdown.Selected.Value, when nothing is selected the value is blank, causing the filter to fail. Option B is wrong because the dropdown is not required to be cleared; the issue is the filter. Option C is wrong because performance is not the issue.

Option D is wrong because the data source is likely fine.

Full explanation →
472
MCQhard

Refer to the exhibit. The JSON shows a table permission configuration for a Dataverse table in Power Pages. A user who is authenticated but not assigned to any custom web role visits the site. What operations can this user perform on the table?

A.No operations; the user must be in a custom web role.
B.Only Read
C.Create, Read, and Update
D.Create and Read only
AnswerC

All three operations are allowed for Authenticated Users.

Why this answer

The 'Authenticated Users' web role is granted to all authenticated users by default, so the user has Create, Read, and Update permissions.

Full explanation →
473
MCQmedium

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

A.Append Queries
B.Merge Queries
C.Pivot Column
D.Group By
AnswerB

Merge Queries joins tables based on a common column, similar to SQL JOIN.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
474
Multi-Selectmedium

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

Select 3 answers
A.Create measures
B.Change data types
C.Merge queries
D.Remove columns
E.Create relationships between tables
AnswersB, C, D

Power Query Editor allows changing data types.

Why this answer

Option B is correct because the Power Query Editor is specifically designed for data transformation and cleaning tasks. Changing data types (e.g., from text to number) is a fundamental transformation that ensures data is correctly formatted for analysis in Power BI.

Exam trap

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

Full explanation →
475
Multi-Selecthard

Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?

Select 2 answers
A.Power BI
B.AI Builder
C.Power Apps
D.Power Automate
E.Power Pages
AnswersC, D

Power Apps allows you to create custom apps with low-code.

Why this answer

Power Apps is a low-code platform that enables users to build custom business applications through a visual drag-and-drop interface, connecting to various data sources without writing traditional code. It directly addresses the requirement of creating and deploying custom business applications without coding.

Exam trap

The trap here is that candidates may confuse Power Automate (a workflow automation tool) with an application development platform, but Power Automate is used for automating processes and flows, not for building the application interface itself.

Full explanation →
476
MCQhard

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

A.Line chart with date hierarchy and revenue, adding year-over-year trend line
B.Matrix visual with years as columns, quarters as rows, and a measure for YoY growth
C.Stacked bar chart with quarters on axis and revenue as values, using year as legend
D.Scatter plot with revenue on both axes and date as detail
AnswerB

Matrix allows side-by-side comparison and custom measures.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
477
MCQeasy

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

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

Power Pages is designed for secure external websites.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
478
MCQmedium

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

A.Create a Conditional Access policy in Microsoft Entra ID that requires MFA for the portal application
B.Enable MFA for all Microsoft Entra ID users
C.Use a third-party identity provider that supports MFA
D.Configure MFA in the Power Apps portal authentication settings
AnswerA

This allows granular MFA enforcement for the portal app without affecting other apps.

Why this answer

Option B is correct because MFA can be enforced via a Conditional Access policy targeting the portal application. Option A is wrong because turning on MFA for all Entra ID users would affect internal users. Option C is wrong because portal authentication settings do not include MFA enforcement.

Option D is wrong because MFA enforcement at the identity provider level is not granular for the portal only.

Full explanation →
479
MCQeasy

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

A.When a new response is submitted
B.When a response is viewed
C.When a response is edited
D.When a response is modified
AnswerA

This trigger fires immediately upon submission.

Why this answer

The 'When a new response is submitted' trigger for Microsoft Forms is the correct trigger. Option B is for when a response is modified. Option C is for viewing responses.

Option D is for editing responses.

Full explanation →
480
MCQmedium

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

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

Power Automate can trigger on SharePoint events and send emails.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
481
MCQeasy

A company wants to build a Power Apps app that can be used offline by field workers. Which type of app should they choose?

A.Canvas app
B.Copilot Studio
C.Power Pages
D.Model-driven app
AnswerA

Correct: Canvas apps can be enabled for offline use.

Why this answer

Option A is correct because Canvas apps support offline use through the Offline feature. Option B is wrong because model-driven apps do not support offline. Option C is wrong because Copilot Studio is for copilots.

Option D is wrong because Power Pages are websites and do not support offline.

Full explanation →
482
Multi-Selectmedium

Which TWO Power Apps features allow you to integrate AI capabilities into your app? (Choose two.)

Select 2 answers
A.Power Virtual Agents
B.Power Automate
C.Common Data Model
D.Copilot integration
E.AI Builder
AnswersD, E

Copilot can be integrated into Power Apps to provide AI-powered assistance.

Why this answer

Options A and D are correct because AI Builder allows you to add AI models to Power Apps, and Copilot integration allows you to embed AI-powered copilots. Options B and C are incorrect because Power Automate is a separate product and Power Virtual Agents is a separate product for chatbots. Option E is incorrect because the Common Data Model is a data schema, not an AI feature.

Full explanation →
483
MCQhard

Refer to the exhibit. A Power Automate flow is defined with a manual trigger expecting an email property. When the flow is run, it fails with an error that the email address cannot be empty. What is the most likely cause?

A.The email subject is not provided.
B.The trigger schema is invalid because it requires a property.
C.The trigger body does not include the 'email' property when invoked.
D.The Send_an_email action is missing the 'To' parameter.
AnswerC

If email is missing, the expression returns null.

Why this answer

Option C is correct because the trigger schema defines 'email' as required, but the Send_an_email action uses an expression that may resolve to null if the trigger body does not contain the email. Option A is wrong because the schema is valid. Option B is wrong because the action is correctly configured.

Option D is wrong because the subject is not the issue.

Full explanation →
484
MCQeasy

Refer to the exhibit. A Power BI developer creates a DAX measure named 'SalesByRegion' as shown. The measure does not appear in the field list. What is the most likely issue?

A.The expression creates a table, not a scalar measure.
B.The 'Sales' table does not exist.
C.The SUMMARIZE function syntax is incorrect.
D.The measure name must be enclosed in single quotes.
AnswerA

Measures must return a single scalar value; SUMMARIZE returns a table.

Why this answer

Option A is correct because DAX measures must return a single scalar value (e.g., a number, date, or string) to appear in the Fields list of a Power BI report. The SUMMARIZE function returns a table with rows and columns, not a scalar, so Power BI treats it as a table expression and does not display it as a measure. Measures that return tables can only be used in other DAX expressions or as calculated tables, not directly in visuals.

Exam trap

The trap here is that candidates often assume any valid DAX expression will automatically appear as a measure, overlooking the critical distinction between scalar and table-returning functions in Power BI.

How to eliminate wrong answers

Option B is wrong because if the 'Sales' table did not exist, the measure would produce a syntax error when validated, not simply fail to appear in the field list. Option C is wrong because the SUMMARIZE function syntax in the exhibit is correct (it groups by 'Region' and creates a 'TotalSales' column), so the issue is not syntax but the return type. Option D is wrong because measure names in DAX do not require single quotes unless they contain spaces or special characters; 'SalesByRegion' has no such characters, so quotes are unnecessary.

Full explanation →
485
Multi-Selecteasy

Which TWO are valid Power BI visualization types?

Select 2 answers
A.Waterfall chart
B.Gantt chart
C.Scatter map
D.Funnel chart
E.Treemap
AnswersD, E

Funnel chart is a standard visual for stages.

Why this answer

Option D (Funnel chart) is a valid Power BI visualization type used to represent stages in a linear process, such as sales pipelines or conversion funnels, where each stage's value decreases progressively. Power BI includes Funnel charts as a built-in visualization in its standard visualizations gallery, making it a correct answer.

Exam trap

The trap here is that candidates often confuse 'Scatter map' with 'Scatter chart' or 'Map' visuals, or assume Gantt charts are native because they are common in project management, but Power BI does not include them as default visualizations.

Full explanation →
486
MCQmedium

A company uses Power Apps to build a leave request app. Managers must approve requests only if the employee has sufficient leave balance. Which approach ensures the balance is checked before submission?

A.Create a Power BI report to visualize leave balances and have managers manually check
B.Use the SubmitForm function with a validation formula checking leave balance
C.Configure a Power Automate flow to check balance after submission and auto-reject if insufficient
D.Set a foreign key constraint in Dataverse to limit leave requests based on balance
AnswerB

Correct: Validation can be done in the app before submission.

Why this answer

Option A is correct because Power Apps allows validation logic in the SubmitForm function to check conditions before data is submitted. Option B is wrong because Power Automate can check after submission but not prevent it. Option C is wrong because Power BI is for analytics, not validation.

Option D is wrong because Canvas apps do not enforce foreign keys.

Full explanation →
487
MCQeasy

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

A.Enable solution component isolation
B.Configure a Data Loss Prevention (DLP) policy
C.Create an environment security group
D.Turn on auditing for the environment
AnswerB

DLP policies allow administrators to define which connectors can be used together in flows.

Why this answer

Option D is correct because Data Loss Prevention (DLP) policies define which connectors can be used together in the same flow. Option A is wrong because environment security groups control user access, not connector combinations. Option B is wrong because solution component isolation is about solution layers, not connectors.

Option C is wrong because auditing is for tracking changes, not restricting connectors.

Full explanation →
488
MCQhard

A developer is building a Canvas app that uses a custom connector to an external API. The API requires OAuth 2.0 authentication. What must the developer do to set up the connector?

A.Select 'OAuth 2.0' as the authentication type and enter the API key
B.Create the connector with a Swagger file and set authentication to 'Anonymous'
C.Use the built-in HTTP connector with Basic authentication
D.Register an application in Microsoft Entra ID and configure the custom connector with the client ID and secret
AnswerD

OAuth 2.0 requires app registration and credentials.

Why this answer

Option D is correct because custom connectors with OAuth 2.0 require registering the app in Microsoft Entra ID. Option A is not possible. Option B is for custom API, not authentication.

Option C is for API key authentication, not OAuth.

Full explanation →
489
Multi-Selectmedium

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

Select 3 answers
A.Copilot Studio
B.Power Apps
C.Power Automate
D.Power BI
E.AI Builder
AnswersB, C, E

Power Apps can capture and display feedback.

Why this answer

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

Exam trap

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

Full explanation →
490
Multi-Selectmedium

Which TWO of the following are capabilities of Power Automate that help with monitoring and troubleshooting flows?

Select 2 answers
A.The 'When a flow is completed' trigger
B.Automatic email notifications when a flow fails
C.Analytics in the Power Platform admin center
D.Run history for each flow execution
E.The 'Configure run after' setting
AnswersC, D

Analytics provide overview of flow performance and errors.

Why this answer

A and D are correct. Run history provides details of each flow execution, including inputs, outputs, and errors. Analytics in the Power Platform admin center provide insights into flow usage and performance.

Option B is incorrect because email notifications are not a built-in monitoring feature; they can be configured but are not a capability. Option C is incorrect because the 'When a flow is completed' trigger is used to start another flow, not to monitor. Option E is incorrect because the 'Configure run after' setting controls flow behavior on failure, not monitoring.

Full explanation →
491
MCQmedium

You are troubleshooting a Power Pages site that fails to load web templates. The site was created from a starter template. What is the most likely cause?

A.The site requires basic authentication
B.The site settings for web templates are misconfigured
C.The Dataverse environment is not provisioned
D.The site is not bound to a custom domain
AnswerB

Web templates rely on site settings like 'WebTemplate/Enabled'.

Why this answer

Option B is correct because missing site settings or page permissions can prevent web templates from rendering. Option A is wrong because Dataverse tables are not required for web templates. Option C is wrong because Power Pages doesn't require a custom domain.

Option D is wrong because basic authentication is not required.

Full explanation →
492
MCQmedium

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

A.Data policies in Microsoft 365 compliance center
B.Data Loss Prevention (DLP) policy in Power Platform admin center
C.Azure Active Directory Conditional Access
D.Connector sharing settings in Power Apps
AnswerB

DLP policies restrict data sharing between connectors.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
493
MCQeasy

Refer to the exhibit. A Power Platform admin views the capacity of a sandbox environment. Based on the exhibit, which statement is true?

A.The environment is a sandbox and thus has reduced capacity limits.
B.The capacity values are unusually low and may indicate a problem.
C.The environment has production-level capacity.
D.The capacity cannot be increased with add-ons.
AnswerA

Sandbox environments have lower default capacity.

Why this answer

Option C is correct because sandbox environments have reduced capacity compared to production. Option A is wrong because the exhibit does not compare to production; sandbox has lower limits by default. Option B is wrong because capacity values shown are not unusually low; they are typical for sandbox.

Option D is wrong because capacity add-ons can increase sandbox capacity.

Full explanation →
494
MCQmedium

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

A.Use a SharePoint list instead of Dataverse
B.Reduce the number of controls on the form
C.Increase the data row limit in Dataverse
D.Enable offline capability in the app settings
AnswerD

Correct: Offline mode caches data locally and syncs when connected.

Why this answer

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

Full explanation →
495
MCQeasy

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

A.Model-driven app
B.Canvas app
C.Power Automate
D.Power Pages
AnswerA

Correct: Model-driven apps auto-generate UI from the data model.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
496
MCQmedium

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

A.Set the table permission scope to 'Global' and restrict using a view.
B.Set the table permission scope to 'Contact' and assign the permission to the student web role.
C.Create a separate web role for each student.
D.Use a Power Automate flow to filter records.
AnswerB

Contact scope matches the user's contact record.

Why this answer

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

Full explanation →
497
MCQmedium

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

A.The users do not have Power Apps licenses assigned
B.The app uses a deprecated connector
C.The users do not have permissions to the underlying SharePoint list
D.The SharePoint connector requires a Premium license in Teams
AnswerC

In Teams, app users may not have direct SharePoint access; permissions must be granted separately.

Why this answer

Option D is correct because SharePoint permissions are inherited; Team members may be from outside the SharePoint group. Option A is wrong because licenses are per user, not per Teams. Option B is wrong because the app works outside Teams, so the app itself is fine.

Option C is wrong because SharePoint connector does not require premium license.

Full explanation →
498
MCQhard

You are the Power Platform administrator for a large enterprise with multiple departments. The HR department uses a Power Apps canvas app to manage employee onboarding. The app is connected to Dataverse and includes a flow that sends a welcome email via Power Automate. Recently, the IT security team mandated that all Power Platform solutions must use Microsoft Entra ID for authentication and that sensitive data (e.g., social security numbers) must be encrypted at rest. The HR app currently uses Dataverse's default encryption. Additionally, the HR team wants to extend the app to external contractors who do not have Microsoft Entra ID accounts. They need to be able to submit their personal information through a secure web form. You need to design a solution that meets security requirements and allows external access. What should you do?

A.Create a SharePoint list for external contractors to submit data, and use Power Automate to send emails.
B.Enable customer-managed encryption key (CMEK) for Dataverse, and create a Power Pages site with Microsoft Entra External ID authentication for external contractors.
C.Use Power Apps portals with Microsoft Entra ID B2B collaboration for external contractors, and leave encryption as default.
D.Implement a Power Automate flow to collect data via Microsoft Forms, and store results in Dataverse with default encryption.
AnswerB

CMEK meets encryption requirements, and Power Pages with External ID allows secure external access.

Why this answer

Option B is correct because it addresses both security requirements: customer-managed encryption key (CMEK) for Dataverse ensures sensitive data like social security numbers is encrypted at rest with a key controlled by the enterprise, meeting the IT security mandate. Additionally, creating a Power Pages site with Microsoft Entra External ID authentication allows external contractors without Microsoft Entra ID accounts to authenticate via social or email-based identities, enabling secure submission of personal information through a web form while maintaining compliance.

Exam trap

The trap here is that candidates may confuse Microsoft Entra ID B2B collaboration (which requires guest accounts in the tenant) with Microsoft Entra External ID (which supports external identities without requiring Microsoft Entra ID accounts), leading them to select Option C instead of the correct Power Pages solution.

How to eliminate wrong answers

Option A is wrong because a SharePoint list does not support customer-managed encryption keys for sensitive data at rest, and it lacks the granular authentication controls required for external contractors; Power Automate email sending does not address encryption or secure external access. Option C is wrong because Power Apps portals (now Power Pages) with Microsoft Entra ID B2B collaboration requires external contractors to have Microsoft Entra ID accounts or be invited as guest users, which contradicts the requirement that they do not have such accounts; also, leaving encryption as default does not meet the mandate for encrypted at rest with a customer-managed key. Option D is wrong because Microsoft Forms does not provide encryption at rest with customer-managed keys, and storing results in Dataverse with default encryption fails the IT security team's requirement for CMEK; additionally, Forms does not offer the secure authentication and web form capabilities needed for external contractors.

Full explanation →
499
Multi-Selecteasy

Which TWO of the following are types of triggers available in Power Automate? (Choose two.)

Select 2 answers
A.Recurrence triggers
B.Automated triggers
C.Scheduled triggers
D.Instant triggers
E.Manual triggers
AnswersB, C

Correct: These fire based on events like new email.

Why this answer

Options A and D are correct. Automated triggers (event-based) and scheduled triggers (time-based) are the main categories. Option B is wrong because 'Manual' is a trigger type but the stem asks for types of triggers; manual is a subtype.

Option C is wrong because 'Recurrence' is a specific scheduled trigger, not a type. Option E is wrong because 'Instant' is a kind of manual trigger.

Full explanation →
500
MCQhard

You review a failed flow run with the log shown. The flow is supposed to send an email when a SharePoint item is created. What is the most likely issue?

A.The SharePoint trigger did not fire
B.The email connector is not properly configured or the SMTP server is down
C.The scope 'SendNotification' failed due to a missing variable
D.The SharePoint list permissions are incorrect
AnswerB

Correct. The error indicates a connectivity issue with the mail server.

Why this answer

The flow log shows a failure in the 'Send an email' action, not the trigger. Since the trigger (SharePoint 'When an item is created') successfully initiated the flow, the issue lies with the email connector. The most likely cause is that the email connector (e.g., Office 365 Outlook, SMTP) is misconfigured—such as incorrect SMTP server, port, authentication, or the SMTP server being unreachable—preventing the email from being sent.

Exam trap

The trap here is that candidates assume a failed flow run always means the trigger didn't fire, but the log clearly shows the trigger succeeded and the failure is in an action, so the issue is with the downstream connector configuration.

How to eliminate wrong answers

Option A is wrong because the flow log shows the trigger fired (the flow ran), so the SharePoint trigger did fire. Option C is wrong because the scope 'SendNotification' failed due to an email sending error, not a missing variable; a missing variable would cause a different error (e.g., 'variable not found') and the log indicates a connector failure. Option D is wrong because incorrect SharePoint list permissions would prevent the trigger from firing or the flow from reading the item, but the flow ran and reached the email action, so permissions are sufficient.

Full explanation →
501
MCQhard

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

A.Increase the data row limit in the app settings
B.Switch the data source to SharePoint for better delegation support
C.Avoid using delegable functions to reduce complexity
D.Use delegable functions such as Filter and LookUp to retrieve only necessary records before performing updates
AnswerD

Delegable functions process data on server, reducing warnings

Why this answer

Option A is correct because delegable functions like Filter, Search, and LookUp can be used to limit data before aggregation. Option B is wrong because increasing batch size does not address delegation. Option C is wrong because delegable functions reduce warnings.

Option D is wrong because switching to SharePoint may still have delegation issues.

Full explanation →
502
MCQmedium

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

A.Microsoft Copilot Studio
B.Power BI natural language queries
C.Power Automate
D.AI Builder
AnswerD

AI Builder provides prebuilt models for sentiment analysis and key phrase extraction.

Why this answer

AI Builder includes sentiment analysis and key phrase extraction models. Power Automate can orchestrate but needs AI Builder for the AI. Power BI and Copilot Studio are not the primary tools for this custom AI task.

Full explanation →
503
MCQmedium

A Power BI report uses the KQL query shown. What is the purpose of this query?

A.To list all sales transactions for North America
B.To show total sales per product category for North America in descending order
C.To calculate average sales amount by region
D.To filter sales data by product category
AnswerB

The query sums sales by Region and ProductCategory, filters for North America, and orders by total sales descending.

Why this answer

The KQL query uses the `summarize` operator to group sales data by `ProductCategory` and calculate the total sales amount using `sum(SalesAmount)`. The `where` clause filters for `Region == 'North America'`, and `order by` sorts the aggregated results in descending order. This produces a list of product categories with their total sales for North America, sorted from highest to lowest.

Exam trap

The trap here is that candidates may confuse the `sum()` aggregation with listing individual transactions (Option A) or calculating averages (Option C), overlooking the specific combination of `summarize`, `where`, and `order by` that defines the query's purpose.

How to eliminate wrong answers

Option A is wrong because the query does not list individual sales transactions; it aggregates sales into totals per product category. Option C is wrong because the query uses `sum()` to calculate total sales, not `avg()` to calculate average sales amount. Option D is wrong because the query does more than just filter by product category; it also summarizes and orders the data.

Full explanation →
504
MCQhard

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

A.Check the on-premises data gateway performance and logs for errors
B.Replace the DirectQuery connection with an Import connection
C.Ask the database team to add more indexes to the SQL Server tables
D.Increase the scheduled refresh frequency to every 15 minutes
AnswerA

Slow load and data errors often indicate gateway issues.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
505
MCQhard

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

A.The Microsoft.PowerApps resource provider is not registered in the subscription.
B.The environment name parameter contains invalid characters.
C.The environmentSku 'Production' is not a valid SKU.
D.The location parameter is set to an unsupported region.
AnswerA

The resource provider must be registered before deploying Power Platform resources.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
506
Multi-Selectmedium

Which TWO components are included in the Microsoft Power Platform? (Select two.)

Select 2 answers
A.Power Apps
B.Power BI
C.Power Automate
D.Microsoft Entra ID
E.Microsoft 365
AnswersA, C

Power Apps is a core component for building custom apps.

Why this answer

Power Apps is a core component of the Microsoft Power Platform that enables users to build custom low-code/no-code applications for web and mobile. It provides a visual drag-and-drop designer and connects to hundreds of data sources via connectors, allowing rapid creation of business apps without traditional programming.

Exam trap

The trap here is that candidates often confuse Power BI as part of the Power Platform because it is commonly used alongside it, but the official PL-900 exam defines the Power Platform as consisting of Power Apps, Power Automate, Power Virtual Agents, and Power Pages only.

Full explanation →
507
MCQhard

A Power Automate flow fails when it tries to update a row in Dataverse that was modified by another user. The error indicates a 'concurrency conflict'. What is the likely cause and best solution?

A.The flow lacks 'Enable Retry' setting; enable it and implement retry logic
B.The flow uses asynchronous triggers; change to synchronous
C.Increase the flow's timeout duration
D.The Dataverse table has a 'Concurrency' field; set it to 'None'
AnswerA

Enabling retry with logic to handle conflicts allows the flow to succeed after a conflict.

Why this answer

Concurrency conflicts occur when multiple users update the same record simultaneously. The best solution is to implement retry logic. Option A is incorrect because changing to synchronous does not resolve the conflict.

Option B is incorrect because disabling concurrency checking is not possible in Dataverse. Option C is incorrect because increasing timeout does not address the conflict.

Full explanation →
508
Multi-Selecteasy

A manufacturing company is planning to implement Microsoft Power Platform. The environment strategy must support data isolation for sensitive production data while allowing developers to experiment with new features without affecting the production environment. Which two environment types should the company use?

Select 2 answers
A.Default environment
B.Sandbox environment
C.Production environment
D.Developer environment
E.Trial environment
AnswersB, C

Sandbox environments are isolated from production, ideal for development and testing.

Why this answer

A sandbox environment provides a non-production area for development and testing. A production environment hosts the live apps and data. Together they allow development without affecting production.

Full explanation →
509
Multi-Selecteasy

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

Select 2 answers
A.Development
B.Production
C.Sandbox
D.Trial
E.Preview
AnswersB, C

Production is a standard environment type.

Why this answer

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

Exam trap

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

Full explanation →
510
MCQmedium

A Power App is used by a global team. The app displays dates in US format (MM/DD/YYYY), but users in Europe expect DD/MM/YYYY. What is the best way to handle this?

A.Hardcode the date format based on the user's region in the app
B.Do nothing; Power Apps automatically formats dates based on the user's browser locale
C.Use the Language function to set the date format manually
D.Use a text input for dates instead of a date picker
AnswerB

Power Apps uses browser locale to format dates appropriately

Why this answer

Option D is correct because the app should respect the user's locale settings. Option A is wrong because hardcoding a format ignores user locale. Option B is wrong because a single format won't satisfy all.

Option C is wrong because the Language function returns the user's locale, which can be used to format dates dynamically, but the best practice is to let Power Apps handle locale automatically by not overriding format.

Full explanation →
511
MCQmedium

Your company has a Power Automate flow that copies files from SharePoint to OneDrive for Business. Recently, some files have not been copied due to permission errors. You need to ensure the flow runs with the appropriate permissions. What should you do?

A.Change the flow owner to a user with full permissions to both SharePoint and OneDrive.
B.Use a service principal with appropriate permissions and configure the flow to use it.
C.Disable the 'Enhanced mode' in the SharePoint connector.
D.Configure the flow to run using the account of the user who triggers it.
AnswerB

A service principal provides consistent, elevated permissions.

Why this answer

Option D is correct because using a service principal with appropriate permissions ensures consistent access. Option A is wrong because run-only users would inherit limited permissions. Option B is wrong because the owner's permissions may not match the flow's needs.

Option C is wrong because turning off enhanced mode would limit capabilities.

Full explanation →
512
MCQmedium

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

A.Business process flow
B.Desktop flow
C.Scheduled cloud flow
D.Automated cloud flow
AnswerC

Scheduled flows run on a recurring schedule.

Why this answer

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

Business process flows guide users through stages.

Full explanation →
513
MCQhard

A Power Pages site uses a custom Liquid template to display a chart using Chart.js. The chart data is fetched from a Dataverse table using a web API call from JavaScript. The page loads but the chart fails to render. You suspect a cross-origin issue. What is the most likely cause and solution?

A.Upload the Chart.js library as a web file in the portal and reference it locally.
B.Disable Content Security Policy in the portal settings.
C.Configure the web API call to use credentials: 'include'.
D.Use a different JavaScript library that doesn't require external resources.
AnswerA

Hosting the library locally ensures it complies with the portal's CSP.

Why this answer

Power Pages sites impose a Content Security Policy (CSP) that restricts the sources from which scripts and data can be loaded. The external Chart.js library may be loaded from a CDN that is not allowed by the CSP. The solution is to upload the Chart.js library to the portal's web files and reference it locally.

Option A is incorrect because disabling CSP is not recommended. Option B is incorrect because the web API call to Dataverse is same-origin. Option D is incorrect because cookies are not typically the issue.

Full explanation →
514
MCQmedium

A hospital uses a Power Automate flow to send appointment reminders via SMS and email. The flow is triggered when a new appointment is created in the patient management system. The IT department wants to ensure that the flow complies with HIPAA regulations, which require that patient health information (PHI) is encrypted both in transit and at rest. Which Power Automate capability should be enabled?

A.Add a condition to check for PHI data
B.Use the 'Run only for the flow owner' setting
C.Implement a solution-aware flow
D.Create a data loss prevention (DLP) policy that restricts connectors to HIPAA-compliant services
AnswerD

DLP policies can block non-compliant connectors and enforce data encryption requirements.

Why this answer

Option D is correct because data loss prevention (DLP) policies allow admins to control which connectors can share data and enforce encryption requirements. Option A is incorrect because the 'Run only for the flow owner' feature controls authentication, not encryption. Option B is incorrect because solution-aware flows are for lifecycle management, not compliance.

Option C is incorrect because conditions are for branching logic.

Full explanation →
515
MCQeasy

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

A.When an item is created
B.Power Apps button
C.Schedule - Recurrence
D.When a new email arrives
AnswerC

Recurrence trigger allows you to set a schedule.

Why this answer

Option A is correct for scheduled flows. Option B is for manual triggers. Option C and D are event-based triggers.

Full explanation →
516
MCQeasy

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

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

Power Automate automates workflows, such as sending emails on lead creation.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
517
MCQhard

Refer to the exhibit. The JSON snippet represents an ARM template for deploying a Power Apps app. The deployment fails with an error that the environment 'Environment1' does not exist. What is the most likely reason?

A.The app name contains invalid characters.
B.The lifecycleId should be 'Development' instead of 'Production'.
C.The apiVersion is incorrect.
D.The environment ID is not a full ARM resource ID.
AnswerD

Should be like '/subscriptions/.../resourceGroups/.../providers/Microsoft.PowerApps/environments/...'.

Why this answer

Option D is correct because ARM templates require the environment to be specified as a full Azure resource ID (e.g., `/providers/Microsoft.PowerApps/environments/{environmentId}`) to uniquely identify the target environment across tenants and subscriptions. The error 'environment does not exist' indicates that the provided ID is likely a short name or GUID, not the full ARM resource path, so the deployment cannot resolve the environment.

Exam trap

Cisco often tests the misconception that a simple environment name or GUID is sufficient in ARM templates, when in fact the full resource ID is required for cross-resource references.

How to eliminate wrong answers

Option A is wrong because invalid characters in the app name would cause a different error (e.g., 'Invalid resource name'), not an environment existence error. Option B is wrong because the lifecycleId property (Development/Production) is a metadata tag and does not affect environment resolution; the error is about the environment ID, not the lifecycle stage. Option C is wrong because an incorrect apiVersion would produce an 'Unsupported API version' error, not an environment existence error.

Full explanation →
518
MCQeasy

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

A.When a new email arrives
B.When a row is added, modified or deleted in Dataverse
C.When a user is added to Azure AD
D.When a file is created in SharePoint
AnswerC

This trigger activates when a new user is created in Microsoft Entra ID.

Why this answer

Option B is correct because 'When a user is added to Azure AD' (now Microsoft Entra ID) triggers on new user creation. Option A is wrong because it triggers on email, not user creation. Option C is wrong because it triggers on file creation.

Option D is wrong because it triggers on record creation in Dataverse.

Full explanation →
519
Multi-Selecthard

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

Select 3 answers
A.Action
B.Connector
C.Business process flow
D.Power Apps
E.Trigger
AnswersA, B, E

Actions are steps in the flow.

Why this answer

Option A (Trigger), Option C (Action), and Option D (Connector) are core components. Option B is a type of flow, not a component. Option E is a service, not a component.

Full explanation →
520
MCQmedium

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

A.Power Virtual Agents with a topic
B.AI Builder
C.Power BI with natural language queries
D.Power Automate with a custom connector
AnswerB

AI Builder offers text classification and key phrase extraction models.

Why this answer

Option D is correct because AI Builder provides prebuilt AI models for text classification and entity extraction. Option A is wrong because Power BI does not have built-in AI for text analysis. Option B is wrong because Power Automate does not have AI capabilities.

Option C is wrong because Power Virtual Agents is for chatbots.

Full explanation →
521
MCQmedium

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

A.Office 365 Outlook
B.Dataverse
C.Microsoft Teams
D.SharePoint
AnswerC

Teams connector enables approvals within Teams.

Why this answer

The Microsoft Teams connector allows sending approval requests and receiving responses directly within Teams. Office 365 Outlook is for email, SharePoint is for document management, and Dataverse is for data storage.

Full explanation →
522
MCQmedium

A company is using Power Automate flows that connect to multiple third-party services. The security administrator wants to ensure that no sensitive data is sent to unauthorized external services. Which feature should be used to enforce this requirement?

A.Create and apply Data Loss Prevention (DLP) policies.
B.Enable audit logging in the Power Platform admin center.
C.Configure environment routing rules.
D.Use the Power Platform Copilot to monitor flows.
AnswerA

DLP policies can block specific connectors from being used in apps and flows.

Why this answer

Data Loss Prevention (DLP) policies allow blocking or restricting connectors to prevent data leakage. Option A is incorrect because audit logs only record activity, not prevent it. Option B is incorrect because environment routing does not control connectors.

Option D is incorrect because Copilot is an AI assistant, not a security feature.

Full explanation →
523
Multi-Selectmedium

Which TWO of the following are valid data sources for a canvas app?

Select 2 answers
A.Power Pages form
B.SharePoint list
C.Power Virtual Agents topic
D.SQL Server database
E.Power BI dataset
AnswersB, D

Canvas apps can connect to SharePoint lists directly.

Why this answer

Options B and D are correct. SharePoint lists and SQL Server are common data sources. Option A is wrong because Power BI is not a data source; it is a visualization tool.

Option C is wrong because Power Virtual Agents is a chatbot builder. Option E is wrong because Power Pages is a website builder.

Full explanation →
524
MCQmedium

A company uses Power Automate to process incoming emails. Some emails need to be forwarded to a manager, while others need to be saved to SharePoint. The decision is based on the email subject. Which action should be used to implement the branching logic?

A.Switch
B.Condition
C.Compose
D.Select
E.Apply to each
AnswerB

A condition can check the email subject and branch accordingly.

Why this answer

The 'Condition' action allows branching based on expressions. Option A is for iteration. Option B is for switching based on multiple values.

Option C is for data transformation. Option D is not a flow action.

Full explanation →
525
MCQmedium

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

A.Check the scheduled refresh settings in the Power BI dataset.
B.Install the on-premises data gateway.
C.Verify that all sales team members have edit permissions on the SharePoint list.
D.Ensure that the SharePoint list has no hidden columns.
AnswerA

Refresh settings determine update frequency.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

Full explanation →
Page 6

Page 7 of 14

Page 8

All pages

1234567891011121314

Practice PL-900 by domain

Target a specific domain to shore up weak areas.

Identify foundational components of Power PlatformDemonstrate capabilities of Power BIDescribe complementary Microsoft Power Platform solutionsDemonstrate the capabilities of Power AutomateDescribe the business value of Microsoft Power PlatformManage the Microsoft Power Platform environmentIdentify foundational components of Microsoft Power PlatformDemonstrate the capabilities of Power BIDemonstrate the capabilities of Power AppsDemonstrate the capabilities of Microsoft Copilot StudioDemonstrate the capabilities of Power Pages
See all domains with question counts →