Free Snowflake COF-R02 Exam Questions

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

Page: 1 / 67

Total 333 Questions | Updated On: Mar 25, 2025

Add To Cart

Question 1

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A : Concurrency

B : Performance

Answer: A

Question 2

How would you determine the size of the virtual warehouse used for a task?

A : Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B : Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C : If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D : Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer: C

Question 3

Which of the following roles is recommended to be used to create and manage users and roles?

A : SYSADMIN

B : SECURITYADMIN

C : PUBLIC

D : ACCOUNTADMIN

Answer: B

Question 4

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

A : The validation_mode option is used when creating an Internal Stage

B : validation_mode=return_all_errors is a parameter of the copy command

C : The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D : The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: D

Question 5

Will data cached in a warehouse be lost when the warehouse is resized?

A : Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B : Yes. because the compute resource is replaced in its entirety with a new compute resource.

C : No. because the size of the cache is independent from the warehouse size

D : Yes. became the new compute resource will no longer have access to the cache encryption key

Answer: A

Page: 1 / 67

Total 333 Questions | Updated On: Mar 25, 2025

Add To Cart