Exam SnowPro Core topic 1 question 538 discussion

from doc: Bulk Unloading into Single or Multiple Files The COPY INTO <location> command provides a copy option (SINGLE) for unloading data into a single file or multiple files. The default is SINGLE = FALSE (i.e. unload into multiple files). Snowflake assigns each file a unique name. The location path specified for the command can contain a filename prefix that is assigned to all the data files generated. If a prefix is not specified, Snowflake prefixes the generated filenames with data_.

Q: .. into single OR multiple files? A: .. default option is SINGLE = TRUE.

https://docs.snowflake.com/en/user-guide/data-unload-overview#bulk-unloading-into-single-or-multiple-files

Not C because DEFAULT for SINGLE is FALSE Not D Not B Leaves A only "However, when an unload operation writes multiple files to a stage, Snowflake appends a suffix that ensures each file name is unique across parallel execution threads" https://docs.snowflake.com/en/sql-reference/sql/copy-into-location

Snowflake uses the COPY INTO Statement for bulk unload into single or Multiple files. By default SINGLE = FALSE

single or multiple files : C is correct for single

COPY command is used to load the Table data into a file which is sure. Whether its Single File or Multiple Filed is decided by SINGLE option being True or False. Option C says, Copy command is used to unload the file which is correct. but the Default value of Single is FALSE. not TRUE. So, the only option is A.

correct

Snowflake assigns each file a unique name. The location path specified for the command can contain a filename prefix that is assigned to all the data files generated. If a prefix is not specified, Snowflake prefixes the generated filenames with data_.

C Bulk Unloading into Single or Multiple Files The COPY INTO <location> command provides a copy option (SINGLE) for unloading data into a single file or multiple files. The default is SINGLE = FALSE (i.e. unload into multiple files).

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

A is correct