Answer-first summary for fast verification
Answer: The job fails upon encountering records that violate the expectation.
The correct answer is that the job fails when records violate the expectation. Delta Live Tables supports three types of expectations to manage bad data in pipelines: keeping invalid records, dropping them, or failing the job. The 'ON VIOLATION FAIL' clause is used when invalid records are unacceptable, causing the job to halt immediately if any record fails validation, with any updates being rolled back atomically.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When a dataset defined using Delta Live Tables includes an expectations clause with 'ON VIOLATION FAIL', what happens if a batch of data violates these constraints?
A
Records violating the expectation are added to the target dataset and marked as invalid in the event log.
B
Records violating the expectation 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
Records violating the expectation are included in the target dataset with an additional flag marking them as invalid.
E
Records violating the expectation are excluded from the target dataset and placed into a quarantine table.
No comments yet.