SnowPro Core Certification — Question 259

While using a COPY command with a Validation_mode parameter, which of the following statements will return an error?

Answer options

• 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

Correct answer: D

Explanation

The correct answer is D because transforming data during a load is not allowed when using the COPY command with Validation_mode. Options A, B, and C do not inherently cause errors in this context, as inserting duplicates, having specific data types, or using duplicate filenames can still be processed without triggering an error.