Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
A data analyst is configuring an AI/BI Genie Space for a customer support dataset. The analyst notices that when users ask "how many open tickets per agent," Genie sometimes counts all tickets instead of only open ones. The analyst wants to fix this. What should the analyst do?
⚠ Common exam trap
The trap here is choosing a view that permanently filters the data, which would prevent answering questions about closed tickets, instead of using an instruction to define the term.
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 an instruction that defines "open tickets" as tickets where status = 'Open'.
The most direct fix is to add an instruction defining "open tickets" as tickets where status = 'Open'. This teaches Genie the business term and ensures it applies the correct filter when generating SQL, without restricting the data for other 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.
- ✗
Add a comment to the status column listing all possible values.
Why it's wrong here
A comment listing status values helps Genie understand the column, but it does not define that "open tickets" means status = 'Open'. Genie might still count all tickets. The comment is useful metadata, but the specific business term mapping requires an instruction or a more explicit definition.
- ✗
Create a view that filters tickets to only those with status = 'Open' and add it to the Genie Space.
Why it's wrong here
A view with a hardcoded filter would exclude closed tickets entirely, which may be undesirable if users later ask about closed tickets. It also does not teach Genie the meaning of "open tickets" for other contexts. A view changes the data, while an instruction changes interpretation, which is more flexible here.
- ✓
Add an instruction that defines "open tickets" as tickets where status = 'Open'.
Why this is correct
Genie relies on instructions to resolve ambiguous business terms. By explicitly defining "open tickets" as tickets with status = 'Open', the analyst gives Genie the filter logic. This directly addresses the misinterpretation and ensures the generated SQL includes the correct WHERE clause for that term.
- ✗
Rename the status column to ticket_status.
Why it's wrong here
Renaming the column to ticket_status improves clarity but does not define "open tickets". Genie still needs to know which status value corresponds to open. The rename alone does not solve the misinterpretation of the business term. An instruction is needed to map the term to the filter.
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.