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 work for Litware, an insurance company. The company has a Power Apps model-driven app for policy management. You need to customize the app to include a custom form for adding new policies, pulling data from Dataverse tables. What should you do in the Power Apps studio?
AUse the model-driven app designer to add a new form
BCreate a portal page for form input
CEdit the app in canvas mode to add forms
DBuild a separate canvas app for forms
Explanation
Model-driven apps are customized in the app designer by adding forms based on Dataverse tables. Canvas mode is for canvas apps, portals are web-focused, and separate apps complicate integration.
2. You work as a Systems Administrator for Contoso. The company has a Microsoft Dataverse environment for managing orders and order details. You need to create a one-to-many relationship between the Orders table and the OrderDetails table, allowing each order to have multiple details. After configuring the relationship, what additional step is necessary to ensure the relationship functions properly in apps and flows?
APublish the customizations in the Dataverse environment.
BCreate a new user account with edit permissions.
CExport the table data to Excel for validation.
DRun a diagnostic tool to check for errors.
Explanation
Publishing the customizations applies the changes to the Dataverse environment, making the relationship active in Power Apps, Power Automate, and other services. Exporting data doesn't activate configurations, diagnostic tools aren't required for standard setups, and user accounts are managed separately from table relationships.
3. Contoso wants to create a team in Dataverse that owns records and can have security roles assigned directly to it. Which team type should they use?
AMicrosoft Entra ID Office Group
BAccess Team
CMicrosoft Entra ID Security Group
DOwner Team
Explanation
Owner Team allows record ownership and direct security role assignment. Access Team does not own records or assign roles, while the other options are managed externally.
4. Adatum is building a Power Automate flow to process customer feedback forms submitted via email. They need to handle potential failures by sending notification emails, but avoid email flooding during high-volume periods. What should they configure for error handling in the flow? (Select two!)
Multiple correct answersAAdd error handling actions to send emails on failure.
BUse loops to retry failed actions automatically.
CConfigure switches for multiple error scenarios.
DApply variables to store error details for later review.
ESet organization scope on triggers to limit access.
FEnable dynamic data embedding for error messages.
Explanation
Adding error handling actions to send emails on failure provides notifications, while using loops to retry failed actions prevents immediate failures without overwhelming users. Configuring switches handles multiple scenarios but doesn't address flooding, variables store details but don't manage retries, organization scope controls trigger access not errors, and dynamic data embedding is for passing outputs not error management.
5. Contoso is developing a Power Apps canvas app to manage employee data stored in Dataverse. They need to create the app quickly using existing data. Which method should they use to start building the app?
AStart with a page design and manually add controls.
BCreate a blank canvas app and connect to data sources.
CUse start with data to select an existing Dataverse table.
DImport an app template and modify it for their needs.
Explanation
Starting with data allows selecting an existing Dataverse table to quickly generate an app with basic CRUD operations. Starting with a page design requires manual addition of controls without initial data integration, creating a blank app leaves all setup to the developer, and app templates may not align with specific data needs.
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