Snowflake
COF-R02 · Question #311
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…
The correct answer is B. Produce the largest files possible, reducing the overall number of files to process. See the full explanation below for the reasoning.
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
How the community answered
(38 responses)- A8% (3)
- B74% (28)
- C5% (2)
- D13% (5)
Community Discussion
No community discussion yet for this question.