Microsoft Power Platform Functional Consultant (PL-200)

You create a Power Automate flow as part of a managed solution. The flow alerts users when files are uploaded to a SharePoint location.
Files are uploaded to SharePoint at a much higher rate than expected. Users report that they receive too many notifications about uploaded files.
You need to stop the flow and correct the issue.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Hot Area:

A company is creating a canvas app and a model-driven app to manage their customer accounts.

The canvas app requires a business rule to set the Business Type column to large if the customer size is greater than a specific currency value.

The model-driven app requires a business rule to recommend the account rating be re-evaluated when the account goes on credit hold for this app only.

You need to configure the scope for the business rules.

Which scope should you use? 

To answer, drag the appropriate scopes to the correct business rules. Each scope 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.

Select and Place:

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

What should you do?

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 plan to create a Pouter Virtual Agents bot.

The bot has the following requirements:

• Ensure that user responses are available to any topic.

• Recognize a list of words from spoken language of users.

You need to configure the bot.

Which features should you use? 

To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You are a system administrator for a company with locations in Mexico, United States, and France. The company has both fulltime employees and contractors in all regions. Fulltime employees use a mobile app. The company has two security groups: fulltime employees and contractors.

The company requests a chatbot in Microsoft Teams to answer employee benefit questions. The chatbot must meet the following requirements:

• It must be in the local language.
• Only fulltime employees may access the chatbot.

You need to configure the chatbot.
What should you do? 

To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You are creating Power Bl reports for a company.

A company that has a app wants to use Power Bl reports within the app. You create the reports.

You need to ensure that these reports are available within the app.

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

NOTE: Each correct selection is worth one point.

A company creates a canvas app.

The app requires users to enter their social security number. The app should only display the last four digits when the user tabs to a different column.

You need to configure the app.

Which option should you use?

You use a dataflow to import data into Microsoft Dataverse.

The data uses the following schema:

The data must load in the least amount of time.

You need to configure the incremental refresh settings for the dataflow.

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

NOTE: Each correct selection is worth one point.

Hot Area:

You plan to create a canvas app.

The app requires a button on the data entry screen that users can select to send an email.

You need to configure the app.

What should you create?

You use Power Virtual Agents to create a bot that will answer and transfer help desk calls.

You create topics that contain nodes and functions. The company has the following requirements for the bot:

• When a caller states the word issue help. or problem, the bot must respond with the question, “How can we help you today?"
• When the bot responds with the question, 'How can we help you today?”, the bot must provide the caller with the choices of hardware, software, or other.
• When the caller asks a question, the bot must save the response so that it can perform an action on the response.

You need to configure the bot.

Which nodes or functions should you use? 

To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You are setting up Power Apps security for a company. The company has a CEO, two vice presidents, and 10 managers. Five support representatives report to each manager.

You set up Manager Hierarchy so managers are able to view data only for the representatives who report to them. The CEO must be able to view all data for everyone.

All support representatives must be able to view customer information in each other's data across all managers.

You need to resolve issues that answer during testing.

What should you do? 

To answer. select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

A company is configuring a Power Apps portal using Microsoft Dataverse.

The company requires the following:

• Only authenticated users must be able to sign into the portal.
• Authenticated users must have varying degrees of access to the different parts of the portal.
• Users must enter one of several external identities when creating an account during the open registration process.

You need to configure user authentication and permissions.

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

NOTE: Each correct selection is worth one point

Hot Area:

A company plans to create two Microsoft Power Platform applications.

One of the applications requires a custom control layout without using code. The other application will be used primarily by external users.

You need to create the applications.

Which application types should you use? To answer, drag the appropriate application types to the correct requirements.

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.

Select and Place:

Your organization does not permit the use of custom code for solutions.

You need to create a view that can be viewed by all users in an organization.

Where should you create the view?

A company uses a model-driven app with Microsoft Dataverse in a single environment.

The company requires a canvas app that includes the same data as the model-driven app.

You need to create the canvas app.

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.

Select and Place:

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 create a new solution for a business process.

The business process includes uploading specific file types to a web service.

You need to ensure that the business process works the same way anywhere the solution is deployed.

Which option should you use? 

To answer, drag the appropriate options to the correct configurations. Each option 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.

Select and Place:

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 uses a Microsoft Power Platform environment.

The company plans to implement a Power Apps app. The application must meet the following requirements:

• Audit all user activity and only retain the audit logs for one year.
• Annually remove products that were created over a year ago.

You need to configure the automated processes.
What should you configure? 

To answer, drag the appropriate configurations to the correct requirements. Each configuration 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 customer uses Power Apps to view and maintain their contacts that are stored in Microsoft Dataverse.

Several columns must be configured to ensure the security settings for sales associates are view only.

You need to configure the access restrictions.

Which component for field-level security should you use? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

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.

On a Contact record, a user creates a Note record that contains the word running.

One week later, the user reports that they cannot find the Contact record associated with the Note record.

You need to find the Note record.

Solution: Use Dataverse Search to search for the word run.

Does the solution meet the goal?

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.

Hot Area:

A company has a model-driven app that uses Microsoft Dataverse.

Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number.

You need to enable the required features.

Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature 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.

Select and Place:

A company uses Power Apps.

The company plans to create a canvas app that uses a responsive design.

You need to configure the app.

Which two actions should you perform? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

A company uses model-driven apps.

Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data.

You need to configure the app.

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.

Select and Place:

A company is implementing Power Apps and Power Automate.

Several components are created within Power Apps, Microsoft Dataverse, and Power Automate. These components must be promoted from the development environment to the user acceptance test environment in a single solution package.

You need to create the solution package for promotion.

Where should you create the package?

A company creates a canvas app.

The app requires near real-time data from an accounting system that resides in a customer's data center.

You need to implement a solution for the app.

What should you create?

You create functionality for a company. The functionality includes a Microsoft Dataverse table with a form for data entry. The functionality will be distributed to other lines of business in the company, each with its own Dataverse environment.
New forms must not be created in order for updates to the functionality to work correctly.
You need to package the new functionality for distribution.
What should you do?

A user needs to create a Power Apps portal app.

The user is getting a permission denied error when creating the portal app.

You need to configure permissions to create the portal app.

Which three permissions should you configure? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

You are configuring Microsoft Dataverse security. You plan to assign users to teams.

Record ownership and permissions will differ based on business requirements.

You need to determine which team types meet the requirements.

Which team type should you use? To answer, drag the appropriate team types to the correct requirements. Each team type 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.

Select and Place:

A company uses a Power Apps app with Microsoft Dataverse.

The company requires the import of records into Dataverse. Duplicate records in the data must be deleted without user intervention.

You create a duplicate detection rule.

You need to configure the rule for the data import.

Which option should you configure?

You need to build a Power BI dashboard for sales managers to track opportunities.

When a new sale closes that is greater than $1 million, a notification must pop up and an email must be sent to the leadership team.

You need to ensure the email is sent without editing the Microsoft Dataverse.

Which two elements should you configure? Each correct answer is part of the solution.

NOTE: Each correct selection is worth one point.

You create a canvas app that uses data from a Microsoft SQL Server database.

You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app.

You need to filter data in the dataflow and in the canvas app.

Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool 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.

Select and Place:

You plan on implementing complex business logic in Microsoft Dataverse tables by using Power Automate flows.
You realize that the functionality required to implement the business logic is not available in a Power Automate flow.
The new business logic must work in multiple Dataverse tables. In addition, the operation must return a value after it finishes and must be able to run from an existing Dataverse action.
You need to recommend the method to implement the missing logic.
What should you recommend?

A company uses a model-driven app for customer support.

The company has the following requirements for the app:

• Send an email in real-time to customers when they enter their email address.

• Send an email to customers at the same time every day for cases that are open for more than 24 hours.

The solution should require the least amount of customization.

You need to configure the model-driven app.

Which components should you use? To answer, drag the appropriate components to the requirements. Each 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.

Select and Place:

A cloud flow you authored failed several times in production due to a transient network issue. The issue is now resolved.

You need to reprocess the failed flow runs with the least amount of administrative effort

What should you do?

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.

Hot Area:

You create a model-driven app for an automobile parts help desk.

A help desk agent uses a form to gather information about customers' automobiles in two custom tables. The names of the tables are Client and Automobile.

The form must prepopulate the following information about the customer from the client table:

• First name

• Last name

The agent must be able to type the following information about the automobile:

• Automobile make
• Automobile model

You need to implement the form.
What should you configure? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You plan to create a Power Virtual Agents bot.

The bot must support single sign-on.

You need to publish the bot.

Which two locations should you use? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle.

After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table.

You add the following columns to the table:

• Bicycle type

• Tire brand

• Special equipment

Select and Place:

A company plans to implement a voice-enabled Power Virtual Agents bot.

The company has the following requirements for the bot:

• Recognize when a caller states Tennis or any variation of the word.

• Provide options when a caller states the name of a sport.

You need to configure the bot.

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

Hot Area:

You are configuring the Invoice table in Dataverse for a billing application. Each invoice has multiple associated invoice line records.

You need to display columns with the following values:

• Total Handling Cost that is the sum of the Handling Cost column on all related invoice lines

• Remaining Balance that subtracts the Payment Received column from the Total Amount column.

You need to implement the Total Freight and Remaining Balance columns on the Invoice table.

Which column types should you use? To answer, move the appropriate column types to the correct calculations. You may use each column 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.

Select and Place:

A company uses a model-driven app. The app uses a Power Virtual Agents chatbot.

The company has two locations in different countries/regions with separate environments for each location. Each location has a development environment, a testing environment, and a production environment. The company uses the Application Lifecycle Management (ALM) process for the environments.

You need to create the different Power Virtual Agents bot environments.

How many Power Virtual Agents bot environments are required?

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:

• 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 duplicate detection rule for the columns.

Does the solution meet the goal?

A company is planning to create a Power Virtual Agents bot.

The bot has the following requirements:

• The bot must provide address information for the company.

• The bot must be available from Microsoft Teams and from the internet website of the company.

You need to configure the bot.

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

HOT AREA

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 model-driven app.

The company needs to automatically update the Status column in real time.

You need to configure this feature.

Solution: Create a flow that has an Update item action.

Does the solution meet the goal?

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.

Select and Place:

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 model-driven app.

The company needs to automatically update the Status column in real time.

You need to configure this feature.

Solution: Create a workflow that has an Update Record step.

Does the solution meet the goal?

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 model-driven app.

The company needs to automatically update the Status column in real time.

You need to configure this feature.

Solution: Create a flow that has an Update a row action.

Does the solution meet the goal?

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.

Hot Area:

A company records data in Microsoft SharePoint Online. The company is creating a mobile app by using Microsoft Power Platform only.

The company requires the app to connect directly to SharePoint Online to collect data.

You need to recommend which Microsoft Power Platform product or feature to implement.

What should you recommend?

A company is implementing a data model by using Dataverse.

The company requires the following columns in a new custom table:

You need to choose the column type that uses the least amount of database storage for each column.

Which column types should you choose? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

You need to set up webpage permissions.

Which permissions must you set? 

To answer, move the appropriate permissions to the correct page. You may use each permission 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 store scanned consent forms.

Where should you store the forms?

Notes

Column

Attachment

SharePoint

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 create a JavaScript web resource named MyBusinessLogic. The code it contains uses functionality from a third-party JavaScript library.

You notice that an independent software vendor (ISV) solution uses the same third-party library in their managed solution.

You plan to deploy your solution to other environments by using a managed solution. The ISV solution might not be installed in the other environments.

You need to package the solution for deployment

What are two ways to achieve this goal? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

You are creating tables for use with Microsoft Power Platform components.

The display names of the tables must not be changed when the solution is promoted to the user acceptance testing environment.

You need to apply this restriction to the solution.

Where should you make the changes?