PL-900 Practice Test 2 — 25 Questions

Question 1

You have a Power Automate flow that sends an email notification when a new file is added to a SharePoint document library. Users report that emails are not being sent for some files. What is the most likely cause?

Accepted Answer

A trigger condition is filtering out some files. Option C is correct because trigger conditions in Power Automate allow you to define expressions that must evaluate to true for the flow to run. If a condition is configured to filter out certain files (e.g., based on file name, metadata, or size), those files will not trigger the flow, and no email will be sent. This is the most likely cause when emails are missing for some files but not all.

Answer

The flow uses a premium connector that requires a license

Answer

The file is being co-authored by multiple users

Answer

The file content contains sensitive information

Question 2

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

Accepted Answer

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

Answer

Dataverse

Answer

Power BI

Answer

Power Apps

Question 3

A company wants to create a custom copilot that answers employee questions about IT policies. The copilot must use existing SharePoint documents as a knowledge source. Which feature of Microsoft Copilot Studio should the company use?

Accepted Answer

Add a knowledge source. Option D is correct because the 'Add a knowledge source' feature in Microsoft Copilot Studio allows you to connect a copilot to existing SharePoint document libraries, enabling it to retrieve and answer questions based on the content of those documents. This is the direct mechanism for grounding a custom copilot with enterprise content without requiring additional development.

Answer

Generative AI feature

Answer

Power Automate cloud flow

Answer

Copilot for Microsoft 365

Question 4

A company has deployed a custom copilot built with Microsoft Copilot Studio. Users report that the copilot sometimes provides outdated information. The knowledge sources are SharePoint sites and public websites. The copilot uses Generative AI to formulate answers. What should the administrator do to improve the accuracy of the copilot's responses?

Accepted Answer

Refresh the knowledge sources periodically. Option C is correct because the copilot's knowledge sources (SharePoint sites and public websites) are not automatically refreshed in real time. By periodically refreshing these sources, the administrator ensures the copilot's generative AI has access to the most current content, directly addressing the issue of outdated information.

Answer

Enable the 'Show citations' option

Answer

Reduce the number of topics

Answer

Turn off Generative AI for responses

Question 5

A sales manager wants to track leads and opportunities without custom development. Which Power Platform component should they use?

Accepted Answer

Power Apps (model-driven app). A model-driven app in Power Apps is designed for data-centric business processes like lead and opportunity tracking, providing out-of-the-box tables, forms, and views without custom development. It leverages the Dataverse to store and manage structured data, making it ideal for a sales manager to track leads and opportunities through a pre-configured, customizable interface.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Automate

Question 6

A company's IT department is overwhelmed with password reset requests. They want to allow employees to reset passwords themselves using a conversational interface. Which Power Platform tool should they use?

Accepted Answer

Power Virtual Agents. Power Virtual Agents (C) is the correct tool because it enables the creation of conversational AI chatbots that can handle password reset requests through natural language interactions. It integrates with Azure Active Directory and other identity systems to allow employees to securely reset their own passwords without IT intervention, reducing the helpdesk workload.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate

Question 7

Refer to the exhibit. You run the Azure CLI command to create a DLP policy. The command fails with an error that the resource type is invalid. What is the most likely cause?

Accepted Answer

The resource type should be 'Microsoft.PowerPlatform/dlpPolicies'.. The Azure CLI command for creating a DLP policy in Power Platform requires the correct Azure Resource Manager (ARM) resource type. The error 'resource type is invalid' indicates that the resource type specified in the command is not recognized. The correct resource type for Power Platform DLP policies is 'Microsoft.PowerPlatform/dlpPolicies'. Option C correctly identifies that the resource type should be exactly this, and the other options are less likely causes such as location, naming prefix, or properties format.

Answer

The --location parameter should be 'global' instead of 'eastus'.

Answer

The --name parameter is missing the policy prefix.

Answer

The --properties parameter should reference a URL instead of a file.

Question 8

A developer creates a canvas app to display orders from Microsoft Dataverse. The app uses the gallery and data configuration shown in the exhibit. When the app runs, the gallery shows orders but the 'View Details' button does nothing when tapped. What is the most likely cause?

Accepted Answer

The target screen 'OrderDetailScreen' does not exist in the app. Option B is correct because the Navigate function in the button's OnSelect property references 'OrderDetailScreen', but if that screen does not exist in the app, the function cannot execute, causing the button to appear unresponsive. The gallery displays orders correctly, confirming the data source and Items property are functional, isolating the issue to the navigation target.

Answer

The button's OnSelect property has a syntax error

Answer

The Dataverse connection requires user authentication

Answer

The gallery's items property is misconfigured

Question 9

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?

Accepted Answer

The OAuth flow type is incorrectly set to 'accessCode' instead of 'authorizationCode'.. 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.

Answer

The scopes array is missing the 'id' scope.

Answer

The apiVersion is not supported by Power Automate.

Answer

The serviceUrl should point to the Salesforce instance, not login.salesforce.com.

Question 10

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

Accepted Answer

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

Answer

No relationship is defined between the tables.

Answer

The Sales table and Product table are from different data sources.

Answer

The 'ProductName' column is missing from the Product table.

Question 11

A customer interacts with a Microsoft Copilot Studio bot and says, "I want to check order status." The bot responds with "Please provide your order number." The customer then types their order number, but the bot does not proceed. Which of the following is the most likely cause?

Accepted Answer

The order number entity is not recognized or extracted from the user's input.. The bot fails to proceed because it cannot extract the order number entity from the user's input. In Microsoft Copilot Studio, entities are used to identify and capture specific data types (like order numbers) from user utterances. If the entity is not configured, not trained, or the user's input format doesn't match the entity pattern, the bot will not recognize the order number and cannot pass it to the next topic or action, causing the conversation to stall.

Answer

The bot is stuck in the Fallback topic.

Answer

The trigger phrase does not match exactly.

Answer

The "Redirect to Order Lookup topic" action is placed before the message actions.

Question 12

Which TWO actions can be performed using Microsoft Copilot Studio without writing custom code?

Accepted Answer

Trigger a Power Automate flow from a topic.. Option A is correct because Microsoft Copilot Studio allows you to trigger a Power Automate flow directly from a topic without writing any custom code. This is achieved by adding a 'Call an action' node within a topic and selecting a Power Automate flow, enabling the copilot to execute automated workflows seamlessly.

Answer

Integrate with a custom API by writing JavaScript code.

Answer

Train the copilot with a custom machine learning model.

Answer

Deploy the copilot to a third-party website using custom HTML.

Question 13

A company wants to build a public-facing website for citizens to submit permit applications and check status. They need to integrate with an existing Microsoft Dataverse database and support anonymous access for browsing but require authentication for submissions. Which TWO features of Power Pages should they use?

Accepted Answer

Anonymous page access for public content. Power Pages offers two key features for this scenario. Anonymous page access (Option A) allows public browsing without authentication, and Dataverse as the backend data source (Option B) enables storing and retrieving permit applications and statuses. Azure AD B2C (Option C) is an optional identity provider but not required because Power Pages includes built-in authentication for submissions. Power Automate (Option D) is a separate automation tool, not a page feature. Power BI (Option E) is for analytics, not form submission. Therefore, only Options A and B are correct.

Answer

Azure AD B2C for external user authentication

Answer

Power Automate flows for form submission

Answer

Power BI embedded reports for status tracking

Question 14

A company wants to build a Power App that allows sales representatives to capture customer feedback offline on their mobile devices. The feedback includes text, images, and signature. Which feature should be used to handle offline image and signature capture?

Accepted Answer

Use a canvas app with offline capability and the Camera and Signature controls, syncing to Dataverse when online. Option C is correct because canvas apps in Power Apps support offline capability, and the Camera and Signature controls can capture images and signatures while offline, syncing to Dataverse when connectivity is restored. Option A is incorrect because a SharePoint list with Power Apps integration does not support offline capture of images and signatures; SharePoint requires connectivity for such data. Option B is incorrect because although the Offline template and Dataverse provide offline capabilities, the Offline template is designed for basic data types and does not inherently support image and signature capture; you would need to use Camera and Signature controls as in option C. Option D is incorrect because model-driven apps with Dataverse offline sync have limitations on which controls can be used offline, and typically they do not support the Camera and Signature controls in the same way a canvas app does.

Answer

Use a SharePoint list with Power Apps integration for offline data capture

Answer

Use a canvas app with the Offline template and store data in Dataverse

Answer

Use a model-driven app with Dataverse offline sync

Question 15

A manufacturing company uses Microsoft Power Platform to manage its inventory. They have a Power Apps app that allows warehouse staff to scan items and update quantities in a SharePoint list. Recently, the app has been slow to load and occasionally times out when scanning multiple items in quick succession. The IT team suspects the issue is related to the data source connection. They want to improve performance without changing the user interface. The company has a Microsoft 365 E3 subscription and all data resides in SharePoint Online. What should the IT team do first?

Accepted Answer

Optimize the Power Apps by enabling delegation for the SharePoint connector.. Option C is correct because enabling delegation for the SharePoint connector allows Power Apps to offload filtering and sorting operations to SharePoint Online, rather than retrieving all rows to the client. This reduces the amount of data transferred over the network, which directly addresses the slow load and timeout issues when scanning multiple items in quick succession, without changing the user interface.

Answer

Implement a timer control to delay scanning between items.

Answer

Migrate the SharePoint list to an on-premises SQL Server database.

Answer

Replace SharePoint with Microsoft Dataverse for better performance.

Question 16

Which TWO of the following are components of Power Platform? (Choose two.)

Accepted Answer

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

Answer

SharePoint

Answer

Teams

Answer

Excel

Question 17

You are designing a Power Automate flow to approve expense reports. The flow must allow managers to approve or reject directly from the email notification without signing in. Which action should you use?

Accepted Answer

Start and wait for an approval. The 'Start and wait for an approval' action is specifically designed to send an approval request via email or the Power Automate mobile app, and it allows recipients to approve or reject directly from the email notification without needing to sign in, using adaptive cards or lightweight approval buttons. This meets the requirement for manager approval without authentication.

Answer

Create a file

Answer

Send an email (V2)

Answer

Send an HTTP request

Question 18

Which TWO Microsoft Power Platform solutions are designed to be used together to build a complete customer feedback analysis system that collects feedback from multiple channels, processes sentiment, and provides actionable insights?

Accepted Answer

AI Builder. AI Builder (D) is correct because it provides pre-built AI models for sentiment analysis, which can process feedback text from multiple channels to determine positive, negative, or neutral sentiment. Power Automate (E) is correct because it orchestrates the collection of feedback from various sources (e.g., email, forms, social media) and triggers actions based on sentiment results, enabling a complete automated feedback analysis pipeline.

Answer

Dataverse

Answer

Power Apps

Answer

Power BI

Question 19

You are building a canvas app for a retail company to track inventory. The app needs to display a list of products from a Dataverse table and allow users to update quantities. The product table has a column 'QuantityOnHand' of type Whole Number. When a user reduces the quantity below zero, the app should show an error message and not save the data. You have added a form and a submit button. What approach should you use to enforce the business rule?
A) Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0.
B) Use the Patch function with an If condition to check the value before updating.
C) Add a workflow in Power Automate to validate the quantity after submission.
D) Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting.

Accepted Answer

Use the Patch function with an If condition to check the value before updating.. Option B is correct because using the Patch function with an If condition allows real-time client-side validation before the data is sent to Dataverse. This ensures that the quantity is not reduced below zero and an error can be displayed to the user immediately. Option A (Dataverse business rule) is not triggered by canvas app submissions; business rules apply in model-driven apps. Option C (Power Automate workflow) runs after submission and cannot prevent the invalid data entry. Option D (form validation rule) is client-side but less direct for this scenario and may still allow submission if the rule is bypassed.

Answer

Add a business rule to the Dataverse table that sets a validation message when QuantityOnHand < 0.

Answer

Add a workflow in Power Automate to validate the quantity after submission.

Answer

Add a validation rule in the form control to check if QuantityOnHand >= 0 before submitting.

Question 20

You are a Power Automate administrator for Contoso Corporation. The company uses Microsoft 365 E5 licenses. The sales team uses a SharePoint Online list named 'Leads' to track potential customers. The list has columns: Title (single line of text), Email (single line of text), Status (choice: New, Contacted, Qualified, Lost), and Score (number). The sales manager wants to automate the following process: When a new lead is added with Status = 'New' and Score > 50, an approval request should be sent to the manager. If approved, the lead Status should be updated to 'Contacted' and an email should be sent to the lead's email address. If rejected, the lead Status should be updated to 'Lost'. Additionally, if the lead is not approved within 7 days, the flow should automatically set Status to 'Lost'. The manager is often on leave, so the flow should also send a reminder to the manager every 2 days if the approval is pending. You need to design the flow using Power Automate. Which of the following designs best meets the requirements?

Accepted Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update item and send email. For reminders, create a separate scheduled flow that runs every 2 days, queries SharePoint for items with Status = 'New' and approval pending, and sends an email.. Option B is correct because it uses the 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, it uses 'Start and wait for an approval' with a 7-day timeout, which automatically handles the timeout and subsequent actions. For reminders, it uses a separate scheduled flow that runs every 2 days, queries items with pending approvals, and sends a reminder email. Option A uses a Power Apps approval screen with an HTTP trigger, which does not handle the 7-day timeout or automated reminders. Option C uses a 'Parallel branch' with a single 'Delay' action, which does not send reminders every 2 days (it would only delay once) and would block the flow. Option D uses a 'Recurrence' trigger every hour instead of reacting to item creation, integrates the timeout with a 'Delay until' action rather than the approval action's built-in timeout, and uses a 'Compose' action to track reminders, which is insufficient to send recurring reminders.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Use 'Send an email' to notify the manager and include a link to a Power Apps approval screen. Use a separate flow triggered by an HTTP request from Power Apps to update the item.

Answer

Use a 'When an item is created' trigger with a condition on Score > 50 and Status = 'New'. Inside the condition, use 'Start and wait for an approval' with a 7-day timeout. After approval, update the item and send email. Use 'Parallel branch' to send a reminder every 2 days by adding a 'Delay' action followed by an email.

Answer

Use a 'Recurrence' trigger that runs every hour, queries the SharePoint list for items with Status = 'New' and Score > 50, then sends an approval request. Use a 'Delay until' action to set a 7-day timeout. Use a 'Compose' action to track reminders.