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

Question 1

A company uses Power BI to analyze customer feedback from surveys. The data is stored in Excel on SharePoint. They want to refresh the report daily without manual intervention. Which feature should they use?

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

Accepted Answer

Power BI scheduled refresh. Power BI scheduled refresh allows you to configure automatic, recurring data refreshes for datasets stored in the cloud (including Excel files on SharePoint). This eliminates the need for manual intervention by using the Power BI service to re-import the data at defined intervals, such as daily.

Answer

Power BI gateway

Answer

DirectQuery mode

Answer

Power Automate flow to refresh the dataset

Question 2

A healthcare organization uses Power Apps to manage patient intake forms. The app is built on Dataverse and includes a field for medical record number (MRN) that must be unique. The app currently uses a text input, but duplicate MRNs have been entered. What is the best way to enforce uniqueness at the data layer?

Accepted Answer

Create a Dataverse alternate key on the MRN field. A Dataverse alternate key enforces uniqueness at the database level, preventing duplicate MRN values from being saved regardless of how data enters the system. This is the only option that operates at the data layer, ensuring integrity even if the app, a flow, or an external integration submits a record. Alternate keys are indexed and validated by Dataverse before commit, making them the proper solution for unique field constraints.

Answer

Use a Power Automate flow to check for duplicates after submission

Answer

Configure a business rule on the MRN field

Answer

Add a validation rule in the app to check for duplicates before submitting

Question 3

A small business wants to create a chatbot to answer common customer questions about store hours and return policies. Which Power Platform tool should they use?

Accepted Answer

Copilot Studio. Copilot Studio (formerly Power Virtual Agents) is the correct tool because it is specifically designed to create conversational AI chatbots without writing code. It allows the business to build a bot that answers common questions about store hours and return policies by defining topics and using natural language processing to interact with users.

Answer

Power BI

Answer

Power Automate

Answer

Power Apps

Question 4

A company wants to use Power Platform to streamline its expense reporting process. Which TWO components can be used together to create a complete solution that allows employees to submit expenses, managers to approve them, and finance to analyze trends?

Accepted Answer

Power Apps. Power Apps (C) is correct because it provides the canvas or model-driven app interface where employees can enter and submit expense data and managers can review and approve them, forming the front-end user experience of the solution. Power Automate (D) is correct because it supplies the workflow automation that routes submitted expenses to the appropriate manager for approval, sends notifications, and triggers downstream actions such as updating Dataverse or SharePoint records and alerting finance. Together, Power Apps and Power Automate deliver the submit-approve-automate flow that the scenario requires. Power BI (B) is a reporting and analytics tool that could visualize trends, but it is not one of the two components needed to build the submission and approval process itself. Copilot Studio (A) is for building conversational AI agents, and Power Pages (E) is for creating external-facing business websites, neither of which is required to implement the internal expense submission and approval workflow.

Answer

Copilot Studio

Answer

Power BI

Answer

Power Pages

Question 5

A retail chain uses Power BI to analyze sales data from multiple stores. The data is stored in an Azure SQL Database. The company wants to give store managers access to a dashboard that shows their store's sales compared to the company average. However, store managers should not see other stores' data. The company also wants to automate the process of sending a weekly sales report to regional managers via email. The regional managers need to see aggregated data for their region. You need to implement a solution using Power Platform components. What should you do?

Accepted Answer

Create a Power BI dataset with RLS to filter by store, publish a dashboard, and use a scheduled Power Automate flow to email a paginated report to regional managers.. It uses Power BI Row-Level Security (RLS) to restrict store managers to only their store's data while allowing regional managers to see aggregated data via a paginated report. The scheduled Power Automate flow automates the weekly email delivery, meeting both security and automation requirements without manual intervention.

Answer

Create a Power Automate flow that runs a SQL query and sends the results via email, and give store managers access to the Azure SQL Database directly.

Answer

Create separate Power BI dashboards for each store and each region, and manually share them.

Answer

Use Power Apps to build a custom dashboard for each store, and use Power Automate to email reports.

Question 6

A small marketing team wants to automate the process of capturing leads from their website into a Dataverse table. Currently, the website sends an email notification when a lead submits a form, and a team member manually enters the data into a Power Apps app. The team wants to eliminate manual data entry. They also want to automatically send a confirmation email to the lead and create a task in Microsoft To Do for the sales representative to follow up. You need to recommend a Power Platform solution. What should you do?

Accepted Answer

Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.. It directly addresses the requirement to eliminate manual data entry by using Power Automate to monitor the website's email inbox (via a trigger like 'When a new email arrives'), parse the lead data from the email body or attachments, add it to a Dataverse table, send a confirmation email, and create a task in Microsoft To Do. This solution automates the entire workflow without requiring changes to the existing website form or manual intervention.

Answer

Replace the website form with a Power Apps portal form, and use Power Automate for emails and tasks.

Answer

Use Microsoft Forms to collect leads, and Power Automate to add to Dataverse and send emails.

Answer

Create a Power Apps app on the website to capture leads, and use Power Automate to send emails and create tasks.

Question 7

A manufacturing company wants to use Power Platform to improve operational efficiency. Which TWO benefits of using Microsoft Power Platform are most relevant?

Accepted Answer

Build custom apps without extensive coding. Option C is correct because Power Apps provides a low-code/no-code development environment with drag-and-drop designers, prebuilt connectors, and Power Fx formulas, letting the manufacturing company build custom apps without extensive coding. Option E is correct because Power Automate enables the automation of business processes and workflows through cloud flows, approvals, and connectors to services like Dynamics 365 and SharePoint, directly improving operational efficiency. The unmarked options do not belong: Power Platform does not replace all third-party software (A), hardware inventory management is a specific use case rather than a general benefit and typically requires additional tooling (B), and Power Platform relies on Microsoft Entra ID authentication rather than eliminating it (D).

Answer

Replace the need for any third-party software

Answer

Automate hardware inventory management

Answer

Eliminate the need for user authentication

Question 8

A retail company uses Power Platform to manage customer feedback. They want to analyze sentiment and trigger alerts for negative reviews. Which THREE components should they use together?

Accepted Answer

Power Apps. Power Apps is correct because it provides the user interface for customers to submit feedback and for staff to view sentiment analysis results. It serves as the front-end application that collects and displays data, making it an essential component for managing customer feedback interactively.

Answer

Copilot Studio

Answer

Power BI

Question 9

A global organization wants to standardize expense reporting across subsidiaries using Power Platform. They require integration with Microsoft Entra ID for identity and must ensure data residency compliance. Which TWO capabilities should they use?

Accepted Answer

Dataverse environments with specific regions. Dataverse environments can be created in specific geographic regions to ensure data residency compliance by storing data at rest within that region. Integration with Microsoft Entra ID is inherent to Dataverse, which uses Entra ID as its identity provider for authentication and authorization, meeting the requirement for standardized identity management across subsidiaries. Additionally, Data Loss Prevention (DLP) policies enforce data residency by restricting data sharing across connectors and preventing data from leaving the designated region, ensuring compliance with regulatory requirements.

Answer

AI Builder

Answer

Power BI dashboards

Answer

Copilot Studio

Question 10

A non-profit organization uses Microsoft 365 but has no IT staff. They want to create a simple app to track volunteer hours and automatically send reminders to volunteers who haven't logged hours in a week. They also need a dashboard to view total hours by project. Which combination of Power Platform tools should they use?

Accepted Answer

Power Apps, Power Automate, and Power BI. Power Apps provides the low-code platform to build the volunteer hour logging app, Power Automate handles the automated reminder emails based on a weekly trigger, and Power BI creates the dashboard for total hours by project. This combination directly addresses all three requirements without needing IT staff, as all tools are designed for citizen developers.

Answer

Power Apps, AI Builder, and Power BI

Answer

Power Pages, Power Automate, and Power BI

Answer

Copilot Studio, Power Automate, and Power BI

Question 11

A small business owner wants to create a customer loyalty program. They want customers to earn points for purchases and redeem them for discounts. The owner has no coding experience and a limited budget. They need a mobile-friendly app for customers to check points and a backend to manage points and redemptions. What should they use?

Accepted Answer

Power Apps, Power Automate, and Dataverse. Power Apps allows building a mobile-friendly app without coding, Power Automate handles workflow automation for points and redemptions, and Dataverse provides a secure and scalable backend data store. This combination meets the requirements of no coding, limited budget, and mobile app with backend management.

Answer

Power BI, Power Automate, and Dataverse

Answer

Power Apps, AI Builder, and Dataverse

Answer

Power Pages, Power Automate, and SharePoint

Question 12

A government agency needs to modernize a paper-based permit approval process. The solution must enforce strict access control, provide an audit trail, and allow citizens to submit applications online. The agency uses Microsoft 365 and has a Power Platform license. Which approach should they take?

Accepted Answer

Use Power Pages for citizen submissions, Dataverse for storage, and Power Automate for approvals. It combines Power Pages for external citizen-facing submission portals, Dataverse for secure, auditable data storage with role-based access control, and Power Automate for automated approval workflows. This architecture meets all requirements: strict access control (Dataverse roles), audit trail (Dataverse change tracking and auditing), and online citizen submissions (Power Pages).

Answer

Use Power Automate with AI Builder to process paper forms and store in SharePoint

Answer

Build a Power Apps model-driven app for internal staff and a canvas app for citizens

Answer

Use Power BI to create a dashboard and Power Automate for approvals

Question 13

An insurance company wants to automate claims processing. They receive claims via email attachments (PDFs) and need to extract key information (policy number, date, amount) and enter it into a Dataverse table. Then, a workflow should evaluate the claim amount: if under $5000, auto-approve and notify the customer; if over $5000, assign to a human adjuster. The solution must be low-code and use AI where beneficial. Which combination should they use?

Accepted Answer

AI Builder, Power Automate, and Dataverse. It combines AI Builder (to extract data from PDFs using prebuilt AI models), Power Automate (to orchestrate the workflow and conditional logic based on claim amount), and Dataverse (to store the extracted data in a structured table). This low-code solution leverages AI where beneficial (PDF extraction) and automates the approval routing without requiring custom development.

Answer

Power BI, AI Builder, Power Automate, and Dataverse

Answer

Power Pages, AI Builder, Power Automate, and Dataverse

Answer

AI Builder, Copilot Studio, Power Automate, and Dataverse

Question 14

A real estate agency wants to provide a portal where tenants can submit maintenance requests online. The portal should allow tenants to track the status of their requests. The agency staff should be able to update the status and assign work orders to contractors. The agency uses Microsoft 365 and has Power Platform licenses. What should they use?

Accepted Answer

Power Pages for tenants, Dataverse for storage, Power Automate for notifications, and Power Apps model-driven app for staff. It uses Power Pages to create an external-facing portal for tenants to submit and track maintenance requests, Dataverse as the underlying data store for all request data, Power Automate to send notifications (e.g., status updates), and a Power Apps model-driven app for staff to manage requests and assign work orders. This combination provides a secure, low-code solution that leverages the existing Microsoft 365 and Power Platform licenses.

Answer

Power Apps canvas app for tenants and Power Apps model-driven app for staff

Answer

AI Builder and Power Automate to process requests

Answer

Power BI dashboard for tenants to view status and Power Apps for staff

Question 15

A financial services firm needs to create a compliance dashboard for regulators. The dashboard must display real-time data from multiple sources, including on-premises SQL Server and Dataverse. The firm requires interactive visualizations and the ability to drill down to transaction details. They also need to ensure that sensitive data is masked for certain users. Which Power Platform components should they use?

Accepted Answer

Power BI, on-premises data gateway, and Dataverse. The scenario requires real-time data from on-premises SQL Server and Dataverse, which necessitates an on-premises data gateway for live connectivity. Power BI provides the interactive visualizations and drill-down capabilities, while Dataverse serves as the unified data source for compliance data. The combination of these components enables real-time dashboards with role-based security for data masking.

Answer

Power Automate, AI Builder, and Power BI

Answer

Copilot Studio, Power BI, and Dataverse

Answer

Power Apps, Dataverse, and Power Automate