Free Snowflake COF-R02 Exam Dumps Questions & Answers


Exam Code/Number:	COF-R02Join the discussion
Exam Name:	SnowPro Core Recertification Exam
Certification:	Snowflake
Free Question Number:	332
Publish Date:	Oct 06, 2026
# of views:	2448
Rating 100%

Page: 1 / 67
Total 332 questions

Question 1

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A.7 days
B.24 hours
C.48 hours
D.30 days

Question 2

Which of the following can be executed/called with Snowpipe?

A.A single copy_into statement
B.A stored procedure
C.A single insert__into statement
D.A User Defined Function (UDF)

Question 3

A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

A.Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
B.The transient table version cannot be retrieved after 24 hours.
C.Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
D.Contact Snowflake Support to have the data retrieved from Fail-safe storage.

Question 4

What is the minimum Snowflake edition required to create a materialized view?

A.Virtual Private Snowflake Edition
B.Business Critical Edition
C.Enterprise Edition
D.Standard Edition

Question 5

True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

A.False
B.True