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: Sep 11, 2025

Add To Cart

Question 1

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 2

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 3

Which TABLE function helps to convert semi-structured data to a relational representation?

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Question 4

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A : Roles

B : Databases

C : Warehouses

D : Users

E : Accounts

Answer: A,D

Question 5

A user created a new worksheet within the Snowsight Ul and wants to share this with teammates

How can this worksheet be shared?

A : Create a zero-copy clone of the worksheet and grant permissions to teammates

B : Create a private Data Exchange so that any teammate can use the worksheet

C : Share the worksheet with teammates within Snowsight

D : Create a database and grant all permissions to teammates

Answer: C

Page: 1 / 67

Total 333 Questions | Updated On: Sep 11, 2025

Add To Cart