Free Online Snowflake COF-R02 Practice Test

Prepare Your Snowflake COF-R02 Exam Questions with Free online COF-R02 Practice Test. Get Brilliant SnowPro Core Recertification Exam Results with Valid COF R02 Exam Dumps.

Page: 1 / 67

Total 333 Questions | Updated On: May 14, 2024

Add To Cart

Question 1

The first user assigned to a new account, ACCOUNTADMIN, should create at least one additional user with

which administrative privilege?

A : USERADMIN

B : PUBLIC

C : ORGADMIN

D : SYSADMIN

Answer: D

Question 2

Which TABLE function helps to convert semi-structured data to a relational representation?

A : CHECK_JSON

B : TO_JSON

C : FLATTEN

D : PARSE_JSON

Answer: D

Question 3

What is the default file size when unloading data from Snowflake using the COPY command?

A : 5 MB

B : 8 GB

C : 16 MB

D : 32 MB

Answer: C

Question 4

What is a responsibility of Snowflake's virtual warehouses?

A : Infrastructure management

B : Metadata management

C : Query execution

D : Query parsing and optimization

E : Management of the storage layer

Answer: C

Question 5

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

Page: 1 / 67

Total 333 Questions | Updated On: May 14, 2024

Add To Cart