In a Delta Live Tables pipeline, a data engineer has set up 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 dropped and their violations are reported in metrics?

Real Exam

Explanation:

The correct answer is ON VIOLATION DROP ROW. This ensures that records violating the expectation are dropped, and their violations are reported in the event log. For more details, refer to the Microsoft documentation.

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 up 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 dropped and their violations are 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 up 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 dropped and their violations are reported in metrics?

In a Delta Live Tables pipeline, a data engineer has set up 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 dropped and their violations are reported in metrics?