AB-410 Dataverse Foundations Practice Test 7 — 15 Questions

Question 1

Which THREE of the following are primary capabilities of Dataverse business rules?

Accepted Answer

Set field requirements (Business Required). Dataverse business rules are declarative, no-code components that operate on a table's forms and data. Option B is correct because business rules can change a column's requirement level to Business Required (or Recommended) based on conditions, without writing code. Option C is correct because business rules can validate data against conditions and display error messages to the user when validation fails. Option D is correct because business rules can set field values automatically when specified conditions are met, such as defaulting or clearing a column. Option A is not a capability of business rules, since they cannot delete records; deletion requires workflows, Power Automate, or code. Option E is not correct because business rules are declarative and do not support custom C# code, which would require plug-ins or custom APIs.

Answer

Delete records automatically

Answer

Write custom C# code

Question 2

You are designing a Dataverse table to store support tickets. Each ticket must be assigned a unique, automatically generated identifier that users can easily reference. The identifier should follow a consistent pattern, such as 'TCK-00001', and increment for each new record. Which Dataverse feature should you use to meet this requirement?

Accepted Answer

Autonumber column. The requirement is for a unique, automatically generated, sequential identifier with a specific format. An Autonumber column is designed exactly for this purpose, allowing you to define a format string that includes a prefix and a number that increments with each new record. Other column types serve different purposes and cannot produce patterned, sequential values.

Answer

Primary key column

Answer

Rollup column

Answer

Calculated column

Question 3

You are creating a Dataverse table for a real estate application. You need to store a list of property features for each listing, such as 'Pool', 'Garage', and 'Fireplace'. Each listing can have multiple features, and you want to easily filter listings by a specific feature. The features are chosen from a predefined list of 20 options. Which column type should you use?

Accepted Answer

Multi-select Choice. The need is to store multiple predefined features per record and filter by them. A Multi-select Choice column is purpose-built for this: it allows selecting multiple options from a single global or local choice list, and it supports querying with the contains operator. Other column types either cannot store multiple values, lack validation, or introduce unnecessary complexity.

Answer

Lookup

Answer

Choice

Answer

Text

Question 4

You are designing a Dataverse solution for a sales tracking app. You need to categorize each opportunity by a predefined set of stages, such as 'Prospecting', 'Qualification', and 'Proposal'. Each opportunity can have only one stage at a time, and you want to ensure users select from these exact values. What should you create?

Accepted Answer

A Choice column with local options. A Choice column with local options is ideal for providing a fixed list of values that users can select from. It ensures data consistency, is easy to configure, and supports single selection per record. This meets the need for categorizing opportunities by predefined stages without additional tables or complex validation.

Answer

A Lookup column to a custom 'Stage' table

Answer

A Yes/No column for each stage

Answer

A Text column with a regular expression validation

Question 5

You are creating a new custom table in Dataverse to store product information. You need to ensure that each product has a unique identifier that is automatically generated and can be used as a primary key. Which column type should you use?

Accepted Answer

Autonumber. An Autonumber column is designed to automatically generate unique numeric values for each record. It can be customized with prefixes and suffixes, making it suitable for use as a primary key. This ensures that every product has a distinct identifier without manual data entry, simplifying record management and integration.

Answer

Date and Time

Answer

Currency

Answer

Text

Question 6

You need to create a relationship between two Dataverse tables where a single record in Table A can be associated with many records in Table B, but each record in Table B can be associated with only one record in Table A. Additionally, you want to ensure that when a record in Table A is deleted, all related records in Table B are also deleted. Which relationship type and behavior should you configure?

Accepted Answer

One-to-Many with Parental behavior. A one-to-many relationship with Parental behavior is the correct choice because it enforces a single parent per child and automatically deletes child records when the parent is deleted. This aligns with the requirement for cascading deletes and ensures data integrity without manual intervention.

Answer

Many-to-Many with Referential behavior

Answer

One-to-Many with Referential behavior

Answer

One-to-Many with Custom behavior

Question 7

A developer creates a custom table named 'Project' in Dataverse. They need to ensure that each project record has a unique project code that is automatically generated when the record is created. The code must follow the format 'PRJ-00001', 'PRJ-00002', etc. Which Dataverse feature should they use to achieve this?

Accepted Answer

Set the 'Project Code' column as an autonumber column with a format of 'PRJ-{00000}'.. Dataverse autonumber columns are specifically designed to automatically generate sequential alphanumeric values when records are created. They support custom formats with placeholders for sequential numbers, such as 'PRJ-{00000}', which produces PRJ-00001, PRJ-00002, and so on. This provides a reliable, no-code solution that ensures uniqueness and sequential ordering without the overhead of custom development or external flows.

Answer

Configure a business rule that sets the 'Project Code' column based on the record's creation date and a random number.

Answer

Write a plug-in that registers on the Create message of the 'Project' table and populates the 'Project Code' column.

Answer

Create a Power Automate cloud flow that triggers on record creation and sets the 'Project Code' column using an expression.

Question 8

You are designing a Dataverse table to store customer orders. You need to ensure that each order is automatically assigned a unique, sequential order number that users can easily reference. The number should be generated when a new record is created and should not be editable by users. What should you use?

Accepted Answer

An autonumber column. An autonumber column is designed to automatically generate unique, sequential numbers for new records. It is read-only, ensuring users cannot edit the value. This makes it the perfect choice for order numbers that need to be unique and easily referenced. Other column types cannot provide sequential numbering without complex workarounds and may not guarantee uniqueness.

Answer

A calculated column that concatenates the creation date and a random number

Answer

A text column with a business rule that sets its value

Answer

A rollup column that counts existing orders

Question 9

A system administrator is setting up a new Dataverse environment. They need to ensure that users can only access records that they own or that are shared with them, and that they cannot see records owned by other users in the same business unit. Which security concept should they configure?

Accepted Answer

Security roles with User-level access. Security roles in Dataverse define both privileges (what actions a user can perform) and access levels (which records they can perform them on). By assigning a security role with 'User' access level for the relevant entities, users can only access records they own or that are explicitly shared with them. This prevents them from seeing records owned by other users, even within the same business unit, unless sharing is configured.

Answer

Column security profiles

Answer

Field-level security

Answer

Business unit hierarchy

Question 10

You are designing a solution for a sales tracking app. You need to create a new custom table called 'Project' that will store project details. The table must have a primary column that uniquely identifies each project and a secondary column for the project's start date. Which of the following best describes the default behavior when you create a new custom table in Dataverse?

Accepted Answer

A primary column named 'Name' of type Single Line of Text is automatically created and can be renamed.. When you create a custom table in Dataverse, the system automatically generates a primary column named 'Name' of type Single Line of Text. This column serves as the primary identifier for records and can be renamed to better suit your business needs. It cannot be deleted, and its data type cannot be changed, but you can modify its display name and other properties.

Answer

A primary column named 'Name' of type Single Line of Text is automatically created and cannot be changed.

Answer

A primary column named 'ID' of type Autonumber is automatically created and cannot be changed.

Answer

No primary column is created; you must manually add one after saving the table.

Question 11

You are a builder working on a Power Platform solution that includes a custom Dataverse table named ProjectTask. You need to ensure that each ProjectTask record has a unique, human-readable identifier that is automatically generated when the record is created, and users should not be able to change it after creation. What should you use?

Accepted Answer

Use an Autonumber column with a format that combines a prefix and a sequential number.. An Autonumber column in Dataverse automatically generates a unique, sequential identifier when a record is created. It supports a configurable format with a prefix, and the generated value is read-only on forms, ensuring users cannot alter it. This satisfies the need for a human-readable, automatically generated, and immutable unique identifier without requiring custom code or external logic.

Answer

Use a text column with a business rule that sets the value to a concatenation of the Project name and a sequential number.

Answer

Create a calculated column that concatenates the created-on date and the record ID.

Answer

Use the primary column of the table and set it to be unique.

Question 12

A Power Platform administrator needs to allow users in a specific department to create and edit records in a custom table, but they should not be able to delete any records. The department users already have a security role with Read and Write privileges on the table. Which security role privilege should you modify?

Accepted Answer

Delete. Deletion of records is controlled by the Delete privilege in a security role. To prevent deletion while allowing create and edit, you must ensure the role lacks Delete permission on that table. The other privileges affect reading, updating, or associating records, not removal.

Answer

Append To

Answer

Read

Answer

Write

Question 13

You are configuring a Dataverse environment for a multinational company. The company requires that certain records be accessible only to users in the same business unit, while other records should be accessible to all users in the organization. You need to set up security roles to enforce this. Which of the following security role privileges should you configure to allow users to read records only within their business unit?

Accepted Answer

Business Unit (BU) level Read privilege on the table.. To allow users to read records only within their business unit, you must set the Read privilege on the table to Business Unit level. This grants access to records owned by the user's business unit while preventing access to records in other business units. Other levels like User, Organization, or Parent: Child Business Units do not meet the specific requirement.

Answer

User level Read privilege on the table.

Answer

Parent: Child Business Units level Read privilege on the table.

Answer

Organization level Read privilege on the table.

Question 14

You are creating a new custom table in Dataverse. You need to ensure that users can quickly find records by searching for a specific text field. Which column property should you enable to allow the field to be used in search?

Accepted Answer

Searchable. The Searchable property is specifically designed to include a column in Dataverse search indexing. When enabled, the column's values become searchable via the global search and APIs. Other properties like Audit, Primary, and Required serve different purposes and do not affect searchability. Therefore, Searchable is the correct property to enable.

Answer

Primary

Answer

Required

Answer

Audit

Question 15

A developer is building a model-driven app that must display a list of active contacts related to an account, with the ability to quickly filter and sort by multiple columns. The developer needs to add this to the account main form. Which control should be used?

Accepted Answer

Subgrid. The requirement is to display a list of related contacts with filtering and sorting. A subgrid is the standard form component for showing related records in a tabular format, and it supports multiple views and sorting. Timeline and quick view forms are for activities and single records respectively, while editable grid is for inline editing.

Answer

Editable grid

Answer

Quick view form

Answer

Timeline control