Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 175

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

Page 1 of 14

Page 2
1
MCQhard

An administrator needs to prevent users from creating Power Apps outside of the approved environment (Production). The company has a Development and a Production environment. Users should only be able to create apps in Development. Which configuration should the administrator use?

A.Assign the Environment Maker role to users in both environments
B.Assign the Environment Maker role to users only in the Development environment
C.Create a DLP policy that blocks app creation in Production
D.Remove the Environment Maker role from all users in all environments
AnswerB

This limits creation to Development.

Why this answer

The Environment Maker role grants permission to create apps within a specific environment. By assigning this role only to the Development environment, users can create apps there but are blocked from creating them in Production, where they lack the role. This directly enforces the requirement without affecting other permissions.

Exam trap

The trap here is that candidates often confuse DLP policies with environment-level permissions, incorrectly assuming DLP can block app creation, when in fact DLP only restricts data connectors and sharing, not the ability to create apps.

How to eliminate wrong answers

Option A is wrong because assigning the Environment Maker role to users in both environments would allow app creation in Production, violating the requirement. Option C is wrong because Data Loss Prevention (DLP) policies control data connectors and sharing, not the ability to create apps; they cannot block app creation itself. Option D is wrong because removing the Environment Maker role from all users in all environments would prevent app creation in Development as well, failing to meet the requirement that users should be able to create apps in Development.

2
Multi-Selectmedium

Which TWO actions can be used to implement error handling in a Power Automate flow? (Choose two.)

Select 2 answers
A.Configure Run After settings
B.Apply to each
C.Compose
D.Scope
E.Condition
AnswersA, D

Correct: Allows running actions on failure, timeout, or skipped.

Why this answer

Options B and C are correct. Configure Run After settings allow running subsequent actions on failure. Scope actions group actions and allow configuration of error handling at the scope level.

Option A is wrong because 'Condition' is for branching, not error handling. Option D is wrong because 'Compose' is for data manipulation. Option E is wrong because 'Apply to each' is for loops.

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

4
MCQmedium

A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?

A.The 'Resolved By' lookup column is not added to the form.
B.The 'Resolved By' column is required and users don't fill it.
C.The business rule is scoped to the form but the status change happens via a quick create form.
D.The business rule is deactivated.
AnswerC

Business rules only apply to the form they are scoped to.

Why this answer

Business rules in model-driven apps can be scoped to either the entity (all forms) or a specific form. If the rule is scoped to a particular form (e.g., the main form) but the status change occurs via a quick create form, the rule will not trigger. This is the most likely cause because users report the field is not populated, indicating the rule is not firing in the context where the status is being changed.

Exam trap

The trap here is that candidates assume a business rule always applies to all forms of an entity, overlooking the scope setting that can restrict it to a specific form type, such as the main form versus a quick create form.

How to eliminate wrong answers

Option A is wrong because the 'Resolved By' lookup column not being on the form would not prevent the business rule from populating it; business rules can set field values regardless of whether the field is visible on the form. Option B is wrong because a required column would cause a validation error on save, not silently leave the field empty. Option D is wrong because if the business rule were deactivated, it would never fire in any context, but the question states users report the field is not being populated, implying it works in some scenarios (e.g., main form) but not others (quick create), which points to a scoping issue rather than deactivation.

5
Multi-Selectmedium

Which TWO of the following are valid trigger types that can start a Power Automate flow?

Select 2 answers
A.Instant
B.Webhook
C.Manual
D.Scheduled
E.Automated
AnswersA, E

Instant flows are triggered manually by a user.

Why this answer

A and B are correct. Instant flows are triggered manually by a user (e.g., from a button). Automated flows are triggered by an event (e.g., new email).

Scheduled flows run on a schedule but are not a separate trigger type; they are a type of automated flow. Webhook triggers are a type of trigger, but the option lists 'Webhook' as a trigger type, which is valid. However, the question asks for 'trigger types', and Power Automate categorizes triggers into instant, automated, and scheduled.

Webhook is a subtype. Given the options, A and B are the broad categories. Option C is not a separate trigger type; it's a subtype of automated.

Option D is not a trigger type. Option E is not a trigger type.

6
MCQmedium

The exhibit shows a JSON snippet from a Power Platform environment configuration. What can be inferred from this snippet?

A.The environment has blocked connectors for Twitter and Facebook
B.The environment has used 1024 MB of storage
C.The environment is named 'Production'
D.The environment has a storage limit of 512 MB
AnswerA

BlockedConnectors includes Twitter and Facebook.

Why this answer

The JSON snippet includes a 'blockedConnectors' array containing 'Twitter' and 'Facebook', which explicitly indicates that these connectors are prohibited in the environment. This is a tenant-level or environment-level policy setting used to restrict data movement to or from these services, directly supporting option A as correct.

Exam trap

The trap here is that candidates may focus on the storage values (currentStorageSizeMB and maxStorageMB) or the display name, missing the explicit 'blockedConnectors' array that directly answers the question about what can be inferred from the snippet.

How to eliminate wrong answers

Option B is wrong because the snippet shows 'currentStorageSizeMB: 1024', which is the current storage usage, not a blocked connector. Option C is wrong because the snippet includes 'displayName: Production', but this is just a label; the question asks what can be inferred about the environment configuration, and the blocked connectors are the key inference. Option D is wrong because the snippet shows 'maxStorageMB: 512', which is the storage limit, not a blocked connector; the question specifically targets the blocked connectors inference.

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

8
MCQeasy

A company wants to build a mobile app for field service technicians to view and update work orders. The app must work offline and sync when connectivity is available. Which Power Apps type should they use?

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

Canvas apps can be configured for offline use with the Offline First feature.

Why this answer

Canvas apps allow offline capability with explicit data sync configuration, while model-driven apps require online connectivity. Option A is correct. Option B is wrong because model-driven apps are primarily online.

Option C is wrong because Power Pages are for external web portals. Option D is wrong because Power Automate is for automation, not app building.

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

10
MCQmedium

Refer to the exhibit. A Power Pages site has an entity permission configured as shown. A user assigned to the 'Support Staff' web role reports that they cannot see any cases when visiting the case list page. Other users with the same role can see cases. What is the most likely issue?

A.The entity name is misspelled; it should be 'cases'.
B.The scope should be 'User' instead of 'Global'.
C.The permission type should be 'Write' to see records.
D.The user is not assigned to the 'Support Staff' web role.
AnswerD

If the user is not assigned to the web role, the entity permission does not apply, and they cannot see cases.

Why this answer

The entity permission has a scope of 'Global', which means it applies to all records. However, if the user is not authenticated or the web role assignment is not effective, they may not see records. But the most likely issue from the configuration is that the entity permission is set to 'Read' only, and the user might need additional permissions or the list view may be restricted by page permissions.

However, the question states other users with the same role can see cases, so the user's role assignment might be missing or incorrect. Option B is incorrect because the permission is explicitly set to 'Read'. Option C is incorrect because the scope is already Global.

Option D is incorrect because the entity name is correct.

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

12
Multi-Selecthard

Which THREE Power Automate features are available only in premium licenses? (Choose 3)

Select 3 answers
A.SharePoint triggers
B.Robotic Process Automation (RPA)
C.Business process flows
D.Approval flows
E.AI Builder models
AnswersB, C, E

Requires premium.

Why this answer

Options A, C, and E are correct. Business process flows, AI Builder, and RPA (desktop flows) require premium licenses. Options B and D are available with standard licenses.

13
MCQeasy

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

A.Start from a blank canvas app
B.Create a model-driven app
C.Use Power Automate to create the app
D.Use the app from data wizard (e.g., from SharePoint)
AnswerD

Quickly generates a three-screen app from a data source.

Why this answer

Option C is correct because the app from data wizard in Power Apps allows creating a simple app from a data source with minimal customization. Option A is wrong because blank canvas app requires more manual work. Option B is wrong because model-driven apps are more complex.

Option D is wrong because Power Automate is not for app creation.

14
MCQmedium

A company uses Microsoft Power Platform to automate invoice processing. They want to integrate with their existing ERP system hosted on Azure SQL Database. Which Power Platform component is best suited for this integration?

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

Power Automate creates automated workflows and can connect to Azure SQL Database via connectors.

Why this answer

Power Automate is the correct choice because it provides built-in connectors for Azure SQL Database, enabling seamless integration with the existing ERP system without custom code. It can trigger automated workflows based on invoice events, such as when a new record is created in the SQL database, and orchestrate data processing across multiple systems.

Exam trap

The trap here is that candidates often confuse Power Automate with Power Apps, thinking that building an app is necessary for integration, but Power Automate is specifically designed for workflow automation and system-to-system integration without a user interface.

How to eliminate wrong answers

Option A is wrong because Dataverse is a data storage and management platform, not an integration tool; it would require additional components to connect to Azure SQL Database. Option B is wrong because Power BI is a data visualization and analytics tool, not designed for system integration or workflow automation. Option D is wrong because Power Apps is a low-code application development platform; while it can connect to Azure SQL Database, it is meant for building user interfaces, not for automating backend integration processes.

15
MCQeasy

A company has a canvas app that uses Microsoft Dataverse. The app is shared with many users, and some users report that they cannot see any data. What is the most likely cause?

A.Users do not have appropriate security roles in Dataverse to read the data.
B.The app uses a premium connector that requires a license.
C.The app is not published to the environment.
D.The app is configured to run only on mobile devices.
AnswerA

Security roles determine read access to records.

Why this answer

Permissions in Dataverse (A) control data access. B, C, D are less likely because the app is shared and appears functional.

16
MCQhard

A Power Pages site is experiencing slow load times because it loads all records from a large Dataverse table. The site uses a list component to display data. What is the most effective way to improve performance without custom code?

A.Use an OData query parameter to limit the number of records.
B.Enable client-side caching in the site settings.
C.Implement server-side paging by setting the 'Page Size' property in the list configuration.
D.Add a FetchXML filter to the list to load only the necessary records.
AnswerD

FetchXML filters the query at the server to return only needed records.

Why this answer

Power Pages list components can use FetchXML to filter data server-side, reducing data transfer. Paging in the browser still loads all data if not filtered. OData filters are less efficient.

Caching is not a standard feature.

17
MCQeasy

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

A.From the app itself by selecting Edit
B.Power Apps maker portal
C.Power Automate
D.SharePoint list settings
AnswerB

The maker portal provides the form designer.

Why this answer

Option C is correct because model-driven app forms are customized using the form designer in Power Apps (make.powerapps.com). Option A is wrong because the app is the runtime view. Option B is wrong because SharePoint list settings are unrelated.

Option D is wrong because Power Automate is for automation.

18
MCQeasy

A manager wants to see a Power BI report on their mobile phone while offline. What should they do?

A.Export the report to PDF on a desktop computer
B.Use the Power BI mobile app and download the report for offline viewing
C.Share the report via email
D.Subscribe to the report to receive email updates
AnswerB

The mobile app supports offline access by downloading reports.

Why this answer

Option B is correct because the Power BI mobile app supports downloading reports for offline viewing. This feature allows users to cache a report on their device, enabling access without an internet connection. The manager can simply open the report in the mobile app and select the download option to make it available offline.

Exam trap

The trap here is that candidates may confuse email subscriptions (Option D) or PDF exports (Option A) with true offline mobile access, not realizing that only the Power BI mobile app's download feature provides interactive, cached offline viewing.

How to eliminate wrong answers

Option A is wrong because exporting a report to PDF on a desktop computer creates a static, non-interactive file that does not support Power BI's interactive features like cross-filtering or drill-through, and it is not a mobile offline solution. Option C is wrong because sharing a report via email sends a link or attachment that requires an internet connection to open the live report or, if a static snapshot, lacks interactivity and offline access. Option D is wrong because subscribing to a report sends periodic email snapshots, which are static images or PDFs and do not provide interactive offline viewing on a mobile device.

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

20
MCQhard

You are reviewing a FetchXML query used in a Power Apps component. The exhibit shows the query. What data will this query return?

A.All inactive accounts created in the last 30 days, including all attributes.
B.All accounts created in the last 30 days, only name, accountid, and createdon.
C.Active accounts created in the last 30 days, returning name, accountid, and createdon.
D.All accounts regardless of state, returning all attributes.
AnswerC

The filter conditions match: statecode=0 (Active) and createdon last 30 days, and only the specified attributes are returned.

Why this answer

The query selects accounts where statecode equals 0 (Active) and createdon is within the last 30 days. It returns name, accountid, and createdon. Option A is wrong because statecode 0 is Active, not Inactive.

Option B is wrong because it's not all accounts. Option D is wrong because it does not include all attributes.

21
MCQmedium

Refer to the exhibit. The Azure RBAC custom role definition shown is assigned to a user. What can this user do?

A.Manage all Power Apps in the subscription
B.Create new Power Apps in resource group RG1
C.Edit and delete Power Apps in resource group RG1
D.Read and install Power Apps in resource group RG1
AnswerD

The actions read and install are allowed.

Why this answer

The role includes 'Microsoft.PowerApps/apps/read' and 'install' actions, allowing the user to read and install apps in the specified scope. Option A is correct. Option B is wrong because the role does not include write or delete.

Option C is wrong because the role does not include create. Option D is wrong because the role only allows read and install, not full management.

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

23
MCQhard

A global company uses Power Platform and wants to ensure that data residency requirements are met for users in different regions. What should they configure?

A.In the Power Platform admin center, create environments in the appropriate geographic regions (e.g., Europe, United States).
B.Create data loss prevention (DLP) policies to block data movement between regions.
C.Configure Microsoft Entra ID Conditional Access policies to restrict access based on geographic location.
D.Use Microsoft Purview to tag environments with data residency labels.
AnswerA

Environments are created in specific regions to ensure data stays within the required boundary.

Why this answer

Option A is correct because Power Platform environments are the boundary for data storage and compute. By creating environments in specific geographic regions (e.g., Europe, United States) via the Power Platform admin center, the company ensures that all data for that environment resides in the chosen region, meeting data residency requirements. This is the primary mechanism for controlling data location in Power Platform.

Exam trap

The trap here is that candidates confuse data residency (where data is stored) with data protection policies (DLP) or access control (Conditional Access), leading them to select options that manage data movement or access rather than storage location.

How to eliminate wrong answers

Option B is wrong because data loss prevention (DLP) policies control data movement between connectors and services, not the geographic storage location of data; they cannot enforce data residency. Option C is wrong because Microsoft Entra ID Conditional Access policies control user authentication and access based on location, but they do not affect where data is stored or processed. Option D is wrong because Microsoft Purview is used for data governance, classification, and compliance, but it does not have the capability to tag environments with data residency labels or control data storage location.

24
MCQhard

A Power Apps developer creates a canvas app that uses the 'Power Apps for Makers' license. The app is shared with 50 users who have 'Microsoft 365 E3' licenses. When users try to run the app, they get a licensing error. What is the most likely cause?

A.The app was published to a different environment
B.The app uses Microsoft Dataverse, which is not included in E3
C.The app uses AI Builder, which is not included in E3
D.The app is a premium app that requires a Power Apps per user license
AnswerD

Correct: Premium connectors or custom apps often need per user licenses.

Why this answer

Canvas apps require Power Apps per user or per app licenses for users without Power Apps for Makers. Microsoft 365 E3 includes only limited Power Apps rights for basic use, not premium custom apps.

25
MCQmedium

A company wants to create a public-facing website where customers can submit support tickets and view their status. The site must allow anonymous users to submit tickets but require authentication to view ticket details. Which Power Pages feature should be used to configure this behavior?

A.Configure page permissions to allow anonymous users to submit tickets and authenticated users to view details.
B.Assign web roles to anonymous and authenticated users to control page access.
C.Use Liquid template tags to conditionally show ticket details based on user authentication.
D.Store ticket visibility settings in a Dataverse table and filter records based on user authentication.
AnswerA

Page permissions control which users (anonymous or authenticated) can access specific pages.

Why this answer

Option A is correct because page permissions in Power Pages allow you to restrict access to specific pages based on the user's authentication status. Option B is wrong because web roles define user permissions, not page-level access. Option C is wrong because the Liquid template engine is used for rendering dynamic content, not for access control.

Option D is wrong because Dataverse tables store data, but they do not control page access.

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

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

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

29
MCQeasy

A user wants to create an app that allows employees to submit expense reports from their mobile devices. The app should capture photos of receipts and store them. Which type of app is most suitable?

A.Model-driven app
B.Power Apps portal
C.Power Automate flow
D.Canvas app
AnswerD

Canvas apps offer flexible design and mobile capabilities including camera input.

Why this answer

Option A is correct because canvas apps provide a customizable, mobile-friendly interface with camera integration. Model-driven apps are form-centric and less flexible for custom layouts. Portal apps are for external users.

Power Automate is for workflows, not app creation.

30
Multi-Selectmedium

Which TWO are valid trigger types in Power Automate?

Select 2 answers
A.Button
B.Flow button
C.Instant
D.Scheduled
E.Automated
AnswersC, E

Instant triggers are manually triggered.

Why this answer

Option A (Automated) and Option D (Instant) are valid trigger types. Option B is a type of flow, not a trigger. Option C is not a trigger type.

Option E is a UI element.

31
Multi-Selecthard

Which THREE of the following are capabilities of Power Virtual Agents? (Choose three.)

Select 3 answers
A.Use prebuilt templates for common scenarios
B.Escalate conversations to a live human agent
C.Create chatbots that can be published to websites and Microsoft Teams
D.Generate interactive reports from conversation data
E.Automate complex workflows with conditions
AnswersA, B, C

Templates accelerate bot creation.

Why this answer

Option A is correct because Power Virtual Agents provides a library of prebuilt templates for common chatbot scenarios, such as customer support or FAQ handling, which accelerates development by offering starter content and dialog structures. These templates are designed to be customized, allowing creators to quickly build functional bots without starting from scratch.

Exam trap

The trap here is that candidates may confuse Power Virtual Agents' ability to trigger Power Automate flows with the capability to automate complex workflows itself, or assume that conversation analytics includes interactive report generation, which is actually a Power BI feature.

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

33
Multi-Selectmedium

Which TWO actions can be used to add conditional logic in a Power Automate flow?

Select 2 answers
A.Switch
B.Do until
C.Parallel branch
D.Condition
E.Apply to each
AnswersA, D

Switch evaluates multiple cases.

Why this answer

A is correct because the Switch action in Power Automate evaluates a single value (e.g., a variable or output from a previous step) against multiple possible cases, executing different sets of actions based on which case matches. This is a direct form of conditional logic, similar to a switch/case statement in programming, allowing branching without nested conditions.

Exam trap

The trap here is that candidates confuse 'Do until' (a loop) or 'Apply to each' (an iterator) with conditional logic because they also involve conditions, but only Switch and Condition are designed for branching based on a condition, not repetition or iteration.

34
MCQhard

Refer to the exhibit. A Power Platform administrator applies this DLP policy to the default environment. What is the result?

A.All connectors are allowed
B.All connectors are blocked
C.The policy applies to all environments
D.Microsoft Teams and Twitter connectors are blocked in the default environment
AnswerD

The blockedConnectors list specifies which connectors are blocked.

Why this answer

The exhibit shows a Data Loss Prevention (DLP) policy configured with Microsoft Teams and Twitter connectors in the 'Blocked' group. Since this policy is applied to the default environment, only those two connectors are blocked in that environment. All other connectors remain in the 'Allowed' group by default, so they are permitted.

Therefore, the correct result is that Microsoft Teams and Twitter connectors are blocked in the default environment.

Exam trap

The trap here is that candidates may assume a DLP policy blocks all connectors or applies globally, when in fact only the connectors explicitly placed in the 'Blocked' group are restricted, and the policy scope is limited to the specified environment.

How to eliminate wrong answers

Option A is wrong because not all connectors are allowed; the policy explicitly blocks Microsoft Teams and Twitter connectors. Option B is wrong because only the two blocked connectors are prohibited, not all connectors. Option C is wrong because the policy is scoped to the default environment only, not to all environments; DLP policies can be applied to specific environments or the entire tenant, but the question states it is applied to the default environment.

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

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

37
Multi-Selectmedium

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Select 2 answers
A.Integration with Common Data Service (Microsoft Dataverse)
B.Pre-built templates for common business scenarios
C.Natural language processing to create conversational bots
D.Automated workflows triggered by business events
E.Real-time data dashboards with drill-down analytics
AnswersA, B

Dataverse provides a secure data platform for Power Apps.

Why this answer

Option A is correct because Power Apps integrates directly with Microsoft Dataverse (formerly Common Data Service), which provides a secure, scalable data platform for storing and managing business data. This integration allows users to build apps that leverage Dataverse’s built-in business logic, security roles, and relationships without writing custom code. Option B is correct because Power Apps offers a library of pre-built templates (e.g., for expense reports, asset management) that can be customized to fit specific business needs, enabling rapid application development with minimal technical effort.

Exam trap

The trap here is that candidates often confuse the distinct roles of Power Platform components—Power Apps for app building, Power Automate for workflows, Power BI for analytics, and Power Virtual Agents for bots—leading them to select options that belong to other services.

38
MCQhard

You are developing a canvas app for a global sales team that needs to access customer data from Dataverse. The app must support offline capability so that sales reps can view and update customer records even without internet connectivity. The app will sync changes when the connection is restored. Which feature should you configure? A) Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile. B) Use the 'SaveData' and 'LoadData' functions to manually manage offline data. C) Use Power Automate to cache data on the device. D) Use SharePoint as the data source because it supports offline natively.

A.Enable the 'Offline' setting in the app settings and add the Dataverse table to the offline profile.
B.Use Power Automate to cache data on the device.
C.Use the 'SaveData' and 'LoadData' functions to manually manage offline data.
D.Use SharePoint as the data source because it supports offline natively.
AnswerA

Power Apps canvas apps support offline profiles for Dataverse, enabling automatic sync.

Why this answer

Option A is correct because the offline feature in Power Apps canvas apps allows you to define offline profiles for Dataverse tables, enabling offline use. Option B: SaveData/LoadData can be used but require manual handling and are not integrated with Dataverse sync. Option C: Power Automate does not provide offline caching for apps.

Option D: SharePoint offline is limited and may not meet requirements.

39
MCQmedium

You are building a canvas app that collects customer feedback. The app must send an email notification to the manager whenever a new feedback entry is submitted. What is the recommended approach?

A.Use the Office365 Outlook connector within Power Apps to send an email directly
B.Configure the app to call a custom API that sends an email
C.Create a Power Automate flow that triggers when a new row is added to the data source and sends an email
D.Store feedback in a SharePoint list and use 'Send email' action in SharePoint
AnswerC

Power Automate is the standard way to automate email notifications.

Why this answer

Option C is correct because Power Automate can trigger on data changes in the data source and send emails. Option A is wrong because the Outlook connector in Power Apps requires user interaction. Option B is wrong because direct email from Power Apps is not secure and not recommended.

Option D is wrong because SharePoint lists don't automatically send emails.

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

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

42
Multi-Selectmedium

Which TWO are valid ways to share a Power Automate flow? (Select TWO.)

Select 2 answers
A.Send a direct link to run the flow to other users.
B.Share the flow via Microsoft Teams.
C.Export the flow as a JSON file and email it.
D.Add co-owners in the flow properties.
E.Add the flow to a solution and export/import the solution.
AnswersD, E

Co-owners have edit permissions.

Why this answer

Options A and B are correct. Adding co-owners in the flow properties allows them to edit and manage. Sharing via a solution and importing into another environment enables distribution across environments.

Option C is wrong because exporting as a JSON file and importing manually is possible but not a direct 'share' feature; also, it's not a typical sharing method. Option D is wrong because sending a link to run the flow only works for instant flows, but the flow must be shared first. Option E is wrong because emailing the flow definition is not supported.

43
MCQeasy

A business analyst wants to create a dashboard that displays real-time sales data from a SQL database and share it with the team. Which Power Platform component is best suited?

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

Power BI is the tool for dashboards and analytics.

Why this answer

Power BI is the correct choice because it is specifically designed for data visualization and business intelligence, enabling real-time dashboards from SQL databases via DirectQuery or live connections. It allows sharing dashboards with the team through Power BI Service, meeting the requirement for real-time sales data display and collaboration.

Exam trap

The trap here is that candidates may confuse Power Apps with Power BI because both can display data, but Power Apps is for app creation with limited real-time dashboard sharing, while Power BI is the dedicated analytics and visualization tool for live dashboards.

How to eliminate wrong answers

Option A is wrong because Power Automate is a workflow automation tool for triggering actions based on events, not for creating dashboards or visualizing real-time data. Option C is wrong because Power Virtual Agents is used to build conversational chatbots, not for data visualization or dashboard creation. Option D is wrong because Power Apps is for building custom applications with forms and logic, but it lacks native real-time dashboarding and sharing capabilities compared to Power BI.

44
Multi-Selecthard

Which THREE are capabilities of Microsoft Dataverse in Power Apps?

Select 3 answers
A.Role-based security to control access to data
B.Calculated fields and rollup fields
C.Real-time co-authoring of canvas apps
D.Business rules to enforce logic on forms
E.Server-side pagination for large datasets
AnswersA, B, D

Dataverse uses role-based security to control data access.

Why this answer

Correct: A, B, and D. Dataverse provides role-based security (A), business rules (B), and calculated fields (D). C is wrong because real-time co-authoring is a Power Apps feature, not Dataverse.

E is wrong because server-side pagination is not exposed directly in Dataverse.

45
MCQeasy

A Power Platform administrator needs to review which users have accessed a specific environment in the last 30 days. What should they use?

A.Power Platform admin center auditing
B.Power Platform PowerShell cmdlets
C.Power Apps maker portal
D.Microsoft 365 admin center
AnswerA

The admin center provides audit logs for user access.

Why this answer

The Power Platform admin center provides built-in auditing capabilities that allow administrators to view user access logs for specific environments. By navigating to the 'Auditing' section within the admin center, an admin can filter by environment and date range (e.g., last 30 days) to see which users have accessed the environment. This is the correct tool because it is purpose-built for Power Platform governance and does not require additional scripting or external tools.

Exam trap

The trap here is that candidates often confuse the Power Platform admin center with the Microsoft 365 admin center, assuming that all administrative tasks for Power Platform are handled in the Microsoft 365 admin center, but environment-specific auditing is exclusive to the Power Platform admin center.

How to eliminate wrong answers

Option B is wrong because Power Platform PowerShell cmdlets can be used to automate environment management tasks, but they do not provide a direct, built-in auditing view of user access logs for a specific environment over the last 30 days; you would need to export and parse audit logs separately. Option C is wrong because the Power Apps maker portal is designed for creating and editing apps, not for administrative auditing of environment access. Option D is wrong because the Microsoft 365 admin center focuses on user and license management across Microsoft 365 services, not on granular Power Platform environment-level access auditing.

46
MCQmedium

A business analyst wants to create an app that uses a SharePoint list as its data source. They need to include conditional formatting to highlight overdue tasks. Which type of app should they use?

A.Power Virtual Agents chatbot
B.Model-driven app
C.Canvas app
D.Power BI report
AnswerC

Canvas apps support formulas to change control properties based on data, enabling conditional formatting.

Why this answer

Option B is correct because canvas apps allow custom formulas for conditional formatting. Option A is wrong because model-driven apps use business rules but not flexible conditional formatting. Option C is wrong because Power BI is for analytics, not app creation.

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

47
MCQeasy

A company 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 user is deleted (Microsoft Entra ID)
B.When a user is added to a group
C.When a user is modified (Microsoft Entra ID)
D.When a new user is created (Office 365 Users)
AnswerB

This trigger fires when a new user is added to a specific group, which can be used to detect new users.

Why this answer

The 'When a user is added to a group' trigger is designed for this scenario. Option B is a trigger for Office 365 users, not Entra ID. Option C is a trigger for Microsoft Entra ID but requires a premium license and is for user modifications.

Option D is a trigger for Microsoft Entra ID but is for user deletions.

48
MCQeasy

You are a business analyst at a manufacturing company. You need to create a flow that automatically saves email attachments from a specific sender to a SharePoint document library. The flow should trigger when a new email arrives in your mailbox. What should you use?

A.Create a business process flow
B.Create a desktop flow
C.Create an approval flow
D.Create an automated cloud flow
AnswerD

Automated cloud flows trigger on events like new email and can save attachments to SharePoint.

Why this answer

A cloud flow (automated) is the correct choice because it triggers on an event (new email) and can integrate with SharePoint. Desktop flows are for legacy desktop automation. Business process flows guide users through steps.

An approval flow is for approvals.

49
MCQhard

You are a Power Platform consultant for a large university that wants to build a public-facing Power Pages site for alumni. The site must allow alumni to register, update their profile, view upcoming events, and donate to the university. The university uses Microsoft Entra ID for staff and students, but alumni will use their personal email accounts to register. The security team requires that all data transmitted between the browser and the portal be encrypted. Additionally, the alumni relations team needs to send targeted emails to alumni based on their interests, which are captured during registration. The development team wants to use a low-code approach to integrate the donation functionality, which should process payments through a third-party payment gateway. You need to design the solution. Which of the following is the best approach?

A.Create a custom web API in Azure to handle payments and call it from Power Pages using Liquid.
B.Configure Microsoft Entra ID as the only identity provider and require alumni to create a Microsoft account.
C.Use the Power Pages design studio to build the donation page with custom JavaScript to call the payment gateway API.
D.Enable HTTPS for the site (default), store alumni profiles and interests in Dataverse, use Power Automate with a custom connector for payment processing, and use Power Automate to send targeted emails.
AnswerD

This approach uses low-code, ensures security, and meets all requirements.

Why this answer

Option C is correct because Power Pages enforces HTTPS automatically, ensuring data encryption. Using a Dataverse table to store profile and interest data allows the alumni team to use Power Automate to send targeted emails. The payment gateway can be integrated via a custom connector in Power Automate.

Option A is wrong because the university should not use its Entra ID for alumni; alumni should register with personal accounts, and the site already supports local authentication. Option B is wrong because custom code for the payment gateway contradicts the low-code requirement. Option D is wrong because Power Automate flows can be triggered from Power Pages without custom web APIs.

50
Multi-Selectmedium

Which THREE are valid options for handling errors in a Power Automate flow? (Choose three.)

Select 3 answers
A.Configure run after
B.Scope
C.Parallel branches
D.Retry policy
E.Try-catch-finally pattern using scopes
AnswersA, B, E

Correct. This sets action execution based on previous action status.

Why this answer

Option A is correct because 'Configure run after' allows a flow action to execute based on the outcome (success, failure, skipped, or timed out) of a preceding action. This is the primary mechanism in Power Automate for handling errors by defining conditional execution paths after an action completes.

Exam trap

The trap here is that candidates often confuse 'Retry policy' as a general error-handling option when it is actually a specific retry mechanism, not a branching or scoping construct for handling errors.

51
Drag & Dropmedium

Drag and drop the steps to create a canvas app from a SharePoint list in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order

Why this order

The process starts in the maker portal, then selects SharePoint as source, connects to the list, chooses a template, and finally publishes and shares.

52
MCQhard

The exhibit shows a trigger definition for a Power Automate flow. What does this trigger do?

A.Triggers when a .csv file is created in the 'Incoming' folder.
B.Triggers when any file is created in the 'Incoming' folder.
C.Triggers when a file is modified in the 'Incoming' folder.
D.Triggers when a .xlsx file is created in the 'Incoming' folder.
AnswerD

Condition ensures only .xlsx files trigger the flow.

Why this answer

Option D is correct because the trigger is set to fire when a file is created in the 'Incoming' folder, but the condition filters to only proceed when the file extension is .xlsx. Option A is wrong because it does not check for any file. Option B is wrong because it does not update.

Option C is wrong because it does not process CSV.

53
MCQeasy

A non-profit organization uses Power Platform to manage donor records. They have a single environment (default). A volunteer accidentally deleted a critical Power App component. The IT coordinator needs to restore the component from a previous version. The environment does not have any backup solution in place. What should the IT coordinator do?

A.Contact Microsoft Support to recover the deleted component.
B.Restore the environment from a backup using the Power Platform Admin Center.
C.Recreate the component manually.
D.Open the app in Power Apps Studio and use the version history feature to restore the previous version.
AnswerD

Version history allows restoring a previous version of the app, including deleted components.

Why this answer

Power Platform includes version history for Power Apps, allowing restoration of previous versions. The coordinator can access the app's version history and restore the component.

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

55
MCQeasy

A manager wants to create a Power App that shows a list of customer orders with the ability to drill into each order's details. Which approach is most efficient?

A.Use a data table connected directly to the data source
B.Use a gallery to list orders and navigate to a detail screen on selection
C.Use a single form with navigation buttons to move between orders
D.Export the data to Excel and use Power Apps to display the Excel file
AnswerB

Gallery allows efficient browsing and drill-down

Why this answer

Option B is correct because using a gallery to show orders and linking to a detail screen is a common pattern. Option A is wrong because a single form is not efficient for browsing. Option C is wrong because a data table is less interactive than a gallery.

Option D is wrong because exporting to Excel is not an app.

56
MCQhard

Your organization uses Power Apps and Power Automate to manage a vendor onboarding process. The app must send an email notification to the compliance team when a high-risk vendor is added. The compliance team resides in a different Microsoft Entra ID tenant. Which approach should you use?

A.Use the Outlook 365 connector with a shared mailbox
B.Use the Dataverse connector with a custom action
C.Use the Microsoft Teams connector to post a message
D.Use the HTTP connector with a custom API
AnswerD

HTTP connector can call an external email service.

Why this answer

Option D is correct because the HTTP connector can send email to external recipients without sharing a mailbox. Option A is wrong because Dataverse connectors are tenant-scoped. Option B is wrong because Outlook connector requires shared mailbox or user credentials.

Option C is wrong because Teams connector is for internal users.

57
MCQhard

A company uses a Power Platform environment that contains several production apps. They need to ensure that changes to these apps are reviewed and approved before deployment to the production environment. What should they implement?

A.Create data loss prevention (DLP) policies for the production environment.
B.Use managed solutions and Azure DevOps for application lifecycle management (ALM) with deployment gates.
C.Assign the System Administrator role to all developers.
D.Configure Microsoft Purview to audit changes and require approval.
AnswerB

Managed solutions and ALM pipelines with approval gates enforce review and approval before production deployment.

Why this answer

Option B is correct because managed solutions and Azure DevOps with deployment gates provide a structured Application Lifecycle Management (ALM) process. This allows changes to be reviewed, tested, and approved before deployment to a production environment, ensuring governance and control over modifications.

Exam trap

The trap here is that candidates may confuse data governance (DLP) or auditing (Purview) with the deployment approval process, or mistakenly think that granting admin rights to all developers is a valid way to manage changes, rather than recognizing the need for a formal ALM pipeline with approval gates.

How to eliminate wrong answers

Option A is wrong because Data Loss Prevention (DLP) policies control data flow between connectors and environments, not the review and approval of app changes. Option C is wrong because assigning the System Administrator role to all developers grants excessive permissions, bypassing the need for review and approval, and violates the principle of least privilege. Option D is wrong because Microsoft Purview is a compliance and auditing tool, not a mechanism for enforcing approval workflows on app deployments.

58
MCQmedium

A Power Pages site has a form that submits data to Dataverse. Users report that the form is slow to load because it contains many lookup fields. What is the best practice to improve form load performance?

A.Reduce the number of lookup fields on the form.
B.Disable the cascading lookup feature.
C.Enable client-side caching for lookups.
D.Add FetchXML filters to each lookup to limit results.
AnswerA

Fewer lookups mean less data to load initially.

Why this answer

Option A is correct because reducing the number of lookup fields directly decreases the number of separate database queries and network round-trips required to load the form. Each lookup field in a Power Pages form triggers an individual request to Dataverse to retrieve the related record's display name and metadata, so fewer lookups means fewer requests and faster load times.

Exam trap

The trap here is that candidates often confuse performance improvements that affect the initial load (like reducing lookups) with features that affect interaction or filtering (like cascading lookups or FetchXML filters), leading them to choose options that only help after the form is already loaded.

How to eliminate wrong answers

Option B is wrong because disabling the cascading lookup feature only prevents automatic filtering of related options when a parent lookup changes; it does not reduce the number of initial queries or improve the form's initial load performance. Option C is wrong because client-side caching for lookups is not a built-in feature in Power Pages; the platform does not provide a native mechanism to cache lookup data on the client side, so enabling it is not a valid option. Option D is wrong because adding FetchXML filters to each lookup limits the number of displayed records but does not reduce the number of queries or the overhead of loading the lookup fields themselves; it may even increase complexity and processing time.

59
MCQeasy

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

A.Security roles
B.Business rules
C.SharePoint connector
D.App properties
AnswerA

Security roles grant or restrict delete permissions on tables.

Why this answer

Option B is correct because security roles in model-driven apps define permissions, including delete rights. Option A is wrong because business rules define logic, not permissions. Option C is wrong because the app's properties do not include security settings.

Option D is wrong because the SharePoint connector is for integration, not security.

60
MCQhard

Refer to the exhibit. A Power Pages site has the above site settings. What behavior will users experience?

A.Users can register with a local account
B.Users cannot register at all
C.Users must use Microsoft Entra ID to sign in
D.Users can register but must use an external identity provider
AnswerD

Registration is enabled; local login is disabled; external login is required.

Why this answer

Option A is correct because local login is disallowed and external login is required. Option B is wrong because registration is enabled. Option C is wrong because local login is not allowed.

Option D is wrong because external login is required, but registration is enabled.

61
MCQhard

You are designing a Power Automate flow that processes sensitive employee data from Dataverse. The flow must run in a secure environment and be triggered by changes to a table that supports auditing. The company policy requires that all flows handling sensitive data use managed identities for authentication and execute within a dedicated environment with data loss prevention (DLP) policies applied. Which combination of features should you use?

A.Instant flow with user connection reference
B.Automated flow using the 'When a row is modified' trigger with a service principal connection
C.Automated flow with the 'Run only for the flow owner' setting
D.Solution-aware automated flow deployed to a dedicated environment with a managed identity
AnswerD

Solution-aware flows can be deployed to dedicated environments with DLP policies, and managed identities provide secure authentication.

Why this answer

Option D is correct because a solution-aware flow can be packaged and deployed to a dedicated environment with DLP policies, and a managed identity (now service principal) provides secure authentication. Option A is incorrect because instant flows are manually triggered, not triggered by data changes. Option B is incorrect because the 'When a row is modified' trigger does not use service principal; it uses the owner's credentials.

Option C is incorrect because automated flows can be triggered by Dataverse changes, but the 'Run only for the flow owner' setting does not use managed identity.

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

63
MCQhard

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

A.Use parallel branches for each row
B.Use an apply to each loop with default settings
C.Use an apply to each loop and configure 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', 'has failed'
D.Use a scope with sequential actions and set 'Configure run after' to 'is successful' only
AnswerC

Correct. This allows the loop to continue even after a failed insert.

Why this answer

Option C is correct because configuring 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', and 'has failed' ensures that even if a row fails validation or the SQL insert fails, the flow continues to the next iteration of the Apply to each loop. This allows the flow to process all rows in the CSV file without stopping on an error, meeting the requirement to skip invalid data and proceed with the next row.

Exam trap

The trap here is that candidates often assume the default 'is successful' run-after behavior is sufficient for error handling, but they miss that without explicitly configuring the action to continue on failure, the entire flow will halt on the first error, which violates the requirement to skip invalid rows and continue processing.

How to eliminate wrong answers

Option A is wrong because parallel branches would attempt to process all rows simultaneously, which could lead to race conditions, resource contention, and does not inherently handle per-row errors without stopping the entire flow; it also does not provide a mechanism to continue on failure for individual rows. Option B is wrong because the default 'Configure run after' setting for an action is 'is successful' only, which means if the SQL insert fails on any row, the flow will terminate and not process subsequent rows. Option D is wrong because a scope with sequential actions and 'Configure run after' set to 'is successful' only will stop the entire scope on the first failure, preventing the flow from continuing with the next row.

64
Multi-Selecteasy

Which TWO of the following are valid data sources for a Canvas app? (Choose TWO.)

Select 2 answers
A.SharePoint Online list
B.Power Automate flow
C.Microsoft Intune
D.Microsoft Entra ID
E.Microsoft Dataverse
AnswersA, E

Canvas apps can connect to SharePoint lists.

Why this answer

Options A and D are correct. Canvas apps can connect to SharePoint lists and Microsoft Dataverse. Microsoft SQL Server is also valid but not listed; Excel Online is a connection, but the options given include SharePoint and Dataverse.

Option C is a service not a data source. Option E is not a data source.

65
MCQhard

Refer to the exhibit. The JSON shows the definition of a Power Apps canvas app. Based on the exhibit, which data source is the app connected to?

A.SharePoint list
B.Microsoft Dataverse
C.SQL Server
D.Excel Online
AnswerA

The 'type' field indicates SharePointList.

Why this answer

The JSON clearly shows the data source type as 'SharePointList'. Option A is correct. Option B is wrong because Dataverse is not listed.

Option C is wrong because SQL Server is not listed. Option D is wrong because Excel is not listed.

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

67
Multi-Selecteasy

Which THREE of the following are common use cases for Power Pages?

Select 3 answers
A.Community forum for product discussions.
B.Employee self-service portal for HR requests.
C.Customer self-service portal.
D.Internal employee expense reporting app.
E.Event registration and management system.
AnswersA, B, C

Power Pages supports forums and community features.

Why this answer

Options A, B, and D are correct. Power Pages is used for public-facing websites like customer portals, community sites, and employee self-service. Option C is wrong because Power Pages is not used for internal back-office apps; those are typically built with Power Apps.

Option E is wrong because event registration is a specific scenario that can be built, but it's not a top-level common use case.

68
MCQmedium

A company wants to build a canvas app to allow field technicians to report equipment issues from their mobile devices. The app must work offline and sync data when connectivity is restored. Which feature should the developer use?

A.Power Automate
B.Power Platform admin center
C.Common Data Service
D.Offline
AnswerD

The Offline feature enables canvas apps to work offline and sync later.

Why this answer

Option B is correct because Power Apps canvas apps support offline capability using the Offline feature, which caches data on the device and syncs when connectivity returns. Option A is wrong because the Common Data Service (now Microsoft Dataverse) is a data platform but does not directly provide offline capabilities; the Offline feature sets up sync. Option C is wrong because the Power Platform admin center is for administration.

Option D is wrong because Power Automate flows can be part of the solution but are not the offline feature itself.

69
MCQeasy

A Power Pages site needs to integrate a Microsoft Copilot Studio chatbot to answer customer questions. What must be done to add the chatbot to the portal?

A.Write custom Liquid code to call the Copilot Studio API.
B.Add the Copilot Studio chatbot component to a page and configure it with the bot's details.
C.Embed the chatbot using an iFrame in a web template.
D.Install a third-party chatbot plugin from the Power Platform marketplace.
AnswerB

The chatbot component in Power Pages simplifies integration with Copilot Studio.

Why this answer

Power Pages provides a dedicated 'Chatbot' component that can be added to a page. You configure it by providing the Copilot Studio bot's ID or URL. Option B is incorrect because embedding via iFrame is not the recommended method.

Option C is incorrect because the component is already available in the portal. Option D is incorrect because Liquid templates are not required; the component handles the integration.

70
MCQmedium

A company uses Power Automate to automate invoice processing. The flow must send an email with the invoice PDF as an attachment to the manager for approval. However, the approval step is failing with an error. What is the most likely cause?

A.The flow is not using a premium license for the approval action.
B.The file size exceeds the 10 MB limit for Power Automate attachments.
C.The SharePoint connector cannot access PDF files.
D.The flow does not include the 'Attachments' parameter in the 'Start and wait for an approval' action.
AnswerD

The approval action requires explicit attachment configuration.

Why this answer

Option A is correct because Power Automate requires the file content to be explicitly included as an attachment in the approval action; simply referencing the file path does not attach the file. Option B is wrong because SharePoint connectors can handle PDFs. Option C is wrong because the issue is not about premium licenses—standard connectors support attachments.

Option D is wrong because there is no 10 MB limit for standard approvals.

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

72
MCQmedium

A company is building a public-facing portal to allow customers to submit support tickets and track their status. The portal must support anonymous browsing for ticket submission but require authentication to view ticket details. Which Power Pages feature should they use?

A.Power Automate flows triggered by page visits
B.Microsoft Customer Voice
C.Dataverse table permissions
D.Page permissions with anonymous and authenticated web roles
AnswerD

Page permissions allow controlling access per page based on web roles, supporting anonymous submission and authenticated viewing.

Why this answer

Option B is correct because Power Pages allows anonymous access to certain pages while requiring authentication for others, using page permissions and web roles. Option A is wrong because Customer Voice is for surveys. Option C is wrong because Power Automate is for workflows, not access control.

Option D is wrong because Dataverse is the underlying database, not a feature for access control.

73
MCQeasy

A manager wants to create an app without writing any code. Which Power Apps type should they use?

A.Power BI
B.Model-driven app
C.Power Automate
D.Canvas app from a template
AnswerD

Canvas apps can be created from templates or data sources with no code required.

Why this answer

Power Apps Studio with templates or from data allows no-code app creation. Option A is correct. Option B is wrong because model-driven apps require some configuration but still no code, but the question implies ease of use.

Option C is wrong because Power Automate is for workflows. Option D is wrong because Power BI is for analytics.

74
MCQeasy

A company wants to create a mobile app for field technicians to log service calls. The app will connect to an existing SQL database. Which type of Power App should they build?

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

Canvas apps provide full control over UI and can connect to SQL databases, perfect for mobile field apps.

Why this answer

Option C is correct because canvas apps allow custom layout and connectivity to many data sources, ideal for mobile scenarios. Option A is wrong because model-driven apps are form-centric and designed for complex business processes. Option B is wrong because Power Pages is for external-facing websites.

Option D is wrong because Power Automate is for automation, not app building.

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

Page 1 of 14

Page 2