Câu 43: Databricks Certified Data Engineer Associate

A dataset has been defined using Delta Live Tables and includes an expectations clause:CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION FAIL UPDATEWhat is the expected behavior when a batch of data containing data that violates these constraints is processed?

1. A. Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
2. B. Records that violate the expectation cause the job to fail. — đáp án hiện tại
3. C. Records that violate the expectation are dropped from the target dataset and loaded into a quarantine table.
4. D. Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.
5. E. Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.