Exam SnowPro Core All QuestionsBrowse all questions from this exam
Question 1118

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

    Correct Answer: C

    When specifying file format options in Snowflake during data loading, the precedence hierarchy is determined by where the options are specified. The highest precedence is given to the options specified directly in the COPY INTO <location> statement, overriding any conflicting settings in the table definition or stage definition. This ensures that the specific load operation follows the exact configuration desired at the time of execution.

Discussion
Mayankb024Option: D

D :https://docs.snowflake.com/en/sql-reference/functions/validate#:~:text=Validates%20the%20files%20loaded%20in,than%20just%20the%20first%20error.