Free PL-200 Sample Questions — Microsoft Power Platform Functional Consultant

Free PL-200 sample questions for the Microsoft Power Platform Functional Consultant exam. No account required: study at your own pace.

Want an interactive quiz? Take the full PL-200 practice test

Looking for more? Click here to get the full PDF with 127+ practice questions for $10 for offline study and deeper preparation.

Question 1

A company sells all types of bicycles, bicycle parts, and accessories. You are creating a chatbot by using Microsoft Power Virtual Agent for the bicycle shop. When someone types in a bicycle brand name or terms such as helmet or shoes, the chatbot must automatically go to the accessories section of the chatbot. You need to configure the chatbot functions. Which two functions should you configure? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

  • A. Entities
  • B. Fallback topic
  • C. Smart matching
  • D. Synonyms
  • E. Slot filling
Show Answer
Correct Answer:
  • A. Entities
  • D. Synonyms
Question 2

You are designing a Power Virtual Agents chatbot. The environment you plan to use does not appear as an option in the Power Virtual Agents user interface. You need to ensure that you can create the chatbot in the environment. What should you do?

  • A. Change the region for the environment
  • B. Convert the environment to a sandbox environment
  • C. Create an environment in a supported region
Show Answer
Correct Answer:
C. Create an environment in a supported region
Question 3

A user has access to an existing Common Data Service database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?

  • A. Environment Admin
  • B. System Customizer
  • C. Common Data Service User
  • D. Environment Maker
Show Answer
Correct Answer:
D. Environment Maker
Question 4

Your organization does not permit the use of custom code for solutions. You need to create a view that can be viewed by all users in an organization. Where should you create the view?

  • A. Advanced Find
  • B. Studio System Settings
  • C. Templates area
  • D. Maker portal
Show Answer
Correct Answer:
D. Maker portal
Question 5

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?

  • A. card
  • B. expression
  • C. gallery
  • D. Power BI dashboard
Show Answer
Correct Answer:
C. gallery
Question 6

A company is implementing Power Apps and Power Automate. Several components are created within Power Apps, Microsoft Dataverse, and Power Automate. These components must be promoted from the development environment to the user acceptance test environment in a single solution package. You need to create the solution package for promotion. Where should you create the package?

  • A. Azure portal
  • B. Microsoft Power Platform admin center
  • C. Office 365 admin center
  • D. Power Apps maker portal
Show Answer
Correct Answer:
D. Power Apps maker portal
Question 7

You are using the Data import wizard to import records into the account table from a CSV file. The CSV-to-table mapping is as follows: ✑ The Name column represents the account name and maps to the Account Name column. ✑ The Parent Name column represents the holding company of the account with subsidiaries underneath. Records that are imported into the table are only related to other records in the file. You need to configure the import to create the relationship between records. What should you do?

  • A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria
  • B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria
  • C. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file
  • D. Look up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column
Show Answer
Correct Answer:
A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria
Question 8

A company has locations in the United States, Brazil, India, and Japan. The company conducts financial transactions in all of these regions. Financial transactions in Brazil are going to stop, but the office will remain open. Users must no longer be able to create records associated with the Brazilian currency. Historical records must remain intact. You need to configure Microsoft Dataverse to meet the requirement What should you do?

  • A. Disable the Brazilian language pack
  • B. Rename the Brazilian currency
  • C. Delete the Brazilian currency record
  • D. Deactivate the Brazilian currency record
Show Answer
Correct Answer:
D. Deactivate the Brazilian currency record
Question 9

You are creating a business rule to implement new business logic. You must apply the business logic to a canvas app that has a single screen named Screen1. You need to configure the scope for the business rule. Which scope should you use?

  • A. Screen1
  • B. Entity
  • C. All Forms
  • D. Global
Show Answer
Correct Answer:
B. Entity
Question 10

Your organization does not permit the use of custom code for solutions. You need to create a view that can be viewed by all users in an organization. Where should you create the view?

  • A. System Settings
  • B. Advanced Find
  • C. Table component of a solution
  • D. Microsoft Excel template
Show Answer
Correct Answer:
C. Table component of a solution
Question 11

You are creating a cloud flow for an automation targeting Dataverse. When a new account is created in Dataverse, the name of the account must be updated based on the following logic: • If the Account Category Code equals Preferred Customer (1), pre append the value Preferred | to the name. • If the Account Category Code equals Standard (2) or is not populated, pre-append Standard | to the name. You need to define the correct formula to use for the automation. Which formula should you use?

  • A. if(equals(triggerOutputs()?['body/accountcategorycode'), 1), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
  • B. if(equals(triggerOutputs()?['body/accountcategorycode'), 2), concat('Standard ', |triggerOutputs()?[‘body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
  • C. if(equals(outputs('trigger')?['body/accountcategorycode'], 1), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ', outputs('trigger')?['body/name']))
  • D. if(equalsfoutputs('trigger')body/accountcategorycode'], 2), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ',outputs('trigger')?['body/name']))
Show Answer
Correct Answer:
A. if(equals(triggerOutputs()?['body/accountcategorycode'), 1), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
Question 12

You need to implement the requirement for the VP of sales. What should you do?

  • A. Use a test account with a base security role with QV security added
  • B. Add the System Administrator security role to your user account
  • C. Use a test account with only QV security added
  • D. Add QV security to your user account
Show Answer
Correct Answer:
A. Use a test account with a base security role with QV security added
Question 13

You need to assign 10 percent of the Qualification records to the QV queue through table configuration by using a Power Automate flow. What should you do?

  • A. Create an autonumber column on the Qualification table and assign its qualification records if the number cleanly divides by 10
  • B. Create a calculated column on the Service Request table that sums the number of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field
  • C. Create a roll-up column on the Service Request table that is the count of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field
  • D. Create an autonumber column on the Service Request table and assign its qualification records if the number cleanly divides by 10
Show Answer
Correct Answer:
A. Create an autonumber column on the Qualification table and assign its qualification records if the number cleanly divides by 10
Question 14

A company creates a Power Automate cloud flow for a Power Apps app. The cloud flow must send a daily email that contains a list of year-to-date (YTD) totals. You need to configure the flow. Which feature should you use?

  • A. Loop
  • B. Wait
  • C. Condition
  • D. Parallel branch
Show Answer
Correct Answer:
A. Loop
Question 15

A company uses Microsoft Teams. You plan to create a Power Apps app for Microsoft Teams. You need to determine the environment that will used by the app. Which environment will the app use?

  • A. An existing Dataverse environment that you select
  • B. An existing Dataverse for Teams environment that you select
  • C. Dataverse environment that is automatically created for the team
  • D. Dataverse for Teams environment that is automatically created for the team
Show Answer
Correct Answer:
D. Dataverse for Teams environment that is automatically created for the team
Question 16

A company is implementing advanced features for a Power Pages website. The company hosts documents and lists in several SharePoint environments that are hosted both on-premises and online. Users of the Power Pages site must be able to view, search for, and filter this data from a single, intuitive experience. You need to determine which advanced feature to implement. What should you implement?

  • A. Faceted search
  • B. Content delivery network
  • C. Power BI embedded
  • D. Progressive search
Show Answer
Correct Answer:
A. Faceted search
Question 17

A company plans to create an app by using Power Apps. The company has the following requirements: • The app must be able to enter data into Microsoft SharePoint. • Users must be able to add the app into Microsoft Teams. You need to recommend which app to create. Which type of app should you recommend?

  • A. model-driven app as a personal app
  • B. model-driven app as a tab app
  • C. canvas app as a personal app
  • D. Canvas app as a tab app
Show Answer
Correct Answer:
D. Canvas app as a tab app
Question 18

You plan to add a Power Apps app to Microsoft Teams. A Microsoft Dataverse for Teams environment has not been provisioned. You need to create a Dataverse for Teams environment. Which two actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  • A. Create a new app in Teams
  • B. Install an existing app in Teams
  • C. Create a new environment in the Microsoft Power Platform Admin Center
  • D. Create an app permission policy in the Teams admin center
Show Answer
Correct Answer:
  • A. Create a new app in Teams
  • B. Install an existing app in Teams
Question 19

You plan to create a Power Virtual Agents bot. The bot must support single sign-on. You need to publish the bot. Which two locations should you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  • A. Mobile app developed for iOS and Android
  • B. Website developed using pro developer tools
  • C. Microsoft Teams
  • D. Azure Bot Service channels
Show Answer
Correct Answer:
  • B. Website developed using pro developer tools
  • C. Microsoft Teams
Question 20

A user has access to an existing Microsoft Dataverse database. You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required. Which out-of-the-box security role should you assign to the user?

  • A. Environment Admin
  • B. Basic User
  • C. Environment Maker
  • D. System Customizer
Show Answer
Correct Answer:
C. Environment Maker

Aced these? Get the Full Exam

Download the complete PL-200 study bundle with 127+ questions in a single printable PDF.