SOL-C01 practice question 13 of 30
How do databases, schemas, tables, and views interact in Snowflake's hierarchy? (Choose any 2 options)
Full set: 214 questionsSnowflake organizes data into a clear hierarchy: databases contain schemas, and schemas contain objects like tables and views. Tables are the primary objects for physically storing data, while views provide a way to represent data through a stored query, acting as virtual tables. This structure allows for logical organization and management of data and access control within an account.
A. A view cannot contain multiple databases. This inverts the organizational hierarchy; databases contain schemas, which in turn contain views.
D. Schemas do not manage network settings. Network policies are security features that are managed at the account level, not within individual schemas.
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
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
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…
