Exam Databricks-Certified-Data-Engineer-Associate Topic 2 Question 95 Discussion

Actual exam question for Databricks's Databricks-Certified-Data-Engineer-Associate exam
Question #: 95
Topic #: 2
A dataset has been defined using Delta Live Tables and includes an expectations clause:
CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION FAIL UPDATE What is the expected behavior when a batch of data containing data that violates these constraints is processed?

Suggested Answer: B Vote an answer

Explanation
https://docs.databricks.com/en/delta-live-tables/expectations.html
Action
Result
warn (default)
Invalid records are written to the target; failure is reported as a metric for the dataset.
drop
Invalid records are dropped before data is written to the target; failure is reported as a metrics for the dataset.
fail
Invalid records prevent the update from succeeding. Manual intervention is required before re-processing.

by Lou at Sep 11, 2026, 07:02 AM

Limited Time Offer

15%

Off

Get Premium Databricks-Certified-Data-Engineer-Associate Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.