Question 1

By default, which role can create resource monitors?

Options :

A : ACCOUNTADMIN

B : SECURITYADMIN

C : SYSADMIN

D : USERADMIN

Answer: A

Question 2

What computer language can be selected when creating User-Defined Functions (UDFs) using the Snowpark API?

Options :

A : Swift

B : JavaScript

C : Python

D : SQL

Answer: C

Question 3

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

Options :

A : USAGE

B : OPERATE

C : MONITOR

D : MODIFY

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

Question 5

Which of the following are characteristics of security in Snowflake?

Options :

A : Account and user authentication is only available with the Snowflake Business Critical edition.

B : Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C : Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D : Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer: C

Free COF-C02 Mock Exam – Practice Online Confidently

Buying Options: