Snowflake SnowPro Core
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.