Free Practice Snowflake COF-R02 Exam Questions 2026

Stay ahead with 100% Free SnowPro Core Recertification COF-R02 Dumps Practice Questions

Page: 1 / 67

Total 333 Questions | Updated On: Feb 21, 2026

Add To Cart

Question 1

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 2

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 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

How would you determine the size of the virtual warehouse used for a task?

A : Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution

B : Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

C : If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first

D : Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule

Answer: C

Question 5

Which of the following roles is recommended to be used to create and manage users and roles?

A : SYSADMIN

B : SECURITYADMIN

C : PUBLIC

D : ACCOUNTADMIN

Answer: B

Page: 1 / 67

Total 333 Questions | Updated On: Feb 21, 2026

Add To Cart