PL-900 Practice Questions 2 — 50 Questions

Question 1

Match each connector type in Power Automate to its description.

Question 2

Match each Power Virtual Agents feature to its purpose.

Question 3

A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?

Accepted Answer

The app uses a non-delegable query on a large data source. The most likely cause of slow loading in a Power Apps inventory management app is a non-delegable query on a large data source. When a query cannot be delegated, Power Apps retrieves all records from the data source to the client device, then filters locally, causing significant performance degradation with large datasets. This is a common issue when using functions like `Filter` with unsupported operators or columns on large tables.

Answer

The app has too many controls per screen

Answer

The app uses too many screens

Answer

The app has complex formulas in OnStart

Question 4

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

Accepted Answer

Power Virtual Agents. Power Virtual Agents (A) is a component of the Microsoft Power Platform that enables users to create intelligent chatbots using a no-code graphical interface, without requiring developers or data scientists. It integrates with Power Automate and Power Apps to extend bot capabilities, making it a core part of the platform's low-code AI offerings.

Answer

Azure DevOps

Answer

Microsoft 365

Answer

Dynamics 365

Question 5

Which THREE components are part of Microsoft Power Platform?

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. It integrates seamlessly with other platform components like Power Automate and Power BI to create end-to-end business solutions.

Answer

Power Virtual Agents

Answer

Azure DevOps

Question 6

A retail company wants to reduce the time store managers spend on manual inventory reporting. Currently, managers use paper forms and email to submit daily stock counts, which then need to be manually entered into a central system. This process is error-prone and delays replenishment. The company wants a solution that automates data entry, provides real-time dashboards, and allows managers to submit reports from their phones without installing any software on the phones. Which combination of Microsoft Power Platform tools should the company use?

Accepted Answer

Power Apps, Power Automate, and Power BI. Option C is correct because the scenario requires a combination of Power Apps (for mobile-friendly report submission without installing software), Power Automate (to automate data entry into the central system), and Power BI (to provide real-time dashboards). Power Apps alone cannot automate data entry or provide dashboards; Power Automate alone cannot provide a mobile input interface or dashboards; Power BI alone cannot capture data or automate workflows. Only the trio covers all requirements: mobile input, automated processing, and real-time visualization.

Answer

Power Automate only

Answer

Power Apps only

Answer

Power BI only

Question 7

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

Accepted Answer

Optimize data source connections and queries. Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Answer

Update the app version number

Answer

Increase the app icon size

Answer

Change the app's background color

Question 8

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they support offline capability by leveraging the Power Apps offline sync feature, which allows data to be cached locally on the device and synchronized with the data source (e.g., Dataverse or SharePoint) when connectivity is restored. This makes them ideal for mobile scenarios like store managers approving discount requests in areas with intermittent connectivity.

Answer

Portal

Answer

Model-driven app

Answer

Power Automate

Question 9

A developer is trying to create a business process flow (BPF) for the 'Opportunity' table in a model-driven app. When activating the BPF, the developer receives the error shown in the exhibit. What is the most likely cause?

Accepted Answer

The BPF is trying to use a table that is not enabled for business process flows.. The error shown in the exhibit indicates that the business process flow (BPF) references a table that is not enabled for business process flows. In Power Apps, only tables that have the 'Business process flows' option enabled in their table settings can be used as the primary entity for a BPF. The 'Opportunity' table is a standard table that is enabled by default, but if it has been disabled or the BPF is referencing a custom table that lacks this setting, activation will fail with this error. Option C correctly identifies this root cause.

Answer

The developer does not have sufficient security role permissions to activate BPFs.

Answer

The BPF has no stages defined.

Answer

The Opportunity table does not exist.

Question 10

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 11

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 12

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 13

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 14

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 15

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 16

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 17

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 18

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 19

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 20

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