SnowPro Core Certification — Question 864

How can a Snowflake user validate data that is unloaded using the COPY INTO [location] command?

Answer options

• 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.

Correct answer: D

Explanation

The correct answer is D because using VALIDATION_MODE = RETURN_ROWS allows the user to validate the data by returning rows that would be written to the target location. Options A and B do not pertain to validation processes, while option C does not provide the means to return rows for validation.