Answer-first summary for fast verification
Answer: A Database may contain one or more Schemas, A Schema is a logical grouping of Database Objects
Based on Snowflake's data organization hierarchy and the community consensus (78% selected BC with multiple upvoted comments supporting this choice), options B and C are correct. Option B ('A Database may contain one or more Schemas') accurately reflects Snowflake's structure where databases are containers for schemas. Option C ('A Schema is a logical grouping of Database Objects') correctly defines schemas as logical containers for tables, views, and other database objects. Option A is incorrect because schemas do not contain databases - the relationship is reversed. Option D is incorrect because schemas are contained within databases, not warehouses; warehouses in Snowflake are compute resources that execute queries, not storage containers for schemas.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which of the following statements are true about schemas in Snowflake? (Choose two.)
A
A Schema may contain one or more Databases
B
A Database may contain one or more Schemas
C
A Schema is a logical grouping of Database Objects
D
Each Schema is contained within a Warehouse
No comments yet.