Answer-first summary for fast verification
Answer: By rejecting any write operation that contains data violating the specified constraint criteria.
Delta Lake maintains data integrity by enforcing constraints at the time of the write operation. If a transaction attempts to insert or update data that violates a `NOT NULL` or `CHECK` constraint, the operation will fail, and the data will not be committed. This ensures that all data residing in the table meets the defined quality standards.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When implementing data quality constraints on a Delta table, how does Delta Lake ensure compliance with these rules?
A
By validating constraints asynchronously during file compaction (the OPTIMIZE command).
B
By checking constraints at query execution time to filter out invalid records from the result set.
C
By rejecting any write operation that contains data violating the specified constraint criteria.
D
By applying constraints retroactively to all existing historical data stored in the transaction log.
No comments yet.