DEA-C02 · Question #37
DEA-C02 Question #37: Real Exam Question with Answer & Explanation
Sign in or unlock DEA-C02 to reveal the answer and full explanation for question #37. The question stem and answer options stay visible for context.
Question
A Data Engineer is trying to load the following rows from a CSV file into a table in Snowflake with the following structure: The engineer is using the following COPY INTO statement: However, the following error is received: Number of columns in file (6) does not match that of the corresponding table (3), use file format option error_on_column_count_mismatch=false to ignore this error File 'address.csv.gz', line 3, character 1 Row 1 starts at line 2, column "STGCUSTOMER"[6] If you would like to continue loading when an error is encountered, use other values such as 'SKIP_FILE' or 'CONTINUE' for the ON_ERROR option. Which file format option should be used to resolve the error and successfully load all the data into the table?
Options
- AESCAPE_UNENCLOSED FIELD = '\\'
- BERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
- CFIELD_DELIMITER = ','
- DFIELD_OPTIONALLY_ENCLOSED_BY = '"'
Unlock DEA-C02 to see the answer
You've previewed enough free DEA-C02 questions. Unlock DEA-C02 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.