Free Microsoft PL-200 Practice Exam with Questions & Answers | Set: 4

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result these questions will not appear on the review screen.

You are building a Power Pages site for a supermarket chain.

The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only.

You need to configure the site security.

Solution: Configure page permissions.

Does the solution meet the goal?

A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents.

The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft Dataverse

Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app.

You need to configure table creation for the app.

How should you configure the app? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

You have a canvas app that allows users to view, select and purchase products. The app uses a Gallery control to display products and checkboxes that allow users to select products.

When users select items from the product catalog, they move to a different screen to complete a purchase.

Users must be able to clear all product selections when they click the button.

You need to configure the button.

What should you do?

You have a model-driven app. You create five Microsoft Excel templates for analyzing customer data.

Four of the templates must be available to all users. The remaining template must be available only to you. You configure the appropriate security roles for users.

You need to determine how to upload the Excel templates.

Which method should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are modifying a model-driven app. You set up a customer table in Microsoft Power Platform to retrieve user data. You set up a form with the following columns for users to enter their data. The form includes the following columns:

The form must do the following:

• The Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value.

• The Passport expiration date column must appear only if the user selects Yes in the Passport ownership column.

You need to configure the app with the least amount of effort.

What should you configure? To answer, drag the appropriate solution component to the correct requirements. Each solution component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

A company that manufactures medical devices uses Power Apps to manage their sales and device maintenance.

A Table named Devices in Microsoft Dataverse has a column named Status. The Status column must have a new status value of Review added to the existing Choice values of Active and Inactive.

The table must be added to a solution to be promoted once the change is made.

Only this change must be promoted to the test environment. The changes must not be able to be changed once promoted. You need to add the change to a solution for promotion.

A company is using Dataverse with a custom table named Prospects. The Prospects table has a lookup to the Account table.

SharePoint document management is configured in the environment but is not configured for the Prospects table. All documents saved as part of the integration must be accessed by using an Account row linked to the Prospects table.

Based on new requirements from end users, the Prospects table must be reconfigured for use with the document management feature.

You need to configure the integration.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

The business team provides the following list of features that they would like you to implement:

• Group by or sort columns in the current view.

• Configure a business rule to show an error message.

• Edit values in calculated fields.

• Edit the Address composite field.

• Use the editable grid on mobile phones.

Which actions can you perform? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You configure and test a user interface (Ul) flow. You plan to run the flow as a scheduled flow.

The Ul flow must run on a Windows 10 device. As part of process automation, the Ul flow must sign into the Windows 10 device with the credentials for a user account named User1.

You need to ensure that the flow runs during non-peak hours and requires no physical user intervention.

What should you do?

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to is. As a result, these questions will not appear in the review screen.

A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.

The Dataverse environment contains a table that has the following columns:

• Name

• Company

• Contacted On

The company requires that the table not contain any duplicate rows when users create data in the environment. You need to implement a solution that meets the requirement.

Solution: Create a Microsoft Power Fx formula for the columns.

Does the solution meet the goal?