PL-900 Identify foundational components of Microsoft Power Platform — All Questions With Answers

Question 1

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

Accepted Answer

Optimize data source connections and queries. Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Answer

Update the app version number

Answer

Increase the app icon size

Answer

Change the app's background color

Question 2

A company wants to automate a business process that requires approval from a manager before an expense report is submitted. Which Microsoft Power Platform component should be used?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that can include approval steps. In this scenario, a Power Automate flow can be triggered when an expense report is submitted, route the request to the manager for approval, and then proceed with submission only after approval is granted.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 3

An organization uses Dataverse as a data source for multiple Power Apps. They notice that records created in one app do not appear in another app until the page is refreshed. Which concept explains this behavior?

Accepted Answer

Caching of data by Power Apps. Power Apps caches data from Dataverse locally to improve performance and reduce network calls. When a record is created in one app, the cache in another app is not automatically invalidated, so the new record does not appear until the user manually refreshes the page or triggers a re-query. This caching behavior is by design to minimize latency and is controlled by the 'Enable data caching' setting in the app's advanced settings.

Answer

Different Dataverse environments used

Answer

Delegation limitations of the data source

Answer

Use of Patch mode instead of SubmitForm

Question 4

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for data visualization and business analytics, capable of connecting directly to a SQL database to create real-time dashboards. It supports DirectQuery or live connections to SQL Server, enabling near-real-time updates without requiring data to be imported into a separate store.

Answer

Power Apps

Answer

Power Automate

Answer

AI Builder

Question 5

A company uses Microsoft Power Platform to manage customer support tickets. The support team wants to automatically categorize incoming emails as 'Complaint', 'Request', or 'Other' before creating a ticket. Which component should be used?

Accepted Answer

AI Builder. AI Builder provides prebuilt models for text classification, enabling automatic categorization of incoming emails into categories like 'Complaint', 'Request', or 'Other' without manual coding. This component integrates directly with Power Automate to process emails and create tickets based on the classification result.

Answer

Power Automate with a trigger

Answer

Power Apps with a dropdown

Answer

Power BI with a report

Question 6

Which TWO components are part of the Microsoft Power Platform? (Choose two.)

Accepted Answer

Power Virtual Agents. Power Virtual Agents (A) is a component of the Microsoft Power Platform that enables users to create intelligent chatbots using a no-code graphical interface, without requiring developers or data scientists. It integrates with Power Automate and Power Apps to extend bot capabilities, making it a core part of the platform's low-code AI offerings.

Answer

Azure DevOps

Answer

Microsoft 365

Answer

Dynamics 365

Question 7

Which THREE are common uses of connectors in Power Automate? (Choose three.)

Accepted Answer

Create a record in Dataverse. Option B is correct because connectors in Power Automate provide pre-built actions and triggers to interact with external services. The Dataverse connector includes a 'Create a new record' action, enabling automated creation of rows in Dataverse tables without custom code, directly from a flow.

Answer

Build a custom user interface

Answer

Create a real-time dashboard

Question 8

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

Accepted Answer

The trigger does not check for attachments by default. Option C is correct because the trigger shown in the question is likely a 'When a new email arrives' trigger, which by default does not include attachments. To process emails with attachments, you must explicitly configure the trigger to include attachments by enabling the 'Include Attachments' option or by using the 'Get attachments' action. Without this, the flow will not trigger for emails that have attachments.

Answer

The path should include '/attachments'

Answer

The connection name is incorrect

Answer

The method should be 'post' instead of 'get'

Question 9

You are the Power Platform administrator for Contoso Ltd., a retail company with 500 employees. The company uses Microsoft 365 and has recently adopted Power Platform. The IT department manages a Power Apps canvas app used by the sales team to track customer interactions. The app connects to a Microsoft Dataverse table named 'Customer Interactions' with columns: CustomerID (text), InteractionDate (date), Notes (text), and SalesPerson (text). The app was working fine for three months, but starting last week, users report that the app loads slowly, sometimes timing out, and the 'Customer Interactions' table shows duplicate records. Upon investigation, you find that the app uses a 'Patch' function to create records, and the 'OnStart' property loads all records from the table using 'Filter(Customer Interactions, SalesPerson = User().FullName)' to show only the current user's records. The Dataverse table has grown to 50,000 rows. Additionally, some users have accidentally created multiple submissions by double-clicking the submit button. You need to resolve the performance and duplicate issues with minimal disruption. What should you do?

Accepted Answer

Modify the 'Submit' button to set its 'DisplayMode' to 'Disabled' after the first click to prevent double submission, and change the 'OnStart' filter to delegate by ensuring the 'SalesPerson' column is indexed in Dataverse and using 'Filter(Customer Interactions, SalesPerson = User().FullName)' with delegation enabled.. Option D is correct because it addresses both performance and duplicate issues directly. Disabling the submit button after the first click prevents double submissions, a common cause of duplicates in canvas apps. Indexing the SalesPerson column in Dataverse ensures the Filter function delegates, meaning the query runs on the server side and only returns relevant rows, drastically reducing data transfer and load times compared to pulling all 50,000 rows client-side.

Answer

Replace the 'Patch' function with 'Collect' in the app and use the 'Distinct' function to remove duplicates from the table every night via a Power Automate flow.

Answer

Increase the 'Data row limit' for the 'Customer Interactions' table in the app settings to 500 and add a 'Remove duplicates' step in the app's 'OnStart'.

Answer

Remove the 'Filter' from 'OnStart' and load all records into a collection, then use 'Filter' on the collection to show current user's records.

Question 10

A company wants to use Power Automate to automate a business process that involves manual data entry from emails into a SharePoint list. Which component of Power Platform should be used to extract the relevant data from the email body?

Accepted Answer

AI Builder. AI Builder is the correct component because it provides prebuilt models for extracting structured data from unstructured text, such as email bodies. The 'Key Phrase Extraction' or 'Entity Extraction' models can parse email content and map relevant fields directly into a SharePoint list, eliminating manual data entry.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 11

Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?

Accepted Answer

Power Apps. Power Apps is a low-code platform that enables users to build custom business applications through a visual drag-and-drop interface, connecting to various data sources without writing traditional code. It directly addresses the requirement of creating and deploying custom business applications without coding.

Answer

Power BI

Answer

AI Builder

Answer

Power Pages

Question 12

You work for a retail company that uses Microsoft Power Platform to manage inventory. The company has a Power Apps canvas app that allows store managers to update stock levels. Recently, the app has been slow to load and sometimes times out when multiple managers use it simultaneously. You need to recommend a solution to improve performance. What should you do?

Accepted Answer

Migrate the app to use a Microsoft Dataverse database.. Option B is correct because using a Dataverse database instead of SharePoint provides better performance and scalability for concurrent users. Option A is wrong because it only addresses connectivity, not server-side performance. Option C is wrong because it reduces functionality. Option D is wrong because it adds complexity without addressing the root cause.

Answer

Reduce the number of fields in the SharePoint list.

Answer

Instruct managers to use a wired network connection instead of Wi-Fi.

Answer

Implement a custom API to handle updates.

Question 13

Drag and drop the steps to set up a Microsoft Dataverse environment in the correct order.

Question 14

Match each Power BI component to its description.

PL-900 Identify foundational components of Microsoft Power Platform — All Questions With Answers

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

A company wants to automate a business process that requires approval from a manager before an expense report is submitted. Which Microsoft Power Platform component should be used?

An organization uses Dataverse as a data source for multiple Power Apps. They notice that records created in one app do not appear in another app until the page is refreshed. Which concept explains this behavior?

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

A company uses Microsoft Power Platform to manage customer support tickets. The support team wants to automatically categorize incoming emails as 'Complaint', 'Request', or 'Other' before creating a ticket. Which component should be used?

Which TWO components are part of the Microsoft Power Platform? (Choose two.)

Which THREE are common uses of connectors in Power Automate? (Choose three.)

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

Exhibit

A company wants to use Power Automate to automate a business process that involves manual data entry from emails into a SharePoint list. Which component of Power Platform should be used to extract the relevant data from the email body?

Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?

Drag and drop the steps to set up a Microsoft Dataverse environment in the correct order.

Match each Power BI component to its description.

PL-900 Identify foundational components of Microsoft Power Platform — All Questions With Answers

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

A company wants to automate a business process that requires approval from a manager before an expense report is submitted. Which Microsoft Power Platform component should be used?

An organization uses Dataverse as a data source for multiple Power Apps. They notice that records created in one app do not appear in another app until the page is refreshed. Which concept explains this behavior?

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

A company uses Microsoft Power Platform to manage customer support tickets. The support team wants to automatically categorize incoming emails as 'Complaint', 'Request', or 'Other' before creating a ticket. Which component should be used?

Which TWO components are part of the Microsoft Power Platform? (Choose two.)

Which THREE are common uses of connectors in Power Automate? (Choose three.)

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

Exhibit

A company wants to use Power Automate to automate a business process that involves manual data entry from emails into a SharePoint list. Which component of Power Platform should be used to extract the relevant data from the email body?

Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?

Drag and drop the steps to set up a Microsoft Dataverse environment in the correct order.

Match each Power BI component to its description.