SnowPro Core Certification — Question 633

A user needs to ingest 1 GB of data that is available in an external stage using a COPY INTO command.

How can this be done with MAXIMUM performance and the LEAST cost?

Answer options

• 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.

Correct answer: C

Explanation

The correct answer is C because splitting the data into smaller compressed files allows for parallel processing, which maximizes performance while reducing costs associated with storage and transfer. Options A and B do not leverage parallel loading effectively, and option D fails to utilize compression, which is essential for cost efficiency.