SnowflakeSnowflake
COF-C02 · Question #223
COF-C02 Question #223: Real Exam Question with Answer & Explanation
The correct answer is D: VALIDATION_MODE. The VALIDATION_MODE parameter can be used with the COPY command to verify data files without loading them into the specified table. This parameter allows users to check for errors in
Data Loading and Unloading
Question
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Options
- ASTRIP_NULL_VALUES
- BSKIP_BYTE_ORDER_MARK
- CREPLACE_INVALID_CHARACTERS
- DVALIDATION_MODE
Explanation
The VALIDATION_MODE parameter can be used with the COPY command to verify data files without loading them into the specified table. This parameter allows users to check for errors in
Topics
#COPY command#Data loading#File validation#VALIDATION_MODE
Community Discussion
No community discussion yet for this question.