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 questions
Answer options
A: A view can contain multiple databases
B: Tables and views store data and provide virtual tables Correct answer
C: A database contains schemas, which contain tables and views Correct answer
D: Schemas manage network settings
Correct Answer:
B. Tables and views store data and provide virtual tables; C. A database contains schemas, which contain tables and views
Explanation

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

Why Incorrect

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.

References

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

Scroll to Top