Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question
An analyst is preparing a Genie Space and wants to ensure users get the most accurate answers while maintaining security. Which TWO actions should the analyst take? (Choose two)
⚠ Common exam trap
Candidates often focus only on technical performance (like indexing) while ignoring the importance of metadata curation. They forget that the AI model relies heavily on descriptive names to accurately map natural language.
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
✓
Exclude highly sensitive columns that are not needed for general analysis.
Proper curation of the Genie Space is vital for performance and security. By including only the necessary columns and providing explicit instructions, the analyst reduces noise and ensures the AI model operates within the boundaries of the organization's data governance framework. These steps directly impact the quality of the SQL generated and the safety of the information exposed to end-users via the AI interface.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Exclude highly sensitive columns that are not needed for general analysis.
Why this is correct
Minimizing the schema surface area reduces the risk of the model inadvertently exposing sensitive PII or financial data. By strictly limiting the columns available to Genie, the analyst enforces the principle of least privilege, ensuring that users can only query the data they truly need for their business tasks.
- ✗
Enable 'auto-query' for all users to maximize data exploration.
Why it's wrong here
Enabling auto-query for all users can lead to unpredictable compute costs and potential data exposure if not properly governed. It is best practice to monitor performance and ensure that users are trained on the tool before enabling broad, unmonitored access to the underlying data via automated queries.
- ✓
Provide descriptive names and comments for all tables and columns in Unity Catalog.
Why this is correct
The Genie AI engine relies on metadata to understand the context and purpose of the data. High-quality comments and clear, meaningful names help the model correctly identify which columns to use, significantly increasing the accuracy of the generated SQL and reducing the frequency of incorrect or nonsensical query results.
- ✗
Grant all users the 'Owner' role on the Genie Space to allow for maximum customization.
Why it's wrong here
Granting 'Owner' permissions to all users is a major security risk that violates the principle of least privilege. Users should be assigned roles based on their specific needs, such as 'Viewer' or 'Editor', to prevent accidental modification or deletion of the Genie Space configuration and its associated underlying data.
- ✗
Remove all constraints and indexes to allow the AI to move faster.
Why it's wrong here
Removing constraints and indexes degrades database performance and removes essential metadata that the AI uses to understand relationships between tables. These structures are critical for the SQL engine to execute queries efficiently, and they provide necessary information for the AI to understand how to perform joins correctly.
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.