Microsoft · PL-200
Microsoft Certified: Power Platform Functional Consultant Associate (PL-200) Practice Test
Validates ability to configure Microsoft Dataverse, create apps using Power Apps, manage logic and process automation, and manage environments for business solutions.
Exam Details
Questions
1120
Duration
120 minutes
Passing Score
700/1000
Difficulty
AssociateLast Updated
Jan 2026
Topics Covered
Microsoft DataversePower AppsProcess AutomationEnvironment ManagementBusiness SolutionsSystem Integrations
Microsoft Certified: Power Platform Functional Consultant Associate (PL-200) Practice Exam Preparation
Use this PL-200 practice exam to prepare for Microsoft Certified: Power Platform Functional Consultant Associate (PL-200) with realistic questions, detailed explanations, and focused study modes. The practice bank includes 1,120 questions for Microsoft PL-200, so you can review the exam steadily instead of relying on one long cram session.
As you practice, pay extra attention to recurring topics such as Microsoft Dataverse, Power Apps, Process Automation, Environment Management, and Business Solutions. Start with short sessions to identify weak areas, then move into timed quizzes once your accuracy is consistent.
The explanations are especially useful when you want to connect exam wording to the responsibilities and scenarios described in the official certification guidance. Use the free preview first, then unlock the full question bank when you are ready to build a complete study routine.
Exam Domain Breakdown
Configure Microsoft Dataverse28%
Create apps by using Microsoft Power Apps28%
Create and manage logic and process automation28%
Manage environments18%
Exam Overview
The Microsoft Power Platform Functional Consultant Associate certification, earned by passing Exam PL-200, validates a professional's ability to configure and extend the Microsoft Power Platform to solve real business problems. The certification covers four core competency areas: configuring Microsoft Dataverse (the underlying data platform), building model-driven and canvas applications with Power Apps, creating and managing process automation using Power Automate cloud flows and business process flows, and managing Power Platform environments through application lifecycle management (ALM) practices. The exam was last updated on December 26, 2024, reflecting current capabilities across Dataverse, Power Apps, Power Automate, and Power Pages.
This credential demonstrates that a holder can act as a liaison between business stakeholders and technical implementation teams — translating requirements into configured solutions, implementing integrations with third-party services, and enabling end-user adoption through documentation and training. It validates hands-on proficiency with data modeling, security configuration (including Dataverse security roles, column-level security, and Microsoft Entra ID group teams), low-code plug-ins, Power Fx formulas, and solution packaging for deployment across environments.
Who Should Take This Exam
This certification is designed for functional consultants working on Microsoft Power Platform implementations — professionals who perform discovery workshops, capture and translate business requirements, configure solutions, and collaborate with solution architects and UX designers. Typical job titles include Power Platform Functional Consultant, Business Analyst, CRM Consultant, and Dynamics 365 Consultant. Candidates typically have one to three years of hands-on experience with Power Platform tools in a project or consulting context.
The PL-200 is also well-suited for business analysts looking to formalize their low-code development skills, IT professionals transitioning into a functional consultant role, and Dynamics 365 practitioners expanding their platform knowledge. Candidates are expected to communicate effectively with both technical team members and non-technical stakeholders, and to understand ALM practices including solution management and environment strategy.
Prerequisites
Microsoft does not enforce formal prerequisites for the PL-200 exam, but candidates are strongly advised to have working familiarity with Microsoft Dataverse, Power Apps (both model-driven and canvas), Power Automate cloud flows, Power Pages, and Power Platform environments before attempting the exam. Proficiency in data modeling, user experience design concepts, and requirements analysis is explicitly listed in the official audience profile.
A recommended starting point is completing the official instructor-led course PL-200T00-A: Microsoft Power Platform Functional Consultant, or the equivalent self-paced learning paths on Microsoft Learn. Candidates with backgrounds in Dynamics 365 customer engagement apps will find significant overlap in Dataverse and security configuration topics. Hands-on experience building solutions end-to-end — including canvas apps, model-driven apps, and automated flows connected to Dataverse — is more predictive of exam success than theoretical knowledge alone.
Exam Format
Exam PL-200 is a proctored exam delivered through Pearson VUE, available both online (via OnVUE) and at physical test centers. The exam is offered in English, Chinese (Simplified), French, German, Japanese, Portuguese (Brazil), and Spanish. The passing score is 700 on a scale of 1–1000, and the exam has no stated retirement date. The exam price is approximately $165 USD, though pricing varies by country or region.
The exam may include a variety of question types such as multiple choice, drag-and-drop, case studies, and interactive lab-style components. Microsoft does not publish a fixed total number of questions, as the count can vary per delivery. The standard time allocation is 120 minutes. Candidates who take the exam in a non-native language may request an additional 30 minutes. A free Practice Assessment aligned to PL-200 objectives is available on Microsoft Learn to help gauge readiness before scheduling the exam.
Skills Measured
- 1.Configure Microsoft Dataverse (25–30%): Covers managing the data model (creating/modifying standard, activity, and virtual tables; configuring one-to-many and many-to-many relationships with cascading rules; creating rollup and formula columns), managing Dataverse features (search index, auditing, data import/export, duplicate detection, bulk deletion), and configuring security settings (business units, security roles, users and teams, column security, hierarchy security, and Microsoft Entra ID group teams).
- 2.Create apps by using Microsoft Power Apps (25–30%): Covers building model-driven apps (form types, controls, views, custom pages, modern commanding with Power Fx, embedded canvas apps, and Power BI dashboards), understanding canvas app structure (navigation, formulas, variables, collections, error handling, and calling Power Automate flows), and building Microsoft Power Pages (configuring pages, forms, lists, navigation, security via web roles, authentication options, multi-step forms, document management, and Power BI integration).
- 3.Create and manage logic and process automation (25–30%): Covers creating and managing cloud flows (flow types, connector components, logic controls including branches/loops/conditions/error handling, dynamic content, Dataverse connector, and troubleshooting), configuring business process flows (stages, workflows, flow steps, and the BPF table), managing classic Dataverse workflows (configuration, troubleshooting, and logs), and implementing low-code logic (low-code plug-ins, Power Fx functions and formulas, and business rules).
- 4.Manage environments (15–20%): Covers application lifecycle management (ALM) participation including use cases for app checker and solution checker, creating and managing Dataverse solutions, differentiating managed vs. unmanaged solutions, managing development environments, and importing/exporting solutions. Also covers interoperability with other services including email integration, SharePoint integration, document management options, and working with Microsoft Word templates.
Study Tips
- Use the official PL-200 Study Guide on Microsoft Learn (aka.ms/PL200-StudyGuide) as your primary study outline — every bullet point under each domain is a potential exam objective. Map your hands-on practice sessions directly to these bullets.
- Take the free official Practice Assessment for PL-200 on Microsoft Learn before scheduling your exam. It reflects the actual question style and helps pinpoint weak domains so you can prioritize study time efficiently.
- Build a complete end-to-end solution in a free Power Apps Developer Plan environment: create a Dataverse table with custom columns and relationships, build both a model-driven app and a canvas app against it, wire up a cloud flow with branching logic, and package everything into a managed solution for export. This mirrors the applied workshop in the PL-200T00-A course.
- Pay close attention to the security model in Dataverse — security roles, business units, column security, hierarchy security, and Microsoft Entra ID group teams are heavily tested. Practice creating roles, assigning them to users, and understanding how cascading rules affect related table records.
- Watch the PL-200 Exam Readiness Zone video series on Microsoft Learn, which covers all six topic areas in dedicated episodes. These videos are produced by Microsoft and are directly aligned to the exam domains updated as of December 2024.
- Study the distinctions between managed and unmanaged solutions, and practice the full ALM cycle: develop in a dev environment, export a managed solution, and import it into a target environment. Understanding solution layering and the difference between patch, clone, and full solution exports is frequently tested.
- For Power Pages, focus on the security model (web roles, page access, table permissions) and authentication options, as these are commonly tested areas that candidates with primarily Power Apps backgrounds tend to overlook.
Career Benefits
Holding the Power Platform Functional Consultant Associate certification positions professionals as the primary bridge between business stakeholders and technical delivery teams in Power Platform projects. Common roles for certified individuals include Power Platform Functional Consultant, Power Platform Business Analyst, Dynamics 365 Consultant, and low-code Solution Architect. The certification also serves as a prerequisite stepping stone toward PL-600 (Power Platform Solution Architect Expert). According to ZipRecruiter, Power Platform Consultants in the United States earn between approximately $118,000 and $206,500 per year, with an average around $111,000–$125,000 depending on seniority and location.
Demand for Power Platform skills continues to grow as organizations expand their use of low-code automation and application development to reduce reliance on custom-coded solutions. The PL-200 certification is recognized by Microsoft partners and enterprise employers as evidence of validated, role-specific platform knowledge, differentiating candidates in hiring processes. The certification requires annual renewal via a free online assessment on Microsoft Learn, ensuring that certified professionals stay current with platform updates.
Sample Questions
5 sample questions with answers and explanations. Start a practice session to test yourself across all 1120 questions.
Preview — answers shown1. You are advising a company on Power Fx features for their Power Platform solutions. You need to identify key features. Which two statements are true? (Select two!)
Multiple correct answersAIt uses an undefined value for uninitialized variables
BIt uses formulas similar to Microsoft Excel formulas
CIt uses synchronous data operations
DIt uses the model-driven app formula language
EIt supports declarative programming
FIt requires custom code for all operations
Explanation
Power Fx uses formulas similar to Microsoft Excel for calculations and logic. It employs synchronous data operations for immediate processing. Undefined values are not standard for uninitialized variables in Power Fx. It does not use the model-driven app formula language exclusively. It supports declarative but not imperative programming. It does not require custom code for all operations.
2. Litware is using AI Builder with Dataverse to extract text from uploaded invoices. Where is the underlying data for AI models stored?
AAzure Storage
BDataverse
CPower BI
DSharePoint
Explanation
AI Builder stores model data in the Dataverse environment for seamless integration with Power Platform apps. Power BI is for analytics, Azure Storage is for general cloud storage, and SharePoint is for document management.
3. You are setting up data import for Litware, a logistics company, using Dataverse. They receive daily CSV files with shipment data from OneDrive, and you need to import only new shipments each day without duplicates. Since the CSV lacks a date field, how should you handle the import process?
AUse a scheduled cloud flow to append all data
BConfigure automatic refresh on a dataflow
CManually edit the CSV daily to remove processed shipments and refresh manually
DSet up incremental refresh on a dataflow
Explanation
Manually editing the CSV to remove already imported shipments and then manually refreshing the dataflow prevents duplicates since the file lacks a date field for incremental refresh. Automatic refresh would process all data each time, causing duplicates. Incremental refresh requires a date field. Scheduled cloud flows don't inherently handle duplicate avoidance.
4. You work as a Power Platform Administrator for Fabrikam. The company has an environment that is no longer needed and contains no active resources. You need to remove the environment to free up resources and reduce costs. Which of the following actions should you perform?
ADisable the environment in the Azure portal.
BArchive the environment in the Power Apps maker portal.
CSuspend the environment in the Dynamics 365 admin center.
DDelete the environment in the Power Platform admin center.
Explanation
Deleting an environment in the Power Platform admin center permanently removes it, freeing up associated resources and stopping billing. Disabling environments isn't a standard option, archiving is for data not environments, and suspending is not available for general environments in Dynamics 365 admin center.
5. You work as a Power Platform Developer for Fabrikam. The company uses a Dataverse table for employee records. You need to show an error message on the 'Department' field if the 'Job Title' is not compatible with the selected department. This validation should occur before the record is saved. Which of the following should you use?
AA business process flow with a stage for validation.
BA canvas app validation rule.
CA business rule with a show error message action.
DA Power Automate flow triggered on save.
Explanation
Business rules can validate data and display error messages on fields, running client-side for immediate feedback and server-side before save to prevent invalid records.
More Microsoft Practice Exams
Microsoft Dynamics 365 Supply Chain Management Functional Consultant Expert (MB-335)
MB-335 · 2039 questions
Microsoft Dynamics 365 Business Central Functional Consultant (MB-800)
MB-800 · 1899 questions
Microsoft Certified: Azure AI Engineer Associate (AI-102)
AI-102 · 1392 questions
Microsoft Certified: Windows Server Hybrid Administrator Associate (AZ-801)
AZ-801 · 1376 questions
Microsoft Dynamics 365 Finance Functional Consultant (MB-310)
MB-310 · 1299 questions
Microsoft 365 Certified: Fundamentals (MS-900)
MS-900 · 1201 questions
$17.99
One-time access to this exam
Full access to all 1120 questions
Or $15/mo for all 253 exams
Detailed explanations
Free preview stays available