Certified Data Engineer Professional Exam

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

Question 81

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 fail when the violating record is reached; any records previously processed will be recorded to the target table.

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.

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

Correct Answer: B

When inserting records into a Delta table with a CHECK constraint, if any record violates the constraint, the entire write operation will fail. This ensures the atomicity of the transaction, meaning that either all records are inserted, or none are inserted. In this case, the record with a longitude of 212.67 violates the constraint that longitude must be between -180 and 180 degrees. Hence, the entire batch insert will fail, and no records will be inserted into the target table.

Discussion

DileepvikramOption: B

B is the answer

sturcuOption: B

B is the answer

vctrhugoOption: B

In Delta Lake, when a batch job attempts to insert records into a table that has a CHECK constraint, if any record violates the constraint, the entire write operation fails. This is because Delta Lake enforces strong transactional guarantees, which means that either all changes in a transaction are saved, or none are.

aragorn_bregoOption: B

In systems that support atomic transactions, such as Delta Lake, when a batch operation encounters a record that violates a CHECK constraint, the entire operation fails, and no records are inserted, including those that do not violate the constraint. This is to ensure the atomicity of the transaction, meaning that either all the changes are committed, or none are, maintaining data integrity. The record with a longitude of 212.67 violates the constraint because longitude values must be between -180 and 180 degrees.

PearAppleOption: B

B is the ans

spaceexplorerOption: B

B is correct