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: Feb 18, 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 command should be used to load data from a file, located in an external stage, into a table in Snowflake?

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 3

What features does Snowflake Time Travel enable?

A : Querying data-related objects that were created within the past 365 days

B : Restoring data-related objects that have been deleted within the past 90 days

C : Conducting point-in-time analysis for Bl reporting

D : Analyzing data usage/manipulation over all periods of time

Answer: B

Question 4

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A : Roles

B : Databases

C : Warehouses

D : Users

E : Accounts

Answer: A,D

Question 5

Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A : A directory table is a separate database object.

B : Directory tables store data file metadata.

C : A directory table will be automatically added to a stage.

D : Directory tables do not have their own grantable privileges.

E : Directory table data can not be refreshed manually.

Answer: B,D

Page: 1 / 67

Total 333 Questions | Updated On: Feb 18, 2026

Add To Cart