PL-900 Practice Test 32 — 15 Questions

Question 1

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?

Accepted Answer

On-premises data gateway with SQL Server connector. 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.

Answer

SQL Server connector directly

Answer

Power Automate on-premises agent

Answer

Dataverse

Question 2

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?

Accepted Answer

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.. Power Pages integrates natively with Dataverse, and the 'List and Form' template provides prebuilt components for displaying records and capturing submissions without custom code. Creating a Dataverse table for appointments and using the template gives a low-code, integrated booking experience with data stored in the platform's native data store. This satisfies the no-custom-database and Microsoft 365 integration requirements.

Answer

Build a Power Automate portal that accepts form submissions and writes to a Dataverse table.

Answer

Use SharePoint lists to store appointments and embed the list in a Power Pages page using an iframe.

Answer

Use Excel Online as the backend and connect via Power Automate to create appointments from the portal.

Question 3

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?

Accepted Answer

Power Automate. Power Automate is the Power Platform component specifically designed for workflow automation and approvals. It provides built-in approval actions and templates that allow you to define multi-step approval processes, send approval requests, and track responses. Power Apps is for building the user interface, Power BI for analytics, and Power Virtual Agents for chatbots, none of which natively handle approval workflows.

Answer

Power Virtual Agents

Answer

Power Apps

Answer

Power BI

Question 4

A company has a Power Platform environment that contains several unmanaged solutions. The administrator wants to promote a solution to production. Which action should the administrator take to ensure the solution can be deployed to other environments?

Accepted Answer

Export the solution as a managed solution. Exporting a solution as a managed solution is the correct action because managed solutions are designed for deployment to production and other non-development environments. They prevent direct customization of components, enforce solution layering, and allow for proper lifecycle management, including upgrades and patching. Unmanaged solutions, by contrast, are intended for development and cannot be reliably deployed to production without breaking the component ownership model.

Answer

Use the 'Backup' feature in the admin center

Answer

Apply a solution patch and export it

Answer

Clone the solution and export as unmanaged

Question 5

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

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse and SharePoint are standard connectors that can be used without a premium license. Salesforce requires a premium connector. Excel Online (Business) is also a standard connector, but the correct answers for this question are Dataverse and SharePoint. SQL Server requires a premium connector.

Answer

Salesforce

Answer

Excel Online (Business)

Answer

SQL Server

Question 6

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

Accepted Answer

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

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Power BI

Question 7

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

Accepted Answer

Block specific connectors from being used in flows. 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.

Answer

Allow users to bypass DLP policies with administrator approval

Answer

Assign DLP policies to specific users

Answer

Inherit the tenant-level DLP policy for all environments

Question 8

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

Accepted Answer

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

Answer

Power Apps canvas app for tenants and Power Apps model-driven app for staff

Answer

AI Builder and Power Automate to process requests

Answer

Power BI dashboard for tenants to view status and Power Apps for staff

Question 9

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

Accepted Answer

Use a Power Apps template from the template gallery. 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.

Answer

Create a Model-driven app from a Dataverse table

Answer

Use Power Automate to generate the app

Answer

Create a Canvas app from blank

Question 10

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

Accepted Answer

Create a Conditional Access policy in Microsoft Entra ID that requires MFA for the portal application. Conditional Access in Microsoft Entra ID is the supported, centralized mechanism to require MFA for a specific application such as a Power Apps portal. By scoping the policy to the portal enterprise application and setting the grant control to 'Require multi-factor authentication', external users authenticating via Entra ID are challenged for MFA without affecting other apps. This is the recommended approach because portal authentication is delegated to Entra ID, so MFA must be enforced at the identity provider layer.

Answer

Enable MFA for all Microsoft Entra ID users

Answer

Use a third-party identity provider that supports MFA

Answer

Configure MFA in the Power Apps portal authentication settings

Question 11

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

Accepted Answer

Configure Run After settings. Option A (Configure Run After settings) is correct because Power Automate lets you set each action's 'Run after' property to fire on Succeeded, Failed, Skipped, or Timed Out, so a subsequent action can handle or compensate for a prior action's failure. Option D (Scope) is correct because a Scope is a container action that groups multiple actions and exposes the same Run After configuration, enabling try/catch-style patterns where a following Scope or action runs only when the first Scope fails. Options B (Apply to each), C (Compose), and E (Condition) are not error-handling mechanisms: Apply to each is a loop, Compose simply outputs a value or expression, and Condition branches on data values rather than on action success or failure.

Answer

Apply to each

Answer

Compose

Answer

Condition

Question 12

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

Accepted Answer

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

Answer

Creating users in Microsoft Entra ID

Answer

Publishing Power BI reports

Question 13

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?

Accepted Answer

When a new email arrives trigger and Send push notification action. The 'When a new email arrives' trigger is designed to monitor an inbox for incoming messages, and the 'Send push notification' action sends a notification directly to a mobile device via the Power Automate mobile app or Microsoft Teams. This combination directly fulfills the requirement to react to a high-priority email and deliver a push notification to the user's device.

Answer

When an item is created trigger and Post message action

Answer

When an approval request is triggered and Send email action

Answer

Recurrence trigger and Send email action

Question 14

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

Accepted Answer

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

Answer

The email is sent to the wrong recipient.

Answer

The update item action is missing.

Answer

The condition expression has incorrect syntax.

Question 15

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

Accepted Answer

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

Answer

Power BI gateway

Answer

DirectQuery mode

Answer

Power Automate flow to refresh the dataset