PL-200: Power Platform Functional Consultant Practice Exam

What the PL-200 exam covers

• Configure Microsoft Dataverse161 questions
• Create Apps with Power Apps147 questions
• Automate with Power Automate147 questions
• Implement Power Virtual Agents / Copilot Studio129 questions
• Analyze Data with Power BI117 questions

Free PL-200 sample questions

A sample of 10 questions with answers and explanations. Sign up free to practice all 701.

1. Question 1Configure Microsoft Dataverse

   What is Microsoft Dataverse?

   • AA secure, scalable data platform (tables/relationships/business logic) underpinning Power Platform appsCorrect
   • BA self-service analytics service for building interactive reports and rich dashboards over all business data
   • CA cloud workflow automation engine that runs triggers and actions to connect apps and services
   • DA low-code tool for authoring conversational chatbots that answer questions and trigger actions
   ✓ Correct answer: A

   Microsoft Dataverse is the foundational data storage and management service for all Power Platform applications. It provides enterprise-grade security, scalability, and built-in business logic capabilities that enable organizations to build sophisticated applications without extensive infrastructure management. Dataverse handles data relationships, enforces security at the table and record level, and supports complex business rules that run across all applications.

   Why the other options are wrong

   • BDescribes Power BI, the analytics service, not the Dataverse data platform.
   • CDescribes Power Automate, the workflow automation service, not the underlying data store.
   • DDescribes Copilot Studio for building chatbots, not the Dataverse data platform.
2. Question 2Configure Microsoft Dataverse

   To reduce Dataverse Database capacity consumed by large attachments, where should you store file/attachment column data?

   • AIn a Text column as base64
   • BIn File capacity using File or attachment columnsCorrect
   • CIn Log capacity
   • DIn a Choice column
   ✓ Correct answer: B

   Dataverse's File capacity is specifically designed and optimized for storing document and media attachments, separate from the main Database capacity used for structured record data. Using File and attachment columns for large documents reduces pressure on Database capacity and aligns with Dataverse's storage architecture. This separation provides better performance and cost efficiency.

   Why the other options are wrong

   • AIn a Text column as base64 is incorrect because storing large files as base64-encoded text consumes Database capacity and performs poorly.
   • CIn Log capacity is incorrect because Log capacity is reserved for system auditing and plugin traces, not document storage.
   • DIn a Choice column is incorrect because Choice columns are for categorization, not file attachment storage.
3. Question 3Create Apps with Power AppsSelect all that apply

   Field technicians use a canvas app on phones in areas with intermittent connectivity. Which TWO design choices best support reliable use? (Choose TWO)

   • ARequire a constant live connection for every screen
   • BLoad the entire data source into memory at app launch
   • CUse offline-capable patterns such as local collections and SaveData/LoadData (or mobile offline) with later syncCorrect
   • DMinimize on-start data loads and only fetch what each screen needsCorrect
   ✓ Correct answer: C, D

   These two approaches work together for intermittent connectivity. Local collections or SaveData/LoadData allow the app to cache data locally and continue functioning when the connection is lost, then sync changes back when connectivity is restored. Minimizing on-start loads and using lazy-load patterns (fetching data per-screen) reduce the volume of data needed at any moment and also reduce the initial network dependency. Together, they enable reliable offline-first operation on intermittent networks.

   Why the other options are wrong

   • ARequire a constant live connection for every screen is incorrect because intermittent connectivity means that requiring a live connection will cause frequent failures and poor user experience.
   • BLoad the entire data source into memory at app launch is incorrect because loading all data upfront requires a full connectivity window at startup and consumes excessive memory, neither of which is realistic on intermittent networks.
4. Question 4Automate with Power AutomateSelect all that apply

   Which TWO techniques help you capture and centralize error details from failing cloud flows? (Choose TWO)

   • AReduce the DNS TTL of the connector
   • BSend failure details to Application Insights or a logging table via an actionCorrect
   • CWrap actions in a scope and use a parallel 'on failure' scope to log errorsCorrect
   • DAdd a DHCP reservation for the gateway
   ✓ Correct answer: B, C

   These two approaches directly address error capture and centralization. Sending failure details to Application Insights or a logging table enables external monitoring and aggregation of errors across flows. Wrapping actions in scopes with parallel 'on failure' branches allows immediate capture of error details within the flow logic, which can then be logged or sent to external systems. Both strategies ensure that detailed diagnostic information is preserved and available for troubleshooting.

   Why the other options are wrong

   • AReduce the DNS TTL of the connector is incorrect because DNS configuration has no relationship to error handling or logging in Power Automate flows.
   • DAdd a DHCP reservation for the gateway is incorrect because DHCP IP address assignment is unrelated to capturing flow failure details and has no impact on error logging or centralization.
5. Question 5Implement Power Virtual Agents / Copilot Studio

   A bot topic collects a date using an entity, but users entering 'next Friday' get an error. What is the best remedy?

   • AUse the prebuilt date/time entity which interprets natural-language dates, rather than a strict text matchCorrect
   • BUse a closed-list custom entity that must contain every single one of the allowed dates as a fixed listed value
   • CUse a regular expression entity that only matches one single exact rigid date format pattern
   • DAdd many more varied trigger phrases onto the date-collecting topic itself instead
   ✓ Correct answer: A

   When a bot topic uses an entity to collect dates but users entering natural language like 'next Friday' receive errors, the issue is that the entity is configured for strict text matching rather than natural language interpretation. Copilot Studio provides a prebuilt Date/Time entity that leverages NLU to understand relative date phrases ('next Friday,' 'tomorrow,' 'three days from now') and convert them to standardized date values. Using this entity instead of a basic text or custom entity allows the bot to gracefully handle natural language date input, improving user experience and reducing input errors.

   Why the other options are wrong

   • BA closed list of literal dates cannot interpret relative phrases like 'next Friday'.
   • CA regex only matches a fixed pattern and cannot resolve natural-language relative dates.
   • DTrigger phrases start a topic; they do not parse or interpret a date the user types.
6. Question 6Create Apps with Power AppsSelect all that apply

   A consultant is reviewing the custom pages configuration at Fabrikam Inc. Which two actions should be performed to optimize the implementation? (Choose two.)

   • ADisable custom pages monitoring
   • BCanvas app performanceCorrect
   • COffline capabilityCorrect
   • DGalleries and forms
   • Edelegation
   ✓ Correct answer: B, C

   Optimizing custom pages requires implementing offline capability so that users can continue working with custom pages even when disconnected from the network.

   Why the other options are wrong

   • ADisable custom pages monitoring is incorrect because monitoring provides visibility into how custom pages are performing and should be enabled, not disabled.
   • Dgalleries and forms is incorrect because while galleries and forms might be used within custom pages, optimizing the gallery and form controls is not the primary optimization focus at the custom pages level.
   • Edelegation is incorrect because delegation is more relevant to data source optimization in canvas apps rather than a primary optimization consideration for custom pages implementations.
7. Question 7Automate with Power Automate

   Custom connectors for flows is a supported feature when implementing solutions for organizations like Adatum Corporation.

   • TrueTrueCorrect
   • FalseFalse
   ✓ Correct answer: True

   Custom connectors for flows is a supported feature in Power Automate when implementing solutions for organizations like Adatum Corporation. Custom connectors enable organizations to integrate with proprietary, legacy, or specialized systems that lack out-of-the-box Power Automate connectors. This extensibility allows enterprises to build comprehensive automation solutions that can interact with any business application, regardless of whether a standard connector exists, making Power Automate a truly universal integration platform. Therefore, the statement is True.

   Why the other options are wrong

   • FalseFalse is incorrect. The statement is true. Custom connectors for flows is a supported feature in Power Automate when implementing solutions for organizations like Adatum Corporation. Custom connectors enable organizations to integrate with proprietary, legacy, or specialized systems that lack out-of-the-box Power Automate connectors.
8. Question 8Analyze Data with Power BISelect all that apply

   A consultant is reviewing the workspace management configuration at Northwind Traders. Which two actions should be performed to optimize the implementation? (Choose two.)

   • Adashboards
   • BDisable workspace management monitoring
   • CApp distributionCorrect
   • DrelationshipsCorrect
   • EData modeling
   ✓ Correct answer: C, D

   Optimizing workspace management here spans both content governance and data-model integrity, which maps to app distribution and relationships. App distribution packages and delivers workspace content to defined audiences with controlled access, supporting governance at the consumption layer. Relationships define the logical joins between tables so the models behind that content return accurate, multi-table results. Configuring both maintains governed distribution alongside a sound data model.

   Why the other options are wrong

   • ADashboards consume data but are not a workspace-management optimization action in this scenario.
   • BDisabling workspace management monitoring removes the visibility needed to optimize a workspace, so it is counterproductive.
   • EData modeling is a broad concept rather than the specific app-distribution and relationships actions the scenario targets.
9. Question 9Configure Microsoft DataverseSelect all that apply

   Which TWO statements about Dataverse environment variables are correct? (Choose TWO)

   • AThey let configuration values like a URL or API key differ per environment without changing the solution componentsCorrect
   • BThey consist of a definition and an optional current value that can be set after importCorrect
   • CThey permanently store secrets only in plain text inside the solution
   • DThey can only be used by canvas apps and not by cloud flows
   ✓ Correct answer: A, B

   Environment variables let components reference configuration (like endpoint URLs) symbolically so the actual value can change per environment without editing the components. Each variable has a definition (schema, type, optional default) and a current value that can be supplied during or after import, keeping ALM clean. They can be referenced by flows, apps, and other solution components.

   Why the other options are wrong

   • CSecret values can be backed by Azure Key Vault references rather than stored as plain text in the solution; this statement is false.
   • DEnvironment variables are usable by cloud flows, canvas apps, and other components, not canvas apps alone.
10. Question 10Automate with Power Automate

    A flow's 'Apply to each' processes orders. If any single order fails validation you want only the actions that follow the validation inside the loop to be skipped for that iteration, while logging continues afterward. Which feature on the action lets a later action run only after the validation action fails?

    • AConfigure run after on the later action to include 'has failed'Correct
    • BSet the validation action's retry policy to None
    • CWrap the loop in a Do until control
    • DEnable trigger conditions on the flow trigger
    ✓ Correct answer: A

    The 'Configure run after' setting controls which preceding-action statuses (is successful, has failed, is skipped, has timed out) allow an action to run. Including 'has failed' lets a logging or compensating action run specifically when the earlier action errors, enabling per-iteration error handling.

    Why the other options are wrong

    • BA retry policy only governs automatic retries of the same action; it does not control downstream branching on failure.
    • CDo until is a loop construct and does not define what runs after a failed action.
    • DTrigger conditions filter when the whole flow starts; they do not affect action-level run-after behavior inside a loop.

Related Microsoft resources

• PL-200 study guideKey concepts
• Microsoft practice examsAll Microsoft
• Certification pathWhere this fits
• Certification exam guides & tipsBlog
• Plans & pricingFree & paid
• SC-200 practice examRelated
• AZ-140 practice examRelated
• AZ-900 practice examRelated

PL-200 practice exam FAQ