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

Free Access Snowflake COF-C02 New Release

Page: 28 / 71
Total 948 questions

SnowPro Core Certification Exam Questions and Answers

Question 109

For which use cases is running a virtual warehouse required? (Select TWO).

Options:

A.

When creating a table

B.

When loading data into a table

C.

When unloading data from a table

D.

When executing a show command

E.

When executing a list command

Question 110

Which views are included in the DATA SHARING USAGE schema? (Select TWO).

Options:

A.

ACCESS_HISTORY

B.

DATA_TRANSFER_HISTORY

C.

WAREHOUSE_METERING_HISTORY

D.

MONETIZED_USAGE_DAILY

E.

LISTING TELEMETRY DAILY

Question 111

What step can reduce data spilling in Snowflake?

Options:

A.

Using a larger virtual warehouse

B.

Increasing the virtual warehouse maximum timeout limit

C.

Increasing the amount of remote storage for the virtual warehouse

D.

Using a common table expression (CTE) instead of a temporary table

Question 112

A column named "Data" contains VARIANT data and stores values as follows:

How will Snowflake extract the employee's name from the column data?

Options:

A.

Data:employee.name

B.

DATA:employee.name

C.

data:Employee.name

D.

data:employee.name

Page: 28 / 71
Total 948 questions