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

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

Page 8

Page 9 of 14

Page 10
601
Drag & Dropmedium

Drag and drop the steps to build a model-driven app in Power Apps 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

Model-driven apps require first setting up Dataverse tables, then designing forms/views, then building the app with sitemap, and finally publishing with security roles.

602
MCQmedium

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

A.Create a Power Automate flow that runs a SQL query and sends the results via email, and give store managers access to the Azure SQL Database directly.
B.Create separate Power BI dashboards for each store and each region, and manually share them.
C.Create a Power BI dataset with RLS to filter by store, publish a dashboard, and use a scheduled Power Automate flow to email a paginated report to regional managers.
D.Use Power Apps to build a custom dashboard for each store, and use Power Automate to email reports.
AnswerC

RLS ensures store managers see only their data; Power Automate automates email delivery.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

603
MCQmedium

A Power Apps developer created a canvas app that uses a SQL Server data source. Users report that the app is slow when navigating between screens. Which design change should the developer make to improve performance?

A.Replace the SQL data source with a SharePoint list to increase delegation limits.
B.Move all data loading logic from OnVisible to the App.OnStart property.
C.Add a Timer control to preload data for the next screen.
D.Apply delegation-compatible filters on galleries to reduce data loaded from the server.
AnswerD

Delegation pushes filtering to SQL, reducing data sent to the app.

Why this answer

Using delegation with server-side filtering (A) reduces data transfer and improves speed. B is incorrect because OnStart runs once and does not affect navigation. C is wrong as SQL supports delegation.

D is unnecessary; the issue is data volume.

604
MCQhard

An administrator needs to manage multiple Power Platform environments across several tenants. The administrator wants to use a single tool to view environment details, apply updates, and configure settings for all environments. Which tool should the administrator use?

A.Power Platform Admin Center
B.PowerShell cmdlets
C.Power Apps Maker Portal
D.Microsoft 365 admin center
AnswerA

The Admin Center provides unified management for environments.

Why this answer

The Power Platform Admin Center is the central tool for managing environments across tenants. Option A is wrong because PowerShell is a scripting tool, not a single interface for all tasks. Option B is wrong because Power Apps Maker Portal is for app creation.

Option D is wrong because Microsoft 365 admin center does not manage Power Platform environments fully.

605
MCQhard

An organization has a Power Pages site that uses Microsoft Entra ID authentication. They want to add a custom registration page that collects additional information like phone number and date of birth. What is the recommended approach?

A.Use the Power Pages registration form customizer in the admin center
B.Embed a canvas app to handle registration and capture additional data
C.Modify the Microsoft Entra ID sign-up policy to include additional attributes
D.Create a custom registration page using Liquid templates and store additional data in a Dataverse table
AnswerD

Custom registration pages can be built with Liquid and can store extra data in Dataverse.

Why this answer

Option C is correct because Power Pages allows extending the registration form by creating a custom page with additional fields that interact with the identity provider registration process. Option A is wrong because modifying the identity provider is not necessary. Option B is wrong because there is no 'registration form customizer' in Power Pages settings.

Option D is wrong because embedding a canvas app is not the standard way to extend registration.

606
MCQhard

A Power Pages site must display a chart showing monthly sales data from Dataverse. The chart should update automatically when new data is added. What is the recommended approach?

A.Embed a Power BI report that connects to Dataverse.
B.Write custom JavaScript using the Chart.js library.
C.Use a list component with a chart visualization.
D.Export data to Excel and display as an image.
AnswerA

Power BI reports can auto-refresh and provide rich visualizations.

Why this answer

Power Pages can embed Power BI reports, which can refresh automatically. Using a list with a chart is limited to basic charts and may not auto-refresh. Custom JavaScript is complex and unreliable.

Excel export is static.

607
MCQhard

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

A.Offline capability in Dataverse (mobile offline sync)
B.Power Apps portals
C.Power Apps component framework
D.Monitor tool in Power Apps
AnswerA

Dataverse enables offline data sync for mobile apps.

Why this answer

Option B is correct because Dataverse supports offline mobile experiences. Option A is not a Power Apps feature. Option C is for debugging.

Option D is for performance optimization.

608
MCQmedium

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

A.In the SharePoint list settings
B.In a Power Automate flow
C.In the Dataverse table's business rules settings
D.In the canvas app's OnStart property
AnswerC

Business rules are defined on Dataverse tables.

Why this answer

Business rules are defined on Dataverse tables and apply to model-driven apps. Option B is correct. Option A is wrong because business rules are not defined in canvas apps.

Option C is wrong because Power Automate is for flows, not business rules. Option D is wrong because SharePoint lists do not support Power Apps business rules.

609
MCQeasy

You are reviewing a Power Automate flow that uses an Office 365 Users connector. The exhibit shows a JSON definition of an action. What does this action do?

A.Updates the profile of the user who triggered the flow.
B.Deletes the user profile of the record owner.
C.Creates a new user profile in Office 365.
D.Retrieves the user profile of the record owner.
AnswerD

The operation is GetUserProfile and the User parameter is the owner.

Why this answer

The action uses the GetUserProfile operation with a User parameter taken from the trigger output. It retrieves the profile of the user who is the owner of the triggering record. Option A is wrong because there is no update.

Option B is wrong because it is not creating. Option D is wrong because it is not deleting.

610
Multi-Selecteasy

Which TWO are types of apps you can create with Microsoft Power Apps?

Select 2 answers
A.Model-driven app
B.Copilot Studio bot
C.Canvas app
D.Flow app
E.Power BI report
AnswersA, C

Model-driven apps are data-centric and use Dataverse.

Why this answer

Correct: A and C. Canvas apps (A) and model-driven apps (C) are the two primary types. B is wrong because Flow is Power Automate.

D is wrong because Power BI is a separate product. E is wrong because Copilot Studio is for chatbots.

611
MCQhard

Refer to the exhibit. A Power Apps administrator runs the PowerShell command shown. What is the purpose of this command?

A.To remove the user from a Power Apps environment
B.To check if the user can connect to Dataverse
C.To create a new Power Apps license for the user
D.To verify which Power Apps licenses are assigned to the user
AnswerD

The AssignedLicenses property shows license SKUs, including Power Apps.

Why this answer

Option D is correct because the administrator is checking which licenses (including Power Apps) are assigned to the user. Option A is wrong because the command is not about app permissions. Option B is wrong because it does not create anything.

Option C is wrong because it does not check connectivity.

612
MCQmedium

A Power Automate flow uses the 'HTTP' action to call an external API. The flow fails intermittently with a 429 (Too Many Requests) error. What is the best practice to handle this?

A.Switch to a different API endpoint
B.Add a 'Terminate' action to stop the flow on error
C.Configure retry policy with exponential backoff
D.Reduce the timeout of the HTTP action
AnswerC

Correct: Retry policies can handle transient failures gracefully.

Why this answer

Option D is correct because implementing retry logic with exponential backoff is a standard pattern for handling rate limiting. Option A is wrong because decreasing the timeout does not address the rate limit. Option B is wrong because ignoring the error could lead to data loss.

Option C is wrong because switching to a different connector might not be possible and does not solve the throttling issue.

613
MCQmedium

A Power Pages site includes a form that allows users to update their profile. The form uses a Dataverse table where users should only be able to update their own record. How should the form's table permission be configured?

A.Self scope with Write permission
B.Account scope with Write permission
C.Global scope with Write permission
D.User scope with Write permission
AnswerD

User scope limits access to records owned by the current user.

Why this answer

Option D is correct because 'User' scope restricts access to records owned by the current user. Option A is wrong because 'Global' allows all records. Option B is wrong because 'Self' is not a valid scope.

Option C is wrong because 'Account' is not a scope; scopes are Global, Contact, Account, and User.

614
MCQmedium

Refer to the exhibit. A canvas app has a gallery (Gallery1) with the Items property shown. The app also has a text input (TextSearchBox1) for searching accounts. Users report that when they type a search term, the gallery does not update until they click a button. What is the most likely cause?

A.The data source is not delegable, causing the filter to fail
B.The text input's OnChange event is not set to refresh the gallery
C.The gallery's DelayOutput property on the text input is set to true
D.The gallery's Items property is set to a static value instead of using TextSearchBox1.Text
AnswerD

If the Items property is not dynamic, it won't respond to text changes

Why this answer

Option A is correct because the gallery's Items property uses the text input value, but if the formula is not set to react to changes, it won't update automatically. The default behavior is that the gallery should update as the user types, but if the TextSearchBox1 is not bound correctly or the formula is in a different context (e.g., only on button click), it may not update. However, the question implies the formula is correct but the gallery doesn't update.

The typical issue is that the formula is placed in the wrong property (e.g., OnSelect of a button). Option A is most plausible.

615
MCQmedium

A company uses Power BI to create reports from Dataverse data. The administrator needs to ensure that report creators can only see data from tables they have access to in Dataverse. Which security feature should the administrator configure?

A.Set environment security group to include only report creators
B.Configure table-level permissions in Dataverse
C.Define row-level security (RLS) roles in Power BI and map them to Dataverse roles
D.Assign the 'Environment Maker' role to report creators
AnswerC

RLS restricts data visible to each user in the report.

Why this answer

Option D is correct because row-level security (RLS) in Power BI restricts data access based on user roles. Option A is wrong because it applies to the environment, not specific tables. Option B is wrong because it affects who can create reports, not data visibility.

Option C is wrong because table permissions do not translate to Power BI.

616
MCQeasy

A marketing team uses a Power Automate flow that posts a message to Microsoft Teams when a new lead is added to a SharePoint list. The flow runs successfully, but the message is not appearing in the expected Teams channel. What is the first thing you should check?

A.Verify that the Teams webhook URL is correctly pointing to the intended channel
B.Review the flow run history for failure details
C.Check if the SharePoint list trigger is properly configured
D.Ensure the flow owner has permissions to post to Teams
AnswerA

A wrong webhook URL would cause the message to go to the wrong channel or fail.

Why this answer

Option A is correct because the most common misconfiguration is using the wrong webhook URL for the channel. Option B is incorrect because the trigger is working if the flow runs. Option C is incorrect because posting to Teams does not require special permissions beyond the connection.

Option D is incorrect because flow execution might not show detailed errors unless you open the run history.

617
MCQmedium

A Power Apps canvas app uses a SharePoint list as its data source. Users report that the app is slow to load when the list contains over 10,000 items. What is the best approach to improve performance?

A.Increase the data row limit in the app settings.
B.Switch to a Microsoft Dataverse data source.
C.Reduce the number of columns in the SharePoint list.
D.Use delegation-compatible functions and filters in the app.
AnswerD

Delegation pushes processing to the data source, reducing the amount of data retrieved.

Why this answer

Delegation allows queries to be processed on the data source side, reducing data transferred. Option C is correct. Option A is wrong because it doesn't address the root cause.

Option B is wrong because limiting fields might not help if delegation is not used. Option D is wrong because using a different data source may not be feasible.

618
MCQeasy

A small business wants to create a simple public-facing website to showcase their services and allow customers to book appointments. They have no existing IT infrastructure and want to use a low-code solution that integrates with Microsoft 365 for email notifications. They also need to manage appointment data without building a custom database. You recommend Power Pages. What is the most efficient way to set up the appointment booking feature?

A.Build a Power Automate portal that accepts form submissions and writes to a Dataverse table.
B.Use SharePoint lists to store appointments and embed the list in a Power Pages page using an iframe.
C.Use Excel Online as the backend and connect via Power Automate to create appointments from the portal.
D.Create a new Dataverse table for appointments, then use the Power Pages 'List and Form' template to allow users to view available slots and submit bookings.
AnswerD

This leverages built-in capabilities for data management and form creation with minimal effort.

Why this answer

Power Pages provides a 'List and Form' template that can be based on a Dataverse table. Option D is the simplest. Option A (SharePoint) is not recommended for structured data.

Option B (Excel) is not a scalable database. Option C (Power Automate) is not a data storage solution.

619
MCQhard

Refer to the exhibit. A Power Platform environment uses Data Loss Prevention (DLP) policy with this JSON snippet. What is the effect of this policy rule?

A.It requires approval for connectors accessing Seattle accounts.
B.It allows all connectors for accounts outside Seattle.
C.It classifies connectors as Business for accounts in Seattle.
D.It blocks all connectors for accounts in Seattle.
AnswerD

The exact match condition triggers block for matching records.

Why this answer

The JSON snippet defines a DLP policy rule that applies to the 'Seattle' environment. It sets the connector classification to 'Blocked' for all connectors, meaning no connectors can be used in that environment. Therefore, the correct effect is that all connectors are blocked for accounts in Seattle, making option D correct.

Exam trap

The trap here is that candidates may misinterpret the 'Blocked' classification as requiring approval or as applying only to certain connector types, when in fact it universally prohibits all connectors in that environment.

How to eliminate wrong answers

Option A is wrong because the policy does not mention any approval process; it directly blocks connectors rather than requiring approval. Option B is wrong because the policy explicitly targets accounts in Seattle, not outside Seattle, and it blocks connectors rather than allowing them. Option C is wrong because the policy classifies connectors as 'Blocked', not 'Business', for accounts in Seattle.

620
MCQeasy

A company wants to build an app that allows employees to submit expense reports. The app must include approval workflow. Which Power Platform component should be used to define the approval process?

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

Power Automate provides built-in approval actions and workflow automation.

Why this answer

Power Automate is the tool for creating approval workflows. Option D is correct. Option A is wrong because Power Apps is for building the app interface, not the workflow.

Option B is wrong because Power BI is for data visualisation. Option C is wrong because Power Virtual Agents is for chatbots.

621
Multi-Selectmedium

A company wants to enforce data loss prevention (DLP) policies for Power Automate flows. Which TWO actions can the administrator perform?

Select 2 answers
A.Allow users to bypass DLP policies with administrator approval
B.Block specific connectors from being used in flows
C.Create a custom DLP policy for a specific environment
D.Assign DLP policies to specific users
E.Inherit the tenant-level DLP policy for all environments
AnswersB, C

Blocking connectors is a common DLP action.

Why this answer

Option B is correct because administrators can block specific connectors from being used in Power Automate flows as part of a DLP policy, preventing data from being shared with unauthorized services. Option C is correct because DLP policies can be scoped to a specific environment, allowing granular control over connector usage within that environment. This enables the administrator to enforce data protection rules tailored to different business contexts.

Exam trap

The trap here is that candidates often confuse environment-level DLP policy assignment with user-level assignment, or assume that tenant-level policies are automatically inherited by all environments, when in fact each environment can have its own independent DLP policy.

622
MCQhard

A model-driven app for inventory management uses a custom entity 'Warehouse'. The app maker added a subgrid showing 'Warehouse Items' related to the selected warehouse. However, the subgrid does not show any data even though there are items linked. What is the most likely cause?

A.The Warehouse form does not include the lookup field to Warehouse Items.
B.The user does not have read permissions on the Warehouse Items entity.
C.The relationship between Warehouse and Warehouse Items is not configured correctly or is missing.
D.The subgrid component is not supported on the main form.
AnswerC

Subgrids rely on a relationship to filter related records; without it, no data appears.

Why this answer

The subgrid must have a relationship defined between Warehouse and Warehouse Items; if the relationship is missing or incorrectly configured, the subgrid will not display related records. Option A is wrong because security roles affect visibility, not relationship. Option C is wrong because the subgrid does not require lookup field on the main form.

Option D is wrong because subgrids can be added to forms.

623
MCQmedium

An organization uses Microsoft Power Platform and wants to enforce data loss prevention (DLP) policies across all environments. They need to block the use of a specific third-party connector in all environments. What should the administrator do?

A.Create a DLP policy for each environment and block the connector
B.Create a custom connector with the same name and block it
C.Remove the connector from the default solution
D.Create a tenant-level DLP policy that blocks the connector
AnswerD

A tenant-level DLP policy applies to all environments.

Why this answer

Option D is correct because DLP policies in Microsoft Power Platform can be configured at the tenant level to apply across all environments. By creating a tenant-level DLP policy and blocking the specific third-party connector, the administrator ensures consistent enforcement without needing to manage individual environment policies. This approach centralizes control and prevents the connector from being used in any environment.

Exam trap

The trap here is that candidates often assume DLP policies must be created per environment, overlooking the tenant-level scope that provides centralized enforcement across all environments.

How to eliminate wrong answers

Option A is wrong because creating a DLP policy for each environment is inefficient and error-prone; it requires manual replication across environments and does not guarantee uniform enforcement if environments are added or missed. Option B is wrong because creating a custom connector with the same name does not block the original third-party connector; custom connectors are separate entities and blocking a custom connector does not affect the built-in or certified connector. Option C is wrong because removing a connector from the default solution does not block its use; connectors are not managed through solutions in that way, and removal from a solution only affects solution components, not connector availability in environments.

624
Matchingmedium

Match each Microsoft Power Platform component to its primary purpose.

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

Concepts
Matches

Build custom apps with low code

Automate workflows and processes

Visualize and analyze data

Create AI-powered chatbots

Build external-facing websites

Why these pairings

These are the five main components of Microsoft Power Platform.

625
MCQeasy

A business analyst wants to build an app quickly using a pre-built template. Which Power Apps capability should they use?

A.Create a Model-driven app from a Dataverse table
B.Use Power Automate to generate the app
C.Use a Power Apps template from the template gallery
D.Create a Canvas app from blank
AnswerC

Templates provide a starting point with pre-built functionality.

Why this answer

Option C is correct because Power Apps offers templates for common scenarios. Canvas apps from blank require more effort. Model-driven apps are not template-based.

Power Automate is for workflows.

626
MCQmedium

A company wants to build a Power Apps canvas app for field technicians to report equipment issues. The app must allow offline data entry and sync when connectivity is restored. Which feature should the developer enable?

A.Use a Power Automate flow to queue data submissions
B.Configure the app to store data in a SharePoint list
C.Use the Common Data Service (Dataverse) offline sync
D.Enable the 'Offline' feature in the app settings
AnswerD

Power Apps canvas apps have an Offline feature that caches data for offline use and syncs later.

Why this answer

Power Apps mobile app supports offline capabilities by enabling the 'Offline' feature, which allows data to be cached and synced later. Option D is correct. Option A is wrong because Power Automate flows can be triggered online but do not provide offline data caching.

Option B is wrong because SharePoint lists require network connectivity unless using a third-party sync tool. Option C is wrong because the Common Data Service (Microsoft Dataverse) supports offline sync only when the app is explicitly configured for offline use, but the question asks about the feature to enable in the app.

627
MCQhard

An organization uses Power Automate flows that connect to Microsoft SharePoint Online and Microsoft Dataverse. The security team requires that all connections to Dataverse use service principal authentication instead of user credentials. The administrator needs to ensure that flows relying on Dataverse connections continue to work after the change. What should the administrator do?

A.Create a new environment and migrate flows there
B.Register a service principal in Microsoft Entra ID and update connection references in the flows' solution
C.Recreate all flows with a shared connection using a service principal
D.Delete existing connections and ask users to create new ones
AnswerB

This allows flows to authenticate using the service principal.

Why this answer

Service principal authentication in Power Automate requires registering an application in Microsoft Entra ID (formerly Azure AD) and using its credentials to authenticate to Dataverse. Updating the connection references in the flows' solution to point to a service principal-based connection ensures all flows continue to work without requiring user credentials, meeting the security team's requirement.

Exam trap

The trap here is that candidates may think recreating flows or migrating environments is necessary, when in fact the solution-level connection reference can be updated to switch authentication methods without rebuilding the flows.

How to eliminate wrong answers

Option A is wrong because creating a new environment and migrating flows does not change the authentication method; the flows would still use user credentials unless the connection references are updated. Option C is wrong because recreating all flows is unnecessary and inefficient; the existing flows can be updated by modifying their connection references to use a service principal connection. Option D is wrong because deleting existing connections and asking users to create new ones would disrupt operations and still rely on user credentials, not service principal authentication.

628
Drag & Dropmedium

Drag and drop the steps to configure a Power Virtual Agents chatbot 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

After creating the bot, define topics, add nodes, test, then publish.

629
Multi-Selectmedium

Which TWO actions can be used to implement error handling in a Power Automate flow?

Select 2 answers
A.Use a Scope action to group actions and configure error handling
B.Add a Condition action to check for errors
C.Use a Compose action to store error details
D.Configure Run After settings
E.Add an Apply to Each action
AnswersA, D

Scope allows parallel branches and combined error handling.

Why this answer

Options A and C are correct because Configure Run After and Scope allow error handling. Option B is wrong because it's for actions. Option D is wrong because Conditions are for logic.

Option E is wrong because it's not for error handling.

630
MCQeasy

A user reports they cannot create a new environment in the Power Platform admin center. What is the most likely reason?

A.The tenant has insufficient trial capacity.
B.The user does not have a Power Apps license.
C.The user lacks the Environment Admin or Global Admin role.
D.The user's network blocks the Power Platform admin center.
AnswerC

Only admins can create environments.

Why this answer

Creating a new environment in the Power Platform admin center requires the user to have either the Environment Admin or Global Admin role in Microsoft Entra ID (formerly Azure AD). These roles grant the necessary permissions to provision environments, manage settings, and assign security roles. Without one of these roles, the 'New environment' button will be grayed out or the operation will fail with an access denied error.

Exam trap

The trap here is that candidates often assume a Power Apps license is sufficient to perform all admin tasks, but Microsoft explicitly separates licensing (for using apps) from administrative roles (for managing environments).

How to eliminate wrong answers

Option A is wrong because insufficient trial capacity prevents the creation of a trial environment, but the question does not specify that the user is trying to create a trial environment; the user could be attempting to create a production or sandbox environment, which do not rely on trial capacity. Option B is wrong because a Power Apps license is required to use Power Apps, but creating environments in the admin center is a management task that depends on administrative roles, not on having a Power Apps license assigned. Option D is wrong because while network blocks could prevent accessing the admin center URL, the user reports they cannot create a new environment, implying they can access the admin center but the creation action fails, which points to a permissions issue rather than a connectivity problem.

631
MCQmedium

A Power Pages site has a page that displays a chart summarizing sales data. The chart is built using a Dataverse view. The sales data changes frequently. What must be configured to ensure the chart updates automatically?

A.No additional configuration is needed; the chart updates automatically
B.Set the chart's cache duration to 0 in the site settings
C.Schedule a Power Automate flow to refresh the chart every hour
D.Configure the chart to use a real-time data stream via Power Automate
AnswerA

Charts based on Dataverse views automatically reflect real-time data changes.

Why this answer

Option B is correct because Power Pages charts automatically reflect changes in the underlying Dataverse view. Option A is wrong because manual refresh is not required. Option C is wrong because Power Automate is not needed for chart updates.

Option D is wrong because there is no specific cache setting for charts; page caching may delay updates but not prevent them.

632
MCQhard

Refer to the exhibit. The JSON describes a Power Apps function. What is the correct usage of this function to return a date 7 days from today?

A.AddDays(7; Today())
B.AddDays(Today(), 7)
C.AddDays(7, Today())
D.AddDays('7', Today())
AnswerC

Correct order: interval then date.

Why this answer

Option B is correct because the function takes the number of days first, then the date. Option A swaps the order. Option C uses incorrect syntax.

Option D is not a valid function call.

633
MCQhard

Refer to the exhibit. A Power Pages site has a web role called 'Partner' with permissions to read the Proposal table and read/write the Invoice table. A user assigned the Partner role attempts to create a new record in the Proposal table. What will happen?

A.The user is denied access because the Partner role does not exist
B.The user is allowed to create the record because the Partner role implicitly includes Write on all tables
C.The user is denied access because the Partner role has only Read permission on the Proposal table
D.The user is allowed to create the record because Write permission is granted on the Invoice table
AnswerC

Write permission is required to create records, and it is not granted.

Why this answer

Option B is correct because the Partner role only has Read permission on the Proposal table, so create (Write) is not allowed. Option A is wrong because the role exists. Option C is wrong because the write is not allowed on Proposal.

Option D is wrong because there is no global permission that would override this.

634
MCQhard

You are a Power Platform administrator. A user reports that they cannot create a new environment in the Power Platform admin center. The user has a Power Apps per user plan license. What is the most likely reason?

A.The user does not have access to the Power Platform admin center.
B.The user is not a global administrator in Microsoft Entra ID.
C.The user has not assigned the license to themselves.
D.The user does not have a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2.
AnswerD

Per user plan does not include environment creation; need Plan 2 or trial.

Why this answer

Option D is correct because creating environments in the Power Platform admin center requires a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2. The user's Power Apps per user plan license only allows them to use apps and flows, not to create or manage environments. Without the appropriate license, the environment creation option is disabled in the admin center.

Exam trap

The trap here is that candidates often assume any Power Apps license grants full admin center access, but Microsoft deliberately restricts environment creation to higher-tier plans to enforce capacity management and security boundaries.

How to eliminate wrong answers

Option A is wrong because the user can access the Power Platform admin center with any Power Apps license, but their license type restricts what they can do there. Option B is wrong because being a global administrator in Microsoft Entra ID is not required to create environments; the user needs the appropriate Power Platform license or a system administrator role in the environment. Option C is wrong because the user has already assigned the license to themselves (as stated in the question), and the issue is not about license assignment but about the license type lacking environment creation rights.

635
MCQeasy

You need to create a flow that sends a push notification to a user's mobile device when a high-priority email arrives in their inbox. Which trigger and action combination should you use?

A.When an item is created trigger and Post message action
B.When a new email arrives trigger and Send push notification action
C.When an approval request is triggered and Send email action
D.Recurrence trigger and Send email action
AnswerB

This directly addresses the requirement.

Why this answer

Option D is correct because the 'When a new email arrives' trigger with 'Send push notification' action meets the requirement. Option A uses a schedule, not event-driven. Option B uses SharePoint trigger.

Option C uses approval, not notification.

636
MCQhard

An app maker creates a canvas app that uses a Dataverse table with 100,000 records. The app includes a gallery that displays all records. Users experience long load times. What should the app maker do to improve performance without changing the data source?

A.Use delegable functions in the gallery's Items property
B.Switch to a SharePoint list as the data source
C.Increase the data row limit in Dataverse settings
D.Remove all filters from the gallery
AnswerA

Delegable filters push processing to the server, improving performance.

Why this answer

Option C is correct because using delegable filters ensures that only relevant data is retrieved, reducing load. Option A is wrong because removing filters could increase data load. Option B is wrong because increasing the data row limit in Dataverse may not help; the issue is delegation.

Option D is wrong because using a different data source is not allowed.

637
MCQeasy

An organization needs a Power App that allows employees to submit expense reports by filling out a form and attaching receipts. Which type of app should you create and why?

A.Canvas app, because it provides flexible form design and supports file attachments
B.Model-driven app, because it uses standard Dataverse forms
C.AI Builder app, because it can process receipts automatically
D.Power Apps portal, because it allows external users to submit expenses
AnswerA

Canvas apps allow custom layouts and attachment controls.

Why this answer

Option A is correct because canvas apps are best for custom form-based interfaces with file uploads. Option B is wrong because model-driven apps are form-based but primarily for data management, not custom input forms. Option C is wrong because portal apps are for external users.

Option D is wrong because AI Builder is not an app type.

638
MCQmedium

Refer to the exhibit. The JSON shows a snippet of a DLP policy. Which effect will this policy have on a Power Automate flow that uses Google Sheets and Dropbox connectors?

A.The flow will be blocked because it uses blocked connectors.
B.The flow will run but the connection references will be deleted.
C.The flow will be blocked only if it uses both connectors together.
D.The flow will run normally but will be restricted to the production environment only.
AnswerA

Both connectors are blocked, so any flow using them will not run.

Why this answer

The DLP policy in the exhibit defines a 'Blocked' connector group that includes both Google Sheets and Dropbox. In Power Automate, when a flow uses any connector listed in a blocked group, the flow is prevented from running. Since the flow uses both blocked connectors, it will be blocked entirely, regardless of whether they are used together or separately.

Exam trap

The trap here is that candidates may think DLP policies only block flows when multiple connectors from different groups are combined (cross-group sharing), but in reality, any connector placed in the 'Blocked' group alone is sufficient to block the flow entirely.

How to eliminate wrong answers

Option B is wrong because DLP policies do not delete connection references; they block the execution of flows that use blocked connectors. Option C is wrong because the policy blocks any flow that uses a blocked connector individually; it does not require both connectors to be used together. Option D is wrong because DLP policies apply across all environments unless specifically scoped, and the policy does not restrict the flow to a production environment—it blocks it entirely.

639
Multi-Selecthard

Which THREE components are part of the Power Platform environment lifecycle management?

Select 3 answers
A.Environment creation
B.Environment deletion
C.Creating users in Microsoft Entra ID
D.Environment backup and restore
E.Publishing Power BI reports
AnswersA, B, D

Creating environments is a key lifecycle operation.

Why this answer

Environment creation is a core component of Power Platform environment lifecycle management because it establishes the isolated container where apps, flows, and data reside. The lifecycle begins when an administrator provisions a new environment, which sets up a dedicated Dataverse database, security boundaries, and resource limits. Without creation, no subsequent lifecycle operations (backup, restore, deletion) can occur.

Exam trap

The trap here is that candidates confuse operational tasks (like creating users or publishing reports) with environment lifecycle management, which strictly covers the creation, deletion, backup, and restore of the environment itself, not activities that occur within it.

640
Multi-Selectmedium

Which THREE components are part of Microsoft Power Platform?

Select 3 answers
A.Power Virtual Agents
B.Azure DevOps
C.Power Apps
D.Power Automate
E.Power BI
AnswersC, D, E

For building custom apps.

Why this answer

Power Apps is a core component of Microsoft Power Platform, enabling users to build custom low-code applications for web and mobile. It integrates seamlessly with other platform components like Power Automate and Power BI to create end-to-end business solutions.

Exam trap

The trap here is that candidates often confuse Power Virtual Agents as a core platform component because it is bundled in some Power Platform licenses, but it is technically an AI builder capability, not one of the four foundational pillars (Power Apps, Power Automate, Power BI, Power Pages).

641
Multi-Selecthard

Which THREE actions can be performed by using Power Apps component framework (PCF) in a model-driven app?

Select 3 answers
A.Add a client-side script that runs on field change
B.Implement data validation using Dataverse Web API
C.Build a custom input control with complex UI elements
D.Change the layout of the main form using drag and drop
E.Configure a business rule to set field values
.Create a custom visualization that calls an external API
AnswersB, C

PCF controls can interact with Dataverse Web API.

Why this answer

Option B is correct because Power Apps component framework (PCF) allows developers to create custom components that can interact with the Dataverse Web API to perform data validation. This is achieved by using the `context.webAPI` methods within a PCF component, enabling server-side validation logic beyond simple client-side scripts.

Exam trap

The trap here is that candidates confuse PCF's ability to call the Dataverse Web API with traditional client-side scripting (Option A), but PCF is specifically for building reusable custom controls, not for attaching scripts to field events.

642
MCQeasy

A Power Pages site needs to display a map showing the locations of company offices stored in Dataverse. Which component should be used to embed the map?

A.A custom JavaScript component using a mapping API
B.A Power Automate flow that generates an image
C.A Power Virtual Agents chatbot
D.A Power BI report embedded in the page
AnswerA

Custom JavaScript can integrate with mapping services like Bing Maps.

Why this answer

Option A is correct because Power Pages supports embedding custom code like JavaScript map APIs. Option B is wrong because Power BI can embed reports but not directly a map from Dataverse coordinates. Option C is wrong because Power Virtual Agents is for chatbots.

Option D is wrong because Power Automate can trigger actions but not display a map.

643
MCQhard

A user sees the exhibit error when opening a Power BI report in the service. What is the most likely cause?

A.The scheduled refresh failed due to credentials
B.The on-premises data gateway is offline
C.The dataset was deleted from the workspace
D.The data source connection in the service was modified
AnswerD

This error indicates the dataset cannot find the data source.

Why this answer

The error shown in the exhibit is a typical 'Couldn't load the data for this visual' message that occurs when the data source connection defined in the Power BI service has been changed (e.g., server name, database name, or authentication method) but the report's underlying dataset still references the old connection. This mismatch prevents the service from retrieving data, even if the gateway is online and credentials are valid. Option D is correct because modifying the data source connection in the service without updating the dataset's connection string breaks the data retrieval pipeline.

Exam trap

The trap here is that candidates often confuse a data source connection modification error with a gateway offline error, because both can prevent data loading, but the gateway error is specific to on-premises connectivity while the connection modification error occurs even with cloud data sources.

How to eliminate wrong answers

Option A is wrong because a scheduled refresh failure due to credentials would produce a specific 'Credentials are invalid' or 'Refresh failed' error in the refresh history, not a generic 'Couldn't load the data' error on the report canvas. Option B is wrong because an offline on-premises data gateway would generate a 'Gateway not reachable' or 'Gateway offline' error message, not a data source connection error. Option C is wrong because if the dataset were deleted from the workspace, the report would show a 'Dataset not found' or 'We couldn't find the dataset' error, not a data loading failure that implies the dataset exists but cannot connect.

644
MCQhard

A Power Pages site is experiencing slow load times for a page that displays a list of products from a Dataverse table. The page uses a Liquid template with a fetch query that retrieves all products without filtering. Which change would most improve performance?

A.Enable the content delivery network (CDN) for the site.
B.Adjust the page caching settings in the Power Pages admin center.
C.Replace the Liquid template with the out-of-the-box list component.
D.Modify the fetch query in the Liquid template to include a filter, such as only active products.
AnswerD

Filtering reduces the dataset returned, improving page load time.

Why this answer

Option B is correct because adding a filter to the fetch query reduces the amount of data retrieved, which improves load times. Option A is wrong because the page caching settings in the Power Pages admin center cache the entire page, but if the data changes frequently, caching may not be appropriate. Option C is wrong because the out-of-the-box list component may still load all data.

Option D is wrong because enabling CDN helps with static content, not dynamic data from Dataverse.

645
MCQmedium

You are reviewing a Power Automate flow definition. The flow should send an email when a new invoice file is added to a SharePoint folder. However, the flow is not triggering. What is the most likely cause?

A.The folder path '/documents/invoices' is incorrect or the flow lacks permissions.
B.The email action uses an incorrect dynamic expression.
C.The flow needs a 'Get file content' action before sending email.
D.The SharePoint trigger requires a 'When a file is created or modified' trigger instead.
AnswerA

Incorrect folder path or permissions can prevent triggering.

Why this answer

The most likely cause is that the folder path '/documents/invoices' is incorrect or the flow lacks permissions. Power Automate triggers for SharePoint require exact folder paths and appropriate access rights to monitor file additions. If the path is misspelled, uses a relative path instead of a server-relative path, or the service account does not have read permissions on the folder, the trigger will not fire.

Exam trap

The trap here is that candidates often assume the trigger type is wrong (option D) because they confuse 'created or modified' with 'created only', but the real issue is typically a misconfigured folder path or permissions, not the trigger selection.

How to eliminate wrong answers

Option B is wrong because an incorrect dynamic expression in the email action would cause the email to fail or send incorrect data, but it would not prevent the flow from triggering. Option C is wrong because the 'Get file content' action is only needed if you want to process the file's binary data; the trigger itself provides metadata about the new file, and sending an email does not require file content. Option D is wrong because the 'When a file is created or modified' trigger is actually the correct trigger for detecting new files; the issue is not the trigger type but the folder path or permissions.

646
MCQmedium

Refer to the exhibit. A Power Pages web role configuration snippet is shown. What access does this web role grant to the 'incident' entity?

A.Read all incidents, write incidents related to the user, and create new incidents.
B.No access because the scope is set to Contact.
C.Only read incidents related to the user's contact.
D.Read, write, and create all incident records globally.
AnswerA

Read Global, write Deep (related to contact), create Global.

Why this answer

The configuration grants read, write, and create privileges with different scopes. Read and create are Global (all records), write is Deep (records owned by user's business unit). Scope 'Contact' means records related to the user's contact record.

647
MCQmedium

A multinational corporation uses Power Platform extensively. They have multiple environments: DEV, TEST, UAT, STAGING, and PROD. A developer accidentally published a Power App that connects to a SQL Server database using an unapproved connector in the PROD environment. The organization has strict data governance policies that require all connections to use approved connectors only. The admin needs to block this connector in PROD while still allowing it in other environments. What should the admin do?

A.Create a tenant-level DLP policy that blocks the connector for all environments.
B.Remove the developer's permissions to the PROD environment.
C.Delete the Power App from PROD.
D.Create an environment-level DLP policy for PROD that blocks the connector.
AnswerD

Environment-level policies can block connectors in specific environments without affecting others.

Why this answer

Environment-level DLP policies allow blocking connectors in specific environments. The admin should create an environment-level DLP policy for PROD that blocks the unapproved connector. This overrides the tenant-level policy that might allow it elsewhere.

648
MCQhard

An organization wants to implement AI-driven insights for sales forecasting using historical data. Which Power Platform capability should they use?

A.Power BI Quick Insights
B.Microsoft Copilot Studio
C.Power Apps with Dataverse
D.Power Automate with AI Builder
AnswerD

AI Builder provides prebuilt and custom AI models that can be used in Power Automate for forecasting.

Why this answer

Option D is correct because AI Builder within Power Automate provides prebuilt AI models (e.g., prediction models) that can analyze historical sales data to generate forecasts. This capability is specifically designed for integrating AI-driven insights into automated workflows without requiring custom machine learning development.

Exam trap

The trap here is that candidates often confuse Power BI's descriptive analytics (Quick Insights) with predictive forecasting, overlooking that AI Builder is the dedicated Power Platform component for building and consuming custom predictive models without code.

How to eliminate wrong answers

Option A is wrong because Power BI Quick Insights provides automated data exploration and pattern discovery (e.g., trends, outliers) but does not generate predictive sales forecasts from historical data; it focuses on descriptive analytics, not predictive modeling. Option B is wrong because Microsoft Copilot Studio is designed for building conversational AI agents (chatbots) and does not include predictive analytics or sales forecasting capabilities. Option C is wrong because Power Apps with Dataverse enables custom app development and data storage but lacks built-in AI forecasting; it would require additional services (e.g., AI Builder or Azure Machine Learning) to implement predictive insights.

649
MCQhard

An organization has deployed a Power Automate flow that processes sensitive customer data. The security team requires that the flow's connections use managed identities instead of user credentials. What should the administrator do?

A.Share the flow with the security team and have them modify the connections.
B.Use a service principal with a certificate and store the certificate in the flow's environment.
C.Store the user credentials in Azure Key Vault and reference them in the flow.
D.Use managed identities for the connections where supported.
AnswerD

Managed identities provide secure, credential-free authentication for supported connectors.

Why this answer

Option D is correct because managed identities in Power Automate allow connections to authenticate to Azure resources without storing credentials, directly addressing the security team's requirement to avoid user credentials. Managed identities are a secure, Azure AD-backed identity that can be assigned to a flow or environment, eliminating the need for shared secrets or user context.

Exam trap

The trap here is that candidates often confuse managed identities with service principals or Key Vault integration, thinking any secretless approach qualifies, but managed identities specifically eliminate the need for any stored credential or certificate.

How to eliminate wrong answers

Option A is wrong because sharing the flow with the security team and having them modify connections does not remove user credentials; it merely shifts the credential management burden and still relies on user identities. Option B is wrong because using a service principal with a certificate still requires certificate management and storage, which is not a managed identity and introduces additional complexity and secret rotation overhead. Option C is wrong because storing user credentials in Azure Key Vault and referencing them in the flow still uses user credentials, not managed identities, and violates the requirement to avoid user credentials entirely.

650
MCQmedium

Your organization uses Power Automate to automate the creation of support tickets in ServiceNow when a critical alert is triggered in Microsoft Sentinel. The flow uses the 'When a new alert is created' trigger from Sentinel. The flow runs but no tickets are created. You check the Sentinel log and see that alerts are being generated. What should you investigate first?

A.Verify that the flow is enabled.
B.Ensure that the Sentinel data connector is properly installed.
C.Review the trigger condition or filter query.
D.Check if the ServiceNow connector is configured with the correct instance.
AnswerC

Filter may exclude critical alerts.

Why this answer

Option D is correct because the flow's trigger filter may be set to only fire for specific severity levels, and critical alerts might be filtered out if the filter is misconfigured. Option A is wrong because the flow runs, so the trigger fires. Option B is wrong because the ServiceNow connection could be fine.

Option C is wrong because the alert creation is not the issue.

651
MCQhard

An organization is configuring a custom connector in Power Automate to connect to Salesforce. The exhibit shows a snippet of the connector definition. However, when attempting to test the connection, the authentication fails. What is the most likely cause?

A.The OAuth flow type is incorrectly set to 'accessCode' instead of 'authorizationCode'.
B.The scopes array is missing the 'id' scope.
C.The apiVersion is not supported by Power Automate.
D.The serviceUrl should point to the Salesforce instance, not login.salesforce.com.
AnswerA

The correct OAuth flow for authorization code is 'authorizationCode'.

Why this answer

Option A is correct because the OAuth 2.0 flow type 'accessCode' is not a valid OAuth 2.0 grant type. The correct value for the authorization code grant type is 'authorizationCode'. Power Automate custom connectors require this exact string to properly initiate the OAuth 2.0 authorization code flow with Salesforce.

Using 'accessCode' causes the authentication handshake to fail because the connector cannot map the flow to a supported OAuth grant.

Exam trap

The trap here is that candidates may assume 'accessCode' is a valid OAuth flow type because it appears in some third-party documentation or older samples, but the PL-900 exam expects the exact OAuth 2.0 standard term 'authorizationCode' as used in Power Automate custom connector definitions.

How to eliminate wrong answers

Option B is wrong because the 'scopes' array does not require an 'id' scope; Salesforce OAuth scopes are defined by the connected app and typically include 'api', 'refresh_token', and 'offline_access' but not 'id' unless specifically needed for OpenID Connect. Option C is wrong because Power Automate supports multiple Salesforce API versions (e.g., v58.0, v59.0) and an unsupported version would cause a different error (e.g., 404 or version mismatch), not an authentication failure. Option D is wrong because 'login.salesforce.com' is the correct OAuth token endpoint for Salesforce production instances; pointing to a specific instance URL would break the token exchange because the OAuth endpoint must be the global login URL for token issuance.

652
MCQmedium

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

A.The SortByColumns function is used incorrectly.
B.The First function cannot be used on a filtered result.
C.The formula is not delegable and returns incomplete data.
D.The column name in the formula uses a space and may be incorrect.
AnswerD

If the actual column is 'AccountName', the filter fails.

Why this answer

Option D is correct because the formula references a column name with a space ('Account Name') without using single-quote delimiters. In Power Apps, when a column name contains a space, it must be enclosed in single quotes (e.g., 'Account Name') to be parsed correctly. Without the quotes, Power Apps interprets the space as a separator, causing the lookup to fail and the condition to evaluate as false, always falling back to 'No records found'.

Exam trap

The trap here is that candidates often assume the issue is delegation (Option C) because 'No records found' suggests a data limit, but the real problem is a syntax error in referencing a column with a space, which is a subtle and easily overlooked detail in Power Apps formulas.

How to eliminate wrong answers

Option A is wrong because the SortByColumns function is used correctly here; it sorts the filtered table by the 'Created On' column in descending order, which is syntactically valid and not the cause of the issue. Option B is wrong because the First function can absolutely be used on a filtered result; it returns the first record of a table, and there is no restriction preventing its use after a Filter or SortByColumns. Option C is wrong because the formula is fully delegable—Filter, SortByColumns, and First are all delegable operations in Power Apps for supported data sources like Dataverse or SQL Server—so incomplete data due to delegation limits is not the problem here.

653
MCQmedium

A model-driven app includes a custom entity 'Project' with a lookup to 'Account'. Users need to see the account name and phone number on the Project form. What is the best way to display these fields?

A.Use a calculated field on the Project entity
B.Create a new main form for the Project entity
C.Add the account fields directly to the Project entity
D.Add a quick view form for the Account entity
AnswerD

Quick view form shows related data inline.

Why this answer

Option B is correct because a quick view form displays related data from the lookup entity without custom code. Option A is incorrect because it would require duplicating fields. Option C is for adding new forms, not displaying related data.

Option D is for fields on the same entity.

654
MCQhard

An organization uses Power BI to analyze sales data. They notice that the report takes over a minute to load, and they need to improve performance quickly without changing the data source. Which action should they take?

A.Change the data source to use DirectQuery instead of Import.
B.Implement data aggregations in Power BI.
C.Reduce the number of visuals on the dashboard.
D.Create a new composite model.
AnswerC

Fewer visuals reduce the number of queries and rendering time.

Why this answer

Option C is correct because reducing the number of visuals on a Power BI dashboard directly decreases the number of queries sent to the data model and the rendering workload, which can significantly improve load times without altering the data source. This is the quickest performance optimization available when the data source cannot be changed, as each visual typically triggers separate DAX queries and rendering processes.

Exam trap

The trap here is that candidates often assume performance issues must be solved by changing the data connectivity mode (DirectQuery vs. Import) or by adding aggregations, but the quickest and simplest fix—reducing visual count—is overlooked because it seems too trivial.

How to eliminate wrong answers

Option A is wrong because switching from Import to DirectQuery would likely worsen performance for a report that already takes over a minute to load, as DirectQuery sends live queries to the data source for every interaction, increasing latency and load on the source system. Option B is wrong because implementing data aggregations requires modifying the data model and often involves creating pre-summarized tables, which is not a quick fix and may not be feasible without changing the data source structure. Option D is wrong because creating a new composite model involves combining DirectQuery and Import modes, which adds complexity and does not provide an immediate performance improvement; it also requires changes to the data source connection.

655
MCQhard

A Power Apps developer needs to create an app that uses AI Builder to extract information from invoices. The app should allow users to upload an image and then display extracted fields. Which control should be used to capture the image?

A.Camera control
B.Add picture control
C.Image control
D.Button control
AnswerB

Allows users to upload an image.

Why this answer

The Add picture control allows users to upload or take a photo. Option D is correct. Option A is wrong because the Camera control captures live video but not file upload.

Option B is wrong because the Image control displays images. Option C is wrong because the Button control does not capture images.

656
MCQmedium

A company uses Power Automate to send approval emails when a new employee is added to Microsoft Entra ID. The approval flow fails intermittently with a '403 Forbidden' error. What is the most likely cause?

A.The Microsoft Entra ID license has expired.
B.The flow is exceeding the API request throttle limit.
C.The connection used in the flow lacks appropriate permissions.
D.The Power Automate connector for Microsoft Entra ID is deprecated.
AnswerC

403 Forbidden indicates the authenticated identity does not have permission to perform the action.

Why this answer

Option B is correct because a 403 error typically indicates insufficient permissions. Option A is wrong because throttling causes 429 errors. Option C is wrong because license issues cause 402 errors.

Option D is wrong because connector issues cause 400 or 500 errors.

657
MCQmedium

Refer to the exhibit. A Power BI report connecting to the SalesDB database is slow. The exhibit shows a SQL Server activity snapshot. What is the most likely cause of the performance issue?

A.The database server has insufficient memory
B.SPID 55 is blocked by SPID 54, causing delays
C.The SELECT query (SPID 55) is performing a table scan
D.The sleeping session (SPID 54) is using too much CPU
AnswerB

BlkBy column shows SPID 55 is blocked by SPID 54.

Why this answer

The exhibit shows SPID 55 (a SELECT query) in a 'suspended' state with a non-zero 'blocked_by' column value of 54, indicating it is waiting for a lock held by SPID 54. SPID 54 is in a 'sleeping' state but still holds locks, which blocks SPID 55 from proceeding. This blocking chain directly causes the report's slow performance, as the Power BI query cannot complete until the blocking session releases its locks.

Exam trap

The trap here is that candidates see SPID 54 as 'sleeping' and assume it is idle and harmless, missing that it still holds locks that block other queries, which is the root cause of the performance issue.

How to eliminate wrong answers

Option A is wrong because insufficient memory would typically manifest as high page life expectancy or memory pressure counters, not as a specific SPID being blocked by another; the exhibit shows no memory-related metrics. Option C is wrong because while a table scan could cause slow performance, the exhibit explicitly shows SPID 55 is 'suspended' due to being blocked (blocked_by = 54), not actively running a scan; a table scan would appear as a 'runnable' or 'running' state with high logical reads. Option D is wrong because a sleeping session (SPID 54) uses negligible CPU; the issue is that it holds locks that block other sessions, not its CPU consumption.

658
MCQmedium

Refer to the exhibit. A Power Pages site is configured with the given authentication settings. When a user clicks 'Sign In', they are redirected to Microsoft Entra ID, but after successful login, they are redirected back to the site and see an error. What is the most likely cause?

A.The clientId is invalid.
B.The tenantId is incorrect.
C.The redirectUrl is not registered in the Microsoft Entra ID app.
D.The site requires HTTPS but is using HTTP.
AnswerC

The redirect URL must match the app registration.

Why this answer

The redirectUrl must be registered as a reply URL in the Microsoft Entra ID app registration. If it is missing, the login fails.

659
MCQmedium

An organization uses a Canvas app to capture customer feedback. The app writes data to a Dataverse table. Recently, users have been submitting duplicate records due to double-clicking the submit button. What is the best way to prevent duplicates?

A.Set the form to require a unique ID before submission
B.Disable the submit button after the first click using the DisplayMode property
C.Add a business rule to check for duplicates before saving
D.Use a Power Automate flow to delete duplicates after creation
AnswerB

Setting DisplayMode to Disabled immediately after click prevents further submissions.

Why this answer

Option D is correct because disabling the button after the first click prevents duplicate submissions. Option A would require significant changes. Option B is not feasible in Canvas apps.

Option C would not prevent duplicates on the same click.

660
MCQmedium

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

A.Power Automate only
B.Power Apps only
C.Power Apps, Power Automate, and Power BI
D.Power BI only
AnswerC

Power Apps provides the mobile input form, Power Automate automates data processing, and Power BI provides real-time dashboards.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

661
MCQeasy

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

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

Power Apps allows building low-code mobile apps that can integrate with Teams.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

662
MCQmedium

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

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

AI Builder extracts data from invoices; Power Automate updates SharePoint.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

663
MCQmedium

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

A.Power Automate
B.Power Apps portal (now Power Pages)
C.Power Virtual Agents
D.Power BI
AnswerB

Power Pages enables building external websites with Dataverse integration for partner submissions.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

664
Multi-Selecteasy

Which TWO data sources can be used directly in a canvas app without a premium connector? (Choose two.)

Select 2 answers
A.Salesforce
B.Microsoft Dataverse
C.Excel Online (Business)
D.SQL Server
E.SharePoint
AnswersB, E

Dataverse is a standard connector.

Why this answer

Common data services (Dataverse) and SharePoint are standard connectors. SQL Server (C) requires premium, Salesforce (D) premium, and Excel Online (E) requires premium.

665
MCQmedium

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

A.SQL Server connector directly
B.Power Automate on-premises agent
C.Dataverse
D.On-premises data gateway with SQL Server connector
AnswerD

The gateway securely connects Power Apps to on-premises SQL Server.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

666
MCQeasy

A sales manager wants a mobile app to view customer details and open orders. The app should be built quickly without custom code. Which approach should they use?

A.Create a model-driven app from Dataverse
B.Build a canvas app from scratch
C.Use Power BI to create a mobile dashboard
D.Use Power Automate to create a mobile flow
AnswerA

Model-driven apps are generated automatically from data models.

Why this answer

Option B is correct because model-driven apps are built from Dataverse and provide a responsive interface quickly. Canvas apps require more design effort. Power Automate is for automation, not apps.

Power BI is for analytics.

667
Multi-Selecteasy

Which TWO components are required to create a Power Automate flow that sends an email when a new item is added to a SharePoint list? (Choose two.)

Select 2 answers
A.A trigger
B.An approval action
C.A variable
D.A condition
E.A Send an email action
AnswersA, E

Correct. Every flow needs a trigger.

Why this answer

A trigger is required because a Power Automate flow must have a starting event to initiate execution. For a SharePoint list, the 'When an item is created' trigger fires automatically when a new item is added, which is the necessary first step before any actions can run.

Exam trap

The trap here is that candidates often think a condition or approval is needed for any 'smart' automation, but the question only asks for the minimum components to send an email on item creation, which is just a trigger and an action.

668
MCQmedium

A manufacturing company uses Power Apps to manage inventory tracking. The current app is a canvas app connected to a SharePoint list. The operations team needs to add a new feature that allows warehouse staff to scan barcodes using a mobile device camera to look up product details. Additionally, the app must work offline in areas with no internet connectivity and sync data when connectivity is restored. The app should also incorporate a Copilot assistant to help staff quickly find product information using natural language queries. The IT department requires that the app be deployed to all warehouse staff without requiring manual installation. Which approach should you take to meet all requirements?

A.Add a Text input control for manual barcode entry, use Power Automate flows to fetch product details, enable offline by storing data locally in collections, and deploy by sending a deep link.
B.Use a Power Fx formula with the Camera control to decode barcodes, enable offline data in SharePoint lists, add a Copilot chat box, and deploy via Microsoft Intune as a required app.
C.Add the Barcode scanner control to the canvas app, enable offline mode in app settings, integrate Copilot using the Copilot control, and deploy the app by sharing it via email link.
D.Add the Barcode scanner control, configure the app for offline use with sync, integrate Copilot using the AI Builder 'Ask a question' component, and deploy the app via Power Apps mobile app with a managed solution and installation policy.
AnswerD

All requirements are met: barcode scanning, offline sync, Copilot, and automatic deployment.

Why this answer

Option D is correct because it combines the Barcode scanner control for camera-based scanning, offline capabilities via Power Apps mobile app with offline sync, Copilot in Power Apps for natural language queries, and automatic deployment using a managed solution and Power Apps mobile app installation policy. Option A fails to address offline and Copilot requirements. Option B uses Power Fx formula, which is not a native barcode scanning method.

Option C uses Power Automate flows, which are not suitable for real-time offline scanning.

669
Multi-Selecteasy

Which TWO of the following are types of connectors available in Power Automate? (Select TWO.)

Select 2 answers
A.Standard
B.Custom
C.Enterprise
D.On-premises
E.Premium
AnswersA, E

Available with most Power Automate licenses.

Why this answer

A and D are correct. Standard connectors are available to all, and Premium connectors require additional licensing. B is incorrect because 'Enterprise' is not a connector tier.

C is incorrect because 'Custom' is a type of connector but not a licensing tier. E is incorrect because 'On-premises' describes data gateway, not a connector type.

670
MCQmedium

A Power Pages site needs to display a list of upcoming events from a Dataverse table. Only events with a start date greater than today should be shown. Which approach should be used to filter the data on the page?

A.Configure a view in Dataverse with a filter for start date > today and use that view on the page.
B.Use a Power Automate flow to remove past events from the table.
C.Use JavaScript on the page to hide past events after loading.
D.Create a calculated column in Dataverse to indicate future events.
AnswerA

Views provide server-side filtering and can be used in Power Pages lists.

Why this answer

Power Pages supports filtering lists using OData queries in the web template or using the List component's filter options.

671
MCQeasy

A company wants to build a custom app that allows employees to submit expense reports from their mobile devices. The app must be easy to customize and deploy without writing code. Which type of Power App should they use?

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

Correct: Canvas apps enable code-free, custom mobile app creation.

Why this answer

Canvas apps allow building custom, code-free apps that can run on mobile devices. Model-driven apps are more data-centric and require more configuration, while Power Pages is for external websites and Power Automate is for workflows.

672
MCQmedium

A company uses Microsoft Power Platform and requires that all environment creation requests go through an approval process. The security team wants to prevent non-admins from creating trial environments. What should the administrator configure?

A.In Power Platform Admin Center, set 'Disable trial environments created by non-admins' to Yes
B.Assign users to an environment group with restricted permissions
C.In Power Apps settings, disable 'Allow users to create environments'
D.Create a Data Loss Prevention (DLP) policy that blocks trial environments
AnswerA

This setting prevents non-admins from creating trial environments.

Why this answer

Option A is correct because the Power Platform Admin Center provides a dedicated tenant-level setting called 'Disable trial environments created by non-admins' that, when set to 'Yes', prevents users without administrative privileges from creating trial environments. This directly addresses the security team's requirement to block non-admins from creating trial environments, as it enforces an approval-based control at the environment creation level.

Exam trap

The trap here is that candidates often confuse DLP policies with environment lifecycle controls, assuming DLP can block environment creation, when in reality DLP only governs data connectors and policies across environments, not provisioning actions.

How to eliminate wrong answers

Option B is wrong because environment groups (or environment routing groups) do not exist in Power Platform; this is a fabricated concept and cannot restrict environment creation permissions. Option C is wrong because the setting 'Allow users to create environments' in Power Apps settings is a legacy control that only applies to the default environment and does not specifically block trial environments; it also does not enforce an approval process. Option D is wrong because Data Loss Prevention (DLP) policies control data movement and connector usage across environments, not environment creation or trial environment provisioning; DLP policies cannot block the creation of environments.

673
MCQhard

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

A.The developer does not have sufficient security role permissions to activate BPFs.
B.The BPF has no stages defined.
C.The BPF is trying to use a table that is not enabled for business process flows.
D.The Opportunity table does not exist.
AnswerC

Only certain tables can be used in BPFs; Opportunity is enabled by default, but if it's a custom table, it might not be enabled.

Why this answer

The error shown in the exhibit indicates that the business process flow (BPF) references a table that is not enabled for business process flows. In Power Apps, only tables that have the 'Business process flows' option enabled in their table settings can be used as the primary entity for a BPF. The 'Opportunity' table is a standard table that is enabled by default, but if it has been disabled or the BPF is referencing a custom table that lacks this setting, activation will fail with this error.

Option C correctly identifies this root cause.

Exam trap

The trap here is that candidates often assume the error is due to missing permissions (Option A) or an incomplete BPF (Option B), but the exhibit's error message specifically references the table not being enabled for business process flows, which is a distinct configuration requirement in Dataverse.

How to eliminate wrong answers

Option A is wrong because security role permissions affect the ability to create or activate BPFs only if the user lacks 'Activate Business Process Flow' privilege, but the error message in the exhibit specifically points to a table configuration issue, not a permissions error. Option B is wrong because a BPF with no stages defined would still activate (though it would be non-functional) and would not produce this specific error; the error is about table enablement, not stage count. Option D is wrong because the 'Opportunity' table is a standard table in Dataverse and always exists; if it didn't, the developer would receive a 'table not found' error during BPF creation, not during activation.

674
MCQeasy

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

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

Power Apps enables rapid, low-code app creation for mobile and web.

Why this answer

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

Exam trap

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

How to eliminate wrong answers

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

675
Multi-Selecteasy

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

Select 2 answers
A.Excel (OneDrive/SharePoint)
B.Microsoft Dataverse
C.SharePoint
D.SQL Server
E.Salesforce
AnswersA, C

Correct: Excel files in OneDrive or SharePoint are standard.

Why this answer

SharePoint and Excel are standard connectors included with Power Apps. Dataverse and SQL Server require premium licenses, and Salesforce is premium.

Page 8

Page 9 of 14

Page 10