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: Jan 07, 2025

Add To Cart

Question 1

Which command sets the Virtual Warehouse for a session?

A : COPY WAREHOUSE FROM <>;

B : SET WAREHOUSE = <>;

C : USE WAREHOUSE <>;

D : USE VIRTUAL_WAREHOUSE <>;

Answer: C

Question 2

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

A : INSERT

B : PUT

C : GET

D : COPY

Answer: D

Question 3

Network policies can be applied to which of the following Snowflake objects? (Choose two.)

A : Roles

B : Databases

C : Warehouses

D : Users

E : Accounts

Answer: A,D

Question 4

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

A : Named Stage

B : User Stage

C : Table Stage

D : Schema Stage

Answer: A,B,C

Question 5

What features does Snowflake Time Travel enable?

A : Querying data-related objects that were created within the past 365 days

B : Restoring data-related objects that have been deleted within the past 90 days

C : Conducting point-in-time analysis for Bl reporting

D : Analyzing data usage/manipulation over all periods of time

Answer: B

Page: 1 / 67

Total 333 Questions | Updated On: Jan 07, 2025

Add To Cart