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

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?

• Scheduled workflow
• Bound action
• Custom API
• Unbound action

You have a classic workflow. The workflow updates a custom column on a record when an account record is created. The workflow must update the custom column based on the following conditions:* Update the custom column value using the Account Number.* If the Account Number column is blank, update the custom column value using the Ticker Symbol.* If the Ticker Symbol column is blank, update the custom column value to N/AYou need to configure the custom column value by using the update record step. What should you do?

• Add the two columns with the default value by using the Forms Assistant.
• Add an expression that evaluates the two column values and uses the first populated value or else the default value.
• Add check conditions to determine if the two columns contain data.
• Add a formula that evaluates the two column values and uses the first populated value or else the default value

You are a Dynamics 365 Customer Service system administrator. You create an app for the sales team.Members of the sales team cannot access the app.You need to ensure that sales team members can access the app.Where should you configure app permissions?

• Security Roles
• Manage Roles
• Dynamics administration center
• Dynamics 365 home

A company deploys a chatbot that is embedded in a Power Pages website. The company has the following requirements for the chatbot:* Azure AD users only must be able to use the chatbot when accessing sensitive data.* The chatbot must be accessible only from the Power Pages website.You need to recommend a solution that meets the requirements.Which two options should you recommend? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

• Enable Manual authentication.
• Set up a new channel for the chatbot.
• Enable Only for Teams authentication.
• Enable web channel security.
• Configure a data loss prevention policy.

You need to create the automation for the qualification verification process.Which two actions should you perform? Each correct answer presents a complete solutionNOTE: Each correct selection is worth one point.

• Add a Dataverse connector.
• Add an Outlook connector.
• Create an on-premises data gateway reference.
• Update the Qualification records to finished.
• Create a Service Request record.

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: Use Microsoft Entra ID authentication.Does the solution meet the goal?

• Yes
• No

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

• dynamic content
• expression
• switch
• condition

You need to build a Power Bl dashboard for sales managers to track opportunities.When a new sale closes that is greater than S1 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.

• alerts in Power Bl
• a calculated column in the Dataverse
• a custom connector
• a paginated report to save to Microsoft OneDrive
• a Power Automate flow

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 a Change Status step.Does the solution meet the goal?

• Yes
• No

You are using the Data import wizard to import records into the account table from a CSV file. The CSV-to-table mapping is as follows:* The Name column represents the account name and maps to the Account Name column.* The Parent Name column represents the holding company of the account with subsidiaries underneath.Records that are imported into the table are only related to other records in the file.You need to configure the import to create the relationship between records.What should you do?

• Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
• Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.
• Look up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column.
• Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria.