ARA-C01 practice question 3 of 25
Based on the Snowflake object hierarchy, what securable objects belong directly to a Snowflake account? (Select THREE).
Full set: 162 questionsA 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
Keep practicing
Take the free ARA-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other ARA-C01 practice questions
- Question 1An Architect needs to improve the performance of reports that pull data from multiple Sno…
- Question 2What is a characteristic of event notifications in Snowpipe?
- Question 4An Architect has designed a data pipeline that Is receiving small CSV files from multiple…
- Question 5Which data models can be used when modeling tables in a Snowflake environment? (Select TH…
- Question 6A user has the appropriate privilege to see unmasked data in a column. If the user loads …
- Question 7A company is using Snowflake in Azure in the Netherlands. The company analyst team also h…
