PL-200 sample exam questions

15 exam-style questions for Microsoft PL-200: Power Platform Functional Consultant, with answers and explanations. Take them as a timed practice exam first if you want a score out of 1000.

Take the free practice exam PL-200 exam guide
  1. Question 1Drag and dropTopic 1
    DRAG DROP

    A company has a model-driven app that uses Microsoft Dataverse.

    Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number.

    You need to enable the required features.

    Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

    Move each item to the matching row:

    • Table
    • View
    • Column
    • Relationship
    • Add alternate phone number.
    • List of customers without alternate phone number.
    Show answer
    • Add alternate phone number. Column
    • List of customers without alternate phone number. View
    Why

    Add a new phone number column to the account table and place it on the form so users can enter it, then create a view filtered on that column Does not contain data to list customers without an alternate number. No new table or relationship is needed.

  2. Question 2Single choiceTopic 1
    A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.

    You need to identify the capabilities of virtual tables.

    What is a capability of virtual tables?
    1. A
      Virtual tables can be configured for user and team ownership.
    2. B
      Virtual tables support Dataverse auditing.
    3. C
      Virtual tables contain columns for Status, Created On, and Modified On by default.
    4. D
      Virtual tables require configuration of a data provider.
    Show answer

    Correct answer: D

    Why

    Every virtual table depends on a data provider (such as the OData v4, SQL or SharePoint virtual connector provider) that maps and retrieves the external data. Virtual tables are organization-owned only, do not support auditing, and do not get standard columns like Status or Modified On by default.

  3. Question 3Drag and drop: orderTopic 2
    DRAG DROP

    A company creates a canvas app.

    The company plans to make the app available in Microsoft Teams. Only employees will be allowed to use the app.

    You need to add the app to Teams.

    Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

    Arrange 3 of these in the correct order:

    • Upload the Power Apps app to the Teams channel Files tab.
    • Share the app to the Teams channel email address.
    • Sign in to the Microsoft Power Platform Admin Center.
    • Select and download the Power Apps app.
    • Sign into the Maker portal for Microsoft Power Platform.
    • Select the required Power Apps app.
    • Add the app to Teams.
    Show answer
    1. Sign into the Maker portal for Microsoft Power Platform.
    2. Select the required Power Apps app.
    3. Add the app to Teams.
    Why

    Canvas apps are embedded from the Power Apps maker portal: open Apps, select the app, then use Add to Teams. The admin center does not publish apps, and the current portal adds the app directly without any need to download a package.

  4. Question 4Single choiceTopic 2
    You create a Power Apps app.

    The app must be able to display a list of records that are sorted by category. The app must also expand or hide the list by subtopics.

    You need to configure the app.

    Which tool should you use?
    1. A
      card
    2. B
      expression
    3. C
      gallery
    4. D
      Power BI dashboard
    Show answer

    Correct answer: C

    Why

    A gallery control lists records sorted by a column such as category, and nested galleries or a toggle on a parent gallery let users expand or hide subtopics. A card is a single field in a form, an expression is not a control, and a Power BI dashboard is not used for this list interaction.

  5. Question 5Single choiceTopic 3
    You add a business process flow to the Account table. The flow has three stages.
    You need to ensure that a workflow can run when a user completes the final stage.
    Which option should you use?
    1. A
      Start when: Record status changes
    2. B
      Available to run: Run this workflow in the background
    3. C
      Available to run: As an on-demand process
    4. D
      Available to run: As a child process
    Show answer

    Correct answer: C

    Why

    A classic workflow can be added to a business process flow stage (via a Workflow step) only if it is activated and configured as an on-demand process for the same table, so it can run when the final stage is completed. Background, child process or status-change triggers do not make it available to the stage.

  6. Question 6Drag and dropTopic 3
    DRAG DROP

    A company uses a model-driven app for customer support.

    The company has the following requirements for the app:

    • Send an email in real-time to customers when they enter their email address.
    • Send an email to customers at the same time every day for cases that are open for more than 24 hours.

    The solution should require the least amount of customization.

    You need to configure the model-driven app.

    Which components should you use? To answer, drag the appropriate components to the requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

    NOTE: Each correct selection is worth one point.

    Move each item to the matching row:

    • Power Apps component framework (PCF) control
    • Classic workflow
    • Power Automate flow
    • JavaScript
    • Send email to customer when email address entered.
    • Send email at the same time every day.
    Show answer
    • Send email to customer when email address entered. Classic workflow
    • Send email at the same time every day. Power Automate flow
    Why

    A real-time classic workflow can send an email immediately as the row changes, without code. Classic workflows have no recurrence trigger, so a scheduled Power Automate flow handles the daily run. Microsoft now generally recommends moving classic background workflows to cloud flows.

  7. Question 7Single choiceTopic 4
    You are creating a Power Virtual Agents chatbot that uses multiple topics.
    Each user interaction can reference more than one topic.
    You need to be able to capture a value in an initial topic and use it in subsequent topics.
    Which type of variable should you create?
    1. A
      Context
    2. B
      Bot
    3. C
      Topic
    Show answer

    Correct answer: B

    Why

    A bot variable (global variable in Copilot Studio) is available to all topics in the conversation, so a value captured in an initial topic can be used in later topics. Topic variables are limited to the topic where they are created, and context is not a variable scope in Power Virtual Agents.

  8. Question 8Single choiceTopic 5
    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might
    meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    The sales team at a software company wants to attach a large number of supporting documents to customer records, but management does not want to incur the
    cost of additional storage.
    The company does not have any Office 365 application integrations enabled.
    You need to recommend a storage solution that keeps storage costs low.
    Solution: Enable Outlook integration.
    Does the solution meet the goal?
    1. A
      Yes
    2. B
      No
    Show answer

    Correct answer: B

    Why

    No. Outlook integration (Dynamics 365 App for Outlook) tracks emails and appointments; it does not provide document storage, so attachments would still consume Dataverse storage. Server-based SharePoint integration stores documents in SharePoint instead.

  9. Question 9HotspotTopic 5
    HOTSPOT

    You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query.

    The dataflow has the following requirements:

    • A table of aggregated data must be created in dataflow storage.
    • A unique identifier must be created for the table.

    You need to configure the dataflow.

    Which solutions should you use? To answer, select the appropriate options in the answer area.

    NOTE: Each correct selection is worth one point.

    Table of aggregated dataFact table / Merge query / Linked entity / Computed entity
    Unique identifierKey column / Pivot column / Alternate key
    Show answer
    • Table of aggregated data Computed entity
    • Unique identifier Alternate key
    Why

    A computed entity performs in-storage calculations such as aggregations and stores the result in dataflow storage. An alternate key uniquely identifies rows in the Dataverse table, so dataflow loads can match existing rows. Computed entities are now called computed tables.

  10. Question 10Single choiceTopic 6
    A company records data in Microsoft SharePoint Online. The company is creating a mobile app by using Microsoft Power Platform only.

    The company requires the app to connect directly to SharePoint Online to collect data.

    You need to recommend which Microsoft Power Platform product or feature to implement.

    What should you recommend?
    1. A
      Power Automate
    2. B
      Power Pages
    3. C
      Canvas app
    4. D
      Model-driven app
    Show answer

    Correct answer: C

    Why

    Canvas apps use the SharePoint connector to read and write SharePoint Online list data directly and run on mobile devices through the Power Apps mobile app. Model-driven apps need Dataverse, Power Pages are websites, and Power Automate is for automation, not mobile data entry.

  11. Question 11Drag and dropTopic 6
    DRAG DROP

    A company has implemented server-side synchronization in Dataverse.

    Users have the following synchronization requirements:

    • As emails are moved to specific locations within an inbox, the emails must relate back to a specific record in Dataverse.
    • Information about key individuals must sync automatically to Outlook.
    • Tagged appointments in Outlook must sync automatically to Dataverse.

    You need to recommend a solution for each requirement.

    What should you recommend? To answer, move the appropriate features to the correct requirements. You may use each feature once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.

    NOTE: Each correct selection is worth one point.

    Move each item to the matching row:

    • Folder-level tracking
    • Outlook category tracking
    • Email synchronization
    • Appointments, contacts, and tasks synchronization
    • Synchronize moved items
    • Individuals appear in Outlook
    • Synchronize tagged appointments
    Show answer
    • Synchronize moved items Folder-level tracking
    • Individuals appear in Outlook Appointments, contacts, and tasks synchronization
    • Synchronize tagged appointments Outlook category tracking
    Why

    Folder-level tracking tracks emails moved to mapped Exchange folders and can set the regarding record. Contacts sync through appointments, contacts, and tasks synchronization. Outlook category tracking syncs items, including appointments, that users tag with the Tracked to Dynamics 365 category.

  12. Question 12Single choiceTopic 8
    You need to design the resort portal's email registration process.
    Which solution should you use?
    1. A
      Default the invitation code from the email upon logging into the portal
    2. B
      Auto-populate the invitation code field on the sign in screen from the email link
    3. C
      Embed the invitation code in the email link URL
    4. D
      Send the customer their username and temporary password in the email link
    Show answer

    Correct answer: C

    Why

    Power Pages invitations work by sending an email containing a link with the invitation code embedded in the URL; when the customer opens it, the code is redeemed and they register and link to their existing contact. Sending credentials by email is insecure and the other options are not how invitation redemption works.

  13. Question 13Single choiceTopic 9
    You need to capture the Date Completed value from the website using a desktop flow.
    Which method should you use?
    1. A
      Use optical character recognition (OCR) on the screen to locate and extract the value.
    2. B
      Display an input dialog and prompt the user to enter the value.
    3. C
      Extract the value from the window the browser is using.
    4. D
      Retrieve the value from the HTML element in the webpage.
    Show answer

    Correct answer: D

    Why

    Because the website UI changes frequently, the most reliable method is web automation that retrieves the value from the HTML element on the page (Get details of element on web page) using a UI element selector. OCR and window extraction depend on screen layout, and prompting users defeats automation.

  14. Question 14Multiple responseTopic 10
    You need to design the chat solution to answer the inquiry from Guest1.
    Which three components can you use? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point.
    1. A
      Variables
    2. B
      Escalations
    3. C
      Smart match
    4. D
      Synonyms
    5. E
      Topics
    Show answer

    Correct answer: A, B, E

    Why

    Community answer, with heavily split votes and no case details available here. A chatbot can answer an inquiry by matching a topic, capturing and reusing details in variables, or escalating to a live agent when it cannot answer. Smart match and synonyms only improve trigger recognition rather than answering by themselves.

  15. Question 15Multiple responseTopic 13
    You need to add the missing components to the Verification Process Automation solution.
    Which two components should you add? Each correct answer presents a complete solution.
    NOTE: Each correct selection is worth one point.
    1. A
      Service Request statuscode field
    2. B
      Dataverse connection reference
    3. C
      Qualification statuscode field
    4. D
      On-premises data gateway reference
    5. E
      Outlook connection reference
    Show answer

    Correct answer: C, E

    Why

    The flows in the verification process update the Qualification status and send email, so the solution must include the Qualification statuscode field customization and the Outlook connection reference that the flow depends on; these missing dependencies caused the import failure. On-premises gateway references are not needed for cloud services.