Answer-first summary for fast verification
Answer: Use the VALIDATION_MODE = RETURN_ROWS statement.
The correct answer is D because the VALIDATION_MODE = RETURN_ROWS parameter in the COPY INTO <location> command is specifically designed to validate data during unloading operations. This parameter returns rows that would be unloaded, allowing users to verify data integrity before actual file creation. The community discussion shows 100% consensus on option D with supporting documentation links. Option A (CSV file) and Option B (relational table) are incorrect as they describe data loading rather than validation of unloaded data. Option C (VALIDATION_MODE = SQL) is invalid syntax and not a supported validation mode for the COPY INTO command.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How can a Snowflake user verify the integrity of data files unloaded using the COPY INTO <location> command?
A
Load the data into a CSV file.
B
Load the data into a relational table.
C
Use the VALIDATION_MODE = SQL statement.
D
Use the VALIDATION_MODE = RETURN_ROWS statement.
No comments yet.