PL-900 Practice Test 3 — 30 Questions

Question 1

A data analyst notices that a Power BI report takes a long time to load when filtering by a specific date range. The data source is a SQL Server view that contains millions of rows. What is the most effective way to improve performance?

Accepted Answer

Use DirectQuery and optimize the SQL view with indexes and filters. Option B is correct because the performance bottleneck is at the data source level—millions of rows in a SQL Server view. Using DirectQuery with optimized indexes and filters pushes query execution back to SQL Server, allowing it to leverage database-level performance features like index seeks and query plan caching. This reduces the amount of data transferred and processed in Power BI, directly addressing the root cause of slow filtering.

Answer

Create a calculated column for the date range filter

Answer

Switch from DirectQuery to Import mode

Answer

Hide unnecessary columns in the report

Question 2

A financial analyst creates a Power BI report to compare quarterly revenue across years. The data has a 'Date' column and a 'Revenue' column. The analyst wants to display year-over-year growth for each quarter. Which visual and configuration would best achieve this?

Accepted Answer

Matrix visual with years as columns, quarters as rows, and a measure for YoY growth. Option B is correct because a Matrix visual allows you to place years as columns and quarters as rows, then define a DAX measure for year-over-year (YoY) growth (e.g., (Current Year Revenue - Previous Year Revenue) / Previous Year Revenue). This directly compares each quarter’s revenue across years in a structured, tabular format, which is the most effective way to display YoY growth for each quarter.

Answer

Line chart with date hierarchy and revenue, adding year-over-year trend line

Answer

Stacked bar chart with quarters on axis and revenue as values, using year as legend

Answer

Scatter plot with revenue on both axes and date as detail

Question 3

A marketing team wants to share a Power BI dashboard with external stakeholders who do not have Power BI licenses. Which sharing method should the team use?

Accepted Answer

Use Publish to web (embed code) to create a public link. Option C is correct because 'Publish to web' generates an embed code that creates a publicly accessible link to the Power BI dashboard, which can be viewed by anyone without requiring a Power BI license or authentication. This is the only method listed that allows external stakeholders without licenses to access the dashboard directly in a browser.

Answer

Share the dashboard from the Power BI service

Answer

Add the stakeholders to a Power BI workspace with viewer role

Answer

Export the report to PDF and email it

Question 4

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

Question 5

You are a data analyst at a manufacturing company that uses Microsoft 365 and Power BI. The company has a Power BI tenant with Free, Pro, and Premium Per User (PPU) licenses. Your team has created a Power BI report that visualizes production line efficiency from a SQL Server database on-premises. The report is published to a workspace assigned to a PPU capacity. You need to ensure that all 50 users in the production department can view the report on their mobile devices, with data refreshing every 30 minutes. The users have a mix of Free and Pro licenses. The report uses DirectQuery mode to the on-premises SQL Server. You have configured an on-premises data gateway in personal mode. Users report that the report is slow and sometimes fails to load. What should you do to improve performance and reliability while meeting the refresh requirement?

Accepted Answer

Switch the on-premises data gateway from personal mode to standard mode and add additional gateways to the cluster.. Option D is correct because the report uses DirectQuery mode, which requires a standard (on-premises data gateway) mode to handle concurrent queries efficiently. Personal mode is limited to a single user and cannot scale to support 50 users, causing slow performance and failures. Adding additional gateways to a standard mode cluster distributes the query load, improving reliability and performance while maintaining the 30-minute refresh requirement via DirectQuery.

Answer

Move the report to a shared capacity and assign all users Pro licenses.

Answer

Change the report from DirectQuery to Import mode and configure scheduled refresh every 30 minutes.

Answer

Assign all users Premium Per User licenses to ensure they can view the report.

Question 6

A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?

Accepted Answer

The business rule is scoped to the form but the status change happens via a quick create form.. Business rules in model-driven apps can be scoped to either the entity (all forms) or a specific form. If the rule is scoped to a particular form (e.g., the main form) but the status change occurs via a quick create form, the rule will not trigger. This is the most likely cause because users report the field is not populated, indicating the rule is not firing in the context where the status is being changed.

Answer

The 'Resolved By' lookup column is not added to the form.

Answer

The 'Resolved By' column is required and users don't fill it.

Answer

The business rule is deactivated.

Question 7

A Power Automate flow uses the trigger configuration shown. Users report that the flow does not start when a new order is added with Status = 'Pending'. What is the most likely cause?

Accepted Answer

The trigger condition only allows items with Status = 'New'. Option D is correct because the trigger condition explicitly filters for items where Status equals 'New'. When a new order is added with Status = 'Pending', the condition evaluates to false, so the flow does not trigger. Trigger conditions in Power Automate act as a pre-filter on the trigger event, preventing the flow from running if the condition is not met.

Answer

The SharePoint dataset URL is incorrect

Answer

The flow is paused or turned off

Answer

The trigger only fires on modification, not creation

Question 8

A company is designing a copilot using Microsoft Copilot Studio. The copilot must handle sensitive employee data. Which TWO actions should the administrator take to ensure data security and compliance?

Accepted Answer

Configure data loss prevention (DLP) policies to restrict data movement. Options A and D are correct. Option A prevents data from leaving the region. Option D ensures data isn't used for model training. Option B is wrong because enabling anonymous access increases risk. Option C is wrong because disabling authentication doesn't secure data. Option E is wrong because public websites aren't secure for sensitive data.

Answer

Enable anonymous access to allow external users

Answer

Disable authentication to simplify access

Answer

Add public websites as knowledge sources

Question 9

A company is using Microsoft Copilot Studio to build a copilot for employee onboarding. The copilot must authenticate users to provide personalized information. The company uses Azure AD (now Microsoft Entra ID) for identity management. Which authentication method should the administrator configure in Copilot Studio?

Accepted Answer

Microsoft Entra ID (Azure AD) authentication. Microsoft Entra ID (Azure AD) authentication is the correct choice because the company uses Azure AD for identity management, and Copilot Studio natively supports this authentication method to provide personalized, authenticated experiences. This allows the copilot to verify user identities via OAuth 2.0 and OpenID Connect, enabling access to user-specific data and context during onboarding.

Answer

Anonymous access

Answer

Manual authentication

Answer

SharePoint authentication

Question 10

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.)

Accepted Answer

A trigger. 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.

Answer

An approval action

Answer

A variable

Answer

A condition

Question 11

Which THREE are valid options for handling errors in a Power Automate flow? (Choose three.)

Accepted Answer

Configure run after. Option A is correct because 'Configure run after' allows a flow action to execute based on the outcome (success, failure, skipped, or timed out) of a preceding action. This is the primary mechanism in Power Automate for handling errors by defining conditional execution paths after an action completes.

Answer

Parallel branches

Answer

Retry policy

Question 12

A team is building a customer service solution using Power Apps and Dataverse. They need to ensure that customer data is synchronized with Dynamics 365 Customer Service. Which approach should they use?

Accepted Answer

Use Dataverse as the data store and connect both Power Apps and Dynamics 365 to it. Using Dataverse as the common data store and connecting both Power Apps and Dynamics 365 to it ensures real-time synchronization. Direct integration via custom APIs is possible but not best practice. Power Automate flows can also sync, but Dataverse is the recommended approach for Dynamics 365.

Answer

Build a custom connector to transfer data between Power Apps and Dynamics 365

Answer

Implement a third-party middleware solution

Answer

Export data from Dynamics 365 and import it into Power Apps periodically

Question 13

A company uses Power Apps to manage employee leave requests. They want to automate the approval process so that managers receive an email when a request is submitted. Which component should they add?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that trigger actions based on events. In this scenario, when a leave request is submitted in Power Apps, a Power Automate flow can be configured to send an email notification to the manager, automating the approval process without manual intervention.

Answer

Power BI

Answer

AI Builder

Answer

Power Virtual Agents

Question 14

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Accepted Answer

Integration with Common Data Service (Microsoft Dataverse). Option A is correct because Power Apps integrates directly with Microsoft Dataverse (formerly Common Data Service), which provides a secure, scalable data platform for storing and managing business data. This integration allows users to build apps that leverage Dataverse’s built-in business logic, security roles, and relationships without writing custom code. Option B is correct because Power Apps offers a library of pre-built templates (e.g., for expense reports, asset management) that can be customized to fit specific business needs, enabling rapid application development with minimal technical effort.

Answer

Natural language processing to create conversational bots

Answer

Automated workflows triggered by business events

Answer

Real-time data dashboards with drill-down analytics

Question 15

A company uses Microsoft Power Platform to automate business processes. They want to extend their solution by integrating with other Microsoft services. Which TWO services can be used together with Power Automate to trigger flows based on events from external systems?

Accepted Answer

Azure Logic Apps. Azure Logic Apps is a cloud service that provides pre-built connectors and enterprise integration capabilities, allowing Power Automate to trigger flows based on events from external systems via HTTP requests, webhooks, or service bus messages. Azure Event Grid is a fully managed event routing service that uses a publish-subscribe model, enabling Power Automate to react to events from Azure services or custom sources in near real-time. Both services extend Power Automate's event-driven triggers beyond its native connectors.

Answer

Power Virtual Agents

Answer

Azure DevOps

Answer

Azure SQL Database

Question 16

Refer to the exhibit. The flow fails to send the email. What is the most likely cause?

Accepted Answer

The email action does not include the list of opportunities in the body. Option D is correct because the flow's email action is configured to send a static email body without including the dynamic content from the 'List rows' action. Even if the trigger and filter are correct, the email will not contain the list of opportunities, so the flow appears to fail in its purpose. Power Automate requires explicit insertion of dynamic content (e.g., the 'value' array from Dataverse) into the email body to transmit the data.

Answer

The filter condition 'statecode eq 0' is invalid

Answer

The recurrence trigger is incorrectly configured

Answer

The connections to Dataverse and Office 365 are not established

Question 17

Drag and drop the steps to create a canvas app from a SharePoint list in the correct order.

Question 18

Drag and drop the steps to build a model-driven app in Power Apps in the correct order.

Question 19

Drag and drop the steps to create a custom connector in Power Automate in the correct order.

Question 20

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.