Microsoft Power Platform Functional Consultant (PL-200) Practice Exam

Microsoft Power Platform Functional Consultant (PL-200) is for candidates with skills and abilities in performing discovery, capturing requirements, engaging with subject matter experts and stakeholders, and configuring business solutions by using Microsoft Power Platform tools and components. They should know how to create application enhancements, tailored user experiences, and process automation.

As a candidate, the role involves executing the design developed in collaboration with a solution architect, following the standards, branding, and artifacts created by user experience designers. They are responsible for integrating with third-party applications and services, creating training materials, and leading training sessions.

Candidates should use their skills to engage and communicate effectively with members of the delivery team, stakeholders, and customer teams is crucial for ensuring their success. Additionally, they should know about application lifecycle management (ALM) practices specific to Microsoft Power Platform and quality assurance principles.

Who should take the exam?

The Microsoft Power Platform Functional Consultant (PL-200) exam is best fit for those who are familiar with using the following Microsoft Power Platform components:

• Microsoft Dataverse
• Microsoft Power Apps
• Microsoft Power Automate cloud flows
• Microsoft Power Pages
• Microsoft Power Platform environments

Candidates with proficiency in data modeling, user experience design, and requirements analysis can also take the exam.

Exam Details

• Exam Code: PL-200
• Exam Name: Microsoft Power Platform Functional Consultant
• Exam Languages: English, Chinese (Simplified), French, German, Italian, Japanese, Portuguese (Brazil), Spanish
• Exam Questions: 40-60 Questions
• Passing Score: 700 or greater (On a scale 1 - 1000)

PL-200 Exam Course Outline 

The Exam covers the given topics  - 

Topic 1: Learn how to configure Microsoft Dataverse (25–30%)

Managing the data model

• Creating or modifying standard, activity, or virtual tables
• Create new tables or modify existing tables
• Determining which type of relationship to implement, including one-to-many and many-to-many
• Configuring table relationships including behaviors and cascading rules
• Creating new or modify existing columns, including calculated, rollup, and formula
• Configuring table properties

Managing Dataverse

• Configuring Dataverse search, and manage the search index
• Manage auditing
• Describing options for importing and exporting data
• Configure duplicate detection settings
• Configuring bulk deletion

Configure security settings

• Managing business units
• Create and manage security roles
• Creating and managing users and teams
• Create and manage column security
• Configuring hierarchy security
• Configure Microsoft Entra ID group teams

Topic 2: Understand about creating apps by using Microsoft Power Apps (25–30%)

Creating model-driven apps

• Create and configure multiple form types
• Using controls in the form designer
• Create and configure views
• Configuring custom pages
• Configure modern commanding by using Power Fx
• Embed a canvas app in a model-driven app form
• Adding Microsoft Power BI dashboards and reports in a model-driven app

Describing canvas apps

• Describe canvas app structure
• Describing form navigation, formulas, variables and collections, and error handling
• Describing how Microsoft Power Automate flows are called from a canvas app

Building Microsoft Power Pages

• Configuring pages, forms, and navigation
• Describing advanced Power Pages features, including document management, search, multi-step forms, and Power BI
• Configuring website security including web roles and page access
• Describe use cases for templates
• Describing authentication options

Topic 3: Learn about creating and managing logic and process automation (25–30%)

Creating and managing cloud flows

• Describe types of flows, use cases, and flow components, including when to use a classic workflow
• Describing components of a connector
• Implement logic controls including branches, loops, conditions, error handling, and variables
• Implementing dynamic content and expressions
• Working with the Dataverse connector
• Managing and troubleshooting flows

Create and manage business process flows

• Configure a business process flow
• Adding stages, workflows, and flow steps to a business process flow
• Managing the business process flow table for a business process flow

Creating and managing classic Dataverse workflows

• Configuring a workflow
• Troubleshooting workflows
• Managing workflow logs

Implementing low-code logic

• Configure low-code plug-ins
• Write and ue Power Fx functions and formulas
• Creating and configuring business rules

Topic 4: Understand about managing environments (15–20%)

Participate in application lifecycle management (ALM)

• Describe use cases for app checker and solution checker
• Create and manage Dataverse solutions
• Describing the difference between managed and unmanaged Dataverse solutions
• Managing Microsoft Power Platform environments for development
• Importing and exporting Dataverse solutions

Manage interoperability with other services

• Configure email integration
• Configuring Microsoft SharePoint integration
• Describe options for document management
• Working with Microsoft Word templates