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: Jun 05, 2025

Add To Cart

Question 1

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with

which administrative privilege?

A : USERADMIN

B : PUBLIC

C : ORGADMIN

D : SYSADMIN

Answer: D

Question 2

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 3

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 4

Which command sets the Virtual Warehouse for a session?

A : COPY WAREHOUSE FROM <>;

B : SET WAREHOUSE = <>;

C : USE WAREHOUSE <>;

D : USE VIRTUAL_WAREHOUSE <>;

Answer: C

Question 5

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

Page: 1 / 67

Total 333 Questions | Updated On: Jun 05, 2025

Add To Cart