Câu 34: SnowPro Advanced Data Engineer

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?

1. A. ESCAPE_UNENCLOSED FIELD = '\\'
2. B. ERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
3. C. FIELD_DELIMITER = ','
4. D. FIELD_OPTIONALLY_ENCLOSED_BY = '"' — đáp án hiện tại