True or False: The COPY command must specify a File Format in order to execute.

exams SnowPro Core SnowPro Core exam 2 Comments

True or False: The COPY command must specify a File Format in order to execute.
A . True
B . False

Answer: A

Explanation:

Reference: https://interworks.com/blog/hcalder/2018/07/26/the-basics-of-loading-data-into-snowflake/

Updated Study Material | Instant Download | Detailed Answers and Explanations

2 Comments

Ajay Shahi

4 years ago

if you don’t specify a File Format to COPY command, SNOWFLAKE will use its own default format.
Answer will be B

Michael

4 years ago

False, the FILE_FORMAT parameter is not required.