SnowPro Core Certification — Question 43

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Answer options

• A. The VALIDATION_MODE option is used when creating an Internal Stage
• B. VALIDATION_MODE=RETURN_ALL_ERRORS is a parameter of the COPY command
• C. The VALIDATION_MODE option will validate data to be loaded by the COPY statement while completing the load and will return the rows that could not be loaded without error
• D. The VALIDATION_MODE option will validate data to be loaded by the COPY statement without completing the load and will return possible errors

Correct answer: B, D

Explanation

Option B is correct because VALIDATION_MODE=RETURN_ALL_ERRORS is indeed a parameter of the COPY command, which helps in error reporting. Option D is also correct as it describes the functionality of VALIDATION_MODE correctly, indicating validation occurs without completing the load. Options A and C are incorrect as they misrepresent the purpose and behavior of the VALIDATION_MODE feature.