Snowflake Exam COF-R02 Topic 1 Question 22 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 22
Topic #: 1

[All COF-R02 Questions]

Which copy INTO command outputs the data into one file?

ASINGLE=TRUE

BMAX_FILE_NUMBER=1

CFILE_NUMBER=1

DMULTIPLE=FAISE

Show Suggested Answer

Suggested Answer: D

by Portia at Dec 12, 2023, 05:13 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 hours ago

C) FILE_NUMBER=1 is an interesting option, but I'm not convinced that's the same as outputting to a single file.

upvoted 0 times

...

9 days ago

B) MAX_FILE_NUMBER=1 sounds like it might work too, but I'm not sure if that's the same as outputting to a single file.

upvoted 0 times

...

11 days ago

I think the correct answer is A) SINGLE=TRUE. This option clearly states that the data will be output into a single file.

upvoted 0 times

...

15 days ago

I'm not sure, but I think A) SINGLE=TRUE could also be a valid option to output data into one file.

upvoted 0 times

...

17 days ago

I agree with Vesta, FILE_NUMBER=1 seems like the correct option to output data into one file.

upvoted 0 times

...

18 days ago

I think the answer is C) FILE_NUMBER=1 because it specifies the file number.

upvoted 0 times

...