Free Snowflake COF-C02 Exam Questions

Become Snowflake Certified with updated COF-C02 exam questions and correct answers

Page: 1 / 194

Total 970 Questions | Updated On: Apr 02, 2026

Add To Cart

Question 1

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

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 2

How can unstructured data be processed in a Snowflake stage? (Select TWO).

A : Use a SQL procedure.

B : Use external functions.

C : Use a C# procedure.

D : Implement a Golang (Go) User-Defined Function (UDF).

E : Implement a Python User-Defined Function (UDF).

Answer: B

Question 3

As part of a data processing pipeline, you are required to store data in an interim table. The subsequent processes then use the table in the pipeline. The data is deleted and reloaded every time the pipeline is executed. You are required to minimize data storage costs. Which type of table will you create?

A : Transient

B : Permanent

C : External

D : Temporary

Answer: A

Question 4

The VALIDATE table function has which parameter as an input argument for a Snowflake user?

A : Last_QUERY_ID

B : CURRENT_STATEMENT

C : UUID_STRING

D : JOB_ID

Answer: C

Question 5

Which Query Profile operator is considered a DML operator?

A : ExternalScan

B : Flatten

C : Merge

D : Sort

Answer: C

Page: 1 / 194

Total 970 Questions | Updated On: Apr 02, 2026

Add To Cart