Databricks-DE-Assoc Data Transformation and Modeling Practice Question
Which TWO of the following statements correctly describe the behavior of the Delta Lake 'MERGE' operation when handling schema evolution?
⚠ Common exam trap
Candidates frequently assume schema evolution happens automatically during a MERGE statement without needing explicit options, leading to runtime failures when new columns appear.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
The 'mergeSchema' option must be enabled for any new columns to be added to the target table during a MERGE.
Schema evolution in Delta Lake allows for flexible data structures. By using MERGE with specific options, engineers can automate updates to target table structures as incoming data evolves. Understanding these behaviors is critical for maintaining robust ELT pipelines where source system changes might otherwise break downstream consumers or cause data ingestion failures that require manual schema repairs.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
The 'mergeSchema' option must be enabled for any new columns to be added to the target table during a MERGE.
Why this is correct
When performing a MERGE, Delta Lake does not automatically add columns unless the explicit 'mergeSchema' option is provided in the configuration. Enabling this option tells the engine to automatically infer and update the target table schema based on the structure of the incoming data source during the operation.
- ✗
MERGE operations automatically drop columns in the target table if they are missing from the source DataFrame.
Why it's wrong here
Delta Lake does not drop columns from a target table during a MERGE operation simply because they are missing from the source data. Dropping columns requires a separate 'ALTER TABLE' command or a full table overwrite, ensuring that data persistence is protected against accidental source system data gaps.
- ✓
Setting 'spark.databricks.delta.schema.autoMerge.enabled' to true globally affects all MERGE operations in the session.
Why this is correct
Configuring the global Spark session setting allows for automatic schema evolution without needing to specify the parameter in every individual query. This is highly useful for teams managing large pipelines where source schemas frequently update, reducing the maintenance overhead of updating every single code block for schema changes.
- ✗
MERGE operations support renaming columns in the target table using the 'RENAME' keyword inside the 'WHEN MATCHED' clause.
Why it's wrong here
The MERGE command is strictly for data manipulation, such as inserting, updating, or deleting rows. It cannot perform DDL operations like renaming columns. Renaming columns must be executed via an ALTER TABLE command or by rewriting the table, which prevents accidental destructive structural changes during row-level operations.
- ✗
The 'overwriteSchema' option is required for MERGE to successfully insert new columns into the target table.
Why it's wrong here
The 'overwriteSchema' option is intended for full table replacements, not incremental MERGE operations. Using it during a MERGE would lead to unintended data loss or errors, as it fundamentally conflicts with the logic of an upsert, which focuses on row-level changes rather than replacing the entire dataset.
About these practice questions
Courseiva writes every Databricks-DE-Assoc question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Assoc exam.