MICROSOFT CERTIFICATION
PL-200 Power Platform Functional Consultant Associate Practice Exam
Exam Number: 3154 | Last updated 16-Apr-26 | 811+ questions across 4 vendor-aligned objectives
The PL-200 Power Platform Functional Consultant Associate certification validates the skills of functional consultants who implement Power Platform solutions including Power Apps, Power Automate, and Copilot Studio. This exam measures your ability to work with Power Apps, Power Automate, Microsoft Copilot Studio, Dataverse, Power Pages, AI Builder, demonstrating both conceptual understanding and practical implementation skills required in today’s enterprise environments.
The heaviest exam domains include Create and Manage Process Automation (25–30%), Configure Microsoft Dataverse (20–25%), and Create Apps by Using Power Apps (20–25%). These areas collectively represent the majority of exam content and require focused preparation across their respective subtopics.
Additional domains tested include Describe the Microsoft Power Platform Ecosystem (10–15%), and Create and Manage Chatbots and AI (10–15%). Together, these areas round out the full exam blueprint and ensure candidates possess well-rounded expertise across the certification scope.
Every answer links to the source. Each explanation below includes a hyperlink to the exact Microsoft documentation page the question was derived from. PowerKram is the only practice platform with source-verified explanations. Learn about our methodology →
729
practice exam users
93.8%
satisfied users
91.1%
passed the exam
4.5/5
quality rating
Test your PL-200 Power Platform Functional Consultant knowledge
10 of 811+ questions
Question #1 - Configure Microsoft Dataverse
A client needs a Dataverse table to track customer complaints. Each complaint has a lifecycle: New → Under Review → Escalated → Resolved → Closed. The system should enforce valid transitions.
Which Dataverse feature models this lifecycle?
A) A lookup to a separate Status table
B) A Choice column (option set) for status combined with a Business Process Flow enforcing stage transitions
C) A boolean field for open/closed
D) A text field where users type the status
Show solution
Correct answers: B – Explanation:
Choice columns define valid statuses, and Business Process Flows guide users through stages with required fields at each gate. Text fields allow arbitrary values. Boolean provides only two states. A lookup table adds complexity without enforcing transitions. Source: Check Source
Question #2 - Configure Microsoft Dataverse
A client tracks customer complaints with lifecycle: New → Under Review → Escalated → Resolved → Closed. Transitions must be enforced.
Which Dataverse feature models this lifecycle?
A) A Choice column for status combined with a Business Process Flow enforcing stage transitions
B) A boolean field providing only two states which cannot represent the five-stage lifecycle
C) A plain text field where users type the current status value manually without validation
D) A lookup to a separate Status table adding complexity without enforcing transition sequence
Show solution
Correct answers: A – Explanation:
Choice columns define valid status values, and Business Process Flows guide users through stages with required fields at each gate preventing invalid transitions. Text fields allow arbitrary values without validation against the defined lifecycle states. Boolean fields support only true/false states which cannot represent a five-stage progression. Lookup tables reference external records but do not inherently enforce sequential stage transition rules between values. Source: Check Source
Question #3 - Configure Microsoft Dataverse
Four business units (Sales, Marketing, Engineering, Support) should each see only their own records by default.
Which Dataverse security concept implements this record-level segregation?
A) Field-level security controlling column visibility without restricting which records are accessible
B) Manual record sharing performed individually for each record which does not scale for operations
C) Business Unit ownership with User/Team-owned tables and BU-scoped security roles for isolation
D) Table-level read permission for all users which grants access to every record in the table
Show solution
Correct answers: C – Explanation:
User/Team-owned tables with BU-scoped security roles restrict record visibility to the owning business unit by default, providing automatic data segregation between departments. Table-level read grants universal access to all records regardless of business unit ownership. Field-level security controls which columns users can see without restricting row-level record access by ownership. Manual sharing requires individual configuration per record and does not scale for operational data volumes. Source: Check Source
Question #4 - Create Apps by Using Power Apps
A helpdesk app where technicians see ticket queues, update details, and search knowledge base — all with consistent navigation.
Which Power Apps type should be built?
A) A Canvas App with custom navigation requiring manual construction of every screen and flow
B) A Power Pages external portal designed for external users rather than internal technician teams
C) A SharePoint list with custom views lacking the rich application experience needed for helpdesk
D) A Model-Driven App with a site map defining areas for Tickets, Knowledge Base, and Dashboard
Show solution
Correct answers: D – Explanation:
Model-driven apps provide a site map with defined areas, automatic forms and views from Dataverse metadata, and consistent navigation ideal for structured internal helpdesk operations. Canvas apps require building all navigation, screens, and data connections manually from scratch. Power Pages create external-facing portals for customers and partners rather than internal technician workspace. SharePoint lists provide basic views and forms without the rich application navigation and dashboard experience. Source: Check Source
Question #5 - Create Apps by Using Power Apps
Field sales need a mobile app capturing visit notes, photos, and GPS location at customer sites, working offline.
Which Power Apps approach supports offline mobile data capture?
A) A Canvas App with offline data using LoadData/SaveData functions and camera/location controls
B) A Power BI mobile report providing read-only analytics visualization without data capture input
C) A Power Pages form requiring internet connectivity for submission without any offline capability
D) A model-driven app with online-only access requiring continuous internet connectivity at all times
Show solution
Correct answers: A – Explanation:
Canvas Apps support offline patterns using LoadData/SaveData for local data persistence, plus built-in camera and location controls for field data capture. Model-driven apps have limited offline support and are primarily designed for connected online scenarios. Power BI mobile provides read-only analytics visualization dashboards without data capture or input form capabilities. Power Pages forms require active internet connectivity for submission and do not support offline data collection workflows. Source: Check Source
Question #6 - Create and Manage Process Automation
Purchase requests need approval: requester submits → manager approves → over $10K finance director approves → PO generated.
Which Power Automate flow type should be used?
A) A desktop flow automating desktop UI interactions which is not designed for approval workflows
B) An automated Cloud Flow triggered by Dataverse row creation with Approval actions and conditions
C) A scheduled daily flow running batch approval processing which introduces unacceptable delay
D) A manual instant flow requiring human initiation for each individual purchase request submission
Show solution
Correct answers: B – Explanation:
An automated Cloud Flow triggers immediately on record creation, uses the Approvals connector for structured multi-level approval actions, and conditions branch based on amount thresholds. Scheduled flows process requests in daily batches introducing significant delay between submission and approval. Desktop flows automate Windows UI interactions and are not designed for cloud-based multi-step approval workflow orchestration. Manual flows require someone to initiate each approval process individually rather than triggering automatically on submission. Source: Check Source
Question #7 - Create and Manage Process Automation
A BPF for Sales requires a signed proposal document uploaded before advancing from Proposal to Negotiation stage.
Which BPF configuration enforces this requirement?
A) Add a text note reminding the user which is informational guidance without any enforcement
B) Configure a required step at the Proposal stage with a data field mapped to the signed document
C) Lock the entire record preventing all modifications rather than gating specific stage transitions
D) Use a separate post-advancement flow that checks after the user has already moved to the next stage
Show solution
Correct answers: B – Explanation:
Required steps in BPF stages prevent advancement until the mapped field is completed — the user cannot move to Negotiation without uploading the signed proposal document. Text notes provide informational guidance that users can read and ignore without any system enforcement. Post-advancement checks execute too late since the user has already passed the stage gate before validation occurs. Record locking prevents all modifications to every field rather than gating a specific stage transition requirement. Source: Check Source
Question #8 - Create and Manage Process Automation
Month-end journal entries need automatic posting at midnight on the last day of each month using Dataverse data.
Which Power Automate flow type should be configured?
A) A Scheduled Cloud Flow set to recur monthly with Dataverse actions processing journal entries
B) A Business Process Flow guiding interactive user data entry rather than executing batch operations
C) A desktop flow automating desktop application screens which is not designed for data processing
D) An instant manual flow requiring someone to remember to initiate the process each month end
Show solution
Correct answers: A – Explanation:
Scheduled Cloud Flows execute at configured intervals on configured dates without human intervention, processing Dataverse data for automated month-end journal posting. Manual flows require a person to remember and initiate the process at midnight on the last day of each month. Desktop flows automate Windows application UI interactions rather than processing cloud data in batch operations. Business Process Flows guide users through interactive multi-stage data entry rather than executing unattended batch processing. Source: Check Source
Question #9 - Describe the Microsoft Power Platform Ecosystem
A business leader asks how Power Platform components work together to solve complete business problems.
Which description correctly represents the Power Platform ecosystem?
A) Power Platform requires professional developers for every task without any low-code capability
B) Power Platform replaces Azure entirely including all infrastructure and developer services
C) Power Platform consists only of Power BI with no application building or workflow automation
D) Power Apps builds apps, Power Automate creates workflows, Power BI provides analytics — all on Dataverse
Show solution
Correct answers: D – Explanation:
The Power Platform ecosystem combines Power Apps for application building, Power Automate for workflow automation, Power BI for analytics, Power Pages for external sites, and Copilot Studio for chatbots, all connected through the shared Dataverse data layer. The platform includes much more than Power BI alone, covering application development and workflow automation. It complements Azure rather than replacing all infrastructure and developer services. Low-code design is a core principle enabling non-developer business users to build solutions alongside professional developers. Source: Check Source
Question #10 - Create and Manage Chatbots and AI
A customer support team wants a website chatbot answering common questions, escalating complex issues to live agents in Teams.
Which Power Platform tool builds this chatbot?
A) Power BI providing data visualization dashboards without conversational chatbot building capability
B) Microsoft Copilot Studio with topic-based conversation design, knowledge base, and agent handoff
C) Power Automate handling workflow automation without chatbot conversation design or NLU capability
D) Power Apps building applications and forms without natural language conversational AI features
Show solution
Correct answers: B – Explanation:
Copilot Studio provides a low-code chatbot builder with topic-based conversation design, knowledge base integration for FAQ answers, and native agent handoff to Teams for complex issues. Power BI creates analytics dashboards and reports without conversational AI or chatbot building tools. Power Apps builds interactive applications and forms but does not include natural language understanding or chatbot conversation design. Power Automate handles workflow automation steps but does not provide the conversation design, NLU, or chatbot deployment features needed. Source: Check Source
Get 811+ more questions with source-linked explanations
Every answer traces to the exact Microsoft documentation page — so you learn from the source, not just memorize answers.
Exam mode & learn mode · Score by objective · Updated 16-Apr-26
Learn more...
What the PL-200 Power Platform Functional Consultant exam measures
- Configure Microsoft Dataverse (20–25%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Create Apps by Using Power Apps (20–25%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Create and Manage Process Automation (25–30%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Describe the Microsoft Power Platform Ecosystem (10–15%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
- Create and Manage Chatbots and AI (10–15%) — Evaluate your ability to implement and manage tasks within this domain, including real-world job skills and scenario-based problem solving.
How to prepare for this exam
- Review the official exam guide to understand every objective and domain weight before you begin studying
- Complete the relevant Microsoft Learn learning path to build a structured foundation across all exam topics
- Get hands-on practice in an Azure free-tier sandbox or trial environment to reinforce what you have studied with real configurations
- Apply your knowledge through real-world project experience — whether at work, in volunteer roles, or contributing to open-source initiatives
- Master one objective at a time, starting with the highest-weighted domain to maximize your score potential early
- Use PowerKram learn mode to study by individual objective and review detailed explanations for every question
- Switch to PowerKram exam mode to simulate the real test experience with randomized questions and timed conditions
Career paths and salary outlook
Earning this certification can open doors to several in-demand roles:
- Power Platform Functional Consultant: $85,000–$120,000 per year (based on Glassdoor and ZipRecruiter data)
- CRM Implementation Consultant: $90,000–$130,000 per year (based on Glassdoor and ZipRecruiter data)
- Business Applications Analyst: $80,000–$115,000 per year (based on Glassdoor and ZipRecruiter data)
Official resources
Microsoft provides comprehensive free training to prepare for the PL-200 Power Platform Functional Consultant Associate exam. Start with the official Microsoft Learn learning path for structured, self-paced modules covering every exam domain. Review the exam study guide for the complete skills outline and recent updates.