Which copy INTO command outputs the data into one file?

The correct answer is B. MAX_FILE_NUMBER=1. NOTE: This question contains an error. The marked correct answer (B: MAX_FILE_NUMBER=1) is NOT a valid Snowflake COPY INTO parameter. The actual Snowflake syntax to output data into a single file is SINGLE = TRUE (option A), which is a recognized parameter in the COPY INTO…

Data Loading and Unloading

Question

Options

ASINGLE=TRUE
BMAX_FILE_NUMBER=1
CFILE_NUMBER=1
DMULTIPLE=FAISE

How the community answered

(44 responses)

B
93% (41)
C
2% (1)
D
5% (2)

Explanation

NOTE: This question contains an error. The marked correct answer (B: MAX_FILE_NUMBER=1) is NOT a valid Snowflake COPY INTO parameter. The actual Snowflake syntax to output data into a single file is SINGLE = TRUE (option A), which is a recognized parameter in the COPY INTO <location> command. When SINGLE = TRUE is specified, Snowflake writes all unloaded data to a single file rather than splitting it across multiple files. If you encounter this on the actual SnowPro exam, choose SINGLE=TRUE. Review the Snowflake documentation on the COPY INTO <location> command for authoritative parameter names.

Topics

#Data Unloading#Output File Control#COPY INTO#Single File

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice