AB-410 Dataverse Foundations — 20 Questions

Question 1

You need to display data from a related table on a form. Which feature should you use to show a read-only list of related records?

Accepted Answer

Quick View Form. A Subgrid control on a form is designed to display related records in a list view.

Answer

Business Process Flow

Answer

Subgrid

Answer

Canvas component

Question 2

You are creating a custom table. You want to track when a record was created and who created it. What must you do?

Accepted Answer

Enable the table for auditing. Dataverse includes 'Audit' or 'System' fields automatically, but they must be enabled in the table configuration.

Answer

Create custom fields for CreatedBy and CreatedOn

Answer

Add the fields to the form

Answer

Write a workflow

Question 3

You are migrating data into Dataverse. You need to ensure that the data import does not trigger existing Power Automate cloud flows. Which feature should you utilize?

Accepted Answer

Data Import Wizard with 'Workflow' exclusion settings.. The 'Data import' experience allows you to disable plug-ins and workflows to prevent redundant processing during large-scale data loads.

Answer

Power Apps CLI data command.

Answer

Power Platform Admin Center data export.

Answer

Set the user to 'Offline'.

Answer

Delete the workflows before import.

Question 4

Which tool is used to manage Dataverse environments and solutions?

Accepted Answer

Power Platform admin center. The Power Platform admin center is the centralized portal for environment administration.

Answer

Power Apps Studio

Answer

Dataverse Web API

Answer

Solution Explorer

Question 5

A developer needs to ensure that a custom field value is validated before the record is saved to the database. Where should this logic be placed?

Accepted Answer

Synchronous Plugin. Synchronous plugins or real-time workflows run during the data pipeline and can block saves.

Answer

Power Automate Cloud Flow

Answer

Client-side JavaScript

Answer

Business Rule on the form

Question 6

You are designing a data model for a CRM. You need to link a 'Contact' record to a 'Company' record such that deleting the Company also deletes all associated Contacts. Which relationship type do you choose?

Accepted Answer

Parental. A parental (cascading) relationship is used to manage record lifecycles in parent-child hierarchies.

Answer

Configurable Cascading

Answer

Many-to-Many

Answer

Referential

Question 7

You need to create a field that automatically calculates the total revenue of a customer based on related invoices. Which field type should you use?

Accepted Answer

Rollup field. Rollup fields are designed to aggregate data from related records.

Answer

Lookup field

Answer

Calculated field

Answer

Formula column

Question 8

You are auditing environment security. You find that a user can see records they should not have access to. The user is assigned two security roles, one that grants access and one that restricts it. How does Dataverse handle this?

Accepted Answer

The privileges are additive (union). Dataverse uses a 'Union' approach; the user receives the sum of all privileges from all assigned roles.

Answer

The most restrictive role wins

Answer

The last assigned role takes precedence

Answer

The user is denied access

Question 9

A user reports they cannot see a custom table in their app, even though the table is part of the solution. What is the most likely cause?

Accepted Answer

The user is missing Read privileges in their security role. Security roles determine access to tables. If the role does not have the necessary privileges, the table will not appear.

Answer

The site map has not been updated

Answer

The table is set to Private

Answer

The table is not in the default solution

Question 10

You have a business requirement to categorize 'Project' records by a 'Status' field. You need to ensure users can only select from a predefined list. Which field type is most appropriate?

Accepted Answer

Choice column. Choice columns provide a controlled list of values for consistent categorization.

Answer

Whole Number column

Answer

Text column

Answer

Lookup column

Question 11

You need to enforce data consistency across forms in a Model-driven app by hiding a field based on the value of another field. Which mechanism should you use?

Accepted Answer

Business Rules. Business Rules are the standard, declarative way to apply logic across forms and server-side in Dataverse.

Answer

Power Automate Cloud Flows

Answer

JavaScript Web Resources

Answer

Calculated Columns

Question 12

What is the primary purpose of a Dataverse 'Solution'?

Accepted Answer

To package and deploy customizations. Solutions are the mechanism to bundle and transport components between environments.

Answer

To store table data

Answer

To act as a database backup

Answer

To define user permissions

Question 13

Which security role type is provided by default in Dataverse?

Accepted Answer

System Administrator. System Administrator is the default, all-access role provided in every environment.

Answer

Environment Member

Answer

Owner

Answer

Data Analyst

Question 14

Which type of relationship is required to allow multiple 'Contacts' to be associated with multiple 'Accounts'?

Accepted Answer

Many-to-Many. Many-to-Many relationships are designed for scenarios where records can relate to multiple records on both sides.

Answer

Many-to-One

Answer

One-to-Many

Answer

Parental

Question 15

You are configuring field-level security for a sensitive 'Salary' field. You have enabled the field for security. What must be done next to ensure the user cannot read the data?

Accepted Answer

Create a Field Security Profile and assign it to the user. You must create a Field Security Profile and add the user to it with specific permissions.

Answer

Remove the field from the Form

Answer

Assign the user a different security role

Answer

Set the field to read-only on the form

Question 16

You need to import a large volume of data into Dataverse. Which feature allows you to perform bulk operations efficiently?

Accepted Answer

Dataflows. Dataflows are designed for ETL (Extract, Transform, Load) tasks and bulk ingestion.

Answer

Excel Online

Answer

Power Automate

Answer

Command line interface

Question 17

A user has 'User' level access to a table. They create a record. Who is the owner of the record?

Accepted Answer

The user who created the record. In Dataverse, the user who creates the record is automatically assigned as the owner unless otherwise specified by logic.

Answer

The Business Unit Manager

Answer

The record has no owner

Answer

The System Administrator

Question 18

A user needs to see the history of changes made to a record's fields. What feature must be enabled?

Accepted Answer

Auditing. Auditing is the mechanism that tracks and logs changes to record fields over time.

Answer

Change tracking

Answer

Version control

Answer

Table logging

Question 19

When creating a new environment, what is the default database type?

Accepted Answer

Dataverse. Dataverse is the native database technology within the Power Platform.

Answer

SharePoint list

Answer

Common Data Model

Answer

SQL Server

Question 20

What is the maximum number of environments a single tenant can create?

Accepted Answer

Dependent on licensing. The limit depends on the license, but the question implies the concept of environment provisioning limitations.

Answer

10

Answer

Fixed at 50

Answer

Unlimited