Question 1

What does Snowflake attempt to do if any of the compute resources for a virtual warehouse fail to provision during start-up?

Options :

A : Repair the failed resources.

B : Restart failed resources.

C : Queue the failed resources

D : Provision the failed resources

Answer: B

Question 2

While unloading data into a stage, how can the user ensure that the output will be a single file?

Options :

A : Use the copy option files=single.

B : Use the COPY Option SINGLE=TRUE .

C : Use the get option SINGLE-TRUE.

D : Use the GET option FILES-SINGLE.

Answer: B

Question 3

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

Options :

A : Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B : All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C : The ACCOUNTADMIN role must be granted to only one user.

D : Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E : All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Answer: A,D

Question 4

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 5

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

Higher Test Marks with Free Online COF-C02 Exam Practice