When a dataset defined using Delta Live Tables includes an expectations clause with 'ON VIOLATION FAIL', what happens if a batch of data violates these constraints?

Real Exam

Records violating the expectation are added to the target dataset and marked as invalid in the event log.

6.8%

Records violating the expectation are dropped from the target dataset and noted as invalid in the event log.

9.4%

The job fails upon encountering records that violate the expectation.

70.5%

Records violating the expectation are included in the target dataset with an additional flag marking them as invalid.

6.8%

Records violating the expectation are excluded from the target dataset and placed into a quarantine table.

6.5%

Databricks Certified Data Engineer - Associate