Answer-first summary for fast verification
Answer: Records that violate the expectation cause the job to fail.
When using Delta Live Tables with the ON VIOLATION FAIL UPDATE clause, if any records violate the specified constraint, the job will fail immediately. This ensures that no invalid data is written to the target dataset, and it requires manual intervention to address the issue before re-processing. This behavior is documented in the Delta Live Tables documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a dataset that has been defined using Delta Live Tables, an expectations clause is included as follows: CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION FAIL UPDATE. What will be the expected behavior when a batch of data, which contains records that do not satisfy these constraints, is processed?
A
Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
B
Records that violate the expectation cause the job to fail.
C
Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
D
Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.
E
Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
No comments yet.