Free Microsoft Power Platform Functional Consultant (PL-200) Sample Questions

Correct answer: B — Activity table

• A. A standard table is a general-purpose customizable table like Account or Contact; it does not automatically provide the time-based subject/start/stop/duration columns this interaction needs.
• B. An activity table is designed specifically for time-bound interactions with subject, start time, stop time, due date, and duration, and can be flagged to display in activity menus.
• C. A virtual table sources its row data dynamically from an external system at runtime, which does not fit a native interaction record created and owned inside Dataverse.
• D. An elastic table is intended for very large datasets backed by Azure Cosmos DB and is not the mechanism for modeling a time-bound interaction record.

Correct answer: A — Cascade All

• A. Cascade All is correct because the Merge action only supports Cascade All or Cascade None, and Cascade All is required for tables where merging referenced rows is supported.
• B. Cascade Active is not a valid option for the Merge action, which is limited to only Cascade All or Cascade None as configurable choices.
• C. Cascade User Owned is not a valid option for the Merge action; only Cascade All and Cascade None can be selected for merging.
• D. Restrict is a Delete-action option and is not part of the limited Cascade All / Cascade None choice set available for the Merge action.

Correct answers: A, B, C — A formula column cannot trigger a classic Dataverse workflow or a plug-in.; A formula expression is limited to a maximum length of 1,000 characters.; A formula column supports a maximum chain depth of 10 when referencing other formula or rollup columns.

• A. Formula columns are documented as unable to trigger classic workflows or plug-ins, so this statement is accurate.
• B. The maximum formula expression length documented for formula columns is 1,000 characters, so this statement is accurate.
• C. The maximum chain depth documented for formula columns referencing other formula or rollup columns is 10, so this statement is accurate.
• D. This statement is inaccurate because direct use of a related table's currency column is unsupported; the Decimal function must be used instead.
• E. This statement is inaccurate because duplicate detection rules are documented as not being triggered on formula columns.
• F. This statement is inaccurate because formula columns do not display values while a mobile app is in offline mode.

Correct answers: A, B, C — Mapping source file columns to Dataverse table columns using a configured data map; Choosing whether the first row of the source file contains column headers or data; Enabling duplicate detection so incoming records are checked against existing rules

• A. Correct. The wizard uses an import map to define how source file columns correspond to table columns, including any transformation mappings.
• B. Correct. The IsFirstRowHeader setting lets the person configure whether the first row is treated as column headings or as data.
• C. Correct. EnableDuplicateDetection can be turned on for the import file so incoming records are checked against the organization's duplicate detection rules during the import.
• D. The Import Data Wizard imports data into existing columns; it does not let the person alter table schema or create new columns as part of reading the file.
• E. Managed solution layers are modified through solution import/export and customization processes, not through the data import wizard's record-level import.

Correct answer: A — columns

• A. Correct. Table-level auditing must be paired with column-level auditing enabled on each specific column for that column's value changes to be logged.
• B. Security roles define privileges for users and teams; enabling them is unrelated to whether a table's column value changes are captured in audit logs.
• C. Business units define the organizational hierarchy for record ownership and security; they are not something enabled per-field to capture audit history.

Correct answers: A, B, E — BeginsWith; Like; Above

• A. Correct. BeginsWith is listed among the filter operators not supported by Dataverse search, so a Quick Find view filter using it will not be honored in search results.
• B. Correct. Like is one of the documented unsupported filter clauses for Dataverse search, along with related pattern-matching operators.
• C. Equals is a standard supported comparison operator and is not part of the documented list of clauses that Dataverse search ignores.
• D. Contains is a standard supported filter and text search operator, not one of the operators listed as unsupported for Dataverse search filter conditions.
• E. Correct. Above is listed among the unsupported filter clauses for Dataverse search, since it is a hierarchical operator not processed by the search index.

Correct answer: A — Position hierarchy, because it grants access across business units based on job position rather than reporting lines.

• Position hierarchy, because it grants access across business units based on job position rather than reporting lines.. Position hierarchy tags users with a position rather than relying on the direct-reporting Manager field, and it allows data access across business units, which fits a service organization that wants oversight regardless of formal reporting lines.
• Manager hierarchy, because it always grants access to every case record regardless of business unit.. This is incorrect because manager hierarchy defaults to requiring the manager to be in the same or parent business unit as the report, which restricts rather than guarantees cross-business-unit visibility.
• Position hierarchy, because it requires every position to belong to the same single business unit.. This is incorrect because position hierarchy is specifically designed to allow access across business unit boundaries, not to confine every position to one business unit.
• Manager hierarchy, because the Manager field automatically spans multiple business units by default.. This is incorrect because by default the ManagersMustBeInSameOrParentBusinessUnitAsReports setting restricts manager hierarchy to the same or parent business unit rather than spanning units automatically.

Correct answer: A — Owners

• Owners. Selecting Owners includes only the Member user type drawn from the Microsoft Entra group's Owners category, which precisely matches wanting only the users formally listed as owners of the group.
• Members and guests. This is incorrect because Members and guests pulls from the Microsoft Entra group's Members category, including both member and guest user types, not the Owners category the administrator wants.
• Members. This is incorrect because Members only includes the Member user type from the group's Members category, which is a different population than the group's formally listed Owners.
• Guests. This is incorrect because Guests includes only Guest user types from the group's Members category, which does not correspond to owners of the Entra group at all.

Correct answer: A — Parent: Child Business Unit

• Parent: Child Business Unit. This access level grants visibility into records owned within the user's own business unit and every subordinate business unit, which matches the director's need without going fully organization-wide.
• User. This is incorrect because User-level access only covers records the director personally owns, has shared with them, or has through team membership, far narrower than the multi-business-unit visibility required.
• Organization. This is incorrect because Organization access grants visibility across the entire environment regardless of business unit hierarchy, which is broader than the director's stated requirement to stay within their branch.

Correct answer: A — Power BI visualization embedding for the environment

• A. Enabling Power BI visualization embedding for the environment is the documented prerequisite that must be turned on before a Power BI report or dashboard can be added as a system dashboard in a model-driven app.
• B. Server-side synchronization configures email and mailbox processing and has no relationship to embedding Power BI visuals in an app.
• C. Column-level security controls field-level access on Dataverse tables through field security profiles; it is unrelated to enabling Power BI report embedding.
• D. Duplicate detection rules identify near-duplicate Dataverse records during data entry or import and have nothing to do with Power BI workspaces or embedding.

Correct answers: A, B, C — Item; AllItems; Unsaved

• A. Item returns the single record selected from the data source and is one of the documented properties exposed through the Selected object in commanding.
• B. AllItems returns a table of every record currently selected in the grid and is a documented Selected property used for multi-row commands.
• C. Unsaved returns true when the selected record has unsaved changes, giving a command formula a way to react to pending edits.
• D. ScreenSize is listed among the areas not available in model-driven commanding, so it is not part of the Selected object exposed to command formulas.
• E. Acceleration is a device sensor concept from canvas apps and is explicitly called out as unsupported in commanding, so it has no equivalent on the Selected object.
• F. Location is another unsupported area in commanding formulas and is not exposed through the Selected object.

Correct answers: A, B, D — Users interacting with the embedded Power BI content need a Power BI license and access to the underlying workspace and report.; A Power BI report can be added to an app page as a report tile, while a Power BI report or dashboard can be added as a system dashboard.; An administrator must enable Power BI visualization embedding for the environment before a maker can add a Power BI system dashboard.

• A. Users still need a Power BI license and the relevant workspace and report permissions in Power BI service to interact with embedded content; the app embed does not bypass Power BI's own access model.
• B. A Power BI report can be surfaced as a tile on a model-driven app page, and separately a Power BI report or dashboard can be added as a full system dashboard, which are two distinct embedding options.
• C. Embedding does not remove Power BI's own permission requirements; users without workspace or report access still cannot view the embedded content.
• D. An administrator must first enable Power BI visualization embedding for the environment in the Power Platform admin center before a maker can add a Power BI dashboard to an app.
• E. A Power BI report used for embedding is not restricted to a Dataverse-only dataset; reports built on other data sources can also be embedded as tiles or system dashboards.

Correct answer: A — context

• A. A value created with UpdateContext and scoped to a single screen is exactly this type of variable, and it matches the requirement that the value not be readable from any other screen.
• B. A value that any screen in the app can reference does not fit here, since the requirement is that the value stay confined to one screen, and this type is created with Set rather than UpdateContext.
• C. A table-shaped store that any screen can reference does not match a single scoped value, and it is created with Collect or ClearCollect rather than UpdateContext.

Correct answer: A — IfError(Total/Count, 0)

• A. This function tests the division for an error and, if one occurs, evaluates and returns the paired replacement value instead, which is exactly the fallback behavior needed here.
• B. This function only returns a Boolean true or false about whether an error occurred and does not accept a replacement value to substitute in its place.
• C. This function creates or rethrows a custom error record rather than testing a value and returning a numeric fallback, so it does not fit this use case.
• D. This function displays a banner message to the user and does not test values for errors or return a numeric substitute, so it would not produce the label value described.

Correct answers: A, C, D — A property formula, such as one on the Text property, recalculates automatically whenever a value it depends on changes.; Functions such as Navigate, Collect, and Patch can only be used inside a behavior formula, never a property formula.; Multiple actions inside one behavior formula can be sequenced in order by separating each action with a semicolon.

• A. A property formula like the one behind Text does recalculate on its own whenever any control or data value it references changes, mirroring how a spreadsheet cell recalculates.
• B. Navigate is restricted to behavior formulas and cannot be placed on a property like Text; attempting to do so produces an error rather than running automatically.
• C. These functions are restricted to behavior formulas, meaning they can only be used on action-triggered properties and not on properties that recalculate automatically.
• D. Separating multiple actions with a semicolon inside one behavior formula is exactly how a maker sequences several steps, such as updating a variable and then writing to a data source.
• E. Patch is a behavior-only function like Navigate and Collect, so it cannot be used inside a property formula the same way it is used inside a behavior formula.
• F. Behavior formulas only run in response to a specific user action, such as a button press, rather than recalculating automatically whenever any control on the screen changes.

Correct answers: A, B, C — Lists; Liquid templates; Web API requests

• A. Lists render Dataverse records on a page and are governed by table permissions, which determine which records a visitor can see.
• B. Liquid code that queries Dataverse data is also subject to table permissions, since Liquid is one of the documented access paths that this control protects.
• C. Requests made through the site's Web API are likewise governed by table permissions, controlling which records a signed-in visitor can read or write.
• D. Site visibility controls whether the entire site is reachable internally or publicly and is a separate setting from table permissions.
• E. HTTPS header configuration relates to cross-origin resource sharing behavior for the site and is unrelated to record-level table permissions.
• F. Security scan results report on threats like cross-site scripting and insecure libraries, which is a different security capability from table permissions.

Correct answers: A, B — Delete; Reopen Case Action

• A. The Delete action lets a customer remove their own case record from the form, which directly satisfies the requirement to delete open cases.
• B. This case-specific action reopens a resolved or canceled case, matching the requirement to let customers reopen their own closed cases.
• C. The Workflow action triggers a classic Dataverse workflow, which is not what is needed to delete or reopen a case and was not requested.
• D. Create Related Record adds a new record tied to the current one, which does not delete an open case or reopen a closed one.
• E. Deactivate changes a record's active state generically and is not the case-specific reopen action the scenario calls for.

Correct answer: A — A classic Dataverse workflow configured to run in real time

• A. Real-time classic workflows execute synchronously inside the platform transaction, so they can inspect the data and block the save before it commits.
• B. A cloud flow's Dataverse trigger fires asynchronously after the save already happened, so it cannot prevent the save from completing.
• C. A recurrence-based check only looks at the table periodically, so it cannot enforce a rule at the exact moment a record is being saved.
• D. A desktop flow runs outside the Dataverse transaction entirely and can only examine the record after it has already been written.

Correct answer: A — Add the email action after the create step and set its Run After condition to trigger only on "has failed"

• A. Configuring the email action's Run After setting to "has failed" makes it execute only when the preceding create step does not succeed, matching the requirement exactly.
• B. The default "is successful" setting sends the email only when the create step succeeds, which is the opposite of what is required.
• C. Checking the returned row ID inside a condition adds unnecessary complexity and does not natively hook into the create step's actual success or failure status.
• D. A Delay action only pauses the flow for a fixed time and has no relationship to whether the create step failed.

Correct answers: A, B, C — has failed; is skipped; has timed out

• A. This status covers the case where the update step executed but returned an error, so it must be included.
• B. This status covers the case where the update step never ran because an earlier action failed, so it must be included to catch that outcome too.
• C. This status covers the case where the update step exceeded its allotted time, so it must be included as another non-success outcome.
• D. This status represents the update step completing normally, which is the opposite of the non-success condition the cleanup action should react to.
• E. There is no "is disabled" Run After status available on an action, so this option does not exist in the designer.
• F. There is no "is paused" Run After status available on an action, so this option does not exist in the designer.

Correct answer: A — The table for the first stage cannot be changed; the maker must recreate the process with the correct table selected at creation time.

• A. This is correct: the table can be changed for any stage except the first one, so correcting the first stage's table requires recreating the process with the right table chosen up front.
• B. The first stage is the specific exception to the rule that stage tables can be changed, so treating it the same as other stages is inaccurate.
• C. Whether security roles have been enabled has no bearing on whether the first stage's table can be edited; the restriction applies regardless of security configuration.
• D. Deactivating and reactivating the process does not lift the restriction on changing the first stage's table, since that limitation is tied to the stage's position, not its activation state.

Correct answer: A — It controls which of several business process flows configured for a table is automatically assigned to a new record that doesn't already have one.

• A. This is correct: when a table has more than one business process flow, Order Process Flow sets the priority order, and the first process a user has access to is applied to a new record without an existing process.
• B. Stage sequencing within a single process is handled by arranging stages in the designer, not by the Order Process Flow command, which instead ranks entire process definitions against each other.
• C. Security role evaluation order is unrelated to Order Process Flow, which only ranks which business process flow definition applies to a record by default.
• D. Workflow component triggering is configured per component in the designer, not through the Order Process Flow command, which addresses which whole process is assigned to a record.

Correct answer: A — activate

• A. This is correct: activating the process is the step that makes a saved, error-free draft available for others to use, and activation is blocked while errors remain.
• B. Archiving refers to a completed or abandoned process instance's status, not the action that first makes a draft definition usable by others.
• C. Cloning would create a copy of the process definition, but it does not make the original draft available for use, and it isn't the step described here.

Correct answer: A — Configure a real-time workflow

• A. A real-time workflow runs synchronously during the save operation, so its results are visible immediately and a Stop Workflow step set to Canceled can block the save if validation fails.
• B. A background workflow runs asynchronously whenever server resources are available, so the person saving the record cannot see the outcome right away and the save itself cannot be blocked.
• C. A scheduled cloud flow runs on a timer rather than in response to a specific save, so it cannot give the user immediate feedback tied to that particular record change.
• D. A business rule can show a message or lock a field, but it cannot start a child workflow, send templated email, or stop the operation with a custom status message the way a workflow step can.

Correct answer: A — The user who made the change to the record

• A. Running as the user who made the change evaluates the workflow's update using that person's own security privileges, matching a requirement that the action reflect whoever triggered the save.
• B. Running as the configured owner of the workflow evaluates the update using that fixed account's privileges regardless of which employee actually made the change.
• C. Running as a default system administrator account bypasses normal record-level security entirely rather than evaluating the privileges of the triggering employee.
• D. Running as the primary owner of the affected row uses that row's existing owner, which may be unrelated to the employee who just triggered the save.

Correct answer: A — It becomes invalid and cannot be activated until the wait condition is removed

• A. Converting a background workflow that still contains a Wait Condition step into a real-time workflow leaves the definition invalid, because real-time workflows cannot use wait conditions, and it can't be activated until the step is removed.
• B. The conversion does not automatically rewrite a Wait Condition into a Check Condition; the maker must manually remove the incompatible step before the workflow becomes valid.
• C. Real-time workflows execute synchronously and have no mechanism to pause execution for a fixed interval, so a wait condition cannot simply continue running for one minute.
• D. The Convert to a real-time workflow action does complete; it is the resulting workflow that becomes invalid until the wait condition is removed, not a blocked conversion.

Correct answer: A — Formula columns don't display computed values when the model-driven app is in mobile offline mode.

• A. Correct. Formula columns are documented as not displaying values when the app is running in mobile offline mode, regardless of the formula's content.
• B. Incorrect. Refreshing the connection does not resolve this; the offline mode limitation applies to formula columns generally, not to a stale cache that a refresh would fix.
• C. Incorrect. Choice columns are one of several supported data types for formula columns, so referencing one is not what causes the offline blank display.
• D. Incorrect. The offline limitation applies to formula columns as a whole, not selectively to certain data types like text versus numeric results.

Correct answer: A — By default, the logic runs post-operation, after the row has already been created in Dataverse.

• A. Correct. By default an automated plug-in's logic runs after the triggering event occurs as a post-operation step, so for a Created event it executes after the row is already created in Dataverse.
• B. Incorrect. Pre-operation execution is not the default; it is a stage a maker must deliberately configure if the logic needs to run before the row is committed.
• C. Incorrect. The default post-operation execution happens synchronously as part of the triggering event, not as an asynchronous job minutes later.
• D. Incorrect. Automated plug-ins fire automatically in response to the configured table event; manual invocation with a command-bar trigger describes a function, not an automated plug-in.

Correct answer: A — Change the plug-in's execution stage to pre-operation instead of the default post-operation.

• A. Correct. Since automated plug-ins run post-operation by default, the maker must explicitly switch the stage to pre-operation to run the Power Fx logic before the row is committed.
• B. Incorrect. Switching the event to Updated changes which action triggers the plug-in, but it does not change whether the logic runs before or after the operation completes.
• C. Incorrect. The table reference identifies which table's data the plug-in reads or writes; it has no effect on the pre-operation versus post-operation timing of execution.
• D. Incorrect. A function is manually invoked rather than bound to a table event, so converting to a function would remove the automatic trigger entirely instead of adjusting its timing.

Correct answers: C, D, F — Components inside a managed solution can't be edited directly without first adding them to an unmanaged solution.; A managed solution should be generated by exporting an unmanaged solution and treated as a build artifact.; Deleting a managed solution removes all the customizations and extensions it included.

• A. A managed solution can't be exported at all; only an unmanaged solution can be exported, either as unmanaged or as managed.
• B. There's no automatic inheritance of a prefix from the environment's default solution; the prefix comes from the publisher chosen when the solution was created.
• C. This is correct: components within a managed solution can't be edited directly, and must first be added to an unmanaged solution to be changed.
• D. This is correct: the recommended ALM practice is to export an unmanaged solution as managed and treat that managed export as the deployable build artifact.
• E. A managed solution cannot be imported into the same environment that already contains the unmanaged solution it originated from; a separate environment is required to test it.
• F. This is correct: deleting, or uninstalling, a managed solution removes all the customizations and extensions that were included in it.

Correct answers: A, C, E — It performs static analysis against unmanaged solutions that have been exported from an environment.; It evaluates Power Automate flows within a solution through the flow checker component.; It evaluates Power Fx expressions used in canvas apps through the app checker component.

• A. This is correct: solution checker works with unmanaged solutions that can be exported from an environment, running a static analysis against their components.
• B. Solution checker's static analysis doesn't know the destination environment's configuration, so passing the check doesn't guarantee a successful import.
• C. This is correct: solution checker evaluates Power Automate flows within a solution by using the flow checker component under the hood.
• D. Solution checker analyzes solutions that publishers create, not just Microsoft-published ones, though Microsoft-managed solutions themselves aren't eligible for the check.
• E. This is correct: solution checker evaluates Power Fx expressions in canvas apps through the app checker component as part of its analysis.
• F. Solution checker can also be run using a PowerShell module, so it isn't limited to the Power Apps portal or admin center.

Correct answers: A, C, E — A patch layers only new or changed components on top of a parent managed solution without deleting anything.; An upgrade merges all patches into a new solution version and removes components no longer included.; An update deploys changes into the parent managed solution but can't delete existing components.

• A. This is correct: a patch only layers new or edited components on top of the parent managed solution and can't delete anything from it.
• B. Creating a solution produces an unmanaged solution first; exporting as managed is a separate, later choice, not an automatic outcome of creation.
• C. This is correct: an upgrade rolls all applied patches into a new version and removes components that are no longer part of the upgraded solution.
• D. Patches don't automatically trigger upgrades based on component count; an upgrade is a deliberate import action chosen separately.
• E. This is correct: an update deploys changes into the parent managed solution but, like a patch, cannot delete existing components.
• F. An upgrade is applied by importing the new solution version directly; it doesn't require uninstalling and reinstalling the parent solution.

Correct answer: A — Because SharePoint stores the document on the SharePoint server, a user with the right SharePoint permissions can open it directly there

• A. Because server-based SharePoint integration stores documents on the SharePoint server, users who are not running the app can access those documents directly, provided they have the appropriate SharePoint permissions.
• B. This is the opposite of how document locations work: files are stored on SharePoint, not exclusively inside Dataverse, which is precisely what enables outside-the-app access.
• C. SharePoint document access is governed by SharePoint permissions on the site collection or library, not by holding a Dataverse security role.
• D. Document locations connect records to SharePoint folders; they do not automatically replicate every file into OneDrive for Business for tenant-wide browsing.

Correct answer: A — Whether users outside the app need direct file access and collaboration features like co-authoring and versioning

• A. SharePoint integration is chosen specifically to enable external, permission-based file access and collaboration features such as versioning and co-authoring that native Dataverse attachments do not provide.
• B. Table type (standard vs. activity) affects what a table is designed to represent, not which document management approach is architecturally appropriate for file storage.
• C. Environment type governs lifecycle purpose such as development versus production use, not the choice between native attachments and SharePoint document management.
• D. Both document management approaches can be surfaced from model-driven apps; the app type alone does not determine which document storage approach best fits the collaboration requirement.

Correct answers: A, B — The organization uses Exchange Server 2007, which server-side synchronization does not support; The scenario requires extending EWS, POP3, or SMTP protocols to build a custom email provider

• A. Correct: Exchange Server 2003 and Exchange Server 2007 are explicitly listed as unsupported for server-side synchronization, which is a documented reason to fall back to the Email Router.
• B. Correct: extensibility scenarios such as extending EWS/POP3/SMTP protocols or creating custom email providers are listed as unsupported by server-side synchronization.
• C. Incorrect: processing speed is not a documented differentiator between the Email Router and server-side synchronization in Microsoft's supported-scenario guidance.
• D. Incorrect: S/MIME encrypted messages are not viewable through server-side sync, but this is a limitation to be aware of, not a case where the Email Router restores that capability.
• E. Incorrect: same-tenant Exchange Online is precisely the scenario where server-side synchronization is the supported, recommended method, not a reason to use the Email Router.