True or False: After a key has been defined on a table, no additional administration is required?

• A. True
• B. False
• C. Depends on table
• D. Not sure

Answer: (A)

In Snowflake, constraints such as primary keys and unique keys are not enforced by the system. They exist as metadata to describe the table and can aid in query planning, but Snowflake does not automatically enforce them or require ongoing maintenance to enforce them. Therefore, once you define a key on a table, there’s no automatic enforcement or dedicated administration to maintain that constraint. If you need to guarantee data integrity, you must implement validation in your ETL processes or add separate checks outside the database. So this statement is considered true.