Answer-first summary for fast verification
Answer: The violating records are dropped from the target dataset and noted as invalid in the event log.
The correct answer is that records violating the expectation are dropped from the target dataset and recorded as invalid in the event log. Delta Live Tables provides mechanisms to handle bad data through expectations, ensuring data quality by automatically managing violations according to the specified constraints.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
When a dataset defined with Delta Live Tables includes an expectations clause like CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW, what happens to records violating this constraint during batch processing?
A
The violating records are added to the target dataset and marked as invalid in the event log.
B
The violating records are dropped from the target dataset and noted as invalid in the event log.
C
The job fails upon encountering records that violate the expectation.
D
Violating records are included in the target dataset with an additional field flagging them as invalid.
E
Records that violate the expectation are excluded from the target dataset and placed into a quarantine table.