Question 1

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

Options :

A : Concurrency

B : Performance

Answer: A

Question 2

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

Options :

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 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

Question 4

What happens when a virtual warehouse is resized?

Options :

A : When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

B : When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

C : The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

D : Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Question 5

A user created a new worksheet within the Snowsight Ul and wants to share this with teammatesHow can this worksheet be shared?

Options :

A : Create a zero-copy clone of the worksheet and grant permissions to teammates

B : Create a private Data Exchange so that any teammate can use the worksheet

C : Share the worksheet with teammates within Snowsight

D : Create a database and grant all permissions to teammates

Answer: C

Free COF-R02 Mock Exam – Practice Online Confidently

Buying Options: