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: Dec 07, 2022

Add To Cart

Question 1

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A : Snowflake leverages a Role-Based Access Control (RBAC) model.

B : Snowflake requires a user to configure an IAM user to connect to the database.

C : All data in Snowflake is encrypted.

D : Snowflake can run within a user's own Virtual Private Cloud (VPC).

E : All data in Snowflake is compressed.

Answer: A,D

Question 2

Will data cached in a warehouse be lost when the warehouse is resized?

A : Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B : Yes. because the compute resource is replaced in its entirety with a new compute resource.

C : No. because the size of the cache is independent from the warehouse size

D : Yes. became the new compute resource will no longer have access to the cache encryption key

Answer: A

Question 3

Which type of table corresponds to a single Snowflake session?

A : Temporary

B : Translent

C : Provisional

D : Permanent

Answer: A

Question 4

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 5

What is a responsibility of Snowflake's virtual warehouses?

A : Infrastructure management

B : Metadata management

C : Query execution

D : Query parsing and optimization

E : Management of the storage layer

Answer: C

Page: 1 / 67

Total 333 Questions | Updated On: Dec 07, 2022

Add To Cart