SnowPro Advanced: Architect — Question 59

What is a valid object hierarchy when building a Snowflake environment?

Answer options

• A. Account --> Database --> Schema --> Warehouse
• B. Organization --> Account --> Database --> Schema --> Stage
• C. Account --> Schema > Table --> Stage
• D. Organization --> Account --> Stage --> Table --> View

Correct answer: B

Explanation

The correct answer is B, as it accurately represents the hierarchy in Snowflake where an Organization contains Accounts, which then include Databases, followed by Schemas and finally Stages. The other options do not reflect the correct structure recognized in Snowflake's architecture, with options A and C misrepresenting the relationships and option D incorrectly placing Stage before Table.