SnowPro Core Certification — Question 717

How can a Snowflake user load duplicate files with a COPY INTO command?

Answer options

• A. The COPY INTO options should be set to PURGE = FALSE
• B. The COPY INTO options should be set to FORCE = TRUE
• C. The COPY INTO options should be set to RETURN_FAILED_ONLY = FALSE
• D. The COPY INTO options should be set to ON_ERROR = CONTINUE

Correct answer: B

Explanation

The correct answer is B because setting FORCE = TRUE allows the COPY INTO command to load duplicate files without errors. The other options do not specifically address the requirement for handling duplicate files during the loading process.