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

Question 1

A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it enables the sales team to create automated workflows that trigger follow-up emails based on customer interactions, such as when a new contact is added or a meeting ends. It integrates with common data sources like Dynamics 365, SharePoint, or Outlook, and uses prebuilt connectors to send emails without any custom code.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 2

A hospital uses Power BI to monitor patient wait times. The data source is an on-premises SQL Server database. To ensure real-time reporting, what should the hospital deploy?

Accepted Answer

On-premises data gateway. The on-premises data gateway (Option C) is the correct choice because it acts as a bridge between Power BI in the cloud and the on-premises SQL Server database, enabling real-time or near-real-time data refreshes for dashboards. Without this gateway, Power BI cannot directly connect to on-premises data sources, making it impossible to achieve real-time reporting from the hospital's local database.

Answer

Azure Data Factory

Answer

Power BI Report Server

Answer

Power BI Desktop

Question 3

A non-profit organization wants to automate donation receipt emails and track donor engagement. Which Microsoft Power Platform tool should they use?

Accepted Answer

Power Automate. Power Automate is the correct tool because it enables the non-profit to create automated workflows that can trigger donation receipt emails when a new donation is recorded, and it can also update donor engagement metrics in a connected data source like Dataverse or SharePoint. This directly addresses the need for automating email notifications and tracking engagement without manual intervention.

Answer

Power Virtual Agents

Answer

Power BI

Answer

Power Apps

Question 4

A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?

Accepted Answer

The app uses a non-delegable query on a large data source. The most likely cause of slow loading in a Power Apps inventory management app is a non-delegable query on a large data source. When a query cannot be delegated, Power Apps retrieves all records from the data source to the client device, then filters locally, causing significant performance degradation with large datasets. This is a common issue when using functions like `Filter` with unsupported operators or columns on large tables.

Answer

The app has too many controls per screen

Answer

The app uses too many screens

Answer

The app has complex formulas in OnStart

Question 5

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

Accepted Answer

Reduces need for custom coding. Microsoft Power Platform provides low-code and no-code tools like Power Automate and Power Apps, enabling users to create automated workflows and applications without writing custom code. This reduces reliance on professional developers and accelerates business process automation.

Answer

Requires dedicated IT team for every automation

Answer

Only works on-premises

Answer

Requires deep knowledge of programming languages

Question 6

A retail company wants to reduce the time store managers spend on manual inventory reporting. Currently, managers use paper forms and email to submit daily stock counts, which then need to be manually entered into a central system. This process is error-prone and delays replenishment. The company wants a solution that automates data entry, provides real-time dashboards, and allows managers to submit reports from their phones without installing any software on the phones. Which combination of Microsoft Power Platform tools should the company use?

Accepted Answer

Power Apps, Power Automate, and Power BI. The scenario requires a combination of Power Apps (for mobile-friendly report submission without installing software), Power Automate (to automate data entry into the central system), and Power BI (to provide real-time dashboards). Power Apps alone cannot automate data entry or provide dashboards; Power Automate alone cannot provide a mobile input interface or dashboards; Power BI alone cannot capture data or automate workflows. Only the trio covers all requirements: mobile input, automated processing, and real-time visualization.

Answer

Power Automate only

Answer

Power Apps only

Answer

Power BI only

Question 7

A global manufacturing company uses Microsoft Power Platform to manage its equipment maintenance processes. The company has over 10,000 maintenance technicians worldwide who use a Power Apps mobile app to report equipment issues and log repairs. The app connects to a common data service (Dataverse) that stores all maintenance records. Recently, the company experienced a data breach where a malicious user exploited a vulnerability in the app to access and delete maintenance records from multiple high-value machines. The security team traced the issue to the app's permissions model: the app was using a single service account with elevated privileges to perform all data operations. The company now wants to redesign the app's security to follow the principle of least privilege while maintaining usability for technicians. The technicians need to view their assigned work orders, create new issue reports, and update the status of their own repairs, but they should not be able to delete records or access records from other regions. Which approach should the company take?

Accepted Answer

Implement row-level security in Dataverse to restrict technicians to their own records and region, assign appropriate role-based access (create, read, update, no delete), and use individual user accounts.. It applies the principle of least privilege by using individual user accounts with Dataverse role-based security and row-level security (RLS). This ensures each technician can only create, read, and update their own assigned records within their region, while explicitly denying delete permissions. This approach eliminates the shared, over-privileged service account and enforces granular data isolation.

Answer

Replace the Power Apps app with a Power Automate flow that technicians trigger via email to submit and update records.

Answer

Configure each technician's individual user account with a basic user role in Dataverse, and remove the service account.

Answer

Create a separate Power Apps app for each region, each with its own service account that has restricted permissions to that region's data.

Question 8

A sales manager wants to track leads and opportunities without custom development. Which Power Platform component should they use?

Accepted Answer

Power Apps (model-driven app). A model-driven app in Power Apps is designed for data-centric business processes like lead and opportunity tracking, providing out-of-the-box tables, forms, and views without custom development. It leverages the Dataverse to store and manage structured data, making it ideal for a sales manager to track leads and opportunities through a pre-configured, customizable interface.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Automate

Question 9

A company uses Dynamics 365 Sales and wants to automatically send a follow-up email to a customer when an opportunity is marked 'Closed Won'. They need a solution that requires no custom code. What should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it provides a no-code workflow automation platform that can trigger a flow when an opportunity's status changes to 'Closed Won' in Dynamics 365 Sales. It uses a prebuilt connector to Dynamics 365 to send an email via the Office 365 Outlook connector, requiring no custom code or development effort.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 10

Drag and drop the steps to configure a Power Virtual Agents chatbot in the correct order.

Accepted Answer

Step 1: Create a new chatbot, Step 2: Define topics, Step 3: Add nodes to topics, Step 4: Test the chatbot, Step 5: Publish the chatbot. The correct sequence for configuring a Power Virtual Agents chatbot is: first create the bot, then define topics to handle user intents, add nodes to each topic to define the conversation flow, test the bot in the test pane to verify behavior, and finally publish the bot to make it available to users. Publishing before testing risks deploying unresolved issues.

Answer

Step 1: Create a new chatbot, Step 2: Add nodes to topics, Step 3: Define topics, Step 4: Test the chatbot, Step 5: Publish the chatbot

Answer

Step 1: Create a new chatbot, Step 2: Define topics, Step 3: Add nodes to topics, Step 4: Publish the chatbot, Step 5: Test the chatbot

Answer

Step 1: Create a new chatbot, Step 2: Test the chatbot, Step 3: Define topics, Step 4: Add nodes to topics, Step 5: Publish the chatbot

Question 11

A sales team wants to automate lead assignment based on region without writing code. Which Microsoft Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it enables users to create automated workflows that can assign leads based on region using conditional logic and data from sources like Dynamics 365 or SharePoint, all without writing code. It provides prebuilt connectors and triggers (e.g., 'When a lead is created') to automate business processes seamlessly.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 12

An organization is deploying Power Apps to external customers for a self-service portal. They need to ensure that customer data is isolated from internal employee data. What is the best approach?

Accepted Answer

Create separate environments for internal and external users. Creating separate environments for internal and external users provides full tenant-level isolation of customer data from employee data. Each environment in Power Platform has its own databases, security settings, and data storage, ensuring that external customers cannot access internal resources even if security roles are misconfigured.

Answer

Use Data Loss Prevention (DLP) policies in the same environment

Answer

Add external customers as B2B guests in the same environment

Answer

Use the same environment with security role-based access

Question 13

A manager needs to quickly analyze sales data from multiple sources and share interactive dashboards with the team. Which Power Platform tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for data analytics and visualization. It can connect to multiple data sources, transform and model the data, and create interactive dashboards that can be shared securely with team members via the Power BI service. This directly meets the manager's need to analyze sales data from multiple sources and share interactive dashboards.

Answer

Power Automate

Answer

Power Apps

Answer

Power Virtual Agents

Question 14

A company has a legacy on-premises SQL Server database and wants to build a Power BI report that refreshes daily. However, the database is behind a firewall. What should they use to securely access the data?

Accepted Answer

An on-premises data gateway. An on-premises data gateway is the correct solution because it acts as a secure bridge between on-premises data sources (like SQL Server behind a firewall) and cloud services such as Power BI. The gateway encrypts data in transit and allows scheduled refresh without opening inbound ports in the firewall, using outbound connections to Azure Service Bus.

Answer

Power Automate with SQL connector

Answer

Microsoft Dataverse

Answer

A VPN connection to the database

Question 15

A non-technical employee wants to create a simple chatbot to answer common HR questions. Which Power Platform component should they use?

Accepted Answer

Power Virtual Agents. Power Virtual Agents (C) is the correct choice because it is a no-code, AI-driven chatbot service within Power Platform specifically designed for building conversational agents. It allows non-technical users to create, publish, and analyze chatbots using a graphical interface without writing code, making it ideal for handling common HR questions through predefined topics and natural language understanding.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate