CertsTopics Logo

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

Legit COF-C02 Exam Download

Page: 49 / 57
Total 751 questions
Get COF-C02 Full Access Download COF-C02 PDF

SnowPro Core Certification Exam Questions and Answers

Question 193

What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

Options:

A.

It removes null values from all columns in the data.

B.

It converts null values to empty strings during loading.

C.

It skips rows with null values during the loading process.

D.

It removes object or array elements containing null values.

Question 194

Which command is used to unload data from a Snowflake database table into one or more files in a Snowflake stage?

Options:

A.

CREATE STAGE

B.

COPY INTO

C.

COPY INTO

D.

CREATE PIPE

Question 195

What does SnowCD help Snowflake users to do?

Options:

A.

Copy data into files.

B.

Manage different databases and schemas.

C.

Troubleshoot network connections to Snowflake.

D.

Write SELECT queries to retrieve data from external tables.

Question 196

What are key characteristics of virtual warehouses in Snowflake? (Select TWO).

Options:

A.

Warehouses that are multi-cluster can have nodes of different sizes.

B.

Warehouses can be started and stopped at any time.

C.

Warehouses can be resized at any time, even while running.

D.

Warehouses are billed on a per-minute usage basis.

E.

Warehouses can only be used for querying and cannot be used for data loading.

Page: 49 / 57
Total 751 questions
Get COF-C02 Full Access Download COF-C02 PDF