15 PL-200 Questions Most Candidates Get Wrong
Here is a set of 8 multiple-choice questions designed to match the difficulty and style of the Microsoft PL-200 (Power Platform Functional Consultant) exam. These questions cover key domains including Dataverse, Power Apps, Power Automate, and AI Builder.
PL-200 Practice Questions For more on this topic, see our guide on 10 MB-920 Questions Most Candidates Get Wrong.
These questions test your practical knowledge of configuring and extending the Power Platform. Read each scenario carefully and select the best answer, just as you would in the real exam.
Q1. A company needs to enforce a business rule that requires a "Credit Limit" field to be greater than "Current Balance" for accounts. They want this enforced regardless of the app or interface used. What is the most efficient way to achieve this?
A. Create a Power Automate flow that triggers on record creation and update.
B. Configure a business rule on the table.
C. Add a validation formula to the "Credit Limit" column.
D. Build a custom JavaScript library and attach it to the main form.
Answer: B
Explanation: Business rules provide a declarative way to enforce logic at the database level, ensuring the rule is applied across all client applications (model-driven, canvas, etc.). Power Automate is overkill for simple validation, and column validation formulas are limited to single-column checks. JavaScript only runs on the form.
Q2. You are building a model-driven app for a sales team. They need to quickly see which of their opportunities are closing this month. You need to provide a personalized view without creating a new shared view. What should you do?
A. Create a system view and assign it to the sales team.
B. Instruct the users to create their own personal views using the "Advanced Find" or view editor.
C. Create a chart and add it to the dashboard.
D. Use a Power BI report embedded in the app.
Answer: B
Explanation: Personal views are user-specific and can be created by each user to filter records according to their individual needs. System views are shared by the organization, while charts and dashboards are for visualization, not just a filtered list of records.
Q3. A Power Automate flow needs to retrieve the manager for an employee who submitted a leave request. The employee record is stored in Dataverse. What is the most efficient connector action to use to find the manager?
A. Use the "List rows" action and filter on the employee name.
B. Use the "Get a row by ID" action with the employee's GUID.
C. Use the "Get manager" action from the Microsoft Dataverse connector.
D. Use the "Send an HTTP request to Dataverse" action with a custom query.
Answer: C
Explanation: The Dataverse connector has a specific "Get manager" action designed for this purpose, which is the most efficient and straightforward. Listing rows and filtering is inefficient, and using raw HTTP is unnecessary when a standard action exists.
Q4. You are creating an AI Builder model to categorize support tickets into "Billing", "Technical", or "General" based on the subject and description text. Which type of AI Builder model should you use?
A. Form Processing
B. Object Detection
C. Text Recognition
D. Category Classification
Answer: D
Explanation: Category Classification is the AI Builder model type designed to classify text into predefined categories. Form Processing extracts key-value pairs from documents, Object Detection identifies objects in images, and Text Recognition extracts text from images.
Q5. You need to create a canvas app for field technicians to report issues. The app must work offline and capture photos. The data must sync to Dataverse when the device reconnects. What is the most important feature to configure?
A. Use a model-driven app instead, as canvas apps cannot work offline.
B. Set the data source to "Dataverse" and enable the "Offline" mode in the app settings.
C. Store photos in a SharePoint library and use a custom connector.
D. Create a Power Automate flow to trigger on device connection.
Answer: B
Explanation: Canvas apps can work offline by leveraging the Dataverse offline sync capability. This requires setting up the app and the device for offline mode, which caches data locally and syncs changes later. SharePoint and custom connectors do not natively support the same seamless offline sync as Dataverse.
Q6. A business unit needs to restrict access to a specific table called "Salary Information" so that only HR members can see it. What is the most appropriate security method to implement?
A. Create a new security role with read privileges to the table and assign it only to HR users.
B. Set the table's "Read" privilege to "None" for the default security role.
C. Use column-level security to hide the sensitive columns.
D. Create a new business unit for HR and move the table into it.
Answer: A
Explanation: Security roles are the primary method for controlling access to tables. By creating a role with specific privileges and assigning it only to HR, you ensure that other users (with different roles) cannot see the table. Changing the default role affects everyone, and column security is for hiding specific columns, not entire tables.
Q7. You are configuring a Power Apps portal for external users to submit support requests. When a request is submitted, you need to automatically create a case in Dataverse and notify the support team. What is the most efficient way to implement this?
A. Create a Power Automate flow triggered by the form submission.
B. Use a plugin to handle the creation and notification.
C. Configure a workflow rule in the portal.
D. Use a JavaScript function to call the Web API directly from the portal.
Answer: A
Explanation: Power Automate is the recommended low-code solution for automating business processes triggered by portal events. It can easily create a record and send notifications. Plugins require .NET code, and portals do not have "workflow rules" in the same way Dataverse does.
Q8. You have an existing environment with a solution that contains a custom table. You need to move this table to a new environment for testing. What is the correct process?
A. Export a backup of the database and restore it to the new environment.
B. Create a new table in the target environment and manually recreate the columns.
C. Add the table to a solution, export the solution, and import it into the target environment.
D. Use the "Copy Environment" feature to duplicate the entire environment.
Answer: C
Explanation: Solutions are the standard mechanism for packaging and transporting components like tables, forms, and flows between environments. Exporting a backup is for disaster recovery of the whole database, and Copy Environment creates an exact copy, which is not suitable for testing a single component in isolation.
This set covers a broad range of the functional consultant’s daily tasks, from data modeling and business logic to automation and security. Remember to focus on the why behind each answer, not just the what, as the real exam often presents scenarios that test your understanding of trade-offs between different Power Platform components.
Gauge your exam readiness with Microsoft Power Platform Functional Consultant (PL-200) mock test questions and pinpoint the topics that still need work.
Once you identify those topics, use free study plans and readiness checks to build a schedule that fits the time you have and revisit your weak areas.