PL-900 Practice Exam 2 — 20 Questions

Question 1

Your organization uses Power Automate to integrate with Microsoft 365 services. You need to create a flow that automatically creates a contact in Outlook when a new lead is added to Dynamics 365. The flow should run immediately when the lead is created. Which connector should you use as the trigger?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Dynamics 365 connector. The Dynamics 365 connector provides a 'When a record is created' trigger. SharePoint, Outlook, and Teams connectors do not trigger on Dynamics 365 leads.

Answer

SharePoint connector

Answer

Outlook connector

Answer

Microsoft Teams connector

Question 2

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

Accepted Answer

Publish the report from Power BI Desktop and schedule a daily data refresh in Power BI service. It separates the report creation (in Power BI Desktop) from the data refresh schedule (in the Power BI service). By publishing the report once and configuring a daily scheduled refresh, the dashboard automatically reflects the latest data from the Excel file without manual intervention, which is the most efficient approach for weekly updates.

Answer

Use Power BI Desktop to connect to the Excel file and publish a new report weekly

Answer

Use Power Query to merge data from the Excel file and create a composite model

Answer

Upload the Excel file to the Power BI service each week

Question 3

Which THREE capabilities does Microsoft Power Platform include to help organizations achieve digital transformation?

Accepted Answer

Low-code application development. Power Platform delivers low-code application development through Power Apps (option B), which lets makers build canvas and model-driven apps with connectors and formulas instead of full custom code, directly supporting digital transformation. Workflow automation is provided by Power Automate (option D), enabling automated flows, approvals, and integration across hundreds of connectors to digitize business processes. Data analytics and visualization come from Power BI (option E), which turns data into interactive dashboards and reports for data-driven decisions. Option A is incorrect because Power Platform consumes prebuilt AI models via AI Builder rather than training custom models from scratch, and option C is incorrect because Power Platform augments rather than replaces custom coding, still allowing pro-code extensibility.

Answer

Custom AI model training from scratch

Answer

Replacement of all custom coding

Question 4

A non-profit organization wants to create a simple app for volunteers to log their hours and submit expenses. The app should be easy to build and require minimal coding. Which Power Platform tool should they use?

Accepted Answer

Power Apps canvas app. Power Apps canvas app is the correct choice because it allows non-developers to quickly build a custom, low-code app for data entry tasks like logging volunteer hours and submitting expenses. Canvas apps start from a blank canvas or a template, enabling drag-and-drop design with minimal coding, and can connect directly to data sources like SharePoint or Dataverse for storing records.

Answer

Power Pages

Answer

Power BI

Answer

Power Automate

Question 5

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Accepted Answer

The users lack write permissions on the SharePoint list.. The 'Access denied' error when submitting new items in a canvas app connected to a SharePoint list indicates that the user lacks write permissions on the underlying data source. Even though the app is shared with the user, the SharePoint list itself enforces its own permission model. Without Contribute or Edit permissions on the list, the user cannot create new items, resulting in the generic access denied error.

Answer

The connection reference is not shared with the users.

Answer

The SharePoint list has exceeded its item limit.

Answer

The app is shared with 'Can edit' permission but not 'Can view'.

Question 6

A company wants to integrate Power Automate with Microsoft Teams so that when a new task is assigned in Planner, a message is posted in a Teams channel. Which connector should be used?

Accepted Answer

Microsoft Teams. Microsoft Teams. The Microsoft Teams connector allows posting messages to Teams channels, which is exactly what the scenario requires. Option A (Outlook.com) is for personal email, not Teams. Option B (SharePoint) is for document management, not Teams messaging. Option C (Office 365 Outlook) is for email and calendar, not for posting to Teams channels.

Answer

Outlook.com

Answer

SharePoint

Answer

Office 365 Outlook

Question 7

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?

Accepted Answer

Create an environment-level DLP policy for PROD that blocks the connector.. Environment-level DLP policies in Power Platform apply only to a specific environment, so creating one for PROD that blocks the unapproved connector restricts it there while leaving DEV, TEST, UAT, and STAGING unaffected. This precisely meets the requirement to block the connector only in PROD. Tenant-level policies would affect all environments, which is too broad.

Answer

Create a tenant-level DLP policy that blocks the connector for all environments.

Answer

Remove the developer's permissions to the PROD environment.

Answer

Delete the Power App from PROD.

Question 8

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

Accepted Answer

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

Answer

Use Power Pages to display the Excel file

Answer

Create a model-driven app using Dataverse

Answer

Use Power Automate to create a mobile app

Question 9

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

Accepted Answer

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

Answer

Drill-through

Answer

Bookmarks

Answer

Slicers

Question 10

Match each Power Automate trigger type to its description.

Accepted Answer

Manual: A flow that runs when a user clicks a button or selects an action.. Correct matches: Manual triggers are user-initiated, scheduled triggers run on a time schedule, and automated triggers react to events. Common confusions arise between event-driven (automated) and time-based (scheduled) triggers, as well as between manual and other types.

Answer

Manual: A flow that runs on a recurring schedule.

Answer

Scheduled: A flow that starts automatically when a new file is created.

Question 11

An organization uses Power Automate to process invoices from email attachments. Some invoices are processed incorrectly because the flow fails to parse PDFs with non-standard layouts. What should the administrator do to improve accuracy?

Accepted Answer

Use AI Builder to create a custom document processing model.. AI Builder provides prebuilt and custom document processing models that use optical character recognition (OCR) and machine learning to extract data from PDFs with non-standard layouts. This directly addresses the root cause—parsing failures due to layout variability—by training the model on sample invoices to handle diverse formats, unlike static parsing logic.

Answer

Increase the flow run frequency to every minute.

Answer

Add a condition to route non-parsed invoices for manual approval.

Answer

Change the trigger to a manual button in Power Apps.

Question 12

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

Accepted Answer

Users do not have appropriate security roles in Dataverse to read the data.. In Microsoft Dataverse, access to data is governed by security roles assigned to users. If users can open the canvas app but see no data, the most likely cause is that their Dataverse security roles do not grant read privileges on the tables the app queries. Sharing the app itself does not automatically grant Dataverse data permissions.

Answer

The app uses a premium connector that requires a license.

Answer

The app is not published to the environment.

Answer

The app is configured to run only on mobile devices.

Question 13

Which TWO are benefits of using Microsoft Power Platform for business process automation?

Accepted Answer

Reduces need for custom coding. Microsoft Power Platform provides low-code and no-code tools like Power Automate and Power Apps, enabling users to create automated workflows and applications without writing custom code. This reduces reliance on professional developers and accelerates business process automation.

Answer

Requires dedicated IT team for every automation

Answer

Only works on-premises

Answer

Requires deep knowledge of programming languages

Question 14

An organization uses Power Automate flows that connect to Microsoft Dataverse. The flows need to run under a service account with specific permissions. What is the best practice to manage the connection?

Accepted Answer

Create a connection reference that uses the service account's connection. Connection references decouple the connection details from the flow definition, allowing you to configure a service account's connection once and reuse it across multiple flows. When you create a connection reference and set it to use a service account's connection (e.g., a pre-created Dataverse connection authenticated with the service account), the flow runs under that account's permissions without exposing credentials or requiring the flow owner to share their identity. This is the recommended pattern for service principal or application user scenarios in Power Automate.

Answer

Use the flow owner's credentials and share the flow with the service account

Answer

Create a service account connection type in the Power Platform admin center

Answer

Hardcode the service account credentials in the flow

Question 15

Your organization has a Power Apps portal that allows external users to submit support tickets. You need to ensure that only authenticated external users from specific domains can access the portal. What should you configure?

Accepted Answer

Configure the portal to use Microsoft Entra ID authentication and set up domain restrictions.. Power Apps portals can be configured to use Microsoft Entra ID (formerly Azure AD) as the identity provider, and within the portal settings you can restrict sign-in to users from specific domains. This ensures that only authenticated external users whose email domain matches the allowed list can access the portal, meeting the requirement without relying on IP filtering or obscurity.

Answer

Create a data loss prevention (DLP) policy that blocks external users.

Answer

Restrict access to the portal by IP address using a web application firewall.

Answer

Share the portal URL only with users from the allowed domains.

Question 16

A company wants to build an app that allows external vendors to submit invoices through a web portal. The app must be accessible without signing in with a Microsoft account. Which Power Platform solution should they use?

Accepted Answer

Power Pages site with anonymous access enabled. Power Pages (option A) is the correct solution because it enables external-facing websites that can be accessed by anonymous users without requiring a Microsoft account or license. Canvas apps and model-driven apps require authenticated users with appropriate licenses, and Power Automate is an automation service, not a portal for external submissions.

Answer

Canvas app shared with everyone

Answer

Model-driven app with anonymous access

Answer

Power Automate portal

Question 17

A company wants to create a Power Apps app that can be embedded in Microsoft Teams. Which type of Power Apps should they use?

Accepted Answer

Canvas app. Canvas apps can be directly embedded in Microsoft Teams using the 'Add to Teams' feature. Option A is incorrect because Power Pages are for building public-facing websites, not for embedding in Teams. Option B is incorrect because Copilot Studio is a tool for creating conversational AI, not a Power Apps type. Option C is incorrect because Model-driven apps are not directly embeddable in Teams; they require additional integration steps.

Answer

Power Pages

Answer

Copilot Studio

Answer

Model-driven app

Question 18

A company wants to build a Power App that uses AI to extract information from uploaded invoices. Which capability should they use?

Accepted Answer

AI Builder invoice processing model. AI Builder's invoice processing model is a prebuilt AI capability in Power Platform specifically designed to extract structured data (vendor, total, line items) from invoices using OCR plus machine learning. It integrates directly with Power Apps and Power Automate and requires no custom model training. This is the purpose-built solution for the stated requirement.

Answer

Power Automate with OCR actions

Answer

Power Virtual Agents

Answer

Copilot Studio

Question 19

Drag and drop the steps to create a Power Automate flow that sends an email when a new item is added to SharePoint in the correct order.

Accepted Answer

Create a new automated flow from blank, then select the trigger 'When an item is created' for SharePoint, then add the action 'Send an email' (Outlook), then configure the email and save.. The flow starts with an automated trigger, then adds an email action, and is saved after configuration.

Answer

Create a new automated flow from blank, then add the action 'Send an email', then select the trigger 'When an item is created' for SharePoint, then configure and save.

Answer

Select the trigger 'When an item is created' for SharePoint, then create a new automated flow from blank, then add action 'Send an email', then configure and save.

Answer

Create a new automated flow from blank, then select the trigger 'When an item is created' for SharePoint, then configure the email and save, then add the action 'Send an email'.

Question 20

A manufacturing company uses Power Apps to track inventory. They want to add a feature that automatically reorders stock when levels fall below a threshold. The solution must be low-code. Which Power Platform component should be integrated with Power Apps?

Accepted Answer

Power Automate. Power Automate is the correct component because it provides low-code workflow automation that can monitor inventory levels in real time and trigger reorder actions when thresholds are breached. By integrating Power Automate with Power Apps, you can create a cloud flow that checks stock data from a data source (e.g., Dataverse or SQL) and automatically sends reorder notifications or creates purchase orders, all without writing traditional code.

Answer

Power BI

Answer

Power Pages

Answer

Power Virtual Agents