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: Oct 29, 2025

Add To Cart

Question 1

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A : True

B : False

Answer: B

Question 2

What is the default file size when unloading data from Snowflake using the COPY command?

A : 5 MB

B : 8 GB

C : 16 MB

D : 32 MB

Answer: C

Question 3

When loading data into Snowflake, how should the data be organized?

A : Into single files with 100-250 MB of compressed data per file

B : Into single files with 1-100 MB of compressed data per file

C : Into files of maximum size of 1 GB of compressed data per file

D : Into files of maximum size of 4 GB of compressed data per file

Answer: A

Question 4

Select the different types of Internal Stages: (Choose three.)

A : Named Stage

B : User Stage

C : Table Stage

D : Schema Stage

Answer: A,B,C

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: Oct 29, 2025

Add To Cart