
Explanation:
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.
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.