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

Question 1

Refer to the exhibit. You see a Power BI DAX measure. What does this measure calculate?

Accepted Answer

Total sales for the previous year relative to the selected year.. The DAX measure uses the `SAMEPERIODLASTYEAR` function, which shifts the current filter context back by one year. When placed in a visual with a year slicer or axis, it returns the total sales for the same period in the previous year relative to the selected year. This is a standard time intelligence calculation for comparing year-over-year absolute values.

Answer

Total sales for the current year.

Answer

Running total of sales up to the selected year.

Answer

Year-over-year growth percentage.

Question 2

Refer to the exhibit. You see a configuration snippet for a Microsoft Copilot Studio bot. What is the purpose of 'triggerPhrases'?

Accepted Answer

They identify which topics the bot should use when a user says those phrases.. Trigger phrases are the phrases that activate a specific topic in a Copilot Studio bot.

Answer

They define the bot's fallback behavior.

Answer

They define the responses the bot will give.

Answer

They are used for analytics reporting.

Question 3

Refer to the exhibit. You are analyzing a Power Automate flow definition. The flow is intended to create a new user record in Dataverse and send an email notification when manually triggered or daily at 8 AM. However, when the flow runs on its schedule, it fails because the trigger output 'name' is empty. What is the most likely cause?

Accepted Answer

The schedule trigger does not provide a 'name' field in its outputs, causing the expression to fail.. A scheduled trigger in Power Automate does not include a 'name' field in its outputs, whereas a manual trigger (e.g., Power Apps or button) typically does. When the flow runs on its daily 8 AM schedule, the expression referencing trigger outputs 'name' evaluates to empty, causing the subsequent actions to fail. This is a common mismatch between trigger types and expected output schemas.

Answer

The action 'CreateRecord' has an invalid entity name 'Users'.

Answer

The flow is configured to run only on manual trigger, ignoring the schedule.

Answer

The flow does not have permission to create records in Dataverse.

Question 4

Refer to the exhibit. You are building a Power BI report to analyze sales performance. You create a measure named 'Total Sales' using the DAX expression shown. However, the measure returns a value that is much higher than expected. What is the most likely issue?

Accepted Answer

The measure is using SUMX without an appropriate filter context, leading to incorrect row iteration.. The DAX expression shown uses SUMX, which iterates over each row of the Sales table and sums the product of Quantity and Price. Without an appropriate filter context (e.g., from a Date table or slicer), SUMX may aggregate over the entire table, including rows that should be excluded, leading to a much higher total than expected. The issue is not a missing relationship but rather the lack of a proper filter context to restrict the rows being iterated.

Answer

The Sales table lacks a relationship to the Date table, causing incorrect time-based calculations.

Answer

The measure is being filtered by a disconnected slicer, causing overfiltering.

Answer

The measure should use DISTINCTCOUNT instead of SUMX to count sales.

Question 5

Your organization wants to allow employees to submit help desk tickets through a mobile app. The solution must be low-code and integrate with Microsoft Teams. Which Microsoft Power Platform component should you use?

Accepted Answer

Power Apps. Power Apps is the correct component because it enables the creation of custom mobile apps with low-code development, allowing employees to submit help desk tickets directly from their mobile devices. It integrates natively with Microsoft Teams through the Power Apps app in Teams, enabling users to access and submit tickets without leaving the Teams interface. This aligns with the requirement for a low-code solution that works within the Teams ecosystem.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Power BI

Question 6

You are a Power Platform administrator. A user reports that a Power Automate flow that connects to SharePoint Online fails intermittently with a '403 Forbidden' error. The flow uses a service principal with application permissions. What is the most likely cause?

Accepted Answer

The service principal lacks the necessary SharePoint API permissions or admin consent.. A 403 Forbidden error specifically indicates that the server understood the request but refuses to authorize it. Since the flow uses a service principal with application permissions, the most likely cause is that the service principal lacks the necessary SharePoint API permissions or that admin consent has not been granted for those permissions. Without proper permissions or consent, SharePoint Online rejects the request regardless of authentication validity.

Answer

The flow is exceeding the SharePoint Online API throttling limits.

Answer

The service principal has been disabled in Microsoft Entra ID.

Answer

SharePoint Online is experiencing a service outage.

Question 7

Your company wants to create a chatbot that can answer employee questions about IT policies and escalate complex issues to a human agent. The chatbot should be built with minimal custom code. Which two Microsoft Power Platform components should you combine?

Accepted Answer

Power Virtual Agents. This is a multiple-select question requiring two components. Power Virtual Agents (A) is the correct choice because it provides a low-code, conversational AI platform specifically designed to build chatbots with minimal custom code, enabling the creation of a bot that answers IT policy questions. Power Automate (C) is correct because it can be used to escalate complex issues to a human agent by triggering workflows, such as sending an email or creating a ticket in a helpdesk system, without writing code.

Answer

Power BI

Answer

Power Apps

Question 8

A sales team wants to track their deals in a shared workspace without using Excel. They need a solution that can be customized quickly and accessed from mobile devices. Which Power Platform component should you recommend?

Accepted Answer

Microsoft Lists. Microsoft Lists is the correct recommendation because it is a shared workspace specifically designed for tracking information like deals. It is highly customizable with columns, views, and rules, and is accessible from mobile devices through the Microsoft Lists mobile app. While it is not a core Power Platform service, it is often integrated with Power Platform solutions and is the best fit for the described scenario. Power Automate is for workflows, not for providing a shared workspace.

Answer

Power Automate

Answer

Power BI

Answer

Power Virtual Agents

Question 9

Your organization has a Power Apps app that uses the Microsoft Dataverse connector. Users report that the app loads slowly. You review the app and find that it loads all records from a large table (over 500,000 rows) into a gallery. What is the best action to improve performance?

Accepted Answer

Modify the gallery's Items property to use a delegable filter, such as Filter(Table, Condition).. Modifying the gallery's Items property to use a delegable filter (e.g., Filter(Table, Condition)) ensures that the query is processed server-side by Microsoft Dataverse, retrieving only the subset of records that match the condition. This avoids loading all 500,000+ rows into the client app, which is the root cause of the slow performance. Delegation allows Power Apps to offload data processing to the data source, significantly reducing network payload and client memory usage.

Answer

Increase the data row limit in the app settings.

Answer

Clear the app cache on the client devices.

Answer

Reduce the delegation limit in the environment settings.

Question 10

You are designing a solution to automatically send a welcome email to new employees after their record is created in a Dataverse table. The solution must use a Microsoft Power Platform component. Which component should you use?

Accepted Answer

Power Automate. Power Automate can create automated workflows that trigger on record creation in Dataverse and send welcome emails. Option A is incorrect because Power Apps is for building custom apps, not for automation. Option B is incorrect because Power BI is for data visualization and analytics. Option D is incorrect because Power Pages is for creating external-facing websites.

Answer

Power Apps

Answer

Power BI

Answer

Power Pages

Question 11

Your company wants to analyze sales data from multiple sources and create interactive dashboards. The solution must be cloud-based and require minimal IT support. Which Power Platform component should you use?

Accepted Answer

Power BI. Power BI is the correct choice because it is a cloud-based business analytics service that enables you to connect to multiple data sources, transform and model the data, and create interactive dashboards and reports. It requires minimal IT support through its self-service capabilities, allowing business analysts to build visualizations without deep technical expertise.

Answer

Power Apps

Answer

Power Automate

Answer

Power Virtual Agents

Question 12

A manufacturing company uses Power Apps to track inventory. They want to add a feature that automatically reorders stock when levels fall below a threshold. The solution must be low-code. Which Power Platform component should be integrated with Power Apps?

Accepted Answer

Power Automate. Power Automate is the correct component because it provides low-code workflow automation that can monitor inventory levels in real time and trigger reorder actions when thresholds are breached. By integrating Power Automate with Power Apps, you can create a cloud flow that checks stock data from a data source (e.g., Dataverse or SQL) and automatically sends reorder notifications or creates purchase orders, all without writing traditional code.

Answer

Power BI

Answer

Power Pages

Answer

Power Virtual Agents

Question 13

You are a Power Platform administrator. A user reports that they cannot create a new environment in the Power Platform admin center. The user has a Power Apps per user plan license. What is the most likely reason?

Accepted Answer

The user does not have a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2.. Creating environments in the Power Platform admin center requires a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2. The user's Power Apps per user plan license only allows them to use apps and flows, not to create or manage environments. Without the appropriate license, the environment creation option is disabled in the admin center.

Answer

The user does not have access to the Power Platform admin center.

Answer

The user is not a global administrator in Microsoft Entra ID.

Answer

The user has not assigned the license to themselves.

Question 14

Your organization wants to create a public-facing website where customers can submit support requests. The website should be built with minimal custom code and integrate with Dataverse. Which Power Platform component should you use?

Accepted Answer

Power Pages. Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform for creating public-facing websites that integrate directly with Dataverse. It enables external customers to submit support requests without custom code, leveraging built-in authentication, form components, and Dataverse data binding.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate

Question 15

You need to design a solution that sends a notification to a manager when an employee submits a time-off request in a SharePoint list. Which Power Platform component should you use?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that trigger on events, such as when an item is created or modified in a SharePoint list. In this scenario, you would configure a Power Automate flow with a SharePoint 'When an item is created' trigger to send an email notification to the manager, without requiring manual intervention or custom code.

Answer

Power Virtual Agents

Answer

Power Apps

Answer

Power BI