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

Question 1

A company's Power Platform environment has a Dataverse table with a business rule that sets the 'Status' field to 'Expired' when 'EndDate' is in the past. However, the rule does not apply retroactively. How can the administrator enforce the rule for existing records?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Create a Power Automate flow that runs on existing records and updates the status.. Business rules in Dataverse do not apply retroactively to existing records; they only trigger on new or updated records. A Power Automate flow can be configured to query all existing records where 'EndDate' is in the past and 'Status' is not 'Expired', then update the 'Status' field accordingly. This provides a scalable, automated solution without manual intervention.

Answer

Manually update the records using Excel import.

Answer

Create a calculated field that computes the status.

Answer

Modify the business rule to run on load for all records.

Question 2

A small business wants to create a custom app to track inventory without hiring developers. Which Microsoft Power Platform tool should they use?

Accepted Answer

Power Apps. Power Apps is the correct choice because it enables users to build custom applications with low-code or no-code tools, allowing the small business to create an inventory tracking app without hiring professional developers. Power Apps provides pre-built templates and connectors to data sources like SharePoint or SQL Server, making it ideal for rapid app development tailored to specific business needs.

Answer

Power Virtual Agents

Answer

Power BI

Answer

Power Automate

Question 3

A global company has multiple Power Platform environments (Dev, Test, Prod) and uses Application Lifecycle Management (ALM) with solutions. The administrator needs to ensure that only tested solutions are deployed to production. What is the recommended approach?

Accepted Answer

Export the solution as managed from Dev, import to Test, then after validation, import to Prod.. Application Lifecycle Management (ALM) in Power Platform requires solutions to be exported as managed from a development environment, then imported into test for validation, and finally imported into production. This ensures that only tested, versioned components are deployed, preventing unvalidated changes from reaching production. Managed solutions also lock components in the target environment, preventing accidental modifications.

Answer

Share the solution from Dev to Test to Prod using sharing permissions.

Answer

Allow developers to make changes directly in the production environment.

Answer

Copy the Dataverse database from Dev to Prod directly.

Question 4

Which TWO of the following are benefits of using Microsoft Power Platform for business process automation? (Choose two.)

Accepted Answer

Provides seamless integration with Microsoft 365 and Azure services.. Option A is correct because Power Platform is natively built into the Microsoft ecosystem, offering out-of-the-box connectors to Microsoft 365 services (SharePoint, Teams, Outlook, Dataverse) and Azure services (Azure Functions, Logic Apps, Service Bus), which lets makers integrate existing enterprise data and identity without custom middleware. Option E is correct because low-code/no-code tools such as Power Apps, Power Automate, and Power Virtual Agents allow citizen developers and pro developers to build, test, and publish apps and flows in hours or days rather than weeks, accelerating delivery of custom business solutions. Option B is incorrect because Power Platform supports hundreds of cloud and on-premises connectors via the on-premises data gateway, so it is not limited to on-premises sources. Option C is incorrect because automation can reduce manual entry but cannot universally eliminate it, since human input, approvals, and exception handling are often still required. Option D is incorrect because Power Platform is explicitly a low-code platform, so extensive programming knowledge is not a prerequisite for building solutions.

Answer

Only works with on-premises data sources.

Answer

Eliminates the need for any manual data entry.

Answer

Requires extensive programming knowledge to build solutions.

Question 5

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

Accepted Answer

Text recognition (OCR) from images and PDFs.. Option A is correct because AI Builder provides a prebuilt text recognition (OCR) capability that extracts printed or handwritten text from images and PDF documents. Option C is correct because AI Builder includes prebuilt object detection models that identify and locate objects within images. Option D is correct because AI Builder offers form processing models that extract structured data such as key-value pairs and tables from documents like invoices and receipts. Option B is not correct because AI Builder is designed for prebuilt and customizable prebuilt models, not for training custom machine learning models entirely from scratch. Option E is not correct because building custom user interfaces for mobile apps is a Power Apps capability, not an AI Builder capability.

Answer

Custom machine learning model training from scratch.

Answer

Building custom user interfaces for mobile apps.

Question 6

Which TWO of the following are best practices for managing Power Platform environments in an enterprise? (Choose two.)

Accepted Answer

Implement Data Loss Prevention (DLP) policies to control data flow between connectors.. Option B is correct because Data Loss Prevention (DLP) policies in the Power Platform Admin Center let administrators classify connectors into Business, Non-Business, and Blocked groups, preventing sensitive data from flowing between incompatible connectors and enforcing enterprise governance. Option E is correct because separating development, testing, and production into distinct environments isolates changes, supports managed solutions and deployment pipelines, and prevents unverified customizations from affecting live business data. Options A, C, and D are not best practices: sharing all connectors and data sources by default violates least-privilege and exposes sensitive data, disabling auditing removes the compliance and security trail needed for enterprise oversight, and using a single environment for all workloads mixes development and production, risking instability and data corruption.

Answer

Share all connectors and data sources with all users by default.

Answer

Disable auditing to improve performance.

Answer

Use a single environment for all development and production workloads.

Question 7

A sales team wants to automate follow-up emails after a lead is created in Dynamics 365 Sales. Which Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is designed to create automated workflows that trigger actions based on events, such as sending a follow-up email when a new lead is created in Dynamics 365 Sales. It uses connectors to integrate with Dynamics 365 and email services, enabling a no-code automation that runs without manual intervention.

Answer

Power BI

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 8

A company wants to build a custom app that allows field technicians to view and update work orders on their mobile devices, with data stored in Dataverse. Which approach minimizes development effort?

Accepted Answer

Create a canvas app in Power Apps. Canvas apps in Power Apps are designed for rapid, low-code development with drag-and-drop UI and direct Dataverse connectivity, making them the fastest path to a mobile-friendly work order app. They can be published to Power Apps mobile and run on iOS and Android without native development.

Answer

Use Power Automate to generate a mobile app

Answer

Build a custom iOS app using Swift and Xcode

Answer

Create a model-driven app in Power Apps

Question 9

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Accepted Answer

The flow is using the cloud SQL connector without an on-premises data gateway.. The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Answer

The Office 365 connector is conflicting with the SQL connector.

Answer

The environment type is Production, which restricts access to on-premises data.

Answer

The region 'eastus' does not support on-premises connectivity.

Question 10

A non-profit organization wants to track donations and manage volunteers using a single system. They have limited IT staff and budget. Which Power Platform solution is most suitable?

Accepted Answer

Custom app built with Power Apps connected to Dataverse. Power Apps allows building a custom app that integrates donations and volunteer management in a single system using Dataverse as the underlying data platform. This provides a low-code solution that minimizes the need for extensive IT resources and budget, while still offering relational data storage, security, and scalability suitable for a non-profit's needs.

Answer

Dynamics 365 Sales

Answer

Power Automate flows to send emails

Answer

Power BI dashboards connected to Excel

Question 11

A healthcare provider needs to ensure that only authorized users can access patient data in a Power Apps app. The app uses Dataverse. What should the administrator configure?

Accepted Answer

Assign Dataverse security roles to users. Dataverse uses its own security model based on security roles, which define the privileges a user has on tables, records, and other resources. To ensure that only authorized users can access patient data in a Power Apps app that uses Dataverse, the administrator must assign appropriate Dataverse security roles to users. These roles control create, read, write, delete, and append privileges at the organization, business unit, parent-child business unit, and user levels.

Answer

Configure SharePoint permissions for the app

Answer

Set environment as restricted in Power Platform admin center

Answer

Use Microsoft Entra ID conditional access policies

Question 12

Refer to the exhibit. A Power Automate flow runs hourly to retrieve new accounts from Dataverse. However, it sometimes misses records created at the exact hour boundary. What is the most likely reason?

Accepted Answer

The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs.. The flow is configured to run on a recurring schedule (e.g., every hour), not as an instant trigger on record creation. When a record is created at the exact boundary between two scheduled runs, it may not be captured by the previous run (which already completed) and may not yet exist when the next run begins, especially if the flow uses a filter query based on a timestamp. This is a classic limitation of scheduled polling compared to event-driven triggers like 'When a row is added, modified, or deleted' in Dataverse.

Answer

The accounts table has a security filter that hides records from the flow owner.

Answer

The API connection to Dataverse is not authenticated properly.

Answer

The filter query uses utcNow() which may not be precise across time zones.

Question 13

A retail company wants to analyze sales data from multiple stores and create interactive reports for regional managers. Which Power Platform component should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is Microsoft's business analytics service designed for visualizing data and sharing interactive reports. The scenario requires analyzing sales data from multiple stores and creating interactive reports for regional managers, which aligns directly with Power BI's core capabilities of data integration, interactive dashboards, and report sharing.

Answer

Power Automate

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 14

An organization uses Power Automate to approve expense reports. Managers want to approve via Microsoft Teams. Which connector should be used?

Accepted Answer

Microsoft Teams. The Microsoft Teams connector is the correct choice because it enables Power Automate flows to interact directly with Microsoft Teams, allowing managers to approve expense reports through Teams messages, adaptive cards, or chat-based approvals without leaving the Teams interface.

Answer

Office 365 Outlook

Answer

Dataverse

Answer

SharePoint

Question 15

A company has a Power Apps portal for external partners to submit support tickets. Partners report that they cannot see the tickets they created. The portal uses Dataverse. What is the most likely cause?

Accepted Answer

Entity permissions for the ticket table are not configured for portal users.. In Power Apps portals, visibility of Dataverse records is governed by entity permissions, not by the portal being published or the browser used. When partners cannot see tickets they created, the most likely cause is that the entity permissions for the ticket table are not configured to grant 'Read' access to the appropriate portal web roles (e.g., 'Authenticated Users' or a custom role). Without these permissions, the portal cannot query and display the records, even though the data exists in Dataverse.

Answer

The partners are using an unsupported browser.

Answer

The portal is not published to the external network.

Answer

The Dataverse environment is in maintenance mode.