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

Exam Databricks-Certified-Professional-Data-Engineer All Questions
Exam Databricks-Certified-Professional-Data-Engineer All Questions

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

Databricks Certification Databricks-Certified-Professional-Data-Engineer Question # 13 Topic 2 Discussion

Databricks-Certified-Professional-Data-Engineer Exam Topic 2 Question 13 Discussion:
Question #: 13
Topic #: 2

A CHECK constraint has been successfully added to the Delta table named activity_details using the following logic:

Databricks-Certified-Professional-Data-Engineer Question 13

A batch job is attempting to insert new records to the table, including a record where latitude = 45.50 and longitude = 212.67.

Which statement describes the outcome of this batch insert?


A.

The write will fail when the violating record is reached; any records previously processed will be recorded to the target table.


B.

The write will fail completely because of the constraint violation and no records will be inserted into the target table.


C.

The write will insert all records except those that violate the table constraints; the violating records will be recorded to a quarantine table.


D.

The write will include all records in the target table; any violations will be indicated in the boolean column named valid_coordinates.


E.

The write will insert all records except those that violate the table constraints; the violating records will be reported in a warning log.


Get Premium Databricks-Certified-Professional-Data-Engineer Questions

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.