Databricks-DA-Assoc Data Modeling with Databricks SQL Practice Question
Exhibit
Error: [DELTA_COLUMN_MAPPING_UNSUPPORTED] Column mapping is required to enable change data feed on this table. Please set 'delta.columnMapping.mode' to 'name'.
Refer to the exhibit. You are attempting to enable Change Data Feed (CDF) on an existing Delta table but receive this error. Why is this error occurring?
⚠ Common exam trap
Candidates often assume that CDF can be enabled on any existing table without configuration changes. They miss that column mapping is a mandatory architectural prerequisite for tracking schema evolution in CDF.
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 table requires column mapping to track physical schema evolution for CDF.
Change Data Feed (CDF) tracks row-level changes, which requires a stable mapping between column names and their underlying physical file data. If the table was created without column mapping, it cannot safely track changes if column names are altered. Setting 'delta.columnMapping.mode' to 'name' decouples the column names from their physical file identifiers, which is a prerequisite for the metadata tracking required by the CDF feature.
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 table is not in the Delta format.
Why it's wrong here
If the table were not in Delta format, the error would not specifically mention Delta column mapping or the specific mode configuration. The error clearly indicates that the table is a Delta table, but its current configuration lacks the metadata layer required to support the Change Data Feed functionality.
- ✓
The table requires column mapping to track physical schema evolution for CDF.
Why this is correct
CDF tracks changes to rows over time. If a table allows schema evolution (renaming columns), there must be a way to map the old column name to the new column name in the files. Column mapping enables this decoupling, which is essential for CDF to function correctly during schema changes.
- ✗
The table has too many rows to enable CDF.
Why it's wrong here
Delta Lake does not have a row count limit for enabling Change Data Feed. CDF is designed to work at scale on large production tables. The error is strictly related to configuration and table properties, not the volume of data contained within the existing Delta table structure at the moment.
- ✗
CDF is only supported on tables with primary keys.
Why it's wrong here
Change Data Feed does not require primary keys to function. It tracks inserts, updates, and deletes by recording the delta changes in the transaction log. While primary keys are useful for some data modeling patterns, they are not a technical prerequisite for the CDF feature in Databricks SQL.
About these practice questions
This Databricks-DA-Assoc question is part of Courseiva's 291-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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-DA-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-DA-Assoc exam.