SnowPro Core Certification — Question 538

A Snowflake user wants to unload data from a relational table sized 5 GB using CSV. The extract needs to be as performant as possible.

What should the user do?

Answer options

• A. Use Parquet as the unload file format, using Parquet's default compression feature.
• B. Use a regular expression in the stage specification of the COPY command to restrict parsing time.
• C. Increase the default MAX_FILE_SIZE to 5 GB and set SINGLE = true to produce a single file.
• D. Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.

Correct answer: D

Explanation

The correct answer is D because keeping the MAX_FILE_SIZE at 16 MB allows the unloading process to leverage parallel operations, which can significantly enhance performance. Options A and C are incorrect as they do not maximize the performance benefits associated with parallel processing. Option B is not relevant to improving the overall extraction performance in this scenario.