
Explanation:
The VALIDATION_MODE parameter in Snowflake's COPY INTO command has three valid options: RETURN_n_ROWS, RETURN_ERRORS, and RETURN_ALL_ERRORS. Based on the community discussion and official Snowflake documentation referenced in the comments, the correct answers are C (RETURN_ALL_ERRORS) and D (RETURN_n_ROWS, though the question shows it as RETURN__ROWS with a likely typo). Option A (TRUE) is not a valid VALIDATION_MODE setting. Option B (RETURN_ERROR_SUM) is invalid as confirmed by community members. Option E (RETURN_FIRST__ERRORS) is also not a valid option. The community consensus strongly supports CD with 90% agreement, and multiple comments reference the official documentation confirming these as the correct choices.
Which of the following are valid settings for the VALIDATION_MODE parameter in the Snowflake COPY INTO command? (Choose two.)
A
TRUE
B
RETURN_ERROR_SUM
C
RETURN_ALL_ERRORS
D
RETURN_[N]_ROWS
E
RETURN_FIRST__ERRORS
No comments yet.