SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 125


True or False: Snowflake enforces unique, primary key, and foreign key constraints during DML operations.

Show Answer
Correct Answer: B

Snowflake does not enforce unique, primary key, and foreign key constraints during DML operations. These constraints can be defined for documentation and design purposes but are not enforced by the system. Only the NOT NULL constraint is enforced. Thus, the correct answer is False.

Discussion

6 comments
Sign in to comment
BigDataBBOption: B
Jan 11, 2023

Snowflake supports defining and maintaining constraints, but does not enforce them, except for NOT NULL constraints, which are always enforced.

Sid460545Option: B
Jan 31, 2022

It doesn't enforce.. But Not null is

sdnv89Option: B
Nov 19, 2022

Only NOT NULL is enforced. https://docs.snowflake.com/en/sql-reference/constraints.html

MultiCloudIronManOption: B
Jul 14, 2023

Correct

_yyuktaOption: B
Feb 25, 2024

B false

Mallikharjuna452Option: B
Jul 19, 2024

B.False