PL 400 Configure Microsoft Dataverse 3 — Questions and Answers
Question 1: Which Dataverse relationship behavior causes related child records to be automatically deleted when a parent record is deleted?
- Cascade None
- Cascade All (Parental) (Correct answer)
- Cascade Active
- Cascade User-Owned
Correct answer: Cascade All (Parental)
The Parental cascade behavior deletes all child records when the parent record is deleted.
Question 2: A developer must implement logic that fires before a record is saved and can cancel the save operation. Which Dataverse extensibility option supports this?
- Asynchronous plug-in
- Pre-validation plug-in stage (Correct answer)
- Post-operation plug-in stage
- Scheduled cloud flow
Correct answer: Pre-validation plug-in stage
Pre-validation plug-ins run before the main operation and can throw exceptions to cancel the transaction.
Question 3: What is the purpose of Dataverse elastic tables compared to standard tables?
- They support complex relationships between multiple entities
- They are designed for large-scale, high-velocity data with flexible schema (Correct answer)
- They replicate data to Azure Synapse automatically
- They allow external data to be surfaced without storage
Correct 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.
Question 4: In Dataverse, which relationship type allows a single record in Table A to be related to multiple records in Table B, and vice versa?
- One-to-Many (1:N)
- Many-to-One (N:1)
- Many-to-Many (N:N) (Correct answer)
- Self-referential
Correct answer: Many-to-Many (N:N)
Many-to-Many relationships use an intersect (relationship) table to link records from both tables bidirectionally.
Question 5: A developer needs to query Dataverse data using standard SQL syntax via an external tool. Which feature enables this?
- Dataverse Web API
- TDS endpoint (Tabular Data Stream) (Correct answer)
- OData feed
- Dataverse connector in Power Automate
Correct 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.
Question 6: Which Dataverse auditing configuration option must be enabled first before individual table or column auditing can be activated?
- Enable auditing for the table
- Enable auditing at the environment level (Correct answer)
- Enable field security on columns
- Enable change tracking on the table
Correct answer: Enable auditing at the environment level
Environment-level auditing must be enabled before table or column-level auditing settings take effect.
Question 7: What does enabling 'Change Tracking' on a Dataverse table primarily support?
- Auditing column changes for compliance
- Efficient delta synchronization with external systems (Correct answer)
- Enforcing business rules on updates
- Generating audit log entries
Correct 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.
PL 400 Configure Microsoft Dataverse 3
Which Dataverse relationship behavior causes related child records to be automatically deleted when a parent record is deleted?