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

Download Full Version COF-C02 Snowflake Exam

Page: 39 / 71
Total 948 questions

SnowPro Core Certification Exam Questions and Answers

Question 153

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

Options:

A.

A single join node uses more than 50% of the query time

B.

Partitions scanned is equal to partitions total

C.

An AggregateOperacor node is present

D.

The query is spilling to remote storage

Question 154

Which statement about billing applies to Snowflake credits?

Options:

A.

Credits are billed per-minute with a 60-minute minimum

B.

Credits are used to pay for cloud data storage usage

C.

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

D.

Credits are consumed based on the warehouse size and the time the warehouse is running

Question 155

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

Options:

A.

The ability to scale up warehouses

B.

The use of warehouse auto scaling

C.

The ability to resize warehouses

D.

Use of multi-clustered warehouses

E.

The use of warehouse indexing

Question 156

A user unloaded a Snowflake table called mytable to an internal stage called mystage.

Which command can be used to view the list of files that has been uploaded to the staged?

Options:

A.

list @mytable;

B.

list @%raytable;

C.

list @ %m.ystage;

D.

list @mystage;

Page: 39 / 71
Total 948 questions