Question 1

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

Options :

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 2

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 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 is the default file size when unloading data from Snowflake using the COPY command?

Options :

A : 5 MB

B : 8 GB

C : 16 MB

D : 32 MB

Answer: C

Question 5

Select the different types of Internal Stages: (Choose three.)

Options :

A : Named Stage

B : User Stage

C : Table Stage

D : Schema Stage

Answer: A,B,C

Higher Test Marks with Free Online COF-R02 Exam Practice

Buying Options: