A company is performing an initial data load of multiple terabytes into Snowflake as part of a migration. They have control over the number and size of the source CSV extract files.

What is Snowflake's recommended approach for maximizing the performance of this data load?

Exam-Like

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

18.2%

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

0.0%

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

72.7%

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

9.1%

Snowflake SnowPro Core