Configure Microsoft Dataverse Flashcards

Which Dataverse relationship behavior causes related child records to be automatically deleted when a parent record is deleted?

Answer: Cascade All (Parental)

The Parental cascade behavior deletes all child records when the parent record is deleted.

A developer must implement logic that fires before a record is saved and can cancel the save operation. Which Dataverse extensibility option supports this?

Answer: Pre-validation plug-in stage

Pre-validation plug-ins run before the main operation and can throw exceptions to cancel the transaction.

What is the purpose of Dataverse elastic tables compared to standard tables?

Answer: They are designed for large-scale, high-velocity data with flexible schema

Elastic tables use Azure Cosmos DB underneath and are optimized for high-volume, time-series, or IoT-type data with schema flexibility.

In Dataverse, which relationship type allows a single record in Table A to be related to multiple records in Table B, and vice versa?

Answer: Many-to-Many (N:N)

Many-to-Many relationships use an intersect (relationship) table to link records from both tables bidirectionally.

A developer needs to query Dataverse data using standard SQL syntax via an external tool. Which feature enables this?

Answer: TDS endpoint (Tabular Data Stream)

The TDS endpoint exposes Dataverse as a SQL data source, allowing SQL queries via tools like SSMS or Power BI.

Which Dataverse auditing configuration option must be enabled first before individual table or column auditing can be activated?

Answer: Enable auditing at the environment level

Environment-level auditing must be enabled before table or column-level auditing settings take effect.

What does enabling 'Change Tracking' on a Dataverse table primarily support?

Answer: Efficient delta synchronization with external systems

Change tracking allows external systems to retrieve only records that changed since the last sync, reducing data transfer.