SnowflakeSnowflake
COF-C02 · Question #205
COF-C02 Question #205: Real Exam Question with Answer & Explanation
Sign in or unlock COF-C02 to reveal the answer and full explanation for question #205. The question stem and answer options stay visible for context.
Data Loading and Unloading
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-C02 to see the answer
You've previewed enough free COF-C02 questions. Unlock COF-C02 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.
Topics
#Data Loading#Performance Optimization#File Sizing#Bulk Load