Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
A financial analyst is building an AI/BI Genie Space to allow executives to query quarterly earnings data. The executives often ask for metrics like 'year-over-year growth' and 'profit margin'. The analyst wants to ensure that Genie correctly calculates these metrics regardless of how the question is phrased. Which approach should the analyst take?
⚠ Common exam trap
The trap here is assuming that a pre-calculated view is sufficient, but it cannot handle the diverse and dynamic questions executives might ask.
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 instructions in the Genie Space that define the formulas for year-over-year growth and profit margin
Providing instructions that define the formulas for year-over-year growth and profit margin allows Genie to understand and apply these calculations consistently. This method is flexible and handles various phrasings, ensuring accurate results for executives' ad-hoc questions without being limited to pre-defined views or exact terminology.
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 pre-calculates year-over-year growth and profit margin
Why it's wrong here
A view can encapsulate calculations, but it limits flexibility. Executives might ask for variations, such as growth by region or margin by product line, which the view may not support. Genie would still need to understand the underlying formulas to generate correct SQL for ad-hoc questions. Relying solely on a view does not teach Genie the business logic.
- ✓
Add instructions in the Genie Space that define the formulas for year-over-year growth and profit margin
Why this is correct
Adding natural language instructions that specify the exact formulas, such as 'year-over-year growth = (current quarter revenue - same quarter last year revenue) / same quarter last year revenue' and 'profit margin = net income / revenue', ensures Genie applies these calculations consistently. This approach handles various phrasings and combinations with other dimensions because Genie uses the definitions to generate SQL dynamically.
- ✗
Train a custom machine learning model to predict the metrics
Why it's wrong here
Training a custom ML model is unnecessary and overly complex. Genie Spaces are designed to translate natural language to SQL using the underlying data and instructions. A custom model would not integrate seamlessly and would require significant effort to maintain. The goal is to leverage Genie's existing capabilities with proper configuration.
- ✗
Restrict the Genie Space to only answer questions that include the exact metric names
Why it's wrong here
Restricting to exact metric names would hinder usability and frustrate executives who may use synonyms or varied phrasing. Genie is designed to handle natural language variations. The analyst should instead provide clear definitions so Genie can recognize and apply the metrics regardless of how they are asked.
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.