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?
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.
B is the answer
B is the answer
B is the ans
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.
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.
B is correct