DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #13
DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Question #13: Real Exam Question with Answer & Explanation
Sign in or unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to reveal the answer and full explanation for question #13. The question stem and answer options stay visible for context.
Question
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?
Options
- ARecords that violate the expectation are dropped from the target dataset and loaded into a
- BRecords that violate the expectation are added to the target dataset and flagged as invalid in a
- CRecords that violate the expectation are dropped from the target dataset and recorded as invalid in
- DRecords that violate the expectation are added to the target dataset and recorded as invalid in the
- ERecords that violate the expectation cause the job to fail.
Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE to see the answer
You've previewed enough free DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE questions. Unlock DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.