SnowPro Core Certification — Question 582

How is the hierarchy of database objects organized in Snowflake?

Answer options

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

Correct answer: A

Explanation

The correct answer is A because it accurately describes that a database is made up of multiple schemas, which in turn contain tables and views. The other options incorrectly define the relationships between databases and schemas, leading to misunderstandings about their structure in Snowflake.