Microsoft PL-200 Microsoft Power Platform Functional Consultant Exam Practice Test

You are creating a Power Virtual Agents chatbot for a Microsoft Power Platform power apps portal app.

The job title of users must be stored automatically when users log in. The job title must always appear in the chatbot.

You need to configure the job title functionality.

Which mechanism should you use?

A company uses Common Data Service to store sales data.

For the past few quarters, the company has experienced a decrease in sales revenue. The company wants to improve sales forecasting.

The company plans to use Al Builder to implement the solution. You select fields that will be used for prediction.

Which three 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.

You develop a model-driven app that has an embedded Power Bl report in the development environment. Another environment has a Power Bl workspace that corresponds to the development environment. All deployments must take place by using the maker portal.

When you manually deploy changes to the other environment, you observe that the report from the development workspace is displayed. You need to resolve the issue.

Which two actions should you perform? Each correct answer presents part of the solution. Choose two. NOTE; Each correct selection is worth one point.

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 in the review screen.

You are creating Power Virtual Agents chatbot that captures demographic information about customers.

The chatbot must determine the group a customer belongs to based on their age. The age groups are:

0 - 17

18 - 25

26 - 35

36 - 55

55 - 100

You need to configure the chatbot to ask a question that can be used to determine the correct age group.

Solution: Use age for Identify in the question and then add branches for each group that use conditional logic.

Does this meet the goal?

A bank uses Power BI visualizations to help determine whether they should loan money to a customer. The bank has three different visuals that are part of a Power BI report. The bank uses a set of four risk variables that indicate whether the customer is creditworthy.

You must create a mechanism so that bank employees can change the values of the four risk variables. Changes to the value of any variable must cause the three visualizations to update.

You need to create the solution.

Which action should you perform? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

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 an alternate key for the columns.

Does the solution meet the goal?

A company uses Power Apps.

Users must be able to view only the address1 columns in the Account table.

You need to ensure other address columns are not visible to users when creating views and filters.

What should you do?

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.

You create a new Power Virtual Agents chatbot for an organization.

Testing and production deployment of the chatbot are not complete.

You need to ensure that appropriate users can access the chatbot.

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

NOTE: Each correct selection is worth one point.

A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data. The company requires that the contacts be added to Dataverse automatically every day You need to identify which tools are required to create and perform the import. What should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You are using power Automate to create a list of customers from a Microsoft Excel file,

The list must contain customers who meet one of the following criteria:

Sales of less than $500,000.

Customers who are on credit hold.

You need to create a condition to filter the list Of customers.

How should you complete the filter condition? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point

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 in the review screen.

A company uses Dataverse.

The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.

You need to recommend a solution.

Solution: Enable attachments for a table.

Does the solution meet the goal?

You plan to add a Power Apps app to Microsoft Teams.

A Microsoft Dataverse for Teams environment has not been provisioned.

You need to create a Dataverse for Teams environment.

Which two actions can you perform? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are designing a Power Virtual Agents chatbot for a store.

You need to teach the chatbot to acknowledge the store ' s product categories and the variations within specific categories.

You need to create custom entities to provide the chatbot with the knowledge of the product categories.

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

NOTE: Each correct selection is worth one point.

You create a Power Apps portal to provide training and documentation for students. Students create a profile on the portal and then select and pay for courses.

You plan to add free courses to the training portfolio. Free courses must be automatically available to all students when they sign in.

You need to assign default permissions to students.

What should you do?

You create a Power Virtual Agents chatbot to reduce the number of incoming support calls that require a live person.

The chatbot does not direct users to the correct information. You determine that this is because the chatbot is not able to identify which product a user is referring to in a conversation.

You need to present a list of products so that users can select the correct product.

What should you create?

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?

A company plans to implement a model-driven app. The company will enter data through the app. The company has the following requirements:

• Users must be able to search for the data inside the app.

• Users must be able to search for the data outside the app.

You need to configure a solution for each requirement.

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

NOTE: Each correct selection is worth one point.

You need to be able to move a Power Automate desktop flow used in the verification process to the testing environment.

What should you do?

You need to address the unnecessary data access.

Which security changes should you make? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to resolve the issue reported by substitute employees after they are assigned service requests.

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

NOTE : Each correct selection is worth one point.

You need to address the executive’s concerns regarding unnecessary data access.

Which security changes should you make? To answer, select the appropriate options in the answer area.

NOTE : Each correct selection is worth one point.

You create a desktop flow to interact with a certification authority’s website.

You need to get data in and out of the desktop flow.

How should you set up the input and output parameters? To answer, select the appropriate options in the answer area.

NOTE : Each correct selection is worth one point.

You need to set up the new service request completion process.

Which two components should you include in the solution? Each correct answer presents a complete solution.

NOTE : Each correct selection is worth one point.

You need to capture the Date Completed value from the website using a desktop flow.

Which method should you use?

You need to implement the requirement for the VP of sales.

What should you do?

You need to configure a Power Automate flow to send the email with the results to the client.

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

NOTE: Each correct selection is worth one point.

You need to add the missing components to the Verification Process Automation solution.

Which two components should you add? Each correct answer presents a complete solution.

NOTE : Each correct selection is worth one point.

You need to coordinate updates and deployment for managed solutions containing completed work without disrupting the system.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to create the automation for the qualification verification process.

Which two actions should you perform? Each correct answer presents a complete solution

NOTE: Each correct selection is worth one point.

You need to assign 10 percent of the Qualification records to the QV queue through table configuration by using a Power Automate flow.

What should you do?

You need to configure a Power Automate flow to send the email with the results to the client.

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

NOTE : Each correct selection is worth one point.

You need to create a flow to send an email to the primary contacts.

Which actions should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to format the Current Date field for parental consent. What should you use?

You need to configure the Primary Contact field.

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

NOTE: Each correct selection is worth one point.

You need to configure the Total field on the Evaluation form.

Which property should you select for the formula? To answer, move the appropriate property to the correct formula. You may use each property once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content

NOTE: Each correct selection is worth one point.

You need to create reminders for the adopters.

What should you use for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to improve the user experience for the care staff to log exercise and feeding.

What should you create?

You need to create adoption duties for the administrative staff.

What should you create?

You need to set up a security role for the care staff.

Which privileges should you set? To answer, move the appropriate privileges to the correct create, read, write tables. You may use each create, read, write privileges once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

NOTE; Each correct selection is worth one point.

You need to manage contact duplicates for the administrative staff.

What should you do?

You need to configure the Deposit column.

How should you write the formula?

You need to ensure that an appropriate date is selected for dog pickup.

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

NOTE: Each correct selection is worth one point.

You need to set up the capability to view the change history for the food type and amount.

What should you set up? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to define the table types for Contoso Suites.

Which table type should you define for each requirement? To answer, move the appropriate table types to the correct tables. You may use each table type once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

You need to enable the care staff to update a dog ' s weight.

Which three 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.

You need to design the guest check-in solution.

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

NOTE: Each correct selection is worth one point.

A guest asks about the start time of a specific scheduled event and wants to know what the snow conditions will be like during their stay.

You need to determine how to design the chat solution to answer those questions.

What should you do? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to design the chat solution to answer the inquiry from Guest1.

Which three components can you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You need to embed the check-in solution into the communication solution. To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You need to design the resort portal ' s email registration process.

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

NOTE: Each correct selection is worth one point.

You need to design and create the solution for gathering contact information from guests for marketing purposes.

What should you use? To answer, select the appropriate options In the answer area.

NOTE: Each correct selection is worth one point.

You need to design the resort portal’s email registration process.

Which solution should you use?

You need to design the resort portal’s email registration process.

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

NOTE: Each correct selection is worth one point.