SOL-C01 practice question 1 of 30
Which Snowflake object is a logical container for schemas and other database objects?
Full set: 214 questionsIn 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.
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.
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."
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 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…
- Question 7Which of the following file formats can be processed by the PARSE_DOCUMENT function?
