AB-410 Dataverse Foundations Practice Test 4 — 15 Questions

Question 1

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. A Rollup field aggregates values from related records in a one-to-many relationship — exactly the scenario described, where total revenue is summed from related invoices. Rollup fields support SUM, COUNT, MIN, MAX, and AVG, and they can also apply filters to the related records. This makes them the correct choice for computing a parent record's value from its children.

Answer

Lookup field

Answer

Calculated field

Answer

Formula column

Question 2

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 role-based access model where a user's effective privileges are the union of all assigned security roles. When a user holds two roles, one granting access and one restricting it, the granting role's privileges are not overridden — they are combined additively. This means the user will retain the access granted by the permissive role, which is why they can see records they should not.

Answer

The most restrictive role wins

Answer

The last assigned role takes precedence

Answer

The user is denied access

Question 3

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. In Microsoft Power Platform, a user's ability to see a custom table in a model-driven app is governed by their security role. Even if the table is included in the app's components, the user must have at least Read privilege on that table to view it. Without Read access, the table will not appear in the app's navigation or be accessible, leading to the reported issue. Therefore, missing Read privileges is the most likely cause.

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 4

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. A Choice column stores a predefined set of options (an option set) and restricts user input to those values, which is exactly what is needed to categorize Project records by a Status field with a fixed list. Choice columns can be local (defined per table) or global (shared across tables), and they support single or multi-select.

Answer

Whole Number column

Answer

Text column

Answer

Lookup column

Question 5

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 no-code mechanism in Dataverse to enforce data consistency and modify form behavior based on conditions. They can hide or show fields, set values, and validate data. For hiding a field based on another field's value, a Business Rule with a condition and a 'Show or Hide' action is the appropriate choice. It runs client-side for immediate feedback and can also run server-side for consistency.

Answer

Power Automate Cloud Flows

Answer

JavaScript Web Resources

Answer

Calculated Columns

Question 6

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

Accepted Answer

To package and deploy customizations. A Dataverse 'Solution' is a container that packages customizations — such as tables, columns, forms, views, workflows, and plugins — so they can be transported between environments (e.g., dev to test to production). It provides a versioned, deployable unit for application lifecycle management. It does not store table data itself; it stores metadata and components.

Answer

To store table data

Answer

To act as a database backup

Answer

To define user permissions

Question 7

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

Accepted Answer

Many-to-Many. A Many-to-Many (N:N) relationship in Dataverse is designed for scenarios where records on both sides can be associated with multiple records on the other side — exactly the case for multiple Contacts linked to multiple Accounts. Dataverse implements N:N relationships using an intersect table that stores the pairings.

Answer

Many-to-One

Answer

One-to-Many

Answer

Parental

Question 8

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. Enabling a field for security in Dataverse only makes the field 'security-enabled'; it does not by itself restrict access. To actually control read/update/create permissions on that field, you must create a Field Security Profile, add the field with the desired access level (e.g., No access for Read), and assign the profile to the user or team. Without a profile assignment, users with the base table privileges can still read the field.

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 9

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

Accepted Answer

Dataflows. Dataflows in Power Platform provide a scalable way to ingest, transform, and load large volumes of data into Dataverse and other destinations. They use Power Query Online to perform ETL operations and can handle bulk data movement efficiently, including scheduled refreshes and incremental loads. This makes Dataflows the appropriate feature for high-volume data import into Dataverse.

Answer

Excel Online

Answer

Power Automate

Answer

Command line interface

Question 10

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, when a user with at least User-level access creates a record, that user is automatically set as the record's owner. Ownership is a core security concept in Dataverse that determines who can access and manage the record, and it is assigned at creation time to the creating user unless explicitly reassigned (e.g., to a team or another user).

Answer

The Business Unit Manager

Answer

The record has no owner

Answer

The System Administrator

Question 11

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

Accepted Answer

Auditing. Auditing in Dataverse (and Dynamics 365) is the feature that records field-level and record-level changes, including who changed what, when, and from where. Once auditing is enabled at the environment, table, and column levels, users with appropriate privileges can view the change history for a record.

Answer

Change tracking

Answer

Version control

Answer

Table logging

Question 12

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

Accepted Answer

Dataverse. When you create a new environment in the Power Platform admin center, the default database provisioning option is Dataverse. Dataverse is the underlying data platform that stores tables, relationships, and business logic. The Common Data Model is a schema standard that Dataverse implements, not a database type you select at creation.

Answer

SharePoint list

Answer

Common Data Model

Answer

SQL Server

Question 13

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

Accepted Answer

Dependent on licensing. The maximum number of environments a tenant can create in Power Platform is not a fixed number — it depends on the licensing model, specifically the number of licenses purchased and the type of licenses (e.g., per-user vs. per-app, and whether capacity add-ons are present). Microsoft documents environment limits in terms of a base allocation plus additional environments per license, so the correct answer is that it is dependent on licensing.

Answer

10

Answer

Fixed at 50

Answer

Unlimited

Question 14

A user needs to see records based on specific criteria. Which object should you configure?

Accepted Answer

View. A View in Dataverse (or model-driven apps) defines which records are displayed and how they are filtered, sorted, and columned. Views are the standard object for showing a filtered subset of records based on criteria, such as 'Active Accounts' or 'My Open Opportunities'. Configuring a view with filter conditions is the correct way to let a user see records matching specific criteria.

Answer

Form

Answer

Relationship

Answer

Chart

Question 15

Which component allows users to navigate between different entities in a Model-driven app?

Accepted Answer

Site Map. The Site Map defines the navigation structure of a model-driven app, including areas, groups, and subareas that link to entities, dashboards, and other components. It is the component that allows users to navigate between different entities. Without a site map, users cannot move between tables in the app.

Answer

Business Process Flow

Answer

View

Answer

Form