SnowPro Core free question 6 / 10 · Domain 3: Data Loading, Unloading, and Connectivity
What is the default value of the SINGLE copy option of COPY INTO <location>, and what does it mean?
- There is no default, so the option must always be set
- FALSE, so the data is unloaded into multiple files
- TRUE, so the data is unloaded into a single file
- AUTO, so Snowflake chooses the number of files itself
Show the answer and explanation
Answer: B
Why this is correct
The COPY INTO <location> command has a SINGLE copy option for unloading data into a single file or multiple files. The default is SINGLE = FALSE, which unloads into multiple files.
Why the other options are wrong
"TRUE, so the data is unloaded into a single file" … TRUE is not the default. By default, multiple files are produced.
"AUTO, so Snowflake chooses the number of files itself" … There is no AUTO setting. The default is FALSE.
"There is no default, so the option must always be set" … The option has a default, FALSE, so setting it is not required.
Key point
When unloading into multiple files, use the MAX_FILE_SIZE copy option to specify the maximum size of each file. Each file is assigned a unique name.
Go to the SnowPro Core practice app (10 free questions; purchase unlocks all questions)