Weekend Sale Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

SnowPro Core Certification COF-C02 Full Course Free

Page: 41 / 45
Total 605 questions

SnowPro Core Certification Exam (COF-C02) Questions and Answers

Question 161

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

Options:

A.

4 minutes

B.

10 minutes

C.

14 minutes

D.

24 minutes

Question 162

Which of the following is a data tokenization integration partner?

Options:

A.

Protegrity

B.

Tableau

C.

DBeaver

D.

SAP

Question 163

The Snowflake Cloud Data Platform is described as having which of the following architectures?

Options:

A.

Shared-disk

B.

Shared-nothing

C.

Multi-cluster shared data

D.

Serverless query engine

Question 164

What is the purpose of multi-cluster virtual warehouses?

Options:

A.

To create separate data warehouses to increase query optimization

B.

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.

To eliminate or reduce Queuing of concurrent queries

D.

To allow the warehouse to resize automatically

Page: 41 / 45
Total 605 questions