PL-900 Practice Test 45 — 15 Questions

Question 1

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 2

A company uses Microsoft Power Platform to automate business processes. They want to extend their solution by integrating with other Microsoft services. Which TWO services can be used together with Power Automate to trigger flows based on events from external systems?

Accepted Answer

Azure Logic Apps. Azure Logic Apps is a cloud service that provides pre-built connectors and enterprise integration capabilities, allowing Power Automate to trigger flows based on events from external systems via HTTP requests, webhooks, or service bus messages. Azure Event Grid is a fully managed event routing service that uses a publish-subscribe model, enabling Power Automate to react to events from Azure services or custom sources in near real-time. Both services extend Power Automate's event-driven triggers beyond its native connectors.

Answer

Power Virtual Agents

Answer

Azure DevOps

Answer

Azure SQL Database

Question 3

An organization wants to ensure that all Power Platform solutions in production environments are tracked and changes are approved. What should the administrator implement?

Accepted Answer

Managed solutions with application lifecycle management (ALM). Managed solutions with application lifecycle management (ALM) ensure that all Power Platform solutions in production environments are tracked and changes are approved by enforcing version control, solution layering, and controlled deployment through environments. This approach uses solution components and environment segmentation to prevent unapproved modifications and maintain an audit trail.

Answer

Data Loss Prevention (DLP) policies

Answer

Environment security groups

Answer

Disable the 'Create personal productivity environments' setting

Question 4

Which TWO features can be used to secure data in Power BI?

Accepted Answer

Row-level security (RLS). Row-level security (RLS) is correct because it restricts data access at the row level based on user roles and filters, ensuring that users only see data relevant to them. This is a core Power BI security feature that controls data visibility without duplicating reports or datasets.

Answer

Q&A visuals

Answer

Bookmarks

Answer

Drill-through

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 Power Apps developer created a canvas app that uses a SQL Server data source. Users report that the app is slow when navigating between screens. Which design change should the developer make to improve performance?

Accepted Answer

Apply delegation-compatible filters on galleries to reduce data loaded from the server.. To improve performance in a canvas app with a SQL Server data source, the most effective design change is to apply delegation-compatible filters on galleries (option D). Delegation allows the server to process the filtering, reducing the amount of data transferred to the app and speeding up screen navigation. Option A is incorrect because replacing SQL Server with SharePoint does not inherently improve delegation; both support delegation, but the root cause is unfiltered data loads. Option B is wrong because moving logic to App.OnStart preloads data only once, not per screen, and doesn't address data volume during navigation. Option C is incorrect because preloading with a Timer control adds complexity and does not reduce the data transferred; delegation is the proper solution.

Answer

Replace the SQL data source with a SharePoint list to increase delegation limits.

Answer

Move all data loading logic from OnVisible to the App.OnStart property.

Answer

Add a Timer control to preload data for the next screen.

Question 7

A manufacturing company uses Microsoft Power Platform to manage its inventory. They have a Power Apps app that allows warehouse staff to scan items and update quantities in a SharePoint list. Recently, the app has been slow to load and occasionally times out when scanning multiple items in quick succession. The IT team suspects the issue is related to the data source connection. They want to improve performance without changing the user interface. The company has a Microsoft 365 E3 subscription and all data resides in SharePoint Online. What should the IT team do first?

Accepted Answer

Optimize the Power Apps by enabling delegation for the SharePoint connector.. Enabling delegation for the SharePoint connector allows Power Apps to offload filtering and sorting operations to SharePoint Online, rather than retrieving all rows to the client. This reduces the amount of data transferred over the network, which directly addresses the slow load and timeout issues when scanning multiple items in quick succession, without changing the user interface.

Answer

Implement a timer control to delay scanning between items.

Answer

Migrate the SharePoint list to an on-premises SQL Server database.

Answer

Replace SharePoint with Microsoft Dataverse for better performance.

Question 8

Your organization uses Power Platform environments for development, test, and production. A developer accidentally deleted a managed solution from the production environment. You need to restore the solution without affecting other components. What should you do?

Accepted Answer

Restore the environment from a backup taken before the deletion.. Restoring the production environment from a backup taken before the deletion is the only supported method in Power Platform to recover a deleted managed solution without affecting other components. Managed solutions are sealed and cannot be partially restored; environment backup restore returns the entire environment to a previous point in time, ensuring the solution is recovered along with its dependencies and without impacting unrelated customizations.

Answer

Reimport the solution from the source-controlled repository using Azure DevOps.

Answer

Use the Power Platform admin center to recover the solution from the recycle bin.

Answer

Reimport the managed solution from a backup file.

Question 9

A Power Pages site must display a chart showing monthly sales data from Dataverse. The chart should update automatically when new data is added. What is the recommended approach?

Accepted Answer

Embed a Power BI report that connects to Dataverse.. Power Pages can embed Power BI reports, which can refresh automatically. Using a list with a chart is limited to basic charts and may not auto-refresh. Custom JavaScript is complex and unreliable. Excel export is static.

Answer

Write custom JavaScript using the Chart.js library.

Answer

Use a list component with a chart visualization.

Answer

Export data to Excel and display as an image.

Question 10

A company wants to use Power Apps to create a mobile app for field technicians. The app must work offline and sync data when connectivity is restored. Which feature should they use?

Accepted Answer

Offline capability in Dataverse (mobile offline sync). Dataverse provides offline capability for mobile apps, allowing field technicians to work without connectivity and sync data when reconnected. Option B, Power Apps portals, is for external-facing websites, not offline mobile apps. Option C, Power Apps component framework, is for building custom controls, not offline sync. Option D, Monitor tool, is for debugging and performance monitoring, not offline functionality.

Answer

Power Apps portals

Answer

Power Apps component framework

Answer

Monitor tool in Power Apps

Question 11

A company uses Power Apps to build a leave request app. Managers must approve requests only if the employee has sufficient leave balance. Which approach ensures the balance is checked before submission?

Accepted Answer

Use the SubmitForm function with a validation formula checking leave balance. The SubmitForm function in Power Apps can include a validation formula in the Items property or via the OnSelect property to check the leave balance before the form is submitted, preventing submission if the balance is insufficient. Option A is wrong because Power BI is for analytics, not validation. Option C is wrong while it can auto-reject, it does not prevent submission, and the requirement is to check before submission. Option D is wrong because foreign key constraints in Dataverse cannot dynamically check leave balance based on current data.

Answer

Create a Power BI report to visualize leave balances and have managers manually check

Answer

Configure a Power Automate flow to check balance after submission and auto-reject if insufficient

Answer

Set a foreign key constraint in Dataverse to limit leave requests based on balance

Question 12

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

Accepted Answer

Condition. Options B, D, and E are correct. A trigger starts the flow, actions perform tasks, and conditions control the flow logic. Option A (Environment) is the container for resources, not a component of a single flow definition. Option C (Connector) is a connection to a service, not a component of the flow itself.

Answer

Environment

Answer

Connector

Question 13

Your organization uses Power Automate to automate approval workflows for purchase orders. The compliance team requires that all approvals be auditable and that the flow logs include the identity of the user who initiated the approval. Which feature should you use?

Accepted Answer

Enable 'Run only user' in the flow's trigger settings.. The 'Run only user' setting in a flow's trigger captures the context of the user who triggered the flow, enabling audit trails. Option A is wrong because the 'When an item is created' trigger does not log the initiator by default. Option B is wrong because 'Configure Run After' settings are for error handling, not for capturing user identity. Option C is wrong because the 'Start and wait for an approval' action does not include the trigger context beyond its own inputs.

Answer

Use the 'When an item is created' trigger for the approval.

Answer

Configure 'Run After' settings for the approval action.

Answer

Use the 'Start and wait for an approval' action.

Question 14

A canvas app displays incorrect data because the source SharePoint list has a lookup column to another list. The app maker used 'Choices' function to populate a dropdown, but the dropdown shows IDs instead of display names. What is the cause?

Accepted Answer

The Choices function was used on a lookup column, which returns a table of IDs; use Choices( [List].[Column].DisplayName ) instead.. The Choices function when used on a lookup column returns a table of IDs by default, not display names. To get display names, the correct syntax is Choices([List].[Column].DisplayName). Option B is incorrect because the Choices function returns both IDs and display names; the DisplayFields property is not needed if using the correct syntax. Option C is incorrect because lookup columns are typically text-based, not number types. Option D is incorrect because delegation is not relevant to this issue.

Answer

The Choices function was used correctly but the dropdown's DisplayFields property is not set to the display name column.

Answer

The lookup column is a number type, not text, so it cannot show names.

Answer

The formula is not delegable, causing only partial data.

Question 15

You need to create a flow that automates the onboarding process for new employees. When a new employee record is added to a Human Resources (HR) system in Dataverse, the flow should: (1) send a welcome email, (2) create user accounts in Microsoft Entra ID, and (3) assign licenses. The flow must run with high reliability and should not fail if one of the actions fails. Which flow design pattern should you use?

Accepted Answer

Use parallel branches for each independent action. Using parallel branches allows each independent action (send welcome email, create user accounts, assign licenses) to run concurrently. If one branch fails, the others continue unaffected, ensuring high reliability. Option A is incorrect because sequential actions in a single branch stop the entire flow if any action fails. Option B is incorrect because a scope timeout only limits execution time, not isolate failures. Option C is incorrect because a condition evaluates a decision but does not provide parallel execution or failure isolation.

Answer

Use a single branch with sequential actions and configure retry policy

Answer

Use a scope to group actions and configure scope timeout

Answer

Use a condition to check success before proceeding