Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
As a data engineer, you're tasked with loading external CSV files into a Delta table using the COPY INTO command. After the initial load, the schema of one file changes due to a new column, causing the data load to fail. Which SQL command will resolve this issue?
A
COPY INTO my_table FROM '/path/to/files' FILEFORMAT = CSV FORMAT_OPTIONS ('overWriteSchema' = 'true') COPY_OPTIONS ('overWriteSchema' = 'true');_
B
COPY INTO my_table FROM '/path/to/files' FILEFORMAT = CSV FORMAT_OPTIONS ('mergeSchema' = 'true') COPY_OPTIONS ('mergeSchema' = 'true');_
C
COPY INTO my_table FROM '/path/to/files' FILEFORMAT = CSV FORMAT_OPTIONS ('mergeSchema' = 'true') COPY_OPTIONS ('overWriteSchema' = 'true');_
D
COPY INTO my_table FROM '/path/to/files' FILEFORMAT = CSV FORMAT_OPTIONS ('overWriteSchema' = 'true') COPY_OPTIONS ('mergeSchema' = 'true');_
E
None of the above