Answer-first summary for fast verification
Answer: A database may contain one or more schemas., A schema represents a logical grouping of database objects.
The question asks for two characteristics of schemas in Snowflake. Option B is correct because in Snowflake's hierarchy, a database contains one or more schemas. Option C is correct because a schema logically groups related database objects like tables, views, and functions. Option A is incorrect as the relationship is reversed - databases contain schemas, not schemas containing databases. Option D is incorrect because schemas are not contained within virtual warehouses; warehouses provide compute resources independent of schema organization. Option E is incorrect because a table exists within a single schema and cannot span multiple schemas. The community discussion shows 100% consensus on BC with multiple users confirming this answer and referencing Snowflake documentation that supports these characteristics.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which of the following are characteristics of a schema 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 represents a logical grouping of database objects.
D
Each schema is contained within a virtual warehouse.
E
A table can span more than one schema.