Answer-first summary for fast verification
Answer: A database consists of one or more schemas. A schema contains tables and views.
Option A is correct because it accurately describes Snowflake's object hierarchy: a database contains one or more schemas, and schemas contain tables and views. This aligns with Snowflake's documentation and the community consensus, where all comments unanimously select A with supporting references. Option B is incorrect because it reverses the database-schema relationship. Option C is incorrect for the same reversal and because warehouses are not contained within databases; they are separate compute resources. Option D is incorrect because warehouses are not part of the database object hierarchy; they exist independently.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
What is the hierarchical organization of database objects in Snowflake?
A
A database consists of one or more schemas. A schema contains tables and views.
B
A schema consists of one or more databases. A database contains tables and views.
C
A schema consists of one or more databases. A database contains tables, views, and warehouses.
D
A database consists of one of more schemas and warehouses. A schema contains tables and views.