Discuss Snowflake ARA-R01 Exam Topic 4 Question 44

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

Suggested Answer: A, E, F

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.

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

Get Premium ARA-R01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

21 comments · newest first

Glory 1 month ago

I’m confused about D. Is it really part of the account?

Kerrie 1 month ago

I feel like it’s A, E, and F for sure.

Clorinda 2 months ago

A and E make sense, but what about F?

Gilbert 2 months ago

I’m leaning towards A, D, and E.

Minna 2 months ago

I think A, E, and F are correct.

Tashia 2 months ago

This question is tricky!

Rikki 2 months ago

I feel like B and C are too specific.

India 2 months ago

No, it’s a core object in the account.

Dean 3 months ago

Why F? Isn't it just for processing?

India 3 months ago

I would go with A, E, and F.

Johnetta 3 months ago

I think it's about understanding the hierarchy.

Ezekiel 3 months ago

This question is tricky.

Carisa 3 months ago

I always mix up Tables and Stages, but I think those aren't direct.

Thurman 3 months ago

Wait, are you sure about the Warehouse being a direct object?

Tran 4 months ago

Definitely agree with A, E, and F!

Jodi 5 months ago

I thought Schemas were part of the account too?

Nicolette 5 months ago

A) Database, E) Role, F) Warehouse are correct!

Vicki 6 months ago

I’m confused about Stage; I thought it was more of a storage object rather than something that belongs directly to the account.

Beckie 6 months ago

I feel like Schema and Table are more related to the database level, so they might not belong directly to the account.

Karima 6 months ago

I remember practicing a question like this, and I think Database and Role were definitely part of the answer.

Melissa 6 months ago

I think the answer might include Role and Warehouse, but I'm not entirely sure about the third one.

Snowflake ARA-R01 Exam - Topic 4 Question 44 Discussion