SnowPro Core Certification — Question 343

Which of the following are characteristics of schemas used in Snowflake? (Choose two.)

Answer options

• 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.

Correct answer: B, C

Explanation

The correct answers are B and C. A database can contain multiple schemas, allowing for better organization of data, and a schema indeed represents a logical grouping of database objects. Options A, D, and E are incorrect; a schema cannot contain databases, schemas are not contained within virtual warehouses, and tables cannot span multiple schemas.