CertsTopics Logo

New Year Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

SnowPro Core Certification COF-R02 Exam Dumps

Page: 7 / 12
Total 330 questions
Get COF-R02 Full Access Download COF-R02 PDF

SnowPro Core Recertification Exam Questions and Answers

Question 25

What is the default File Format used in the COPY command if one is not specified?

Options:

A.

CSV

B.

JSON

C.

Parquet

D.

XML

Question 26

What is the recommended file sizing for data loading using Snowpipe?

Options:

A.

A compressed file size greater than 100 MB, and up to 250 MB

B.

A compressed file size greater than 100 GB, and up to 250 GB

C.

A compressed file size greater than 10 MB, and up to 100 MB

D.

A compressed file size greater than 1 GB, and up to 2 GB

Question 27

What feature can be used to reorganize a very large table on one or more columns?

Options:

A.

Micro-partitions

B.

Clustering keys

C.

Key partitions

D.

Clustered partitions

Question 28

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Options:

A.

Pipes

B.

Streams

C.

Tasks

D.

Procedures

Page: 7 / 12
Total 330 questions
Get COF-R02 Full Access Download COF-R02 PDF