Practice COF-C02 Exam Online

Question 1

You have a medium-sized virtual warehouse for executing ad-hoc queries. Due to many queries concurrently executing at peak times, the queries start queuing. What is the best way to reduce queuing?

A : Kill all long-running queries

B : Create several Medium-sized virtual warehouses and redirect users to use different virtual warehouses.

C : Configure the virtual warehouse to be a multi-cluster virtual warehouse. The virtual warehouse scales out and back depending on the query demands.

D : Request users to spread their queries throughout the day.

Answer: C

Question 2

True or False: The COPY command can load data using a SELECT query.

A : True

B : False

Answer: A

Question 3

Which of the following can be executed/called with Snowpipe?

A : A User Defined Function (UDF)

B : A stored procedure

C : A single copy_into statement

D : A single insert__into statement

Answer: C

Question 4

When a database or a schema is cloned, which of the following objects will NOT be cloned?

A : Internal Snowflake Stages

B : External Tables

C : Permanent Tables

D : Snowpipes that point to an Internal Snowflake Stage

E : Transient Tables

Answer: A,B,D

Question 5

The expiry duration can be configured for which of the following URL types?

A : File URL

B : Pre-signed URL

C : (Correct)

D : Scoped URL

Answer: C

Name:	SnowPro Core Certification
Exam Code:	COF-C02
Certification:	SnowPro Certification
Vendor:	Snowflake
Total Questions:	1392
Last Updated:	Apr 24, 2024

Snowflake COF-C02