SnowPro Core Exam QuestionsBrowse all questions from this exam

SnowPro Core Exam - Question 202

Which COPY INTO command outputs the data into one file?

SINGLE=TRUE

MAX_FILE_NUMBER=1

FILE_NUMBER=1

MULTIPLE=FALSE

Show Answer

Correct Answer: A

The correct option to ensure that the COPY INTO command outputs data into one file is SINGLE=TRUE. This parameter, when set to TRUE, specifies that the output should be a single file.

Discussion

6 comments

halolOption: A

Dec 7, 2022

https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

vmsaranOption: A

Feb 20, 2023

Answer is A

EmiBOption: A

Mar 11, 2023

A. SINGLE=TRUE

shyemkoOption: A

Mar 24, 2023

SINGLE = TRUE

_yyuktaOption: A

Feb 26, 2024

A. SINGLE=TRUE are correct

Mallikharjuna452Option: A

Jul 21, 2024

A is correct