Answer-first summary for fast verification
Answer: There is no need to add ON VIOLATION clause. By default, records violating the constraint will be kept, and reported as invalid in the event log
Correct. By default, records that violate the expectation are added to the target dataset along with valid records, but violations will be reported in the event log. Reference: [Delta Live Tables Expectations](https://learn.microsoft.com/en-us/azure/databricks/workflows/delta-live-tables/delta-live-tables-expectations)
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a Delta Live Tables pipeline, a data engineer has set a data quality constraint as follows: CONSTRAINT valid_id EXPECT (id IS NOT NULL) _____________. How should the blank be filled to ensure that records violating this constraint are added to the target table and reported in metrics?
A
ON VIOLATION SUCCESS UPDATE
B
ON VIOLATION ADD ROW
C
There is no need to add ON VIOLATION clause. By default, records violating the constraint will be kept, and reported as invalid in the event log
D
ON VIOLATION FAIL UPDATE
E
ON VIOLATION NULL
No comments yet.