The correct answer is B. RETURN_ROWS .
Corrected typo:
Option D contains a typing error. RETURN_ALL_ERRORSs should be RETURN_ALL_ERRORS .
When using COPY INTO < location > to unload data, VALIDATION_MODE = RETURN_ROWS returns the query results instead of unloading them to files. This is useful for validating the result set that would be unloaded.
Why B is correct:
RETURN_ROWS is the validation mode used with unload operations to return rows generated by the query.
Example:
COPY INTO @my_stage/output/
FROM (
SELECT *
FROM customers
)
VALIDATION_MODE = RETURN_ROWS;
Why the other options are incorrect:
A. RETURN_ < n > _ROWS is associated with validation behavior for loading data, not the unload query result validation mode.
C. RETURN_ERRORS returns errors and is used for validating data load errors. It does not return query results.
D. RETURN_ALL_ERRORS returns all errors in validation mode for loading scenarios. It does not return the unload query result set.
Official Snowflake documentation reference:
Snowflake documentation for COPY INTO < location > describes VALIDATION_MODE = RETURN_ROWS as returning the rows that would be unloaded.
