Question 1

What Snowflake parameter is configured in the Query Processing layer?

Options :

A : The minimum and maximum serverless compute limits

B : The types of tables available in an account

C : The sizing of virtual warehouses

D : The minimum and maximum micro-partition limits

Answer: C

Question 2

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 3

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

Question 4

Which command will create a named internal stage?

Options :

A : CREATE @STAGE

B : CREATE NAMED STAGE

C : CREATE STAGE

D : CREATE INTERNAL STAGE

Answer: C

Question 5

What is the default Time Travel data retention period?

Options :

A : 45 days

B : 1 day

C : 7 days

D : 90 days

Answer: B

Free SOL-C01 Mock Exam – Practice Online Confidently