Pre-Summer Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: validbest

Discussions
  1. Home
  2. Discussions
  3. Databricks
  4. Databricks
  5. Databricks-Certified-Data-Engineer-Associate Discussions
  6. Databricks-Certified-Data-Engineer-Associate Exam Topic 6 Question 50 Discussion
 Databricks Discussions
Exam Databricks-Certified-Data-Engineer-Associate All Questions
Exam Databricks-Certified-Data-Engineer-Associate All Questions

View all questions & answers for the Databricks-Certified-Data-Engineer-Associate exam

Go to Exam

Databricks Databricks-Certified-Data-Engineer-Associate Question # 50 Topic 6 Discussion

Databricks-Certified-Data-Engineer-Associate Exam Topic 6 Question 50 Discussion:
Question #: 50
Topic #: 6

Identify the impact of ON VIOLATION DROP ROW and ON VIOLATION FAIL UPDATE for a constraint violation.

A data engineer has created an ETL pipeline using Delta Live table to manage their company travel reimbursement detail, they want to ensure that the if the location details has not been provided by the employee, the pipeline needs to be terminated.

How can the scenario be implemented?
A.

CONSTRAINT valid_location EXPECT (location = NULL)

B.

CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL UPDATE

C.

CONSTRAINT valid_location EXPECT (location != NULL) ON DROP ROW

D.

CONSTRAINT valid_location EXPECT (location != NULL) ON VIOLATION FAIL

Get Premium Databricks-Certified-Data-Engineer-Associate Questions
Actual exam question for Databricks Databricks-Certified-Data-Engineer-Associate exam by Kai8978 at May 3, 2026, 4:52:07 PM

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.

Submit