SOL-C01 practice question 10 of 30

What can a schema in Snowflake contain? (Choose any 3 options)

Full set: 214 questions
Answer options
A: Views Correct answer
B: Tables Correct answer
C: Stage Correct answer
D: Virtual warehouses
Correct Answer:
A. Views; B. Tables; C. Stage
Explanation

In Snowflake's object hierarchy, a schema is a logical grouping of database objects. A schema belongs to a single database. The objects that can be contained within a schema include tables, views, and named stages. Virtual warehouses are compute resources and are considered account-level objects, meaning they are not contained within specific schemas or databases but can be used to access objects within them.

Why Incorrect

D. Virtual warehouses are compute resources defined at the account level, not within a schema. They are used to execute queries on data contained in schema objects.

References

Snowflake Documentation. (n.d.). Schemas. In SQL Reference > Data Definition Language (DDL) > Schema DDL. Retrieved from https://docs.snowflake.com/en/sql-reference/ddl-schema

Snowflake Documentation. (n.d.). Overview of Databases, Tables and Views. In Introduction to Snowflake. Retrieved from https://docs.snowflake.com/en/user-guide/tables-databases-views-overview

Snowflake Documentation. (n.d.). Understanding Snowflake's Object Hierarchy. In Introduction to Snowflake > Key Concepts & Architecture. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts#understanding-snowflake-s-object-hierarchy

Scroll to Top