Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
An analyst is setting up a Genie Space to handle financial reporting. They want the model to always group results by 'fiscal_quarter'. How should they enforce this requirement?
⚠ Common exam trap
Candidates often look to modify the physical table structure or default database settings rather than using the Genie space configuration options to enforce grouping behavior.
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 constraint to the system instructions.
Forcing specific groupings is best achieved through system instructions in the Genie Space configuration. By explicitly stating 'Always group by fiscal_quarter for all time-based queries,' the analyst provides a mandatory rule for the model. This guarantees that every time-series query generated by the AI aligns with the company's fiscal calendar, preventing the model from defaulting to calendar months and ensuring reporting consistency across the organization.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Update the default table sort order in the catalog.
Why it's wrong here
Table sort order is a database storage concern and does not influence the SQL generation logic of an LLM. Changing it will not force the model to group by a specific column in its query outputs. This approach fails to provide the semantic instruction required to guide the model's behavior.
- ✓
Add a constraint to the system instructions.
Why this is correct
System instructions are the correct place for business rules. By clearly defining that 'all time-based queries must be aggregated by fiscal_quarter', the model is conditioned to prioritize this column. This ensures that the generated SQL respects the mandatory fiscal reporting standards of the organization without requiring user intervention.
- ✗
Force users to type 'group by fiscal_quarter' in their prompts.
Why it's wrong here
Relying on users to provide specific query clauses is error-prone and defeats the purpose of natural language analytics. An effective BI solution should handle these constraints automatically. If users forget, the results will be incorrect, leading to data quality issues and frustration among the business stakeholders.
- ✗
Create a view that excludes the 'date' column.
Why it's wrong here
Removing the date column would prevent the model from performing any time-based analysis, effectively breaking the reporting capability. The goal is to force a specific grouping, not to disable time-based filtering. This approach is destructive to the utility of the Genie Space for financial analysis.
About these practice questions
One of 291 original Databricks-DA-Assoc practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.