PL-900 Practice Test 4 — 25 Questions

Question 1

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. Option A is correct because 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 2

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 3

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 4

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 5

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 6

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 7

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 8

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

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 12

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 13

A canvas app includes a gallery that shows a list of customers. The app loads slowly when the gallery displays more than 500 records. What is the best way to improve performance?

Accepted Answer

Apply a filter to the gallery data source. Applying a filter to the gallery data source reduces the number of records loaded into the gallery, which improves performance because fewer records need to be transferred and rendered. Option A (non-delegable query) would actually worsen performance by loading all records locally. Option B (converting to a model-driven app) is a significant redesign and not a simple performance fix. Option D (increasing gallery height) does not affect the amount of data loaded; it only changes the display area.

Answer

Use a non-delegable query

Answer

Convert the app to a model-driven app

Answer

Increase the gallery height

Question 14

Refer to the exhibit. An administrator wants to enforce a mobile app management policy that prevents screen capture in Power Apps. Which Microsoft service should the administrator use to deploy this policy?

Accepted Answer

Microsoft Intune. Option C is correct because Microsoft Intune can deploy app protection policies, such as preventing screen capture, to Power Apps on mobile devices. Option A is incorrect because Microsoft Entra ID is for identity and access management, not device policy enforcement. Option B is incorrect because Microsoft Defender XDR is for threat detection and response, not mobile app management. Option D is incorrect because Microsoft Purview is for data governance and compliance, not mobile app management policies.

Answer

Microsoft Entra ID

Answer

Microsoft Defender XDR

Answer

Microsoft Purview

Question 15

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 16

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 17

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 18

Drag and drop the steps to create a Power BI report from a Dataverse table in the correct order.

Accepted Answer

Connect to Dataverse, then load data, then build visuals, then publish. The correct sequence for creating a Power BI report from a Dataverse table is to first connect to the Dataverse source, then load the data into Power BI, then build visuals (like charts and tables), and finally publish the report to the Power BI service for sharing. This order ensures a logical workflow where each step depends on the previous one.

Answer

Connect to Dataverse, then build visuals, then load data, then publish

Answer

Load data, then connect to Dataverse, then build visuals, then publish

Answer

Connect to Dataverse, then load data, then publish, then build visuals

Question 19

Drag and drop the steps to create a security role in Dataverse in the correct order.

Accepted Answer

Go to Power Platform admin center, then create a new security role and name it, then set permissions for the role, then save and assign the role to users.. Security roles are created in admin center, named, permissions set, then saved and assigned.

Answer

Create a new security role and name it, then go to Power Platform admin center, then set permissions, then save and assign.

Answer

Go to Power Platform admin center, then set permissions, then create a new security role and name it, then save and assign.

Answer

Go to Power Platform admin center, then create a new security role and name it, then save and assign, then set permissions.

Question 20

A team is creating a model-driven app to manage customer service cases. They want to ensure that only users with a specific security role can delete cases. What should they configure?

Accepted Answer

Security roles. Option A is correct because security roles in model-driven apps define permissions, including the ability to delete records. Option B is wrong because business rules define business logic and form behavior, not security permissions. Option C is wrong because the SharePoint connector is used for integration with SharePoint, not for security. Option D is wrong because app properties control settings like appearance and ownership, not security permissions.

Answer

Business rules

Answer

SharePoint connector

Answer

App properties