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

Add To Cart

Question 1

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 2

A materialized view should be created when which of the following occurs? (Choose two.)

A : There is minimal cost associated with running the query.

B : The query consumes many compute resources every time it runs.

C : The base table gets updated frequently.

D : The query is highly optimized and does not consume many compute resources.

E : The results of the query do not change often and are used frequently.

Answer: A,C

Question 3

Which of the following statements are true of Snowflake releases: (Choose two.)

A : They happen approximately weekly

B : They roll up and release approximately monthly, but customers can request early release application

C : During a release, new customer requests/queries/connections transparently move over to the newerversion

D : A customer is assigned a 30 minute window (that can be moved anytime within a week) during whichthesystem will be unavailable and customer is upgraded

Answer: A,C

Question 4

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 5

What is a responsibility of Snowflake's virtual warehouses?

A : Infrastructure management

B : Metadata management

C : Query execution

D : Query parsing and optimization

E : Management of the storage layer

Answer: C

Page: 1 / 67

Total 333 Questions | Updated On: Jul 29, 2025

Add To Cart