Question 1

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

Options :

A : Database

B : Schema

C : Table

D : Stage

E : Role

F : Warehouse

Answer: A,E,F

Question 2

Which of the below commands will use warehouse credits?

Options :

A : SHOW TABLES LIKE 'SNOWFL%';

B : SELECT MAX(FLAKE_ID) FROM SNOWFLAKE;

C : SELECT COUNT(*) FROM SNOWFLAKE;

D : SELECT COUNT(FLAKE_ID) FROM SNOWFLAKE GROUP BY FLAKE_ID;

Answer: B,C,D

Question 3

Which system functions does Snowflake provide to monitor clustering information within a table (Choose two.)

Options :

A : SYSTEM$CLUSTERING_INFORMATION

B : SYSTEM$CLUSTERING_USAGE

C : SYSTEM$CLUSTERING_DEPTH

D : SYSTEM$CLUSTERING_KEYS

E : SYSTEM$CLUSTERING_PERCENT

Answer: A,C

Question 4

When activating Tri-Secret Secure in a hierarchical encryption model in a Snowflake account, at what level is the customer-managed key used?

Options :

A : At the root level (HSM)

B : At the account level (AMK)

C : At the table level (TMK)

D : At the micro-partition level

Answer: B

Question 5

What is a characteristic of event notifications in Snowpipe?

Options :

A : The load history is stored In the metadata of the target table.

B : Notifications identify the cloud storage event and the actual data in the files.

C : Snowflake can process all older notifications when a paused pipe Is resumed.

D : When a pipe Is paused, event messages received for the pipe enter a limited retention period.

Answer: D

Free ARA-R01 Mock Exam – Practice Online Confidently