Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
An analyst is configuring an AI/BI Genie Space and wants to ensure that the model correctly interprets the term 'revenue' as the sum of the 'sales_amount' column. Which action should the analyst take?
⚠ Common exam trap
Many candidates confuse metadata comments or free-text instructions with the dedicated synonym feature that directly maps terms to columns.
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
✓
Add a synonym 'revenue' to the 'sales_amount' column in the Genie Space's semantic configuration.
The correct approach is to add a synonym in the Genie Space's semantic configuration. This feature allows analysts to map business terms to specific columns, ensuring the model understands that 'revenue' refers to 'sales_amount'. Synonyms are part of the Space's semantic layer and are used during natural language to SQL translation, leading to more accurate and consistent results.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Create a view that renames 'sales_amount' to 'revenue' and add that view to the Genie Space.
Why it's wrong here
Creating a view with a renamed column could work, but it introduces an extra object and may not align with existing data models. The Genie Space already allows synonyms, which are simpler and do not require data duplication. This approach is indirect and could lead to maintenance overhead, whereas synonyms directly address the terminology mapping within the Space configuration.
- ✗
Add a column comment to the 'sales_amount' column in Unity Catalog that says 'This is revenue'.
Why it's wrong here
Column comments in Unity Catalog are metadata that can be used by Genie, but they are not the primary mechanism for defining synonyms. Comments are descriptive and may not be interpreted as direct mappings. The Genie Space's synonym feature is explicitly for this purpose and takes precedence. Relying solely on comments may not ensure consistent behavior.
- ✗
In the Genie Space instructions, write a note that says 'revenue means sales_amount'.
Why it's wrong here
While instructions can provide guidance, they are less structured than synonyms. The Genie model may not consistently apply free-text instructions to column mapping. Synonyms are specifically designed for term-to-column associations and are more reliable. Using instructions alone might lead to inconsistent interpretations, especially for complex queries.
- ✓
Add a synonym 'revenue' to the 'sales_amount' column in the Genie Space's semantic configuration.
Why this is correct
Adding a synonym maps the business term 'revenue' to the specific column 'sales_amount'. This directly informs the Genie model that when users ask about revenue, it should use that column. The synonym feature is part of the semantic layer that helps translate natural language into accurate SQL, reducing ambiguity and improving answer correctness.
About these practice questions
Courseiva writes every Databricks-DA-Assoc question from scratch — 291 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-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.