Answer: The COPY INTO options should be set to FORCE = TRUE

The question asks how to load duplicate files using the COPY INTO command. Option B (FORCE = TRUE) is correct because it forces Snowflake to load all files regardless of whether they have been loaded previously, bypassing the default behavior where Snowflake checks file metadata to avoid reloading unchanged files. This allows duplicate files to be loaded, potentially creating duplicate data in the table. The community discussion shows 100% consensus on B, with references to Snowflake documentation confirming that FORCE = TRUE reloads files even if they were previously loaded. Other options are incorrect: PURGE = FALSE relates to staging file cleanup after loading, RETURN_FAILED_ONLY = FALSE controls error reporting format, and ON_ERROR = CONTINUE handles row-level errors during loading but doesn't override the duplicate file check.

Author: LeetQuiz Editorial Team