Databricks Certified Data Engineer - Associate

Get started today

Ultimate access to all questions.

Explanation:

E: None of the above — because the correct syntax is:

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

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

Reference: https://docs.databricks.com/aws/en/sql/language-manual/delta-copy-into#format-options

https://docs.databricks.com/aws/en/sql/language-manual/delta-copy-into

Explanation:

E: None of the above — because the correct syntax is:

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

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

Reference: https://docs.databricks.com/aws/en/sql/language-manual/delta-copy-into#format-options

https://docs.databricks.com/aws/en/sql/language-manual/delta-copy-into

Comments (1)

Jordan ReavesOct 16, 2025 4:29 AM

the answer is wrong.

Daniyal AhsanJan 1, 2026 4:51 AM

What is the correct answer jordan, and how is this answer wrong?

LeetQuiz .Jan 3, 2026 7:15 AM

Hi, Thanks for your comment. After we've reviewed the question and referred to the official documents. Option E remains correct based on the official documentation. According to Databricks docs, schema evolution for `COPY INTO` is controlled **only** by `COPY_OPTIONS `mergeSchema' and `force`. CSV `FORMAT_OPTIONS` are used strictly for file parsing (header, inferSchema, delimiter, etc.) and do **not** handle Delta table schema changes. All options A–D are incorrect because they either use unsupported options like `overwriteSchema` or incorrectly place `mergeSchema` inside `FORMAT_OPTIONS`. Therefore, none of the listed commands correctly follow the documented behavior, making **E (None of the above)** the correct answer. For the details, please refer to the CSV format options official documents: https://docs.databricks.com/aws/en/sql/language-manual/delta-copy-into#csv-options and attached image displaying that COPY_OPTIONS only supports `mergeSchema' and `force`.

Comments (1)

Jordan ReavesOct 16, 2025 4:29 AM

the answer is wrong.

Daniyal AhsanJan 1, 2026 4:51 AM

What is the correct answer jordan, and how is this answer wrong?

LeetQuiz .Jan 3, 2026 7:15 AM

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

Last updated: April 4, 2026 at 14:03

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');
``

15.1%

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');

26.6%

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.3%

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');

17.3%

None of the above

21.7%

Databricks Certified Data Engineer - Associate

Get started today

Comments (1)

Get started today

Comments (1)

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?

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?