Microsoft PL-200: Microsoft Power Platform Functional Consultant

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Configure Microsoft Dataverse

   Which relationship type should be used when many contacts can belong to many marketing lists?

   1. AA self-referencing lookup, which links a list only to other lists inside the same table and never to contacts
   2. BA one-to-many relationship, which allows each list to hold many contacts but each contact only one list at a time
   3. CA many-to-many relationship, which links each contact to any number of lists and each list to any number of contacts
   4. DA calculated column, which stores the number of lists for each contact but creates no link between the tables
   Show answer and explanationHide answer

   Correct answer: C

   A many-to-many relationship links records in both directions in any number. One-to-many, self-referencing lookups and calculated columns do not model that case.

2. Question 2Create apps by using Microsoft Power Apps

   Which Power Apps app type is built around Dataverse tables and business processes with forms and views?

   1. AA model-driven app, which is generated from the data model with forms, views and dashboards
   2. BA canvas app, which is designed pixel by pixel from a blank screen with free placement of each control on it
   3. CA portal built on Power Pages, which is used for external websites rather than for internal business processes
   4. DA flow, which automates steps in the background and does not present forms or views to users in any screen
   Show answer and explanationHide answer

   Correct answer: A

   Model-driven apps are generated from the data model with forms and views. Canvas apps are freeform, Power Pages serves websites and flows automate background steps.

3. Question 3Create and manage logic and process automation

   Which automation type runs in response to a Dataverse row being created or updated?

   1. AA canvas app timer that refreshes a gallery on a schedule and does not respond to table events
   2. BA scheduled flow that runs only at fixed times and has no connection to any table event in Dataverse
   3. CA manual flow that a user starts from a button and that does not respond to table changes by itself
   4. DAn automated cloud flow with a Dataverse trigger for the relevant table event
   Show answer and explanationHide answer

   Correct answer: D

   An automated cloud flow with a Dataverse trigger responds to row events. Scheduled, manual and timer approaches do not respond to table events in that way.

4. Question 4Manage environments

   What is a development environment in Power Platform used for?

   1. AStoring archived records that users no longer need for their work in the business each day of the year
   2. BServing live customers directly with the production data of the company's most important business process
   3. CBuilding and testing solutions away from production users and data
   4. DHosting the public website of the company for search engines to index on the internet for the marketing team
   Show answer and explanationHide answer

   Correct answer: C

   Development environments are for building and testing away from production users. The other options describe production or archive use.

5. Question 5Configure Microsoft Dataverse

   What does a cascading delete behaviour on a relationship do?

   1. AIt copies the child records into an archive table each time the parent record is saved by the system
   2. BIt deletes the parent record automatically when any child record is changed by a user in the application
   3. CIt prevents the parent from being deleted while any child records exist, with no other effect on the children
   4. DIt deletes related child records automatically when the parent record is deleted
   Show answer and explanationHide answer

   Correct answer: D

   Cascading delete removes related child records when the parent is deleted. Other behaviours describe changes or blocks that are different settings.