What happens when a data engineer attempts to add a NOT NULL constraint to a Delta table's column that already contains null values, and then tries to insert another null value into that column?

Real Exam

The ALTER TABLE command fails, but new NULL values cannot be added to the location column.

15.6%

The ALTER TABLE command returns an error, allowing new NULL values to be added to the location column.

55.8%

The ALTER TABLE command executes successfully, yet new NULL values can still be added to the location column.

7.8%

The ALTER TABLE command is successful, and no new NULL values will be accepted in the location column.

11.7%

The ALTER TABLE command succeeds, and all previous and new NULL values are dropped.

9.1%

Databricks Certified Data Engineer - Professional