SOL-C01 practice question 10 of 30
What can a schema in Snowflake contain? (Choose any 3 options)
Full set: 214 questionsIn 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.
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.
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
Keep practicing
Take the free SOL-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other SOL-C01 practice questions
- Question 1Which Snowflake object is a logical container for schemas and other database objects?
- Question 2How can Python variable substitution be performed in Snowflake notebooks?
- Question 3Which SQL command is commonly used to load structured data from a stage into a Snowflake …
- Question 4Which command can be used to query the Information Schema in Snowflake to retrieve a list…
- Question 5Which command is synonymous with the LIST command in Snowflake?
- Question 6Which of the following data format supported to unload semi-structured data from Snowflak…
