The data engineering team has a Delta table named ‘users’ with a recently added CHECK constraint to ensure age values are positive. An attempt to insert a batch of records, some with negative ages, failed due to constraint violation. What was the outcome of this batch insert?

Real Exam

Only records processed before reaching the first violating record have been inserted in the table.

8.2%

All records except those that violate the table constraint have been inserted in the table. Records violating the constraint have been ignored.

14.6%

None of the records have been inserted into the table.

50.6%

All records except those that violate the table constraint have been inserted in the table. Records violating the constraint have been recorded into the transaction log.

14.6%

The outcome depends on the action defined using the ON VIOLATION clause in the table properties.

12.0%

Databricks Certified Data Engineer - Professional

Get started today

Comments

The data engineering team has a Delta table named ‘users’ with a recently added CHECK constraint to ensure age values are positive. An attempt to insert a batch of records, some with negative ages, failed due to constraint violation. What was the outcome of this batch insert?