Answer-first summary for fast verification
Answer: Statements that transform data during a load
The VALIDATION_MODE parameter in Snowflake's COPY command is designed to validate data files without actually loading them. According to Snowflake documentation and the community discussion consensus (with the highest upvoted comment having 12 upvotes), VALIDATION_MODE does not support COPY statements that transform data during a load. When VALIDATION_MODE is specified with such statements, it returns an error. Option D is correct because it directly addresses this limitation. The other options are incorrect: A (duplicate record insertion) is unrelated to VALIDATION_MODE restrictions, B (specific data types) is not a documented limitation, and C (duplicate file names) is not mentioned in the context of VALIDATION_MODE errors.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
When using a COPY command with the VALIDATION_MODE parameter, which of the following statements will return an error?
A
Statements that insert a duplicate record during a load
B
Statements that have a specific data type in the source
C
Statements that have duplicate file names
D
Statements that transform data during a load
No comments yet.