Free Microsoft PL-200 Practice Test & Real Exam Questions

  • Exam Code/Number: PL-200
  • Exam Name/Title: Microsoft Power Platform Functional Consultant
  • Certification Provider: Microsoft
  • Corresponding Certification: Microsoft Power Platform
  • Exam Questions: 304
  • Updated On: Oct 07, 2026
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.
Correct Answer:

Explanation:
You create a new independent software vendor (ISV) solution for a Power Apps app.
The Power Apps solution will be imported into multiple customer environments. The environments will have a large variety of solutions and publishers.
You need to avoid naming conflicts during solution import.
Which element should you configure?
Correct Answer: D Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You need to configure the Deposit column.
How should you write the formula?
Correct Answer: B Vote an answer
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.
Correct Answer:

Explanation:

Box 1: Use the demo website
When publishing the bot to the web, you can publish to a prebuilt demo website (which you can use to share the bot with your teammates and stakeholders) and to your own live website.
Box 2: Share the chatbot to a security group containing all users.
A license for each user, also known as a " per user license " (or " Power Virtual Agent User License " as referred to on the Microsoft 365 admin center), should be assigned to individual users who need access to create and manage chatbots.
To simplify user license management, you can assign licenses to an Azure Active Directory (Azure AD) security group.
Box 3: Embed the chatbot code in an IFRame on your copany ' s public website You can add your bot to a live website as an IFrame. Your live website can be a customer-facing external website or an internal site, like a SharePoint or Yammer site.
Reference:
https://docs.microsoft.com/en-us/power-virtual- agents /publication-connect-bot-to-web-channels
https://docs.microsoft.com/en-us/power-virtual-agents/requirements-licensing
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.
Correct Answer: B,C Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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.
Correct Answer:

Explanation:
First Box: Power Query
To filter data in a dataflow, you should use Power Query. Power Query is a data connection tool that is part of the Microsoft Power Platform, which allows you to connect to various data sources, transform, and load data into other applications such as Power BI, Excel, and Dataverse. It is a functional, case-sensitive, and data- transformation language that enables you to discover, connect, combine, and refine data sources to meet your business intelligence needs.
Power Query allows you to filter data by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions. You can also use the advanced editor to write complex queries using M code, which is the underlying language used by Power Query.
Reference: https://docs.microsoft.com/en-us/pow er-query/ https://docs.microsoft.com/en-us/power-query
/transform/filter-rows-by-condition
2 nd Box: Power Fx
To filter data in a canvas app, you should use Power Fx. Power Fx is a no-code, low-code, and code-based platform that enables you to build custom business logic and automate workflows in your Power Platform apps. It allows you to create custom formulas and expressions in the app using a functional language, which allows you to filter data in the app.
Power Fx can be used to create custom formulas and expressions in the app which can filter data in the app by using its built-in functions and operators. You can filter data by using the filter, sort, and group by functions, as well as by using custom formulas and conditions. You can also use the advanced editor to write complex queries using Power Fx code.
Reference: https: //docs.microsoft.com/en-us/power-apps/maker/canvas-apps/power-fx-formulas
You are implementing a model-driven app to support a new line of business.
There are several places where automated business logic must be applied.
You need to determine how to apply the business logic.
Which method should you use? To answer, drag the appropriate methods to the appropriate business logic statements. Each method 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.
Correct Answer:

Explanation:

Box 1: Business rule
By combining conditions and actions, you can do any of the following with business rules:
* NSE5_FSM-5.2 Set column values
* Clear column values
* Set column requirement levels
* Show or hide columns
* Enable or disable columns
* Validate data and show error messages
* Create business recommendations based on business intelligence.
Box 2: Real-time workflow
Real-time workflows:

Box 3: Power Automate instant flow
Instant Flows don't have a trigger in the same way as the Automated flow. Instead, they are triggered manually or on-demand, such as a user clicking a Flow button in the mobile app.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-busi ness-rule s-recommendations-ap ply-logic-form
https: //docs.microsoft.com/en-us/powerapps/maker/data-platform/configure-workflow-steps
https://carl desouza.com/difference-between-instant-automated-and-scheduled-flows-in-power-automate-and-how-to-change-the-type/
You ate a Dynamics 365 help desk administrator
You need to create a dashboard that displays information on help desk cases that ate handled each week.
Which dashboard components should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:

Explanation:
System
Personal
Personal
Personal
System
https ://docs.microsoft.com/en-us/dynamics365/customer-engagement/basics/add-edit -power-bi- visualizat ions-dashboard
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.
Correct Answer:

Explanation:
You configure an alert in Power Bl.
You need to alert users when the value of a tile exceeds a threshold. To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:

Explanation:

Reference:
https://docs.microsoft.com/en-us/pow er-bi/create-reports/service-set-d ata-alerts
A car dealership has a Dynamics 365 Sales environment for its sales company and another environment for its leasing company. Users in one environment must not be able to see the other environment. You need to grant salespeople access to the sales company environment. What should you do?
Correct Answer: B Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
You are configuring a new Power Apps portal. You have two web roles, one for authenticated users and one for anonymous users. You grant the Anonymous Users role to users.
A test user reports that they can access the home page but cannot view a page linked from the home page.
You need to determine why the test user cannot view the portal page.
What is the cause of the issue?
Correct Answer: C Vote an answer
Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).
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.
Correct Answer:

Explanation:
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: Configure SharePoint Online integration.
Does the solution meet the goal?
Correct Answer: B Vote an answer
You must create a new entity to support a new feature for an app. Entity data will be transactional and will be associated with business units.
You need to configure entity ownership.
Which entity ownership type should you use?
Correct Answer: A Vote an answer