Answer: RETURN_ROWS

The question asks which validation option is exclusively supported by the COPY INTO <location> command (used for unloading data). According to Snowflake documentation and the community discussion, COPY INTO <location> (unloading) only supports RETURN_ROWS as a validation mode. In contrast, COPY INTO <table> (loading) supports RETURN_N_ROWS, RETURN_ERRORS, and RETURN_ALL_ERRORS. The community discussion with upvotes confirms this distinction, citing official documentation links that show RETURN_ROWS is the only validation mode available for unloading operations.

Author: LeetQuiz Editorial Team