Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
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?
CONSTRAINT valid_timestamp EXPECT (timestamp > ‘2020-01-01‘)
A
The job fails immediately upon encountering any records that violate the expectation.
B
Violating records are excluded from the target dataset but noted as invalid in the event log.
C
Violating records are included in the target dataset and marked as invalid within an additional field.
D
Violating records are included in the target dataset and their invalidity is recorded in the event log.
E
Violating records are excluded from the target dataset and placed into a quarantine table.
