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

What is the default file size when unloading data from Snowflake using the COPY command?

    Correct Answer: C

    The default file size when unloading data from Snowflake using the COPY command is 16 MB.

Discussion
SV1122Option: C

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. https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

Mallikharjuna452Option: C

C.16 MB

_yyuktaOption: C

C. 16 MB

MultiCloudIronManOption: C

Correct

dmitriypoOption: C

16 Mb https://docs.snowflake.com/en/sql-reference/sql/copy-into-location#copy-options-copyoptions

KarBiswaOption: C

16 MB maximum file size

halolOption: C

correct C