SnowPro Core Certification — Question 402

Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

Answer options

• A. STRIP_NULL_VALUES
• B. SKIP_BYTE_ORDER_MARK
• C. REPLACE_INVALID_CHARACTERS
• D. VALIDATION_MODE

Correct answer: D

Explanation

The VALIDATION_MODE parameter is specifically designed to validate the data files to ensure they meet the required format before any loading occurs. The other options do not serve this purpose, as STRIP_NULL_VALUES, SKIP_BYTE_ORDER_MARK, and REPLACE_INVALID_CHARACTERS focus on altering or handling the data during the loading process rather than verification.