Snowflake Exam COF-R02 Topic 1 Question 3 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 3
Topic #: 1

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.

How does Snowflake recommend maximizing the load performance?

AUse auto-ingest Snowpipes to load large files in a serverless model.

BProduce the largest files possible, reducing the overall number of files to process.

CProduce a larger number of smaller files and process the ingestion with size Small virtual warehouses.

DUse an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Show Suggested Answer

Suggested Answer: B

by Jerry at Dec 11, 2022, 10:38 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!