Answer-first summary for fast verification
Answer: Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.
Option C is optimal because splitting the 1 GB file into smaller files of 100-250 MB each and compressing them before ingestion aligns with Snowflake's best practices for data loading. Smaller files enable parallel processing, improving performance by utilizing multiple compute resources simultaneously. Compression reduces storage and data transfer costs, as Snowflake automatically decompresses files during loading. Option A uses compression but lacks file splitting, limiting parallelism. Option B is uncompressed and a single file, resulting in higher costs and slower performance. Option D splits files but omits compression, missing cost savings from reduced data transfer and storage.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A user needs to ingest 1 GB of data from an external stage using the COPY INTO command. How can this be done to achieve maximum performance and the least cost?
A
Ingest the data in a compressed format as a single file.
B
Ingest the data in an uncompressed format as a single file.
C
Split the file into smaller files of 100-250 MB each, compress and ingest each of the smaller files.
D
Split the file into smaller files of 100-250 MB each and ingest each of the smaller files in an uncompressed format.