SnowPro Core Certification — Question 363

Which constraint type is enforced in Snowflake from the ANSI SQL standard?

Answer options

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

Correct answer: D

Explanation

The NOT NULL constraint is enforced in Snowflake to ensure that a column cannot contain NULL values, adhering to the ANSI SQL standard. Unlike NOT NULL, constraints like UNIQUE, PRIMARY KEY, and FOREIGN KEY are not strictly enforced in Snowflake, as they serve primarily as informational and can be ignored during data loading.