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

Question 1

A Power BI report uses the KQL query shown. What is the purpose of this query?

Accepted Answer

To show total sales per product category for North America in descending order. The KQL query uses the `summarize` operator to group sales data by `ProductCategory` and calculate the total sales amount using `sum(SalesAmount)`. The `where` clause filters for `Region == 'North America'`, and `order by` sorts the aggregated results in descending order. This produces a list of product categories with their total sales for North America, sorted from highest to lowest.

Answer

To list all sales transactions for North America

Answer

To calculate average sales amount by region

Answer

To filter sales data by product category

Question 2

An administrator configures a Power Platform tenant-level policy with the JSON shown. What is the effect of this policy?

Accepted Answer

It restricts all users from accessing any Power Platform environment. The JSON policy sets the 'blocked' property to true for all environments, which effectively denies all users (including admins) access to any Power Platform environment. This is a tenant-level restriction that overrides individual environment permissions, making it impossible for anyone to interact with Power Apps, Power Automate, or Power Virtual Agents within the tenant.

Answer

It allows only admins to manage environments

Answer

It prevents data export from environments

Answer

It blocks all users from creating new environments

Question 3

A retail company uses Power Apps to manage inventory. Store managers report that the app loads slowly during peak hours. Which action should the administrator take to improve performance?

Accepted Answer

Enable app caching in the app settings.. Enabling app caching in Power Apps stores app resources locally on the user's device, reducing load times by minimizing repeated downloads of the app definition and data requests during peak usage. This directly addresses the slow loading reported by store managers by leveraging client-side caching to improve performance.

Answer

Create a Power Automate flow to preload data.

Answer

Increase the data source row limit to 2000.

Answer

Add more screens to distribute data entry.

Question 4

A non-profit organization wants to digitize its volunteer sign-up process. They need a solution that can be built quickly without custom code. Which Microsoft Power Platform component should they use?

Accepted Answer

Power Apps. Power Apps is the correct choice because it enables rapid creation of custom apps with a low-code or no-code approach, allowing the non-profit to build a volunteer sign-up form and data submission interface without writing custom code. It directly addresses the need to digitize a manual process by providing a user-friendly canvas or model-driven app that can connect to data sources like SharePoint or Dataverse.

Answer

Power BI

Answer

Copilot Studio

Answer

Power Automate

Question 5

A company has multiple Power Platform environments: Development, Test, and Production. They want to ensure that changes to a Power Automate cloud flow are validated before reaching production. Which approach should they use?

Accepted Answer

Use solution-aware flows and managed properties in Dev, then import to Test, and finally to Production after testing.. Solution-aware flows support managed properties and allow for structured application lifecycle management (ALM). By exporting the solution from Dev as a managed solution and importing it into Test for validation, then into Production, the company ensures that changes are validated at each stage. This approach prevents direct edits in production and maintains version control.

Answer

Edit the flow directly in the Production environment.

Answer

Create a new flow in Production based on a copy of the Dev flow.

Answer

Export the flow as a ZIP file from Dev and import to Production.

Question 6

A sales team uses Power BI dashboards to track quarterly revenue. They notice that the data in the dashboard is not updating as expected. The data source is a SharePoint list. What should the administrator check first?

Accepted Answer

Check the scheduled refresh settings in the Power BI dataset.. Power BI datasets connected to SharePoint lists require a scheduled refresh to update the dashboard with the latest data from the list. If the refresh is not configured or fails, the dashboard will display stale data. The administrator should first check the scheduled refresh settings in the Power BI service to ensure it is enabled and running successfully.

Answer

Install the on-premises data gateway.

Answer

Verify that all sales team members have edit permissions on the SharePoint list.

Answer

Ensure that the SharePoint list has no hidden columns.

Question 7

A healthcare organization is deploying Power Apps for patient intake. They must ensure that the app complies with HIPAA regulations. Which feature should they use to protect patient data at rest?

Accepted Answer

Enable Customer Managed Key (CMK) for the Power Platform environment.. Customer Managed Key (CMK) allows the healthcare organization to control the encryption key used to protect data at rest in their Power Platform environment. This ensures that even Microsoft cannot access the underlying data without the organization's key, which is a critical requirement for HIPAA compliance regarding data encryption at rest.

Answer

Require multi-factor authentication (MFA) for app users.

Answer

Enable audit logging in the Power Platform admin center.

Answer

Create a Data Loss Prevention (DLP) policy to restrict connectors.

Question 8

A marketing department wants to create a dashboard that shows real-time social media sentiment analysis. Which Power Platform tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed for data visualization and real-time analytics, including the ability to connect to social media APIs (e.g., Twitter, Facebook) via built-in connectors or custom streaming datasets to display sentiment analysis dashboards. It supports real-time data refresh through DirectQuery or streaming datasets, making it ideal for monitoring live social media sentiment.

Answer

Power Automate

Answer

Power Apps

Answer

Copilot Studio

Question 9

A company uses Power Virtual Agents (now Copilot Studio) to handle customer inquiries. They want to escalate complex issues to a human agent when the bot cannot resolve them. What should they configure?

Accepted Answer

Use the 'Escalate' topic to hand off to a live agent.. Power Virtual Agents (Copilot Studio) includes a built-in 'Escalate' topic that, when triggered, hands off the conversation to a live agent via a configured engagement hub (e.g., Dynamics 365 Customer Service or Omnichannel for Customer Service). This is the native mechanism for transferring unresolved issues to a human agent without requiring custom automation or removing other topics.

Answer

Create a Power Automate flow to send an email to the support team.

Answer

Remove all topics except the escalation topic.

Answer

Configure the bot to transfer to a second bot.

Question 10

An organization uses Power Automate to process invoices from email attachments. Some invoices are processed incorrectly because the flow fails to parse PDFs with non-standard layouts. What should the administrator do to improve accuracy?

Accepted Answer

Use AI Builder to create a custom document processing model.. AI Builder provides prebuilt and custom document processing models that use optical character recognition (OCR) and machine learning to extract data from PDFs with non-standard layouts. This directly addresses the root cause—parsing failures due to layout variability—by training the model on sample invoices to handle diverse formats, unlike static parsing logic.

Answer

Increase the flow run frequency to every minute.

Answer

Add a condition to route non-parsed invoices for manual approval.

Answer

Change the trigger to a manual button in Power Apps.

Question 11

A small business wants to automate sending a welcome email when a new customer is added to a CRM system. Which Power Platform service should they use?

Accepted Answer

Power Automate. Power Automate is the correct service because it is designed to create automated workflows that trigger actions based on events, such as sending a welcome email when a new customer record is added to a CRM system. It uses connectors to integrate with CRM platforms (e.g., Dynamics 365, Salesforce) and email services (e.g., Office 365 Outlook) to execute the automation without manual intervention.

Answer

Power Apps

Answer

Power BI

Answer

Copilot Studio

Question 12

Which TWO are benefits of using Microsoft Power Platform for business process automation? (Select TWO)

Accepted Answer

It reduces development time compared to traditional coding.. Microsoft Power Platform provides pre-built connectors, templates, and low-code tools like Power Automate and Power Apps that drastically reduce the time required to build business process automation compared to writing code from scratch. This enables rapid development and iteration without the overhead of traditional software development lifecycles.

Answer

It can be used offline without any connectivity.

Answer

It requires no coding skills for any scenario.

Answer

It only works with Microsoft data sources.

Question 13

Which THREE components are part of the Microsoft Power Platform? (Select THREE)

Accepted Answer

Power Apps. Power Apps is a core component of the Microsoft Power Platform that enables users to build custom business applications with low-code or no-code development. It integrates directly with other platform components like Power Automate and Power BI, and connects to hundreds of data sources via connectors, making it essential for rapid app creation.

Answer

Power Virtual Agents

Answer

Power Pages

Question 14

Which TWO are examples of using AI Builder within Power Platform? (Select TWO)

Accepted Answer

Extracting text from scanned invoices using prebuilt models.. AI Builder provides prebuilt models that can extract text and data from scanned invoices without requiring custom machine learning expertise. This capability integrates directly into Power Automate and Power Apps, enabling automated processing of invoice data within the Power Platform.

Answer

Setting up a Power Automate trigger when a new email arrives.

Answer

Designing a custom screen in a Power Apps canvas app.

Answer

Creating a Power BI dashboard to visualize sales data.

Question 15

Refer to the exhibit. A developer created a Power Automate flow based on the JSON. The flow is not updating the item status even when the manager approves. What is the most likely reason?

Accepted Answer

The flow does not wait for the approval response before running the condition.. The flow lacks a 'Wait for an approval' action or equivalent configuration. Without this, the flow proceeds immediately to the condition step before the manager has responded, so the condition evaluates based on the initial (unapproved) state of the approval variable, not the actual response. Power Automate requires an explicit 'Wait for an approval' action to pause execution until the approval decision is made.

Answer

The email is sent to the wrong recipient.

Answer

The update item action is missing.

Answer

The condition expression has incorrect syntax.