PL-900 Practice Test 21 — 15 Questions

Question 1

A business analyst wants to quickly create a simple app to track team tasks without writing complex formulas. Which Power Apps option is most suitable?

Accepted Answer

Use the app from data wizard (e.g., from SharePoint). The app from data wizard (e.g., from SharePoint) is the most suitable because it allows a business analyst to quickly generate a functional app based on an existing data source, such as a SharePoint list, without writing complex formulas. This wizard automatically creates a three-screen app (browse, detail, edit) with built-in controls and formulas, enabling rapid app development. It is ideal for simple task tracking.

Answer

Start from a blank canvas app

Answer

Create a model-driven app

Answer

Use Power Automate to create the app

Question 2

A company wants to build a Power App that uses AI to analyze survey responses and extract sentiment. Which Power Platform capability should they use?

Accepted Answer

AI Builder sentiment analysis model. AI Builder provides prebuilt AI models, including a sentiment analysis model, that can be invoked directly from Power Apps and Power Automate without custom ML code. For analyzing survey text and extracting sentiment, the AI Builder sentiment analysis model is the purpose-built capability. It returns a sentiment score and label per response, which can then be stored or visualized.

Answer

Power BI dashboards

Answer

Power Automate flows

Answer

Power Apps Canvas app with formulas

Question 3

A Power Apps canvas app uses a SharePoint list as a data source. Users report that the app is slow when loading data. The list has 10,000 items. Which optimization should you recommend?

Accepted Answer

Use delegable filters like Filter() with indexed columns to limit data retrieved. Delegable filters such as Filter() with indexed columns allow Power Apps to push filtering to the data source (SharePoint), reducing the amount of data retrieved and improving performance. Option A is incorrect because reducing columns has minimal impact on the amount of data loaded, and delegable queries are more effective. Option B is incorrect because increasing the data row limit for non-delegable queries only affects the number of records displayed, not the data retrieved from SharePoint; the query still fetches all 10,000 items. Option C is incorrect because moving to SQL and using Power Automate introduces additional complexity and potential latency, and is not the most direct optimization for a SharePoint data source.

Answer

Reduce the number of columns in the SharePoint list

Answer

Increase the data row limit for non-delegable queries to 2000

Answer

Move the data to a SQL database and connect via Power Automate

Question 4

An insurance company wants to automate claims processing. They receive claims via email attachments (PDFs) and need to extract key information (policy number, date, amount) and enter it into a Dataverse table. Then, a workflow should evaluate the claim amount: if under $5000, auto-approve and notify the customer; if over $5000, assign to a human adjuster. The solution must be low-code and use AI where beneficial. Which combination should they use?

Accepted Answer

AI Builder, Power Automate, and Dataverse. It combines AI Builder (to extract data from PDFs using prebuilt AI models), Power Automate (to orchestrate the workflow and conditional logic based on claim amount), and Dataverse (to store the extracted data in a structured table). This low-code solution leverages AI where beneficial (PDF extraction) and automates the approval routing without requiring custom development.

Answer

Power BI, AI Builder, Power Automate, and Dataverse

Answer

Power Pages, AI Builder, Power Automate, and Dataverse

Answer

AI Builder, Copilot Studio, Power Automate, and Dataverse

Question 5

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

Accepted Answer

Formula bar. The Formula bar (A) is a core Power Apps Studio component where makers write Power Fx expressions for controls and properties, making it essential for building Canvas apps. The Tree view (C) is also part of Power Apps Studio, providing a hierarchical list of screens, controls, and components so makers can select, reorder, and manage app elements. The Property pane (D) is the third correct component, allowing configuration of selected controls' properties such as text, color, size, and behavior directly in the authoring interface. Solution Explorer (B) is not a Power Apps Studio Canvas app builder component; it belongs to solution management experiences in Power Platform. Report Designer (E) is not part of Power Apps Studio either; reporting and paginated report design are handled by Power BI Report Builder or related reporting tools.

Answer

Solution Explorer

Answer

Report Designer

Question 6

Which TWO of the following are benefits of using Microsoft Power Platform for business users?

Accepted Answer

Reduced dependency on IT for simple solutions.. Option A is correct because Power Platform's low-code/no-code tools (Power Apps, Power Automate, Power BI, Power Virtual Agents) let business users create simple apps, flows, and reports themselves, reducing the backlog and dependency on IT for routine solutions. Option B is correct because citizen developers can use drag-and-drop designers, prebuilt connectors, and templates to build apps and automations without writing traditional code. Option C is not a benefit specific to Power Platform for business users; custom code (e.g., plug-ins, Azure Functions, PCF controls) is typically a pro-dev capability and is not the primary advantage for citizen developers. Option D is incorrect because Power Platform is a development and automation tool, not a mechanism that automatically generates revenue from builds.

Answer

Ability to use custom code in production environments.

Answer

Automatic generation of revenue from builds.

Question 7

Which THREE components are part of a canvas app's formula language?

Accepted Answer

Functions. In Power Apps canvas apps, the formula language (Power Fx) is built from functions such as Filter, Sum, and Patch, which perform calculations and data operations, so option A is correct. Operators like +, -, =, &&, and in are also core elements of the formula language because they combine and compare values within expressions, making option D correct. Controls and properties are essential because formulas are written into a control's property, such as a Label's Text or a Button's OnSelect, and those properties are what the formula evaluates, so option E is correct. Dataverse tables (B) are data sources that formulas can reference, but they are not themselves components of the formula language, and Power Automate flows (C) are separate automation resources invoked from apps rather than part of the formula syntax.

Answer

Dataverse tables

Answer

Power Automate flows

Question 8

Which THREE of the following are capabilities of Microsoft Copilot in Power Platform?

Accepted Answer

Create a Power App from a description.. Option B is correct because Microsoft Copilot in Power Apps allows makers to describe an app in natural language and have Copilot generate the app's structure, including screens, controls, and data connections. Option D is correct because Copilot in Power Automate can suggest the steps and actions needed to build a flow from a natural-language description of the desired automation. Option E is correct because Copilot can generate Power Fx formulas from natural-language prompts, helping makers write expressions for controls and logic. Option A is not a Copilot capability, since designing complex custom code components requires professional developer tools such as the Power Apps Component Framework (PCF) CLI, not Copilot. Option C is not a Copilot capability, because deployment to production environments is handled through solutions, pipelines, and Power Platform administration rather than Copilot automation.

Answer

Design complex custom code components.

Answer

Automatically deploy apps to production environments.

Question 9

Which TWO of the following scenarios are best suited for Power Automate's cloud flows?

Accepted Answer

Automating approval processes in SharePoint.. Option A is correct because SharePoint is a first-class cloud connector in Power Automate, and approval processes are a canonical cloud flow scenario: a flow can trigger on an item being created or modified in a SharePoint list or library and use the Approvals connector to route the request to approvers, all without any on-premises infrastructure. Option B is correct because Microsoft Entra ID (Azure AD) exposes a native cloud connector, so a flow can trigger on events such as 'When a new user is created' and immediately send a welcome email via Outlook/Office 365 Outlook — a purely cloud-to-cloud integration with no gateway required. Option C is not the best fit because moving files from an on-premises server requires the on-premises data gateway (or a desktop flow), which is a hybrid scenario rather than a native cloud flow. Option D is not the best fit because automating data entry in a legacy desktop application requires UI automation, which is the domain of Power Automate desktop flows (RPA), not cloud flows.

Answer

Moving files from an on-premises server to a cloud storage.

Answer

Automating data entry from a legacy desktop application.

Question 10

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'. 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 11

A Power Apps app uses a canvas and connects to multiple data sources. Users complain that the app loads slowly. What is the best practice to improve performance?

Accepted Answer

Use the 'ClearCollect' function to cache data in a collection. The ClearCollect function allows you to cache data from external sources into a local collection within the app. This reduces the number of round trips to the data source during user interactions, significantly improving load and response times by minimizing network latency and data source throttling.

Answer

Add more screens to distribute the load

Answer

Increase the timeout settings

Answer

Use a single data source

Question 12

A Power Platform administrator wants to delegate the responsibility of managing environments to regional leads without granting them full admin privileges. Which role should the administrator assign?

Accepted Answer

Environment Admin role.. The Environment Admin role grants administrative rights scoped to a specific environment, allowing the user to manage that environment's settings, users, and resources without full tenant-wide admin privileges. This is the correct role for delegating environment management to regional leads.

Answer

Dynamics 365 Administrator role.

Answer

System Customizer role.

Answer

Power Platform Administrator role.

Question 13

A small business wants to create a Power Apps app to track customer interactions. They have limited budget and no dedicated IT staff. The app must be easy to maintain and should use a data source that requires minimal setup. The app will be used by 5 sales reps. Which approach should they take?

Accepted Answer

Use a SharePoint list as the data source and a Canvas app. SharePoint lists are easy to set up with no extra licensing (often included with Microsoft 365) and can be used with Canvas apps, which are low-code and easy to maintain. Option A is wrong because Dataverse requires additional licensing and Model-driven apps are more complex to build and maintain. Option B is wrong because Excel on OneDrive does not support multi-user concurrent access reliably and can lead to data conflicts. Option C is wrong because SQL Server requires dedicated infrastructure and maintenance, which is not feasible for a small business with limited budget and no IT staff.

Answer

Use Dataverse as the data source and a Model-driven app

Answer

Use Excel stored on OneDrive and a Canvas app

Answer

Use SQL Server as the data source and a Canvas app

Question 14

A company uses Power Virtual Agents (now Copilot Studio) to build a customer service chatbot. The bot needs to securely escalate to a live agent when it cannot resolve the issue. The escalation must pass the conversation context to the agent. What should the bot use?

Accepted Answer

Transfer conversation action. In Power Virtual Agents (now Copilot Studio), the 'Transfer conversation' action is the built-in mechanism to escalate a bot conversation to a live agent while preserving the full conversation context. This action hands off the session to a configured engagement hub or live agent system, passing along the transcript and context so the agent can continue seamlessly. It is the native, supported method for human handoff in Copilot Studio.

Answer

HTTP request to a webhook

Answer

Power Automate flow trigger

Answer

Custom connector for the live agent system

Question 15

Refer to the exhibit. A Power Automate cloud flow is configured to move files in a SharePoint document library based on approval status. The flow triggers when a file is created in the 'Pending' folder. However, when a file is uploaded to the 'Pending' folder, the flow does not trigger. What is the most likely cause?

Accepted Answer

The flow is configured to trigger on file creation in the root of the document library, not the 'Pending' folder. The most likely cause is that the flow trigger is configured to monitor the root of the SharePoint document library rather than the specific 'Pending' folder. Power Automate's 'When a file is created' trigger requires explicit folder path selection; if the trigger is set to the library root, it will not fire for files created in subfolders unless the trigger is configured with the folder path pointing to 'Pending'. This is a common misconfiguration when the trigger scope is not narrowed to the intended folder.

Answer

The condition expression is incorrect, causing the flow to fail silently

Answer

The flow uses a 'When a file is created' trigger, but the file is being modified, not created

Answer

The flow requires a Power Automate per user plan