Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Consider a scenario where you have defined a dataset using Delta Live Tables in Databricks, and this dataset includes an expectations clause to enforce data quality. The specific clause is:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW
Given this setup, what would be the expected behavior when a batch of data, which includes rows that do not meet the defined timestamp constraint, is processed?_
Consider a scenario where you have defined a dataset using Delta Live Tables in Databricks, and this dataset includes an expectations clause to enforce data quality. The specific clause is:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW
Given this setup, what would be the expected behavior when a batch of data, which includes rows that do not meet the defined timestamp constraint, is processed?_
Exam-Like
A
Records that violate the expectation cause the job to fail.
5.3%
B
Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
4.4%
Comments
Loading comments...