Practice COF-R02 Exam Online

Question 1

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

A : SYSADMIN

B : SECURITYADMIN

C : PUBLIC

D : ACCOUNTADMIN

Answer: B

Question 2

What happens when a virtual warehouse is resized?

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 3

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

A : The Pipe load history is reset to empty.

B : The REFRESH command is executed.

C : The stage will be purged.

D : The destination table is truncated.

Answer: B

Question 4

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

A : The ability to scale up warehouses

B : The use of warehouse auto scaling

C : The ability to resize warehouses

D : Use of multi-clustered warehouses

E : The use of warehouse indexing

Answer: B,D

Question 5

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

Name:	SnowPro Core Recertification
Exam Code:	COF-R02
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	333
Last Updated:	Apr 24, 2024

Snowflake COF-R02