Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
A data analyst is preparing an AI/BI Genie Space for a sales team. The team often asks questions like 'Show me the top 10 customers by revenue' and 'What were the total sales last quarter?' The analyst wants to ensure that Genie understands that the 'revenue' column in the sales table is calculated as 'quantity * unit_price' and that 'last quarter' refers to the most recent completed fiscal quarter. Which feature should the analyst use to provide this business context?
⚠ Common exam trap
The trap here is assuming that metadata descriptions in Unity Catalog are sufficient to convey business logic, but they are static and cannot encode dynamic calculations or relative time definitions.
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
✓
Configure the Genie Space with instructions and sample queries
Genie Spaces are configured with natural language instructions and sample queries to teach the model business-specific terminology and calculations. This allows Genie to correctly interpret terms like 'revenue' as a formula and 'last quarter' as a relative time period, enabling accurate responses to ad-hoc questions.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Set up a scheduled job to refresh the data and update statistics
Why it's wrong here
Scheduled jobs and statistics updates improve data freshness and query performance but do not provide semantic context. They do not help Genie understand what 'revenue' means or how to interpret 'last quarter'. These are operational tasks, not semantic configuration for the Genie Space.
- ✓
Configure the Genie Space with instructions and sample queries
Why this is correct
Genie Spaces allow analysts to provide natural language instructions that define business terms and calculations, such as 'revenue = quantity * unit_price' and 'last quarter = most recent completed fiscal quarter'. Sample queries further guide the model by showing expected SQL patterns. This combination ensures Genie correctly interprets the team's questions.
- ✗
Add table and column descriptions in the Unity Catalog
Why it's wrong here
Adding descriptions in Unity Catalog documents the data but does not provide the dynamic business logic or time period definitions needed for Genie to interpret 'revenue' as a calculation or 'last quarter' as a relative time frame. Genie uses these descriptions for understanding, but they are static and cannot encode formulas or relative date logic.
- ✗
Create a view in Databricks SQL that pre-calculates revenue and filters for last quarter
Why it's wrong here
Creating a view can simplify queries, but it does not teach Genie the business definitions. The team might ask about other time periods or calculations, and the view would not adapt. Genie needs to understand the underlying logic to generate correct SQL for varied questions, not just a single pre-defined view.
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.