AB-410 Dataverse Foundations — Timed 50 Questions

Question 1

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?

50 minute time limit — choose an answer to begin.

Accepted Answer

Parental. In Salesforce, a Parental relationship is a lookup relationship where the child record is tightly coupled to the parent. When the parent is deleted, all child records are automatically deleted as well. This matches the requirement that deleting a Company should delete all associated Contacts. The Parental relationship is implemented via a Lookup field with the 'Delete this record also' option selected, effectively creating a cascade delete.

Answer

Configurable Cascading

Answer

Many-to-Many

Answer

Referential

Question 2

Which security role type is provided by default in Dataverse?

Accepted Answer

System Administrator. Dataverse ships with a set of default security roles, and System Administrator is one of them — it grants full privileges across the environment, including customization and security management. It is a built-in role available in every environment. Other default roles include System Customizer, Environment Maker, and Basic User.

Answer

Environment Member

Answer

Owner

Answer

Data Analyst

Question 3

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 4

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 5

Which Dataverse feature is best for synchronizing data from an external SQL database?

Accepted Answer

Virtual tables. Virtual tables in Dataverse allow you to surface data from an external system (such as SQL Server, SharePoint, or an OData endpoint) as if it were a native Dataverse table, without copying the data. This is ideal for synchronizing or integrating external SQL data because it provides real-time access to the external source through the Dataverse interface. Virtual tables are the recommended feature for this scenario.

Answer

Power Automate

Answer

API access

Answer

Dataflows

Question 6

Which THREE items are required to create a new Model-driven app?

Accepted Answer

Site map. A Site map (A) is required because it defines the navigation structure of a model-driven app, specifying which tables, dashboards, and other components appear in the app and how users move between them. A security role (D) is required because model-driven apps are built on Microsoft Dataverse, where access to tables and records is governed by security roles; without assigning appropriate roles, users cannot access the app's data. At least one table (E) is required because a model-driven app is fundamentally data-driven and is generated from the Dataverse table metadata, so there must be at least one table to render forms, views, and the app itself. An Azure SQL database (B) is not required, since model-driven apps use Dataverse storage rather than Azure SQL. A canvas component (C) is not required, as canvas components belong to the Power Apps canvas app model, not the model-driven app model.

Answer

An Azure SQL database

Answer

A canvas component

Question 7

Which THREE actions are permitted by a Business Rule?

Accepted Answer

Set visibility of fields. In ServiceNow, Business Rules are server-side scripts that run when records are displayed, inserted, updated, deleted, queried, or when a database operation occurs, and they can directly manipulate the current record before it is saved. Option C is correct because a Business Rule can set the visibility of fields by using g_scratchpad to pass data to the client or by calling setVisible() on a field via a client-callable rule or UI policy-like logic, controlling whether fields appear on the form. Option D is correct because Business Rules can set field requirements through setMandatory() on the current record, making a field mandatory before insert or update. Option E is correct because Business Rules commonly set field values using current.field_name = value, which is one of their primary uses for defaulting or deriving data. Option A is not correct because external API calls from a Business Rule are not a permitted or recommended action in the standard exam scope; outbound integrations should use RESTMessageV2 or similar from a Script Include or scheduled job, and synchronous external calls in a Business Rule are discouraged and not listed as a permitted action. Option B is not correct because deleting records is not a standard permitted action of a Business Rule; while a Business Rule can trigger on delete, performing record deletions is typically done through other mechanisms such as a Scheduled Job or Script, and the exam treats delete as outside the permitted actions of a Business Rule.

Answer

Perform external API calls

Answer

Delete records

Question 8

Which TWO methods can be used to import data into Dataverse?

Accepted Answer

Dataflows. Dataflows (C) are a correct method because Power Query-based dataflows can load and transform data from sources such as Excel, SQL, and OData, then write that data directly into Dataverse tables. Data Import Wizard (D) is also correct because the built-in import wizard in Power Apps/Dynamics 365 lets you upload files like Excel or CSV, map columns to Dataverse table columns, and import the records. Direct SQL injection (A) is not a valid import method and is a security attack, not a supported Dataverse data-loading feature. Power BI dashboard (B) is a visualization/reporting layer and does not import data into Dataverse. Manual form entry only (E) is not an import method and is also incorrectly limited, since Dataverse supports bulk and programmatic import options.

Answer

Direct SQL injection

Answer

Power BI dashboard

Answer

Manual form entry only

Question 9

Which THREE items are considered default table behaviors?

Accepted Answer

Record ownership. In ServiceNow, default table behaviors are the built-in characteristics that every table inherits unless explicitly changed. Option B (Record ownership) is correct because every table has a sys_created_by and sys_updated_by field, and tables extending task also inherit the Assigned to and Assignment group ownership fields by default. Option D (Connections) is correct because the Connections related list is a default behavior available on task-based tables, allowing users to relate records such as incidents, problems, and changes. Option E (Auditing) is correct because auditing is a default table behavior that can be enabled per table to track field-level changes in the Audit [sys_audit] table. Option A (External API exposure) is not a default behavior because tables must be explicitly configured with a REST or SOAP API or exposed via a scripted web service. Option C (Form-based workflows) is not a default behavior because workflows must be created and attached to a table through configuration, not inherited automatically.

Answer

External API exposure

Answer

Form-based workflows

Question 10

Which THREE actions can a system administrator perform in an environment?

Accepted Answer

Deploy solutions. In this environment, a system administrator can Deploy solutions (A), which packages and transports customizations such as entities, workflows, and forms between environments using the solution framework. They can also Restore database backups (B), since administrators hold the highest privileges needed to perform backup and recovery operations for the organization's data. Additionally, they can Assign security roles (C), granting or modifying user access rights to records and features based on role-based security. Options D and E do not belong: editing all user personal records is restricted by record ownership and sharing rules rather than being a blanket administrator action, and creating custom JavaScript web resources is a customization task typically performed by a customizer or developer role, not an inherent system administrator capability.

Answer

Edit all user personal records

Answer

Create custom JavaScript web resources

Question 11

You have a business rule that sets a field value when a form loads. Users report that the value is not being updated when they change the trigger field. What is the most likely cause?

Accepted Answer

The business rule is set to Entity scope only.. The business rule is set to Entity scope only, which means it executes only when a record is loaded from the database, not when a field on the form changes. To update a field value dynamically as users change a trigger field, the business rule must run on the client side (form) with the appropriate 'When' condition, such as 'On Change' or 'On Load'. Entity-scoped rules are server-side and do not respond to real-time form field changes.

Answer

The business rule is deactivated.

Answer

The field is read-only.

Answer

The business rule scope is set to Global.

Question 12

You need to enforce data security where a user can only view records that belong to their specific business unit. Which security setting should you modify?

Accepted Answer

Business Unit. The Business Unit security setting in Dataverse controls record-level access so that users can only see records owned by their own business unit. Setting a table's or record's access to 'Business Unit' means users in the same BU as the record owner can read/write it, but users in other BUs cannot. This directly satisfies the requirement that a user only view records belonging to their specific business unit.

Answer

Parent: Child Business Units

Answer

User

Answer

Organization

Question 13

Which THREE of the following are valid components of a Dataverse solution?

Accepted Answer

Table. A Dataverse solution is a container that packages customizable components for transport between environments, and a Table (option A) is a core Dataverse component that can be added to a solution because it defines the data schema, columns, relationships, and keys. A Canvas App (option D) is a valid solution component, as Power Apps canvas apps can be included in a solution to move the app together with its dependencies. A Power Automate cloud flow (option E) is also a valid solution component, since cloud flows can be added to solutions to support application lifecycle management and deployment. System Administrator (option B) is a security role, not a solution component, and User Security Profile (option C) is not a valid Dataverse solution component type; security roles are configured in the environment rather than packaged as solution components.

Answer

System Administrator

Answer

User Security Profile

Question 14

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 15

You are configuring a new table. Which TWO of the following are true regarding 'Auditing' in Dataverse?

Accepted Answer

Auditing must be enabled at the environment level before it can be configured for tables.. Option D is correct because Dataverse auditing requires the organization/environment-level setting 'Start Auditing' to be turned on before any table or column auditing can take effect; without it, table-level audit configuration has no effect. Option E is correct because, once auditing is enabled for a table, you can selectively enable auditing on individual columns (via the column's 'Audit' property), allowing granular control over which fields are tracked. Option A is wrong because audit records are stored in Dataverse itself (in the Audit table/entity), not in a separate database. Option B is wrong because auditing is disabled by default for new tables and must be explicitly enabled. Option C is wrong because auditing does not capture the user's IP address; it records details such as the user, action, timestamp, and changed values.

Answer

Auditing records are stored in a separate database.

Answer

Auditing is enabled by default for all new tables.

Answer

Auditing tracks the IP address of the user.

Question 16

You are designing a Dataverse data model for a customer support application. The support manager wants each case to be linked to a single customer account, and when viewing a case record, they want to see the account's primary contact and phone number directly on the case form without navigating away. Which Dataverse feature should you use to achieve this?

Accepted Answer

Create a quick view form on the Case form that displays Account details.. The requirement is to display read-only information from a related account directly on the case form. A quick view form is designed exactly for this purpose: it shows fields from a related table within the context of the current record. Other options either create relationships without displaying the needed data or use mechanisms that do not automatically surface related fields on the form.

Answer

Create a 1:N relationship from Account to Case and add a subgrid on the Case form.

Answer

Create a calculated column on the Case table that pulls the account's phone number.

Answer

Create a lookup column on the Case table that references the Account table.

Question 17

You are building a model-driven app for a sales team. The app uses a custom table called 'Opportunity' that has a many-to-one relationship with the 'Account' table. When viewing an Opportunity record, users need to see the name of the related Account. Which type of column should you add to the Opportunity table to display the Account name?

Accepted Answer

Lookup. To display a related record's field, you must establish a relationship between the tables. A Lookup column does this and automatically shows the primary name of the related record. Other column types do not create relationships and cannot dynamically fetch related data.

Answer

Calculated

Answer

Text

Answer

Choice

Question 18

You need to add a column to the Account table that stores a monetary value with a maximum of four decimal places. The column must be available in all forms and views. Which Dataverse column data type should you use?

Accepted Answer

Currency. The Currency data type is purpose-built for monetary values in Dataverse, offering configurable precision up to four decimal places and currency-aware formatting. It also supports multi-currency scenarios. The other numeric types lack the monetary context and formatting, making them unsuitable for a currency field. Thus, Currency is the correct answer.

Answer

Floating Point

Answer

Decimal

Answer

Money

Question 19

A sales manager wants a new column on the Account table that automatically calculates a discount percentage based on the Annual Revenue column. The value should be recalculated whenever the revenue changes. Which type of column should you create?

Accepted Answer

Calculated column. The requirement is for an automatic, read-only value derived from another column in the same record. Calculated columns are designed exactly for this: they evaluate a formula on the server whenever dependent columns change. Rollup columns aggregate related rows, formula columns are more limited, and currency columns only store monetary amounts.

Answer

Currency column

Answer

Rollup column

Answer

Formula column

Question 20

You are configuring a Dataverse table for a project management app. You need to track the total number of tasks associated with each project. Each task is a record in a related 'Task' table and has a status column indicating whether it is complete. You want the 'Project' table to display the count of all tasks and also the count of completed tasks. Which column type should you use to achieve this?

Accepted Answer

Two Rollup columns. To count related records, you need a Rollup column. Since the requirement is for two distinct counts (total tasks and completed tasks), you must create two Rollup columns. Calculated columns cannot aggregate across relationships, so they are not suitable.

Answer

Two Calculated columns

Answer

Calculated

Answer

Rollup