Exam Certified Data Engineer Associate topic 1 question 126 discussion

Repeated, Correct answer is C

ON VIOLATION DROP ROW

it's C

C. Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log. When a constraint defined using the EXPECT clause is violated, Delta Live Tables will drop the records that violate the expectation from the target dataset. Additionally, information about the dropped records and the reason for their exclusion will be recorded in the event log for audit and monitoring purposes. This ensures that only valid data meeting the specified constraints is included in the target dataset.

C should be correct, A is for ON VIOLATION FAIL UPDATE

A should be correct