Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
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