Snowflake
COF-R02 · Question #311
COF-R02 Question #311: Real Exam Question with Answer & Explanation
Sign in or unlock COF-R02 to reveal the answer and full explanation for question #311. The question stem and answer options stay visible for context.
Question
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?
Options
- 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
- DUse an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and
Unlock COF-R02 to see the answer
You've previewed enough free COF-R02 questions. Unlock COF-R02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.