SnowPro Core Certification — Question 1317

If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?

Answer options

• A. Table definition
• B. Stage definition
• C. Session level
• D. COPY INTO TABLE statement

Correct answer: D

Explanation

The COPY INTO TABLE statement has the highest precedence when determining file format options during a load operation. Options defined at the table definition, stage definition, and session level are overridden by those specified directly in the COPY INTO TABLE statement, making it the first to be applied.