Which of the following statements are true regarding schemas in Snowflake? (Select TWO)

Question

Options

• AA schema can only contain tables and views.
• BSchemas are logical groupings of database objects within a database.
• CSchemas must be explicitly created using the `CREATE SCHEMA' command; Snowflake does not
• DA database can contain multiple schemas, allowing for logical separation of data and objects.
• ESchemas do not provide any security benefits; role-based access control must be configured on

• A
  2% (1)
• B
  94% (49)
• E
  4% (2)

Explanation

B and D are correct because schemas in Snowflake are logical containers within a database that group related objects (tables, views, stages, sequences, stored procedures, UDFs, etc.), and a single database can hold multiple schemas - enabling clean separation of concerns like RAW, STAGING, and ANALYTICS layers.

Why the distractors fail:

• A is wrong because schemas can contain far more than tables and views - stages, file formats, sequences, tasks, streams, and more are all schema-level objects.
• C is wrong because Snowflake auto-creates two schemas (PUBLIC and INFORMATION_SCHEMA) in every new database without any explicit CREATE SCHEMA call.
• E is wrong because schemas do provide a security boundary - you can GRANT USAGE ON SCHEMA to roles, making schema-level access control a real and commonly used pattern.

Memory tip: Think of the Snowflake hierarchy as Account → Database → Schema → Object. Schemas sit in the middle as an organizational and security layer - just like folders on a filesystem that can have their own permissions.

No community discussion yet for this question.