
Answer-first summary for fast verification
Answer: The use of a COPY INTO [table] statement
The question asks about the highest precedence for file format options when specified in multiple locations during data loading in Snowflake. According to Snowflake documentation and the community discussion, the precedence order is: 1) COPY INTO statement options (highest), 2) Stage definition options, 3) Table definition options (lowest). The COPY INTO statement takes precedence because it allows explicit override of file format settings at the time of data loading. The community discussion shows 80% consensus for option C, with references to Snowflake documentation confirming that COPY INTO options override both stage and table definitions. Option B (table definition) is incorrect as it has the lowest precedence. Option D (COPY INTO location) is not relevant to file format option precedence.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.