PL-900 Practice Test 12 — 15 Questions

Question 1

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

Question 2

You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?

Accepted Answer

Use an apply to each loop and configure 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', 'has failed'. Option C is correct because configuring 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', and 'has failed' ensures that even if a row fails validation or the SQL insert fails, the flow continues to the next iteration of the Apply to each loop. This allows the flow to process all rows in the CSV file without stopping on an error, meeting the requirement to skip invalid data and proceed with the next row.

Answer

Use parallel branches for each row

Answer

Use an apply to each loop with default settings

Answer

Use a scope with sequential actions and set 'Configure run after' to 'is successful' only

Question 3

Match each Power Apps license type to its description.

Question 4

Match each solution type in Power Platform to its description.

Question 5

Match each Common Data Service (Dataverse) term to its description.

Question 6

Match each Power Automate trigger type to its description.

Question 7

Match each Microsoft Dataverse security concept to its definition.

Question 8

Match each AI Builder model type to its use case.

Question 9

A company uses Power Automate flows that connect to SharePoint and Microsoft Entra ID. The administrator needs to ensure that the flows can access data only from approved data sources. What should the administrator configure?

Accepted Answer

Create a Data Loss Prevention (DLP) policy that restricts connectors to approved data sources. Data Loss Prevention (DLP) policies in the Power Platform allow administrators to control which connectors can be used together in flows and apps, effectively restricting flows to approved data sources like SharePoint and Microsoft Entra ID. By classifying connectors as Business or Non-Business, DLP policies prevent unauthorized data sharing between environments, which directly addresses the requirement to limit data access to approved sources.

Answer

Define SharePoint site permissions for the flows

Answer

Configure data policies in Power Apps settings

Answer

Set connector sharing permissions to limit access

Question 10

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 11

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 is correct because it allows you to build a custom expense submission form that employees can use to enter expense details. Combined with Power Automate, which handles the approval workflow and data routing, and Power BI for trend analysis, this creates a complete solution. Power Apps provides the user interface, while Power Automate orchestrates the backend process.

Answer

Copilot Studio

Answer

Power BI

Answer

Power Pages

Question 12

A Power Apps app uses a canvas and connects to multiple data sources. Users complain that the app loads slowly. What is the best practice to improve performance?

Accepted Answer

Use the 'ClearCollect' function to cache data in a collection. Option A is correct because the ClearCollect function allows you to cache data from external sources into a local collection within the app. This reduces the number of round trips to the data source during user interactions, significantly improving load and response times by minimizing network latency and data source throttling.

Answer

Add more screens to distribute the load

Answer

Increase the timeout settings

Answer

Use a single data source

Question 13

A company is planning to build a Power Apps app for field service technicians to view and update work orders. The app must work offline and sync data when connected. Which TWO components are required to achieve offline capability?

Accepted Answer

Offline profile in Microsoft Dataverse. An offline profile in Microsoft Dataverse defines which tables, columns, and relationships are available when the app is disconnected. It enables the Power Apps mobile player to cache data locally and synchronize changes automatically when connectivity is restored. Without an offline profile, the app cannot determine what data to store or how to resolve conflicts during sync.

Answer

Power Automate flow triggered on data change

Answer

SharePoint list as data source

Answer

Common Data Service (Dataverse) database

Question 14

A company uses a Power Platform environment that contains several production apps. They need to ensure that changes to these apps are reviewed and approved before deployment to the production environment. What should they implement?

Accepted Answer

Use managed solutions and Azure DevOps for application lifecycle management (ALM) with deployment gates.. Option B is correct because managed solutions and Azure DevOps with deployment gates provide a structured Application Lifecycle Management (ALM) process. This allows changes to be reviewed, tested, and approved before deployment to a production environment, ensuring governance and control over modifications.

Answer

Create data loss prevention (DLP) policies for the production environment.

Answer

Assign the System Administrator role to all developers.

Answer

Configure Microsoft Purview to audit changes and require approval.

Question 15

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

Accepted Answer

Returns all records from array1 where Status is 'Active'. The Filter function returns records from array1 where the Status column equals 'Active'. Option A is correct. Option B is wrong because Sort is for ordering. Option C is wrong because LookUp returns a single record. Option D is wrong because Search is for matching substrings.

Answer

Returns the first record from array1 with Status 'Active'

Answer

Sorts array1 by Status in ascending order

Answer

Searches array1 for the text 'Active' in any column