Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).

A securable object is an entity to which access can be granted in Snowflake. Securable objects

include databases, schemas, tables, views, stages, pipes, functions, procedures, sequences, tasks,

streams, roles, warehouses, and shares1.

The Snowflake object hierarchy is a logical structure that organizes the securable objects in a nested

manner. The top-most container is the account, which contains all the databases, roles, and

warehouses for the customer organization. Each database contains schemas, which in turn contain

tables, views, stages, pipes, functions, procedures, sequences, tasks, and streams. Each role can be

granted privileges on other roles or securable objects. Each warehouse can be used to execute

queries on securable objects2.

Based on the Snowflake object hierarchy, the securable objects that belong directly to a Snowflake

account are databases, roles, and warehouses. These objects are created and managed at the

account level, and do not depend on any other securable object. The other options are not correct

because:

Schemas belong to databases, not to accounts. A schema must be created within an existing

database3.

Tables belong to schemas, not to accounts. A table must be created within an existing schema4.

Stages belong to schemas or tables, not to accounts. A stage must be created within an existing

schema or table.

Reference:

1: Overview of Access Control | Snowflake Documentation

2: Securable Objects | Snowflake Documentation

3: CREATE SCHEMA | Snowflake Documentation

4: CREATE TABLE | Snowflake Documentation

[5]: CREATE STAGE | Snowflake Documentation