Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

The correct answer is D. VALIDATION_MODE. The VALIDATION_MODE parameter in the COPY INTO <table> command tells Snowflake to validate the staged data files for errors without actually loading any data into the target table. Common values include RETURN_ERRORS (returns all errors found) and RETURN_n_ROWS (validates the…

Data Loading and Unloading

Question

Options

ASTRIP_NULL_VALUES
BSKIP_BYTE_ORDER_MARK
CREPLACE_INVALID_CHARACTERS
DVALIDATION_MODE

How the community answered

(31 responses)

A
3% (1)
B
3% (1)
C
6% (2)
D
87% (27)

Explanation

The VALIDATION_MODE parameter in the COPY INTO <table> command tells Snowflake to validate the staged data files for errors without actually loading any data into the target table. Common values include RETURN_ERRORS (returns all errors found) and RETURN_n_ROWS (validates the first n rows). This is useful for pre-flight checks before committing a load. STRIP_NULL_VALUES (A), SKIP_BYTE_ORDER_MARK (B), and REPLACE_INVALID_CHARACTERS (C) are file format options that control how data is parsed during an actual load-they do not trigger a validation-only mode.

Topics

#COPY command#Data loading#File validation#VALIDATION_MODE

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice