To ensure the successful execution of the command intended to add a check constraint on the `routes` table, which of the following modifications would you recommend? The original command is: `ALTER TABLE routes ADD CHECK (distance > 0)`.

Real Exam

Replace the CHECK keyword with CONSTRAINT.

19.1%

Remove the TABLE keyword from the command.

3.2%

Change ADD CHECK to ADD CONSTRAINT CHECK.

17.0%

Eliminate the brackets around the condition, changing (distance > 0) to distance > 0.

7.4%

Modify ADD CHECK to ADD CONSTRAINT constraint_name CHECK._

53.2%

Databricks Certified Data Engineer - Professional