PL-900 Describe the business value of Microsoft Power Platform — 30 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 logistics company uses Power Apps to build a fleet management app. They need to integrate real-time GPS data from IoT devices. Which connector should they use?

Accepted Answer

IoT connector. The IoT connector is specifically designed to ingest and process data from Internet of Things devices, including real-time GPS streams from fleet telematics. It provides built-in triggers and actions for handling device telemetry, making it the correct choice for integrating live GPS data into a Power Apps fleet management solution.

Answer

SharePoint connector

Answer

Dynamics 365 connector

Answer

Office 365 Users connector

Question 3

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 4

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 5

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 6

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

Accepted Answer

Reduces need for custom coding. Option A is correct because 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 7

Which THREE components are part of Microsoft Power Platform?

Accepted Answer

Power Apps. Power Apps is a core component of Microsoft Power Platform, enabling users to build custom low-code applications for web and mobile. It integrates seamlessly with other platform components like Power Automate and Power BI to create end-to-end business solutions.

Answer

Power Virtual Agents

Answer

Azure DevOps

Question 8

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. Option C is correct because 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 9

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.. Option C is correct because 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 10

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 11

A company's IT department is overwhelmed with password reset requests. They want to allow employees to reset passwords themselves using a conversational interface. Which Power Platform tool should they use?

Accepted Answer

Power Virtual Agents. Power Virtual Agents (C) is the correct tool because it enables the creation of conversational AI chatbots that can handle password reset requests through natural language interactions. It integrates with Azure Active Directory and other identity systems to allow employees to securely reset their own passwords without IT intervention, reducing the helpdesk workload.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate

Question 12

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 13

A non-profit organization needs to collect feedback from event attendees via a form that automatically populates a SharePoint list. Which Power Platform component should they use?

Accepted Answer

Power Apps (canvas app). A canvas app in Power Apps can be built to collect feedback from event attendees and, using its built-in SharePoint connector, automatically write responses to a SharePoint list. This directly meets the requirement of a custom form that populates a SharePoint list without additional workflow logic.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Power BI

Question 14

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

Question 15

Match each Microsoft Dataverse security concept to its definition.

Question 16

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 17

A company wants to build a custom app to track inventory across multiple warehouses. The app must use existing data from a SQL Server database and provide real-time updates. Which Power Platform component should they use to connect the app to the data source?

Accepted Answer

Power Apps with a connector. Option A is correct because Power Apps connectors provide pre-built integration with SQL Server, enabling the app to read and write data directly from the existing database. This allows real-time updates by using the SQL Server connector, which supports live queries and triggers without requiring data migration.

Answer

Microsoft Dataverse

Answer

Power BI

Answer

Power Automate

Question 18

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. Option C is correct because 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 19

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 20

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