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

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/

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

2 Comments

Inline Feedbacks

View all comments

Ajay Shahi

2 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

2 years ago

False, the FILE_FORMAT parameter is not required.