PL-900 Practice Test 1 — 30 Questions

Question 1

Refer to the exhibit. A Power Automate flow definition is shown. The flow is supposed to trigger when a high-importance email with attachments arrives in the inbox, and then send a notification email to support. However, the flow does not trigger for emails that have attachments but are not marked as high importance. What is the most likely reason?

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

Accepted Answer

The importance filter is set to 'High', so lower importance emails are ignored.. The trigger parameters include 'importance': 'High', so only emails with high importance trigger the flow. If the email has attachments but is not marked as high importance, the flow will not trigger. Option A is incorrect because the folder path being set to 'Inbox' does not affect the trigger; the trigger fires on new emails arriving in the inbox regardless of folder. Option B is incorrect because attachments are set to 'Yes', meaning attachments are required, but the flow still triggers only on high-importance emails; the issue is the importance filter, not attachments. Option D is incorrect because the trigger is set to 'When a new email arrives', which fires on new emails; the email being read does not prevent the trigger from firing on arrival.

Answer

The folder path is set to 'Inbox' but the email was moved to a different folder.

Answer

The trigger requires attachments, so emails without attachments are ignored.

Answer

The trigger is set to 'When a new email arrives' but the email is already read.

Question 2

A small business wants to automate sending a welcome email when a new customer is added to a CRM system. Which Power Platform service should they use?

Accepted Answer

Power Automate. Power Automate is the correct service because it is designed to create automated workflows that trigger actions based on events, such as sending a welcome email when a new customer record is added to a CRM system. It uses connectors to integrate with CRM platforms (e.g., Dynamics 365, Salesforce) and email services (e.g., Office 365 Outlook) to execute the automation without manual intervention.

Answer

Power Apps

Answer

Power BI

Answer

Copilot Studio

Question 3

A company uses Power Virtual Agents (now Copilot Studio) to handle customer inquiries. They want to escalate complex issues to a human agent when the bot cannot resolve them. What should they configure?

Accepted Answer

Use the 'Escalate' topic to hand off to a live agent.. Power Virtual Agents (Copilot Studio) includes a built-in 'Escalate' topic that, when triggered, hands off the conversation to a live agent via a configured engagement hub (e.g., Dynamics 365 Customer Service or Omnichannel for Customer Service). This is the native mechanism for transferring unresolved issues to a human agent without requiring custom automation or removing other topics.

Answer

Create a Power Automate flow to send an email to the support team.

Answer

Remove all topics except the escalation topic.

Answer

Configure the bot to transfer to a second bot.

Question 4

A company wants to create a dashboard that shows real-time sales data from their ERP system and allows managers to drill down into individual transactions. Which Power Platform component should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is designed for data visualization and business intelligence, enabling real-time dashboards with drill-through capabilities. It can connect directly to an ERP system via connectors or DirectQuery to display live sales data, and managers can use the drill-down feature to navigate from summary metrics to individual transaction details.

Answer

Power Apps

Answer

Power Automate

Answer

AI Builder

Question 5

A company has multiple Power Platform environments: Development, Test, and Production. They want to ensure that changes to a Power Automate cloud flow are validated before reaching production. Which approach should they use?

Accepted Answer

Use solution-aware flows and managed properties in Dev, then import to Test, and finally to Production after testing.. Solution-aware flows support managed properties and allow for structured application lifecycle management (ALM). By exporting the solution from Dev as a managed solution and importing it into Test for validation, then into Production, the company ensures that changes are validated at each stage. This approach prevents direct edits in production and maintains version control.

Answer

Edit the flow directly in the Production environment.

Answer

Create a new flow in Production based on a copy of the Dev flow.

Answer

Export the flow as a ZIP file from Dev and import to Production.

Question 6

Refer to the exhibit. An administrator runs this PowerShell command against a Power Platform environment. What can the administrator conclude?

Accepted Answer

The environment is accessible only to members of the ContosoUsers security group. The PowerShell command `Get-AdminPowerAppEnvironment` returns the environment details, including the `SecurityGroupId` property. If this property is populated with a GUID, it indicates a security group is assigned to the environment, restricting access to its members. Since the exhibit shows a non-null `SecurityGroupId` for the ContosoUsers group, the environment is accessible only to members of that security group.

Answer

The environment creation failed

Answer

The environment has no security group assigned

Answer

The environment is a personal productivity environment

Question 7

Which TWO of the following are valid environment types in Power Platform?

Accepted Answer

Production. Production and Sandbox are both valid environment types in Power Platform. Production environments are intended for live, end-user applications and data, while Sandbox environments are isolated, non-production environments used for development, testing, and training. Both support the full set of Power Platform capabilities, including Dataverse, Power Apps, Power Automate, and Power Virtual Agents.

Answer

Development

Answer

Trial

Answer

Preview

Question 8

A flow uses a 'When an item is created' trigger for a SharePoint list. The flow needs to access the item's title and the user who created it. Which dynamic values should be used?

Accepted Answer

Title and Created By. The 'When an item is created' trigger for a SharePoint list exposes dynamic values that include the item's 'Title' field and the 'Created By' field, which contains the user who created the item. These are standard columns in a SharePoint list and are automatically available as dynamic content in Power Automate when the trigger fires.

Answer

Title and Modified By

Answer

ID and Modified By

Answer

Created By and Created By Email

Question 9

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

Accepted Answer

Copilot Studio. Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps

Question 10

A company wants to automate the process of archiving completed sales orders from a SQL Server database to a SharePoint list every night. Which approach should they use?

Accepted Answer

Use a SQL Server connector with a 'Recurrence' trigger to query and move data.. It uses a Recurrence trigger to run the flow on a schedule (every night) to query SQL Server for completed sales orders and archive them to SharePoint. Option A uses an event-driven trigger (when an item is created) which is not suitable for a nightly batch process. Option B is an instant flow triggered manually by a button, not automated. Option C requires an external scheduler to send an HTTP request, but Power Automate's built-in Recurrence trigger is simpler and more appropriate.

Answer

Use a 'When an item is created' trigger on the SQL table.

Answer

Create an instant flow triggered by a Power Apps button for manual archiving.

Answer

Use a 'When a HTTP request is received' trigger from an external scheduler.

Question 11

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?

Accepted Answer

Create a tenant-level DLP policy that blocks the connector. 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.

Answer

Create a DLP policy for each environment and block the connector

Answer

Create a custom connector with the same name and block it

Answer

Remove the connector from the default solution

Question 12

Which TWO of the following are valid reasons to create multiple Power Platform environments?

Accepted Answer

To isolate data for different business units or projects.. Power Platform environments act as security and data boundaries, allowing organizations to isolate data for different business units or projects. Each environment has its own Dataverse database, which prevents data leakage and enables role-based access control tailored to specific teams or initiatives.

Answer

To increase the total storage capacity available.

Answer

To improve performance of Power Automate flows.

Answer

To reduce the cost of Power Apps licenses.

Question 13

A marketing team wants to allow external users to register on a Power Pages site using their own social media accounts. Which identity provider should they configure?

Accepted Answer

Azure AD B2C. Azure AD B2C (Business-to-Consumer) is the identity provider that supports social identity providers like Google, Facebook, and Microsoft accounts. It allows external users to register using their social media accounts. Local authentication is for username/password within the site, not social accounts. Microsoft Entra ID is for organizational accounts. Microsoft account is a single social provider, but Azure AD B2C is the configured identity provider that can integrate multiple social providers.

Answer

Local authentication

Answer

Microsoft Entra ID

Answer

Microsoft account

Question 14

Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?

Accepted Answer

When an email with 'Invoice' in the subject arrives in the Inbox. The trigger fires when a new email arrives in the Inbox with 'Invoice' in the subject. Option A is wrong because 'fetchOnlyWithAttachment' is set to false, so it will trigger even without attachments. Option B is wrong because 'importance' is set to 'Any', so it is not filtering by high importance. Option C is wrong because the trigger is on new email arrival, not on email modification.

Answer

When an email with an attachment arrives

Answer

When a high-importance email arrives

Answer

When an email is modified in the Inbox

Question 15

Which TWO are valid ways to distribute a Power App to end users? (Select 2)

Accepted Answer

Add the app to Microsoft Teams. Power Apps can be added directly to Microsoft Teams as a tab or personal app, allowing end users to access the app within the Teams interface without leaving the collaboration environment. This leverages the Teams integration capabilities of Power Apps, which uses the Teams manifest and the Power Apps app for Teams to provide seamless access.

Answer

Email the app as an attachment

Answer

Export the app and send it as a .msapp file

Answer

Publish the app to Microsoft AppSource

Question 16

A sales team needs a dashboard showing real-time sales data from multiple sources to identify trends. Which Power Platform component is best suited for this?

Accepted Answer

Power BI. Power BI is the correct choice because it is designed specifically for data visualization and business intelligence, enabling users to create interactive dashboards that combine real-time data from multiple sources. Its ability to connect to various data streams (e.g., SQL databases, Excel, cloud services) and update visuals automatically makes it ideal for identifying sales trends as they happen.

Answer

Power Apps

Answer

Power Pages

Answer

Power Automate

Question 17

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Accepted Answer

The flow is using the cloud SQL connector without an on-premises data gateway.. The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Answer

The Office 365 connector is conflicting with the SQL connector.

Answer

The environment type is Production, which restricts access to on-premises data.

Answer

The region 'eastus' does not support on-premises connectivity.

Question 18

A company wants to automate the approval process for purchase orders. Managers should receive an email with a link to approve or reject. Which Power Platform component is best suited?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is designed specifically for workflow automation, including approval processes. It can trigger an email to managers with an approval link and handle the response (approve/reject) without manual intervention, making it ideal for automating purchase order approvals.

Answer

Power Apps

Answer

Microsoft Copilot Studio

Answer

Power BI

Question 19

An organization has several Power Platform environments used for development and testing. They want to prevent accidental deletion of important data. What strategy should they implement?

Accepted Answer

Use the Power Platform admin center to configure environment backups and enable solution checker.. The Power Platform admin center provides automated daily backups (with a 28-day retention for production environments) and allows manual backups, which directly protects against accidental data loss. Enabling solution checker is a separate best practice for quality assurance, but the core strategy for preventing accidental deletion is leveraging the built-in backup and restore capabilities.

Answer

Regularly export all data to Excel files and store them in OneDrive.

Answer

Set environment capacity limits to prevent storage of excessive data.

Answer

Enable versioning on all SharePoint lists used by Power Apps.

Question 20

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

Accepted Answer

Configure the data source credentials in the Power BI service under dataset settings. The error indicates that the data source credentials are missing in the Power BI service, not in the JSON configuration. The JSON only defines the refresh schedule and dataset parameters; credentials must be configured separately in the Power BI service under dataset settings because they are sensitive and not stored in deployment artifacts. Option B is correct because you must manually enter or update the credentials in the Power BI service to authenticate against the data source.

Answer

Add the credentials to the JSON configuration and redeploy

Answer

Set the data source privacy level to Organizational

Answer

Change the connection string to use SQL Server authentication