Databricks Certified Data Engineer - Associate

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?

Real Exam

COPY INTO my_table 
FROM '/path/to/files'
FILEFORMAT = CSV
FORMAT_OPTIONS ('overWriteSchema' = 'true')
COPY_OPTIONS ('overWriteSchema' = 'true');
``

COPY INTO my_table 
FROM '/path/to/files'
FILEFORMAT = CSV
FORMAT_OPTIONS ('overWriteSchema' = 'true')
COPY_OPTIONS ('overWriteSchema' = 'true');
``

12.8%

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV 
FORMAT_OPTIONS ('mergeSchema' = 'true') 
COPY_OPTIONS ('mergeSchema' = 'true');

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV 
FORMAT_OPTIONS ('mergeSchema' = 'true') 
COPY_OPTIONS ('mergeSchema' = 'true');

30.4%

Loading comments...

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV 
FORMAT_OPTIONS ('mergeSchema' = 'true') 
COPY_OPTIONS ('overWriteSchema' = 'true');
``

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV 
FORMAT_OPTIONS ('mergeSchema' = 'true') 
COPY_OPTIONS ('overWriteSchema' = 'true');
``

19.1%

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV
FORMAT_OPTIONS ('overWriteSchema' = 'true')
COPY_OPTIONS ('mergeSchema' = 'true');

COPY INTO my_table
FROM '/path/to/files'
FILEFORMAT = CSV
FORMAT_OPTIONS ('overWriteSchema' = 'true')
COPY_OPTIONS ('mergeSchema' = 'true');

16.7%