Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Go to Exam

Question 538

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.

It uses the PUT command to download the data by default.

It uses COPY INTO for bulk unloading where the default option is SINGLE = TRUE.

It uses COPY INTO to copy the data from a table into one or more files in an external stage only.

Correct Answer: A

Snowflake handles the bulk unloading of data by assigning each unloaded data file a unique name. The COPY INTO <location> command provides a copy option (SINGLE) for unloading data into a single file or multiple files, but the default option is SINGLE = FALSE, meaning it unloads into multiple files by default. The unique naming ensures that even if multiple files are generated, they are easily distinguishable.

Discussion

bibisaOption: A

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_.

EmiBOption: C

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

h8er

ANS = A... default is SINGLE = False. https://docs.snowflake.com/en/user-guide/data-unload-overview

SimbajagnoleOption: A

A is correct

kayuhanbidukOption: C

single or multiple files : C is correct for single

ViniJsrOption: C

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).

Simbajagnole

SINGLE = FALSE is default, which is why this answer is incorrect

dementorOption: D

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

Simbajagnole

It can be Internal stage also, so this answer is not correct

0e504b5Option: A

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

FranzozOption: D

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

RajivnbOption: A

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.

MultiCloudIronManOption: A

correct

KarBiswaOption: A

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_.