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

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 3

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

A : Concurrency

B : Performance

Answer: A

Question 4

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

Question 5

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with

which administrative privilege?

A : USERADMIN

B : PUBLIC

C : ORGADMIN

D : SYSADMIN

Answer: D

Page: 1 / 67

Total 333 Questions | Updated On: Dec 07, 2022

Add To Cart