Exam SnowPro Advanced Data Engineer topic 1 question 37 discussion

Actual exam question from Snowflake's SnowPro Advanced Data Engineer

Question #: 37
Topic #: 1

[All SnowPro Advanced Data Engineer Questions]

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?

A. ESCAPE_UNENCLOSED FIELD = '\\'
B. ERROR_ON_COLUMN_COUNT_MISMATCH = FALSE
C. FIELD_DELIMITER = ','
D. FIELD_OPTIONALLY_ENCLOSED_BY = '"'

Show Suggested Answer

Suggested Answer: D 🗳️

by stopthisnow at Nov. 12, 2023, 11:08 p.m.

Comments

Submit Cancel

ecvdata

10 months, 3 weeks ago

https://docs.snowflake.com/en/user-guide/data-unload-considerations FIELD_OPTIONALLY_ENCLOSED_BY = 'character' | NONE Use this option to enclose strings in the specified character: single quote ('), double quote ("), or NONE.

upvoted 1 times

...

stopthisnow

1 year ago

Selected Answer: D

D makes sense. Due to commas in the column value, the column needs to be enclosed by " to be treated as a single column.

upvoted 1 times

...