In order to set realistic expectations, please note: These questions are NOT official questions that you will find on the official exam. These questions DO cover all the material outlined in the knowledge sections below. Many of the questions are based on fictitious scenarios which have questions posed within them.

The official knowledge requirements for the exam are reviewed routinely to ensure that the content has the latest requirements incorporated in the practice questions. Updates to content are often made without prior notification and are subject to change at any time.

Each question has a detailed explanation and links to reference materials to support the answers which ensures accuracy of the problem solutions.

The questions will be shuffled each time you repeat the tests so you will need to know why an answer is correct, not just that the correct answer was item "B" last time you went through the test.

Candidates for this exam perform discovery, capture requirements, engage subject matter experts and stakeholders, translate requirements, and configure Power Platform solutions and apps. They create application enhancements, custom user experiences, system integrations, data conversions, custom process automation, and custom visualizations.

Candidates implement the design provided by and in collaboration with a solution architect and the standards, branding and artifacts established by User Experience Designers. They design integrations to provide seamless integration with third party applications and services.

Candidates actively collaborate with quality assurance team members to ensure that solutions meet functional and non-functional requirements. They identify, generate, and deliver artifacts for packaging and deployment to DevOps engineers, and provide operations and maintenance training to Power Platform administrators.

Power Platform Functional Consultants should be familiar with using Power Platform components to extend and customize Microsoft apps and services such as Teams, Dynamics 365, Excel, and Word.

Skills measured on Microsoft PL-200 Exam

Configure Microsoft Dataverse (25-30%)

Manage an existing data model

• assign a type for a table including standard, activity, or virtual

• configure tables ownership

• create new tables or modify existing tables

• determine which type of relationships to implement including 1: N and N: N

• configure table relationship behaviors including cascading rules

• create new relationships or modify existing relationships

• create new columns or modify existing columns

• create alternate keys for tables

• configure table properties

• configure connection roles

Create and manage processes

• define requirements for business rules

• define and implement business rule logic

• define the scope for business rules

• configure and test business rules

• configure a synchronous classic workflow

Configure Dataverse

• configure Relevance Search

• configure auditing

• perform data management tasks

• configure duplicate detection settings

• configure privacy preferences

• Configure security settings

• create and manage business units

• create and manage security roles

• create and manage users and teams

• create and manage column security profiles

• configure hierarchy security

• configure Conditional Access settings

Create apps by using Power Apps (20-25%)

Create model-driven apps

• create and configure forms

• create and configure views

• create and configure charts

• create and configure dashboards

• configure site maps

• select applicable assets for an app including tables, forms, views, business process flows, dashboards, and charts

• share a model-drive app

• apply organizational branding by using themes

Create canvas apps

• create a canvas app

• configure Dataverse as a data source for an app

• create canvas app screens

• implement form navigation, formulas, variables and collections, and error handling

• build reusable components and component libraries

• configure offline capabilities for apps

• run Power Automate flows based on actions that occur in a canvas app

• interpret App Checker results and resolve identified issues

• test, monitor, and share apps

Create portal apps

• create a portal app

• expose Dataverse data

• configure portal web pages, forms, and navigation

• configure portal security including web roles and page access

Create and Manage Power Automate (15-20%)

Create flows

• describe types of flows and flow components

• trigger a flow by using Dataverse connectors

• run actions by using the Dataverse connector

• implement logic control

• implement dynamic content and expressions

• interpret and act on Flow Checker results

• activate and deactivate flows

• interpret flow analytic data

Create and manage business process flows

• configure a business process flow

• add business rules, workflows, and action steps to a business process flow

• define stages and steps

• configure parallel branches

• manage the business process flow table for a business process flow

Build desktop flows

• describe types of desktop flows

• identify use cases for desktop flows

• differentiate between attended and unattended desktop flows

• record business process tasks

Implement Power Virtual Agents chatbots (10-15%)

Create chatbot

• assign a chatbot to an environment

• publish a chatbot

• share a chatbot

• add chatbots to Teams and other channels

• monitor and diagnose bot performance, usage, and topic usage

Configure topics

• define topic conversation triggers

• create questions, messages, and conditions

• extract topics from a web page

• implement greetings, escalations, error messages, and statuses

• call a Power Automate flow to run an action

Configure entities

• create custom entities

• implement entities in conversations

• implement variables to store data

Integrate Power Apps with other apps and services (15-20%)

Integrate Power BI with Power Apps

• create Power BI visualizations

• create data flows and schedule data flow runs

• filter data

• build reports and dashboards

• publish and share reports and dashboards

• add Power BI tiles to model-driven apps and canvas apps

• add canvas apps to a Power BI dashboard

• trigger Power Automate flows from Power BI alerts

Implement AI Builder

• determine which AI Builder model type to use

• create an AI Builder model

• prepare source data for use by models

• train, test, and publish a model

• consume a model by using Power Apps

• consume a model by using Power Automate

Integrate Power Apps with Microsoft 365

• add apps to Microsoft Teams

• create a Teams app from a Power Apps app

• create an app directly in Teams

• configure app policies

• create a Teams channel by using Power Automate

• configure and use Microsoft Word and Microsoft Excel templates

The exam is available in the following languages: English