I85PREP
⌘ K
PL-200 study materials
PL-200 study resources

PL-200 practice questions

One question at a time. Build your PL-200 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Configure Microsoft Dataverse

Which Dataverse table type is designed to store business activities such as phone calls, tasks, and appointments that can be associated with customer records?

  1. Standard table
  2. Activity table Correct answer.
  3. Elastic table
  4. Virtual table

Explanation

Activity tables derive from the Activity base table, so they automatically include the Regarding lookup and party fields that let a record be associated with customers and appear in timelines. Standard tables do not get those behaviors.

Question 2Configure Microsoft Dataverse

Every standard Dataverse table includes a primary name column. What is its main purpose?

  1. It records why the record's status changed.
  2. It controls which business unit owns the record.
  3. It stores the unique GUID that identifies each record.
  4. It holds the text used to identify a record in lookups, views, and search results. Correct answer.

Explanation

The primary name column supplies the human-readable label for a record wherever the record is referenced, including lookup fields, views, and search. Every table must have exactly one primary name column, and it must be a text column.

Question 3Configure Microsoft Dataverse

You need a fixed list of values that is maintained in one place and reused as a column on several different tables, without creating a new table. What should you create?

  1. A global choice column Correct answer.
  2. A lookup column pointing to a new Department table
  3. A local choice column added separately to each table
  4. A two-option column added to each table

Explanation

A global choice defines the option set once at the environment level, and the same definition can then be used by multiple columns across multiple tables. Local choices are defined per column, so each copy would drift apart over time.

Question 4Configure Microsoft Dataverse

What does a solution publisher's prefix control?

  1. The default currency used by new tables
  2. The security roles granted to importers of the solution
  3. The version number assigned to the solution
  4. The prefix added to the schema names of custom components created in the solution Correct answer.

Explanation

The publisher's prefix is prepended to the schema name of every custom table and column created inside that publisher's unmanaged solution, which keeps customizations distinguishable from Microsoft components. The prefix is set when the publisher is created and cannot be changed later.

Question 5Configure Microsoft Dataverse

A managed solution has been installed in a production environment. Which statement describes its components there?

  1. They can be freely edited by any system administrator.
  2. They cannot be edited or deleted directly and are removed by uninstalling the solution. Correct answer.
  3. They are excluded from solution layering.
  4. They are stored only in the default solution.

Explanation

Managed solutions are locked in the target environment, so components can only be changed by importing an updated version or by uninstalling the solution. This protects the integrity of the deployed customization.

Question 6Configure Microsoft Dataverse

Which Dataverse component groups users, owns records, and forms a level in the security hierarchy used to partition data access?

  1. Team
  2. Security role
  3. Field security profile
  4. Business unit Correct answer.

Explanation

Business units form a hierarchy in which each business unit owns the records assigned to users within it, and security roles are assigned per business unit to scope access. Teams and roles are assigned within business units but do not define the hierarchy level.

Question 7Configure Microsoft Dataverse

A table named Project contains a lookup column that points to Account. Which relationship type does this represent?

  1. One-to-one
  2. Many-to-many
  3. One-to-many Correct answer.
  4. Self-referential

Explanation

A lookup placed on the Project table makes Project the many side and Account the one side, so one account can be related to many projects. Dataverse creates this one-to-many relationship automatically when you add a lookup column.

Question 8Configure Microsoft Dataverse

Which security role privilege grants the ability to associate a record with another record?

  1. Delete
  2. Read
  3. Create
  4. Append Correct answer.

Explanation

The Append privilege allows a user to attach a record to another record, while Append To allows other records to be attached to the record in question. Both are needed for users to build relationships between records they work with.

Question 9Configure Microsoft Dataverse

Which statement accurately describes a calculated column?

  1. It can be edited by users after the record is created.
  2. It aggregates values from related child records.
  3. It is computed when the record is saved and can use values from the same record and its parent record. Correct answer.
  4. It is recalculated by a background job at an interval you configure.

Explanation

Calculated columns are evaluated by the platform when a record is saved and can reference other columns on the same record as well as columns reached through a many-to-one lookup. The result is read-only and recalculates whenever a source column changes.

Question 10Configure Microsoft Dataverse

Which statement accurately describes a rollup column?

  1. It aggregates values from related records and is refreshed by a scheduled job or on demand. Correct answer.
  2. It recalculates instantly whenever any column on the record changes.
  3. It requires a plug-in to compute and store its values.
  4. It can only total currency columns from child records.

Explanation

Rollup columns aggregate data from related records using functions such as SUM, COUNT, MIN, and MAX, and the platform refreshes them with a scheduled system job or an on-demand refresh. They are asynchronous, so values can lag behind the source data.

Question 11Configure Microsoft Dataverse

A manager must be able to see a salary column only for records they already have access to, while other users must not see that column at all. Which feature should you configure?

  1. Field security profile Correct answer.
  2. Record sharing with the manager's team
  3. Hierarchy security model
  4. A column-level business rule

Explanation

Column security is implemented by marking the column as secured and then granting read or update access through field security profiles assigned to users or teams. Users without a profile that grants access see the column as empty even when they can open the record.

Question 12Configure Microsoft Dataverse

You create a business rule on the Account table that sets a column value when another column changes. Which scope should you choose so the rule also runs when records are updated outside a specific form, such as through the Web API?

  1. Form
  2. Canvas app
  3. Entity Correct answer.
  4. A single named form

Explanation

The Entity scope applies the business rule to all forms and to server-side operations, so updates made through integrations are also processed. Form scope limits execution to the client form where the rule is placed.

Question 13Configure Microsoft Dataverse

You must record the before-and-after values of two specific sensitive columns on the Contact table. What must you enable?

  1. Auditing only at the environment level
  2. Auditing on the table and on those specific columns Correct answer.
  3. Field security on those columns
  4. Change tracking on the table

Explanation

Audit history is captured only when auditing is enabled for the organization, the table, and the individual columns you want to track. Enabling at a higher level alone does not start column-level change logging.

Question 14Configure Microsoft Dataverse

Users should be warned when they create an account whose name already exists, but they must still be allowed to save the record. What should you configure?

  1. A form column mapping between tables
  2. A published duplicate detection rule Correct answer.
  3. A business rule that shows an error
  4. A calculated column that flags repeated names

Explanation

Duplicate detection rules compare new or updated records against existing data and, when a match is found, display a warning that the user may override. Publishing the rule and enabling duplicate detection for the table makes it active.

Question 15Configure Microsoft Dataverse

What is the main purpose of an alternate key on a Dataverse table?

  1. To create a filtered index used by system views
  2. To replace the primary key of the table
  3. To provide another unique identifier so external systems can reference records without using the GUID Correct answer.
  4. To encrypt the referenced column at rest

Explanation

An alternate key declares a column or combination of columns as unique, giving integrations a stable business identifier for upsert and lookup operations. The table still keeps its GUID primary key.

Question 16Configure Microsoft Dataverse

A solution uses a service endpoint whose URL differs between development, test, and production. What should you add to the solution so the value can be set per environment?

  1. An environment variable Correct answer.
  2. A connection reference
  3. A configuration table populated by a flow
  4. A global choice column

Explanation

Environment variables store configuration values in a solution and let each target environment supply its own value at import time or through a current value. This avoids hard-coding environment-specific settings into components.

Question 17Configure Microsoft Dataverse

Why should a cloud flow that is deployed through a solution use a connection reference instead of a connection embedded in the flow?

  1. Each environment can bind the flow to its own connection when the solution is imported. Correct answer.
  2. It encrypts the flow definition during export.
  3. It automatically creates a new connection for every user.
  4. It removes the requirement that the flow be stored in a solution.

Explanation

A connection reference is a solution component that holds a pointer to a connector, and at import time the person deploying the solution supplies the connection to use in that environment. This keeps credentials and environment-specific connections out of the exported solution.

Question 18Configure Microsoft Dataverse

Which team type grants a group of users permission to a single record without assigning them a security role?

  1. Access team Correct answer.
  2. Organization team
  3. Owner team
  4. Microsoft Entra security group team

Explanation

Access teams are created automatically per record when the table is enabled for access teams, and members receive only the access rights defined for that record. They do not carry security roles, which makes them suitable for ad hoc collaboration.

Question 19Configure Microsoft Dataverse

Which statement about organization-owned tables is correct?

  1. Records have no owner and access is granted only through security roles. Correct answer.
  2. Records are placed in the business unit of the creating user.
  3. Individual users can be assigned ownership of their records.
  4. Records can be shared with individual users and teams.

Explanation

Organization-owned tables, such as the User table, do not have an Owner column, so records cannot be assigned or shared individually. Access is controlled entirely by the privileges on the security roles assigned to users.

Question 20Configure Microsoft Dataverse

How does a system view differ from a personal view in Dataverse?

  1. Only system views can be displayed in a model-driven app.
  2. System views cannot include filters or sorting.
  3. System views are created by administrators and shared with users, while personal views belong to the user who created them. Correct answer.
  4. Personal views are shared with everyone, while system views are visible only to their creator.

Explanation

System views are solution components that administrators define and publish so that all users see the same filtered record lists. Personal views are saved by individual users and are visible only to them unless they choose to share one.

Question 21Configure Microsoft Dataverse

A one-to-many relationship is configured with parental cascade behavior. What happens to the related child records when a parent record is assigned to a different user?

  1. The child records keep their original owner.
  2. The child records become organization-owned.
  3. The child records are reassigned to the new owner as well. Correct answer.
  4. The child records are deleted with the parent.

Explanation

Parental cascade is the broadest behavior and cascades all actions, including assign, delete, reparent, share, and unshare, from the parent to the child. Reassigning the parent therefore reassigns the related children.

Question 22Configure Microsoft Dataverse

An application must store hundreds of millions of sensor readings that have differing attributes per reading and must be retrieved with low latency by partition key. Which Dataverse table type should you use?

  1. Standard table
  2. Activity table
  3. Elastic table Correct answer.
  4. Virtual table

Explanation

Elastic tables are built for very large volumes of data with a flexible schema, and they support partitioning and horizontal scale for low-latency key-based access. Standard tables are not designed for that scale of heterogeneous records.

Question 23Configure Microsoft Dataverse

What does a virtual table do in Dataverse?

  1. It merges two Dataverse tables into a single logical view.
  2. It exposes data from an external system as a table without storing that data in Dataverse. Correct answer.
  3. It copies external data into Dataverse on a scheduled basis.
  4. It maintains a read-only replica of a Dataverse table in an external database.

Explanation

A virtual table uses a virtual entity data provider, often backed by a connector, so queries are passed through to the external source at run time. Because nothing is persisted, capabilities such as offline use and some relationship behavior are limited.

Question 24Configure Microsoft Dataverse

Which limitation applies to formula columns that use Power Fx in Dataverse?

  1. They can return only whole-number results.
  2. They can use values from the current record but cannot reference columns from related tables. Correct answer.
  3. They can be edited by users after the record is saved.
  4. They can aggregate values from related child records.

Explanation

Formula columns evaluate Power Fx expressions against columns on the same record, and they cannot traverse relationships to pull in values from related tables. Aggregating child records is a capability of rollup columns instead.

Question 25Configure Microsoft Dataverse

A custom table has a Customer lookup column. Which statement about this column type is correct?

  1. It can reference any table enabled as a customer, and each record can point to a different table. Correct answer.
  2. It stores the target record as a plain GUID without table information.
  3. It can hold several customer references at the same time in one column.
  4. It can reference only the Account table.

Explanation

A Customer lookup is a polymorphic lookup that can target any table marked as a customer, such as Account or Contact, and the target table can differ from one record to the next. Dataverse stores both the record identifier and the target table name.

Question 26Configure Microsoft Dataverse

Which column does Dataverse use by default to identify a record in lookups, views, and search results?

  1. The created on column
  2. The owner column
  3. The primary key column
  4. The primary name column Correct answer.

Explanation

Every Dataverse table has exactly one primary name column, and its value is the text shown for a record in lookups, views, and search results. The primary key holds a GUID and is never used as the human-readable label.

Question 27Configure Microsoft Dataverse

A maker needs a column where a user can select more than one value from a single predefined list stored with the table. Which column type meets this requirement?

  1. Two options
  2. Single line of text
  3. Lookup
  4. Multi-select choice Correct answer.

Explanation

A choice column stores values from a predefined list, and the multi-select variant lets one record hold several of those values at once. The list is metadata stored with the environment rather than free-form text.

Question 28Configure Microsoft Dataverse

Which column type automatically generates a formatted value such as ACC-0001 for each new record?

  1. Autonumber Correct answer.
  2. Formula
  3. Rollup
  4. Whole number with a default value

Explanation

An autonumber column generates the next value in a defined format whenever a record is created. The format string controls the prefix, the digit count, and any optional date segment.

Question 29Configure Microsoft Dataverse

What is the advantage of a global choice over a local choice?

  1. It can be secured with field-level security
  2. It stores multiple values in one record
  3. It is stored as a separate related table
  4. It can be reused on multiple tables Correct answer.

Explanation

A global choice is defined once at the environment level, so choice columns on any table can point to the same list. A local choice is defined inside one table and cannot be shared.

Question 30Configure Microsoft Dataverse

A column is set to Business Required. What happens when a user tries to save a form while that column is empty?

  1. The save succeeds with the column blank
  2. Saving is blocked and an error is shown Correct answer.
  3. The record is saved as a draft
  4. The save succeeds and a warning is logged

Explanation

Business Required is enforced at save time, so an empty value stops the save and displays a message to the user. Recommended only adds a visual hint and never blocks saving.

Question 31Configure Microsoft Dataverse

When you create a native many-to-many relationship between two tables, what does Dataverse create?

  1. A system view that joins the tables
  2. A lookup column on each table
  3. A child table owned by the first table
  4. An intersect table that stores the links Correct answer.

Explanation

A native many-to-many relationship is implemented through a hidden intersect table that holds one row per link between the two tables. Neither of the related tables receives a lookup column.

Question 32Configure Microsoft Dataverse

You create a new table inside an unmanaged solution. Where does the prefix in the table's schema name come from?

  1. The publisher of the solution Correct answer.
  2. The display name of the table
  3. The name of the environment
  4. The security role of the maker

Explanation

The customization prefix is taken from the publisher associated with the solution in which the table is created. It keeps schema names unique and identifies who owns the component.

Question 33Configure Microsoft Dataverse

Which statement describes a managed solution?

  1. It is stored only in the default solution
  2. It cannot be deleted after it is imported
  3. Its components cannot be edited directly Correct answer.
  4. It can be exported again as unmanaged

Explanation

A managed solution is meant for distribution: its components are locked in the target environment and change only through an updated managed solution or through unmanaged layering on top. The solution itself can be uninstalled, which removes its components.

Question 34Configure Microsoft Dataverse

A table needs a parent-child hierarchy so that users can roll up values and use hierarchy security. Which configuration provides this?

  1. A many-to-many relationship with an intersect table
  2. A parental relationship to the Account table
  3. A self-referential relationship marked as hierarchical Correct answer.
  4. A connection role between the records

Explanation

A hierarchical relationship is a one-to-many relationship on the same table that is flagged as hierarchical. That flag enables hierarchy visualizations and allows the relationship to be used for hierarchy security.

Question 35Configure Microsoft Dataverse

A user is assigned two security roles: one grants Read on the Case table and the other grants Write on the same table. What access does the user have?

  1. No access, because the roles conflict
  2. Read and Write, because privileges are combined Correct answer.
  3. Read only, because the first role takes precedence
  4. Write only, because the most recent role wins

Explanation

A user's effective privileges are the union of every security role assigned directly and through team membership. Roles never subtract access from one another.

Question 36Configure Microsoft Dataverse

A one-to-many relationship uses Cascade All for the Assign behavior. What happens to the child records when the parent record is assigned to a new owner?

  1. The child records keep their original owner
  2. The reassignment is blocked
  3. The child records are deleted
  4. The child records are also reassigned Correct answer.

Explanation

Cascade All flows the parent's action to related children for every behavior, including Assign. Reassigning the parent therefore reassigns the children to the same new owner.

Question 37Configure Microsoft Dataverse

A lookup relationship is configured as Referential, Restrict Delete. What happens when a user deletes a parent record that has related child records?

  1. The child lookup is set to null
  2. The child records are deleted with the parent
  3. The children are reassigned to the parent's owner
  4. The delete is blocked while children exist Correct answer.

Explanation

Referential, Restrict Delete prevents removal of the parent while related child records exist. Users must first delete or reparent the children before the parent can be deleted.

Question 38Configure Microsoft Dataverse

A maker wants an external system to fetch only records that changed since its last synchronization without scanning the whole table. Which table setting supports this?

  1. Duplicate detection
  2. Auditing
  3. Change tracking Correct answer.
  4. Connection roles

Explanation

Change tracking maintains a per-table change log so a client can request only rows modified after a known version. Auditing captures detailed history for compliance and is not designed for incremental synchronization.

Question 39Configure Microsoft Dataverse

Which view determines the columns that a lookup control searches when a user types into it?

  1. The associated view
  2. The system view
  3. The main form
  4. The quick find view Correct answer.

Explanation

The quick find view defines the columns that are searched and the columns shown in the lookup results. Its filter also drives the search box above the table's grid.

Question 40Configure Microsoft Dataverse

How does Dataverse search differ from a quick find view search?

  1. It searches only the current table's quick find columns
  2. It requires a personal view to be created first
  3. It works only inside model-driven apps
  4. It searches many tables and returns ranked results Correct answer.

Explanation

Dataverse search builds a separate index across many tables and ranks the matches it returns. Quick find searches only the columns defined in one table's quick find view.

Question 41Configure Microsoft Dataverse

A business process flow is configured with stages that reference different tables. What does this allow?

  1. The process replaces the table security model
  2. The process cannot be used in model-driven apps
  3. One process can span records from several tables Correct answer.
  4. The process can only run on one table at a time

Explanation

A business process flow can include stages that point to different tables, letting one process guide a user from, for example, a lead to an opportunity and then to an order. Security and permissions are still governed by the underlying tables.

Question 42Configure Microsoft Dataverse

A maker needs to add a custom button that runs a JavaScript action against selected records of a table in a model-driven app. Where is the button defined?

  1. The site map
  2. The command bar Correct answer.
  3. The main form
  4. A business rule

Explanation

Custom buttons that act on records are added to the command bar and defined with the command designer, including their action and visibility rules. Forms, site maps, and business rules do not host record-level command buttons.

Question 43Configure Microsoft Dataverse

A Single Line of Text column stores email addresses, and users should be able to click them. Which setting should be changed?

  1. The requirement level
  2. The maximum length property
  3. The format property of the column Correct answer.
  4. The audit setting

Explanation

The format property changes how a text value is rendered and validated, for example as an email address, URL, or phone number. Email format also makes the value render as a clickable address.

Question 44Configure Microsoft Dataverse

Which values can the Owner column of a user- or team-owned table contain?

  1. A user, team, or business unit
  2. A user only
  3. Any record in the environment
  4. A user or a team Correct answer.

Explanation

On a user- or team-owned table the owner is either a user or a team. Ownership drives which business unit and security role privileges apply to the record.

Question 45Configure Microsoft Dataverse

Activity records such as emails and appointments include a Regarding lookup. What is the purpose of that lookup?

  1. It links the activity to the record it concerns Correct answer.
  2. It stores the owner of the activity
  3. It links the activity to another activity
  4. It stores the status of the activity

Explanation

The Regarding lookup connects an activity to the record it is about, such as an account or opportunity. This is what makes the activity appear in that record's timeline.

Question 46Configure Microsoft Dataverse

Managed Solution A is installed first, then managed Solution B. Both customize the same form, and no unmanaged customizations exist. Which change does a user see on the form?

  1. Both changes merged field by field
  2. The change from Solution B Correct answer.
  3. The change from Solution A
  4. The change from the base system layer

Explanation

Managed solutions layer in the order they are installed, so a later solution sits above an earlier one. With no unmanaged customization on top, the most recently installed managed change is the one displayed.

Question 47Configure Microsoft Dataverse

Which prerequisite must be met before a Manager hierarchy security model can be enabled?

  1. The Manager field must be set on each user record Correct answer.
  2. Each manager must own a team
  3. An access team must exist for each manager
  4. A parental relationship must link business units

Explanation

A manager hierarchy is built from the Manager field on user records, which establishes the reporting chain. Position hierarchies instead use a custom table with a hierarchical relationship.

Question 48Configure Microsoft Dataverse

Which cascade behavior can be configured on a relationship where a table has a lookup to itself?

  1. Parental
  2. Referential, Restrict Delete Correct answer.
  3. Cascade Assign
  4. Cascade All

Explanation

A self-referential relationship cannot use parental behaviors because parental cascades assume a strict parent-child chain and would risk circular operations. Only the referential behaviors, including Referential, Restrict Delete, are available.

Question 49Configure Microsoft Dataverse

Which statement about parental relationships is correct?

  1. A table can be the child in many parental relationships
  2. A table can be the child in only one parental relationship Correct answer.
  3. Parental relationships cannot cascade delete
  4. Parental relationships can be self-referential

Explanation

A table may act as the child in only one parental relationship, because parental behavior requires a single unambiguous ownership chain. Any additional relationship to the same table must use referential behavior.

Question 50Configure Microsoft Dataverse

An existing table is added to an unmanaged solution. What is the effect of that action?

  1. It locks the table against further changes
  2. It creates a copy of the table in the solution
  3. It moves the table out of the default solution
  4. It adds a reference to the existing component Correct answer.

Explanation

A solution stores references to components rather than copies, so adding an existing table simply includes a pointer to it. The table remains in the default solution as well.