Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
The data engineering team has a Delta table named ‘users’ with a recently added CHECK constraint to ensure age values are positive. An attempt to insert a batch of records, some with negative ages, failed due to constraint violation. What was the outcome of this batch insert?
The data engineering team has a Delta table named ‘users’ with a recently added CHECK constraint to ensure age values are positive. An attempt to insert a batch of records, some with negative ages, failed due to constraint violation. What was the outcome of this batch insert?
Real Exam
Explanation:
Write operations failed due to the constraint violation. Delta Lake's ACID guarantees ensure all transactions are atomic, meaning they either succeed or fail completely. Thus, none of the records were inserted into the table, even those not violating the constraints. Reference: ACID Transactions.