SOL-C01 practice question 1 of 30

Which Snowflake object is a logical container for schemas and other database objects?

Full set: 214 questions
Answer options
A: Schema
B: View
C: Table
D: Database Correct answer
Correct Answer:
D. Database
Explanation

In Snowflake's object hierarchy, a database serves as a primary organizational unit. It acts as a logical container for schemas. Each schema, in turn, contains other database objects such as tables, views, stored procedures, and user-defined functions. This hierarchical structure allows for the logical grouping and management of related data and objects within a single, overarching container. All objects within a database share a common access control framework.

Why Incorrect

A. Schema: A schema is a container for objects like tables and views, but it is contained within a database, not the other way around.
B. View: A view is a database object that represents a saved query; it does not contain other objects.
C. Table: A table is a fundamental database object that stores data in rows and columns; it does not contain other objects.

References

1. Snowflake Documentation. (n.d.). Databases, Tables & Views - An Overview. In Databases. Retrieved from https://docs.snowflake.com/en/sql-reference/ddl-database. "Databases are the logical containers for all of the schemas, tables, views, and other objects you create."

2. Snowflake Documentation. (n.d.). Understanding Snowflake's Object Hierarchy. In Introduction to Snowflake. Retrieved from https://docs.snowflake.com/en/user-guide/intro-key-concepts#object-hierarchy. "A database is a logical grouping of schemas. Each schema is a logical grouping of database objects, such as tables and views."

Scroll to Top