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

Question 1

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 2

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

Question 3

A company wants to automate the approval process for purchase orders. Which Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to automate workflows, including approval processes for purchase orders. It can trigger actions based on events, route documents for approval, and integrate with various data sources, making it ideal for streamlining business processes like purchase order approvals.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Apps

Question 4

A sales team needs to create a custom app to track leads and manage follow-ups, but they have no coding experience. Which Power Platform tool should they use?

Accepted Answer

Power Apps. Power Apps (Option D) is the correct tool because it enables users with no coding experience to build custom apps using a low-code, drag-and-drop interface. The sales team can create a lead-tracking app with forms, galleries, and data connections to Microsoft Dataverse or SharePoint without writing traditional code.

Answer

Power Pages

Answer

Power BI

Answer

Power Automate

Question 5

An organization wants to analyze customer sentiment from social media data and create interactive dashboards. Which combination of Power Platform tools should they use?

Accepted Answer

Power BI and AI Builder. Power BI can connect to data sources and create dashboards, while AI Builder can analyze sentiment. Power Automate is for workflows, and Power Apps for apps.

Answer

Power BI and Power Apps

Answer

Power Automate and Power Virtual Agents

Answer

Power Apps and Power Automate

Question 6

A company wants to provide a self-service portal where customers can check their order status. Which Power Platform tool is best suited for this?

Accepted Answer

Power Pages. Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform designed specifically for creating external-facing websites. It allows customers to log in and view their order status without requiring internal system access, making it ideal for self-service portals.

Answer

Power Automate

Answer

Power BI

Answer

Power Apps

Question 7

Your organization uses Microsoft Copilot Studio to create a chatbot that answers HR questions. What is the primary business value of this approach?

Accepted Answer

It automates routine inquiries, allowing HR to focus on strategic tasks.. The primary business value of using Microsoft Copilot Studio to create an HR chatbot is that it automates routine inquiries (e.g., leave balances, policy lookups), freeing HR staff to focus on strategic tasks like talent management and employee engagement. This aligns with the core Power Platform value of empowering users to build low-code solutions that improve operational efficiency without requiring custom app development or replacing human expertise.

Answer

It creates custom apps for HR processes.

Answer

It reduces the need for a human resources department.

Answer

It provides data analytics on HR metrics.

Question 8

A retail chain uses Power BI to analyze sales data from multiple stores. They want to enable store managers to see only their store's data. What feature should they use?

Accepted Answer

Power BI row-level security (RLS). Row-level security (RLS) in Power BI restricts data access at the row level based on user roles and filters. By defining roles that filter sales data by store ID and assigning store managers to their respective roles, each manager will only see their own store's data when viewing reports. This is the native Power BI feature designed for this exact scenario.

Answer

Power Pages permissions

Answer

Power Apps custom connector

Answer

Power Automate to filter data

Question 9

A company wants to automatically send a welcome email to new customers when they submit a form on the company website. Which Power Platform tool should be used?

Accepted Answer

Power Automate. Power Automate is the correct tool because it enables the creation of automated workflows that can trigger when a form is submitted, then send a welcome email via an email connector. This aligns with Power Automate's core purpose of automating business processes across applications and services without manual intervention.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 10

Your team needs to build a custom app that connects to Microsoft 365 and third-party services like Salesforce. Which Power Platform feature enables this?

Accepted Answer

Power Apps connectors. Power Apps connectors are the specific feature that enables integration with external services like Microsoft 365 and Salesforce. Connectors provide pre-built APIs and authentication wrappers that allow Power Apps to securely read, write, and trigger actions in these services without custom code.

Answer

Power Automate triggers

Answer

Power Pages templates

Answer

Power BI datasets

Question 11

A global organization uses Power Platform with Microsoft Dataverse as the data source. They need to ensure that users in different regions only see data relevant to their region. What should they implement?

Accepted Answer

Dataverse security roles with row-level security. Dataverse security roles can be configured with row-level security to restrict data access by region. This is a native capability of Dataverse.

Answer

Power Apps app permissions

Answer

Power Automate conditional logic

Answer

Power BI dashboard filters

Question 12

Which THREE of the following are core components of Microsoft Power Platform? (Select three.)

Accepted Answer

Power Automate. Power Automate is a core component of Microsoft Power Platform because it provides low-code workflow automation capabilities that integrate seamlessly with other Power Platform services like Power Apps and Power BI. It enables users to create automated workflows across hundreds of connectors without writing code, directly supporting the platform's goal of empowering citizen developers.

Answer

Azure Logic Apps

Answer

Dynamics 365

Question 13

Which TWO of the following are benefits of using Microsoft Power Platform for citizen developers? (Select two.)

Accepted Answer

Low-code/no-code tools enable non-developers to create solutions.. Microsoft Power Platform provides low-code/no-code tools like Power Apps, Power Automate, and Power BI that allow citizen developers—users without formal programming training—to build applications, automate workflows, and create data visualizations using drag-and-drop interfaces and simple logic. This democratizes solution creation by reducing the technical barrier to entry.

Answer

Requires extensive coding knowledge.

Answer

High-performance computing for complex algorithms.

Answer

Only available for enterprise customers.

Question 14

Which THREE of the following are capabilities of AI Builder within Power Platform? (Select three.)

Accepted Answer

Sentiment analysis. AI Builder includes a prebuilt sentiment analysis model that analyzes text and returns sentiment scores (positive, negative, neutral, or mixed) using natural language processing (NLP). This capability allows Power Apps and Power Automate to assess customer feedback, social media posts, or survey responses without requiring custom machine learning expertise.

Answer

Replacing Azure Machine Learning

Answer

Building custom machine learning models from scratch

Question 15

Refer to the exhibit. You see a Power Automate flow definition in JSON. What does this flow do?

Accepted Answer

It creates a lead in Dataverse when a new email arrives in the inbox.. The flow trigger is 'When a new email arrives' (inbox trigger), and the action is 'Create a new lead' in Dataverse. This means the flow automatically creates a lead record in Dataverse whenever a new email arrives in the specified inbox, without requiring any manual intervention.

Answer

It updates a lead record when an email is received.

Answer

It deletes emails after creating leads.

Answer

It sends an email when a new lead is created in Dataverse.