SnowPro Core Certification — Question 338

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?

Answer options

• A. Use auto-ingest Snowpipes to load large files in a serverless model.
• B. Produce the largest files possible, reducing the overall number of files to process.
• C. Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
• D. Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Correct answer: C

Explanation

The correct answer is C because Snowflake performs better with many smaller files as it allows for parallel processing, which enhances load performance. Option A is incorrect as auto-ingest Snowpipes are effective but not the recommended approach for this scenario. Option B suggests minimizing file counts but larger files can lead to bottlenecks. Option D involves row-by-row inserts which are inefficient for bulk data loading.