Answer-first summary for fast verification
Answer: Leave the default MAX_FILE_SIZE to 16 MB to take advantage of parallel operations.
Option D is correct because it leverages Snowflake's default parallel operations for optimal performance when unloading data. The default MAX_FILE_SIZE of 16 MB allows multiple files to be created and processed in parallel, which is more performant than creating a single large file. Option A (Parquet) is incorrect as the question specifies CSV format. Option B (regular expression) is unrelated to performance optimization for unloading. Option C (increasing MAX_FILE_SIZE to 5 GB with SINGLE=true) would create a single large file, eliminating parallel processing benefits and reducing performance.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
A Snowflake user needs to unload 5 GB of data from a relational table into CSV files as performantly as possible.
What is the recommended approach?
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.