Certified Data Engineer Professional Exam

Exam Certified Data Engineer Professional All QuestionsBrowse all questions from this exam

Question 145

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

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?

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

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

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

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

Correct Answer: B

A CHECK constraint enforces specific rules on the data entering a table. In this particular case, the constraint ensures that the latitude must be between -90 and 90 and that the longitude must be between -180 and 180. Since the record with latitude = 45.50 and longitude = 212.67 violates the longitude constraint, the entire batch insert will fail, and no records will be inserted into the target table. Constraints are designed to prevent any invalid data from entering the table, ensuring the integrity of the data.

Discussion

vexor3Option: B

B is correct