Answer: SINGLE = FALSE

The question asks about the default behavior of the COPY INTO <location> command for unloading data into multiple files. According to the Snowflake documentation referenced in the community discussion, the SINGLE parameter controls whether data is unloaded into a single file or multiple files. The default value is SINGLE = FALSE, which means data is unloaded into multiple files by default. This is confirmed by the community discussion where the answer D (SINGLE = FALSE) has 100% consensus and 3 upvotes, with a direct link to the official Snowflake documentation supporting this answer.

Author: LeetQuiz Editorial Team