Microsoft · PL-200
Microsoft Certified: Power Platform Functional Consultant Associate (PL-200) Practice Tests
Validates ability to configure Microsoft Dataverse, create apps using Power Apps, manage logic and process automation, and manage environments for business solutions.
Exam Details
Practice Questions
1,120
≈ 22 practice exams
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. The full bank has 1,120 questions, enough for 22 full-length practice exams.
Preview — answers shown1. You create a business rule for a Canvas app with one screen to implement logic on an entity. What scope should you use?
AScreen1
BGlobal
CEntity
DAll Forms
Explanation
Entity scope applies the rule across the entity, suitable for app-wide logic. Screen1 is specific to one screen, All Forms covers form views but not all apps, and Global applies universally but may be too broad.
2. Adatum is importing customer data from an Excel file into a Dataverse table. You need to map the source columns to the destination columns. Which feature allows you to select and map specific columns during import?
ABusiness rules
BData export wizard
CColumn mapping in import tool
DTable relationships
Explanation
The import tool in Dataverse provides column mapping to associate Excel columns with table fields, ensuring accurate data placement. Data export wizard handles exporting, table relationships link tables, and business rules enforce data logic but do not map imports.
3. Woodgrove Bank has a user with Dataverse access needing to create Canvas apps. They must grant minimal permissions. Which security role should they assign?
ACommon Data Service User
BSystem Customizer
CEnvironment Admin
DEnvironment Maker
Explanation
Environment Maker allows creating apps without excess permissions. Environment Admin grants full control. System Customizer focuses on schema changes. Common Data Service User provides data access only.
4. You work as a Power Platform Developer for Litware. The company uses Dataverse entities to store inventory data. You need to create a field in the Product entity that allows users to select from predefined options such as 'In Stock', 'Out of Stock', and 'Discontinued'. The field must enforce that only these values can be entered. Which field type should you configure?
ALookup
BYes/No
CText Area
DChoice
Explanation
Choice field type enables predefined options with validation to restrict input to only the specified values, ensuring data integrity for inventory status. Yes/No is binary, Lookup references other entities, and Text Area allows free-form text without restrictions.
5. You are a developer for Fabrikam, a retail company. The company uses Power Automate to automate invoice processing. You need to create a flow that triggers when an email with an attachment arrives, extracts data using AI Builder, and saves it to Dataverse. Which trigger and action should you use?
AManual trigger with text classification
BSharePoint trigger with object detection
CEmail trigger with form processing AI action
DDataverse trigger with prediction model
Explanation
Power Automate email triggers can detect attachments, and form processing AI Builder extracts data for saving to Dataverse. Other triggers and AI models are not suited for email-based document processing.
More Microsoft Practice Exams
Microsoft Certified: Power Automate RPA Developer Associate (PL-500)
PL-500 · 380 questions
Microsoft Certified: Power BI Data Analyst Associate (PL-300)
PL-300 · 956 questions
Microsoft Certified: Power Platform Developer Associate (PL-400)
PL-400 · 675 questions
Microsoft Certified: Power Platform Fundamentals (PL-900)
PL-900 · 223 questions
Microsoft Certified: Power Platform Solution Architect Expert (PL-600)
PL-600 · 1080 questions
Microsoft Certified: Security, Compliance, and Identity Fundamentals (SC-900)
SC-900 · 230 questions
$17.99
One-time access to this exam
1,120 questions (22 practice exams' worth)
Unlimited timed exam simulations
Yours forever — no subscription
Detailed explanations
Free preview stays available