PL-900 Describe the business value of Microsoft Power Platform Practice Test 3 — 15 Questions

Question 1

A sales team uses a SharePoint list to track leads. They want to automatically send an email notification when a lead's status changes to 'Closed Won'. Which Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is designed to create automated workflows that trigger on events, such as a change in a SharePoint list item. When a lead's status changes to 'Closed Won', a Power Automate flow can use the 'When an item is modified' trigger, check the status value, and then send an email via the 'Send an email' action (e.g., using Office 365 Outlook). This directly addresses the requirement for automatic notification without manual intervention.

Answer

Power BI

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 2

A company wants to build a custom app for field technicians to log maintenance reports offline and sync when connected. Which Power Platform component should be used?

Accepted Answer

Power Apps. Power Apps is the correct component because it allows building custom canvas or model-driven apps that can run offline on mobile devices using the Power Apps mobile app. Field technicians can log maintenance reports without connectivity, and the app automatically syncs data to Dataverse or other data sources when a network connection is restored, leveraging the offline-first capability.

Answer

Power Pages

Answer

Power Automate

Answer

Power BI

Question 3

A retail company uses Power BI to analyze sales data. They want to allow store managers to view their own store's sales but not other stores. Which Power BI feature should they implement?

Accepted Answer

Row-level security (RLS). Row-level security (RLS) in Power BI allows you to restrict data access for specific users based on roles and filters. By defining a role that filters sales data by store ID and assigning store managers to that role, each manager can only see their own store's sales, meeting the requirement without duplicating reports or data.

Answer

Power Apps embedding

Answer

Power Automate flows to filter data

Answer

Microsoft Copilot Studio

Question 4

A nonprofit organization wants to create a public website to accept donations without writing code. Which Power Platform component should they use?

Accepted Answer

Power Pages. Power Pages is the correct choice because it enables users to create low-code, externally facing websites that can securely accept payments and donations without writing custom code. It provides built-in templates, data integration with Dataverse, and supports anonymous access for public users, making it ideal for a nonprofit's donation portal.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps

Question 5

A company uses Microsoft Dataverse to store customer data. They want to create a unified view of sales and support interactions for each customer. Which feature should they use?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse is the correct choice because it provides a unified, relational data store that can combine sales and support interaction data into a single customer entity. By using Dataverse tables and relationships, you can create a 360-degree view of each customer without moving data to external systems, enabling real-time insights within Power Apps or model-driven apps.

Answer

Power BI

Answer

Microsoft Copilot Studio

Answer

Power Automate

Question 6

An organization wants to implement AI-driven insights for sales forecasting using historical data. Which Power Platform capability should they use?

Accepted Answer

Power Automate with AI Builder. Option D is correct because AI Builder within Power Automate provides prebuilt AI models (e.g., prediction models) that can analyze historical sales data to generate forecasts. This capability is specifically designed for integrating AI-driven insights into automated workflows without requiring custom machine learning development.

Answer

Power BI Quick Insights

Answer

Microsoft Copilot Studio

Answer

Power Apps with Dataverse

Question 7

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 8

A marketing team needs to analyze customer feedback from surveys and social media. They want to use AI to extract sentiment and key topics. Which capability should they use?

Accepted Answer

AI Builder. AI Builder includes sentiment analysis and key phrase extraction models. Power Automate can orchestrate but needs AI Builder for the AI. Power BI and Copilot Studio are not the primary tools for this custom AI task.

Answer

Microsoft Copilot Studio

Answer

Power BI natural language queries

Answer

Power Automate

Question 9

A company wants to build a custom copilot for internal IT support. The copilot should answer common questions and escalate to a human agent if needed. Which component should they use?

Accepted Answer

Microsoft Copilot Studio. Microsoft Copilot Studio is the correct choice because it is specifically designed to build custom copilots (formerly Power Virtual Agents) that can handle conversational Q&A and seamlessly escalate to a human agent when the copilot cannot resolve the issue. This directly matches the requirement for an internal IT support copilot that answers common questions and escalates to a human agent.

Answer

Power Automate

Answer

Power BI

Answer

Power Apps

Question 10

Which TWO statements accurately describe the business value of Microsoft Power Platform?

Accepted Answer

It provides integration with Microsoft 365 and Azure services.. Option C is correct because Microsoft Power Platform is designed to seamlessly integrate with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL Database), enabling organizations to extend their existing investments and build end-to-end solutions. This integration is a core business value, as it allows data and processes to flow across the Microsoft ecosystem without custom middleware.

Answer

It can only be used with Microsoft 365 data.

Answer

It requires professional developers to write all code.

Answer

It is primarily a data analytics tool.

Question 11

Which TWO benefits does using Microsoft Power Platform provide to an organization?

Accepted Answer

Reduces the time needed to build business applications.. Power Platform reduces development time and enables business users to solve problems directly. It does not require heavy IT involvement for every change, and it is not limited to large enterprises.

Answer

Eliminates the need for any security governance.

Answer

Only benefits large enterprises with extensive IT resources.

Answer

Requires dedicated IT teams for every modification.

Question 12

Which THREE capabilities does Microsoft Power Platform include to help organizations achieve digital transformation?

Accepted Answer

Low-code application development. Power Platform includes low-code app development (Power Apps), workflow automation (Power Automate), and data analytics (Power BI). Custom AI model training is via AI Builder, not a separate component, and it does not replace all coding.

Answer

Custom AI model training from scratch

Answer

Replacement of all custom coding

Question 13

You are reviewing a Power Automate flow definition. The flow should send an email when a new invoice file is added to a SharePoint folder. However, the flow is not triggering. What is the most likely cause?

Accepted Answer

The folder path '/documents/invoices' is incorrect or the flow lacks permissions.. The most likely cause is that the folder path '/documents/invoices' is incorrect or the flow lacks permissions. Power Automate triggers for SharePoint require exact folder paths and appropriate access rights to monitor file additions. If the path is misspelled, uses a relative path instead of a server-relative path, or the service account does not have read permissions on the folder, the trigger will not fire.

Answer

The email action uses an incorrect dynamic expression.

Answer

The flow needs a 'Get file content' action before sending email.

Answer

The SharePoint trigger requires a 'When a file is created or modified' trigger instead.

Question 14

A Power BI report shows a measure 'Sales Growth %' defined as above. The measure returns blank for some months even though sales data exists. What is the most likely cause?

Accepted Answer

The date table is not marked as a date table in Power BI.. When a date table is not marked as a date table in Power BI, time intelligence functions like SAMEPERIODLASTYEAR may not correctly identify the date context, causing them to return blank for certain periods even when data exists. Marking the table as a date table ensures that Power BI uses its built-in date hierarchy and calendar logic, which is required for functions that shift or compare date ranges.

Answer

The measure should use TOTALYTD instead of SAMEPERIODLASTYEAR.

Answer

The Sales table has no relationship with the Date table.

Answer

The DIVIDE function requires a third argument for alternate result.

Question 15

In a Power Apps canvas app, the App.OnStart property contains the code above. The LookUp function returns blank for a user who exists in the Roles data source. What is the most likely cause?

Accepted Answer

The Roles data source column name does not match 'UserEmail'.. Option D is correct because the LookUp function in Power Apps relies on exact column name matching. If the Roles data source has a column named 'Email' or 'UserID' instead of 'UserEmail', the function will not find a match and will return blank, even if the user exists. This is a common schema mismatch issue in canvas apps.

Answer

The app needs to refresh the Roles data source first.

Answer

The Set function cannot store records.

Answer

The User() function is not available in Power Apps.