Question 1

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

Options :

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

What is a responsibility of Snowflake's virtual warehouses?

Options :

A : Infrastructure management

B : Metadata management

C : Query execution

D : Query parsing and optimization

E : Management of the storage layer

Answer: C

Question 3

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Options :

A : Materialized views

B : Sequences

C : Procedures

D : Tables

E : Secure User Defined Functions (UDFs)

Answer: A,D

Question 4

Which of the following statements are true of Snowflake releases: (Choose two.)

Options :

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 newer

version

D :

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which

the

system will be unavailable and customer is upgraded

Answer: A,C

Question 5

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

Options :

A : SYSADMIN

B : SECURITYADMIN

C : PUBLIC

D : ACCOUNTADMIN

Answer: B

Smartly Prepare Exam with Free Online COF-R02 Practice Test

Buying Options: