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?
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.
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit