Which of the following statements describes a schema in Snowflake?

The correct answer is A. A logical grouping of objects that belongs to a single database. In Snowflake's three-level hierarchy (Organization > Account > Database > Schema > Objects), a schema is a logical namespace that lives inside exactly one database and groups related database objects such as tables, views, stages, sequences, and stored procedures. A schema…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AA logical grouping of objects that belongs to a single database
BA logical grouping of objects that belongs to multiple databases
CA named Snowflake object that includes all the information required to share a database
DA uniquely identified Snowflake account within a business entity

How the community answered

(27 responses)

A
93% (25)
C
4% (1)
D
4% (1)

Explanation

In Snowflake's three-level hierarchy (Organization > Account > Database > Schema > Objects), a schema is a logical namespace that lives inside exactly one database and groups related database objects such as tables, views, stages, sequences, and stored procedures. A schema cannot span multiple databases. Option B is incorrect because a schema belongs to one database only. Option C describes a Share object. Option D describes an Account.

Topics

#Schema#Database objects#Snowflake architecture

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice