SnowPro Core Certification — Question 667

Which constraint is enforced in Snowflake?

Answer options

• A. FOREIGN KEY
• B. NOT NULL
• C. PRIMARY KEY
• D. UNIQUE KEY

Correct answer: B

Explanation

The NOT NULL constraint is enforced in Snowflake to ensure that a column cannot have a NULL value. While FOREIGN KEY, PRIMARY KEY, and UNIQUE KEY constraints can be defined, they are not enforced by Snowflake, making NOT NULL the only enforced constraint.