Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 662

When unloading data to an external stage, what is the MAXIMUM file size supported?

    Correct Answer: B

    When unloading data to an external stage in Snowflake, such as Amazon S3, Google Cloud Storage, or Microsoft Azure, the maximum file size supported is 5 GB. This is set by the MAX_FILE_SIZE copy option in the COPY INTO location statements, designed to optimize for parallel operations and larger file sizes.

Discussion
miomio123Option: B

By default, COPY INTO location statements separate table data into a set of output files to take advantage of parallel operations. The maximum size for each file is set using the MAX_FILE_SIZE copy option. The default value is 16777216 (16 MB) but can be increased to accommodate larger files. The maximum file size supported is 5 GB for Amazon S3, Google Cloud Storage, or Microsoft Azure stages. https://docs.snowflake.com/en/user-guide/data-unload-considerations#

MultiCloudIronManOption: B

correct, i was confused by 16MB being the default

ravuri_rkOption: B

correct B. 5 GB max

Snow_POption: B

https://docs.snowflake.com/en/user-guide/data-unload-considerations

MultiCloudIronManOption: D

correct

MultiCloudIronMan

I change my answer to B