When a dataset defined with Delta Live Tables includes an expectations clause, such as `CONSTRAINT valid_timestamp EXPECT (timestamp > ‘2020-01-01‘)`, and a batch of data containing violations of these constraints is processed, what happens?_

Real Exam

The job fails immediately upon encountering any records that violate the expectation.

10.2%

Violating records are excluded from the target dataset but noted as invalid in the event log.

20.9%

Violating records are included in the target dataset and marked as invalid within an additional field.

12.3%

Violating records are included in the target dataset and their invalidity is recorded in the event log.

46.2%

Violating records are excluded from the target dataset and placed into a quarantine table.

10.5%

Databricks Certified Data Engineer - Associate