Question 1

Which function determines the kind of value stored in a VARIANT column?

Options :

A : CHECK_JSON

B : IS_ARRAY

C : IS_JSON

D : TYPEOF

Answer: D

Question 2

How can a Snowflake user post-process the result of SHOW FILE FORMATS?

Options :

A : Use the RESULT_SCAN function.

B : Create a CURSOR for the command.

C : Put it in the FROM clause in brackets.

D : Assign the command to RESULTSET.

Answer: A

Question 3

What is the recommended file sizing for data loading using Snowpipe?

Options :

A : A compressed file size greater than 100 MB, and up to 250 MB

B : A compressed file size greater than 100 GB, and up to 250 GB

C : A compressed file size greater than 10 MB, and up to 100 MB

D : A compressed file size greater than 1 GB, and up to 2 GB

Answer: C

Question 4

How long is the Fail-safe period for temporary and transient tables?

Options :

A : There is no Fail-safe period for these tables.

B : 1 day

C : 7 days

D : 31 days

E : 90 days

Answer: A

Question 5

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Options :

A :

B : Specify the TEMPORARY option when creating the file format.

C :

D : Use the REMOVE command after the load completes.

E : Use the DELETE LOAD HISTORY command after the load completes.

Answer: C,D