Question 1

Which types of stages are supported in Snowflake for data loading and unloading? (Select TWO)

Options :

A : Managed Stages

B : Permanent Stages

C : Temporary Stages

D : External Stages

E : Internal Stages

Answer: D,E

Question 2

What types of privileges can be granted to a role in Snowflake?

Options :

A : INSERT

B : SELECT

C : MONITOR

D : All of them

Answer: D

Question 3

What is the SHOW GRANTS SQL command primarily used for?

Options :

A : To view the history of data loads.

B : To display all privileges granted to a role or user.

C : To list all active users in the account.

D : To show current warehouse credit usage.

Answer: B

Question 4

What is the default Time Travel data retention period?

Options :

A : 45 days

B : 1 day

C : 7 days

D : 90 days

Answer: B

Question 5

What parameter is used to define how long Time Travel can be used to access a table?

Options :

A : DATE_OUTPUT_FORMAT

B : DATA_RETENTION_TIME_IN_DAYS

C : TIMEZONE

D : USE_CACHED_RESULT

Answer: B

Free SOL-C01 Mock Exam – Practice Online Confidently