In a Delta Live Tables pipeline, a data engineer has set a data quality constraint as follows: `CONSTRAINT valid_id EXPECT (id IS NOT NULL) _____________`. How should the blank be filled to ensure that records violating this constraint are added to the target table and reported in metrics?

Real Exam

Explanation:

Correct. By default, records that violate the expectation are added to the target dataset along with valid records, but violations will be reported in the event log. Reference: Delta Live Tables Expectations

Powered ByGPT-5

Databricks Certified Data Engineer - Associate

Get started today

Databricks Certified Data Engineer - Associate

Get started today

In a Delta Live Tables pipeline, a data engineer has set a data quality constraint as follows: `CONSTRAINT valid_id EXPECT (id IS NOT NULL) _____________`. How should the blank be filled to ensure that records violating this constraint are added to the target table and reported in metrics?

Databricks Certified Data Engineer - Associate

Get started today

Databricks Certified Data Engineer - Associate

Get started today

In a Delta Live Tables pipeline, a data engineer has set a data quality constraint as follows: CONSTRAINT valid_id EXPECT (id IS NOT NULL) _____________. How should the blank be filled to ensure that records violating this constraint are added to the target table and reported in metrics?

In a Delta Live Tables pipeline, a data engineer has set a data quality constraint as follows: `CONSTRAINT valid_id EXPECT (id IS NOT NULL) _____________`. How should the blank be filled to ensure that records violating this constraint are added to the target table and reported in metrics?