Question 1

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 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 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

What are the benefits of using the Snowsight data loading interface? (Select TWO).

Options :

A : It creates permanent file formats that can be used to load data in the future.

B : It allows a user to insert the records of a supported file into a table.

C : It will try to detect data types.

D : It allows a user to optimize data loading into a table.

E : It lets a user merge file rows into the table records.

Answer: B,C

Question 5

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

Free SOL-C01 Mock Exam – Practice Online Confidently