Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu
Databricks Discussions
exam questions

Exam Certified Data Engineer Associate All Questions

View all questions & answers for the Certified Data Engineer Associate exam
Go to Exam

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 Hide Answer
Suggested Answer: C 🗳️
by PreranaC at May 22, 2024, 10:03 p.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
9d4d68a
3 months ago
Repeated, Correct answer is C
upvoted 2 times
...
vigaro
5 months ago
Selected Answer: C
ON VIOLATION DROP ROW
upvoted 2 times
...
31cadd7
5 months, 2 weeks ago
Selected Answer: C
it's C
upvoted 2 times
...
d39c1db
6 months 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 2 times
...
PreranaC
6 months ago
Selected Answer: C
C should be correct, A is for ON VIOLATION FAIL UPDATE
upvoted 1 times
...
PreranaC
6 months ago
Selected Answer: A
A should be correct
upvoted 1 times
MDWPartners
6 months ago
i don't agree, it shouldn't make the job to fail.
upvoted 2 times
...
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.

SaveCancel