PL-900 Describe complementary Microsoft Power Platform solutions — 10 Questions

Question 1

A company uses Microsoft Power Platform to automate invoice processing. They want to integrate with their existing ERP system hosted on Azure SQL Database. Which Power Platform component is best suited for this integration?

Accepted Answer

Power Automate. Power Automate is the correct choice because it provides built-in connectors for Azure SQL Database, enabling seamless integration with the existing ERP system without custom code. It can trigger automated workflows based on invoice events, such as when a new record is created in the SQL database, and orchestrate data processing across multiple systems.

Answer

Dataverse

Answer

Power BI

Answer

Power Apps

Question 2

A team is building a customer service solution using Power Apps and Dataverse. They need to ensure that customer data is synchronized with Dynamics 365 Customer Service. Which approach should they use?

Accepted Answer

Use Dataverse as the data store and connect both Power Apps and Dynamics 365 to it. Using Dataverse as the common data store and connecting both Power Apps and Dynamics 365 to it ensures real-time synchronization. Direct integration via custom APIs is possible but not best practice. Power Automate flows can also sync, but Dataverse is the recommended approach for Dynamics 365.

Answer

Build a custom connector to transfer data between Power Apps and Dynamics 365

Answer

Implement a third-party middleware solution

Answer

Export data from Dynamics 365 and import it into Power Apps periodically

Question 3

A company wants to create a dashboard that shows real-time sales data from their ERP system and allows managers to drill down into individual transactions. Which Power Platform component should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is designed for data visualization and business intelligence, enabling real-time dashboards with drill-through capabilities. It can connect directly to an ERP system via connectors or DirectQuery to display live sales data, and managers can use the drill-down feature to navigate from summary metrics to individual transaction details.

Answer

Power Apps

Answer

Power Automate

Answer

AI Builder

Question 4

A company uses Power Apps to manage employee leave requests. They want to automate the approval process so that managers receive an email when a request is submitted. Which component should they add?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that trigger actions based on events. In this scenario, when a leave request is submitted in Power Apps, a Power Automate flow can be configured to send an email notification to the manager, automating the approval process without manual intervention.

Answer

Power BI

Answer

AI Builder

Answer

Power Virtual Agents

Question 5

Which TWO Microsoft Power Platform solutions are designed to be used together to build a complete customer feedback analysis system that collects feedback from multiple channels, processes sentiment, and provides actionable insights?

Accepted Answer

AI Builder. AI Builder (D) is correct because it provides pre-built AI models for sentiment analysis, which can process feedback text from multiple channels to determine positive, negative, or neutral sentiment. Power Automate (E) is correct because it orchestrates the collection of feedback from various sources (e.g., email, forms, social media) and triggers actions based on sentiment results, enabling a complete automated feedback analysis pipeline.

Answer

Dataverse

Answer

Power Apps

Answer

Power BI

Question 6

You are a Power Platform administrator for a large multinational company that uses Microsoft Power Platform to manage its sales operations. The company has a Power App for sales representatives to log customer meetings and a Power Automate flow that sends a summary email to the sales manager after each meeting is logged. Recently, sales representatives have reported that the app is slow to load and sometimes times out. The IT team has checked network connectivity and server performance and found no issues. The app uses Dataverse as its data source and includes several lookup fields to related tables. The Power Automate flow runs immediately after a meeting is created and queries additional data from the Dataverse. You suspect the issue is related to the flow's trigger and subsequent queries. What course of action should you take to improve performance?

Accepted Answer

Modify the flow to run on a schedule instead of immediately upon record creation. Option A is correct because the performance issue is likely caused by the Power Automate flow's trigger running synchronously or near-synchronously upon record creation, which can block the app's response or cause timeouts if the flow queries additional Dataverse data. By modifying the flow to run on a schedule (e.g., every 5 minutes), you decouple the heavy query operations from the real-time app interaction, reducing the load on the app's session and preventing timeouts.

Answer

Disable the Power Automate flow and manually send summary emails

Answer

Implement caching in the Power App to store lookup data locally

Answer

Increase the timeout duration of the Power Automate flow to allow more time for queries

Question 7

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 8

An organization is configuring a custom connector in Power Automate to connect to Salesforce. The exhibit shows a snippet of the connector definition. However, when attempting to test the connection, the authentication fails. What is the most likely cause?

Accepted Answer

The OAuth flow type is incorrectly set to 'accessCode' instead of 'authorizationCode'.. Option A is correct because the OAuth 2.0 flow type 'accessCode' is not a valid OAuth 2.0 grant type. The correct value for the authorization code grant type is 'authorizationCode'. Power Automate custom connectors require this exact string to properly initiate the OAuth 2.0 authorization code flow with Salesforce. Using 'accessCode' causes the authentication handshake to fail because the connector cannot map the flow to a supported OAuth grant.

Answer

The scopes array is missing the 'id' scope.

Answer

The apiVersion is not supported by Power Automate.

Answer

The serviceUrl should point to the Salesforce instance, not login.salesforce.com.

Question 9

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

Drag and drop the steps to create a Power Automate flow that sends an email when a new item is added to SharePoint in the correct order.