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 19, 2025

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

What is the default file size when unloading data from Snowflake using the COPY command?

A : 5 MB

B : 8 GB

C : 16 MB

D : 32 MB

Answer: C

Question 3

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

A : Informatica

B : Power Bl

C : Adobe

D : Data Robot

Answer: D

Question 4

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

Question 5

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

A : The validation_mode option is used when creating an Internal Stage

B : validation_mode=return_all_errors is a parameter of the copy command

C : The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error

D : The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Answer: D

Page: 1 / 67

Total 333 Questions | Updated On: Feb 19, 2025

Add To Cart