Power Up Your Study Prep: Black Friday 75% Discount! Use coupon code below to save! - Ends in 0d 00h 00m 00s - Coupon code: big75certs

Note! Following COF-R02 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

Verified By IT Certified Experts

CertsTopics.com Certified Safe Files

Up-To-Date Exam Study Material

99.5% High Success Pass Rate

100% Accurate Answers

Instant Downloads

Exam Questions And Answers PDF

Try Demo Before You Buy

Certification Exams with Helpful Questions And Answers

What our customers are saying

Fiji Islands certstopics Fiji Islands
Ethan
Sep 4, 2026
I appeared in the Snowflake COF-R02 exam and studied from certstopic which provides all the mock tests and exam dumps. I got 905/1000 marks.

SnowPro Core Recertification Exam Questions and Answers

Question 1

When is the result set cache no longer available? (Select TWO)

Options:

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Buy Now
Question 2

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

Options:

A.

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

Question 3

Which of the following objects can be cloned? (Choose four.)

Options:

A.

Tables

B.

Named File Formats

C.

Schemas

D.

Shares

E.

Databases

F.

Users