SnowPro Core Certification — Question 1085

What takes the highest precedence in Snowflake file format options, when specified in multiple locations during data loading?

Answer options

• A. The stage definition
• B. The table definition
• C. The use of a COPY INTO [table] statement
• D. The use of a COPY INTO [location] statement

Correct answer: C

Explanation

The correct answer is C, as the COPY INTO [table] statement takes precedence over other definitions when multiple file format options are specified. The stage and table definitions can be overridden by the parameters set in the COPY INTO command, making them less significant in this context.