SnowPro Core Certification COF-R02 Exam Dumps

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?

CSV

JSON

Parquet

XML

Question 26

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

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

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

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

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?

Micro-partitions

Clustering keys

Key partitions

Clustered partitions

Question 28

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

Pipes

Streams

Tasks

Procedures