Exam Certified Data Engineer Associate topic 1 question 126 discussion

Actual exam question from Databricks's Certified Data Engineer Associate

Question #: 126
Topic #: 1

[All Certified Data Engineer Associate Questions]

A dataset has been defined using Delta Live Tables and includes an expectations clause:

CONSTRAINT valid_timestamp EXPECT (timestamp > '2020-01-01') ON VIOLATION DROP ROW

What is the expected behavior when a batch of data containing data that violates these constraints is processed?

A. Records that violate the expectation cause the job to fail.
B. Records that violate the expectation are added to the target dataset and flagged as invalid in a field added to the target dataset.
C. Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log.
D. Records that violate the expectation are added to the target dataset and recorded as invalid in the event log.

Show Suggested Answer

Suggested Answer: C 🗳️

by PreranaC at May 22, 2024, 10:03 p.m.

Comments

Submit Cancel

azurean

6 days, 7 hours ago

Selected Answer: C

C is the answer - Hint -> ON VIOLATION DROP ROW

upvoted 1 times

...

9d4d68a

10 months, 1 week ago

Repeated, Correct answer is C

upvoted 2 times

...

vigaro

1 year ago

Selected Answer: C

ON VIOLATION DROP ROW

upvoted 2 times

...

31cadd7

1 year ago

Selected Answer: C

it's C

upvoted 2 times

...

d39c1db

1 year, 1 month ago

C. Records that violate the expectation are dropped from the target dataset and recorded as invalid in the event log. When a constraint defined using the EXPECT clause is violated, Delta Live Tables will drop the records that violate the expectation from the target dataset. Additionally, information about the dropped records and the reason for their exclusion will be recorded in the event log for audit and monitoring purposes. This ensures that only valid data meeting the specified constraints is included in the target dataset.

upvoted 3 times

...