Free Snowflake COF-R02 Exam Questions

Become Snowflake Certified with updated COF-R02 exam questions and correct answers

Page: 1 / 67

Total 333 Questions | Updated On: Nov 14, 2024

Add To Cart

Question 1

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 2

True or False: Loading data into Snowflake requires that source data files be no larger than 16MB.

A : True

B : False

Answer: B

Question 3

Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A : Schema Stage

B : User Stage

C : Database Stage

D : Table Stage

E : External Named Stage

F : Internal Named Stage

Answer: A

Question 4

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 5

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

Page: 1 / 67

Total 333 Questions | Updated On: Nov 14, 2024

Add To Cart