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: Dec 16, 2025

Add To Cart

Question 1

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 2

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

A : Materialized views

B : Sequences

C : Procedures

D : Tables

E : Secure User Defined Functions (UDFs)

Answer: A,D

Question 3

What happens when a virtual warehouse is resized?

A : When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B : When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C : The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D : Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Question 4

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A : The ability to scale up warehouses

B : The use of warehouse auto scaling

C : The ability to resize warehouses

D : Use of multi-clustered warehouses

E : The use of warehouse indexing

Answer: B,D

Question 5

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A : The Pipe load history is reset to empty.

B : The REFRESH command is executed.

C : The stage will be purged.

D : The destination table is truncated.

Answer: B

Page: 1 / 67

Total 333 Questions | Updated On: Dec 16, 2025

Add To Cart