A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW
What is the expected behavior when a batch of data containing data that violates these constraints is processed?
When a constraint is defined using the EXPECT clause in Delta Live Tables with the ON VIOLATION DROP ROW keyword, any records that violate the constraint are dropped from the target dataset. Additionally, information about the dropped records, including the reason for their exclusion, is recorded in the event log for audit and monitoring purposes. This ensures that the target dataset contains only records that meet the specified constraints.
A should be correct
i don't agree, it shouldn't make the job to fail.
C should be correct, A is for ON VIOLATION FAIL UPDATE
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.
it's C
ON VIOLATION DROP ROW