Databricks-DA-Assoc · domain
Developing AI/BI Genie Spaces
This domain covers building AI/BI Genie Spaces on Databricks: curating Unity Catalog tables and metadata so natural-language questions return accurate SQL, controlling which SQL warehouse executes queries, and applying governance. Questions present analyst scenarios about freshness, join accuracy, and security, asking you to choose the correct configuration location or the two best actions.
Focused practice
Practice Developing AI/BI Genie Spaces questions
Scored sessions drawing only from this domain — pick a length below.
Start 20-question practice test →What this domain covers
What to know about Developing AI/BI Genie Spaces
Be able to configure a Genie Space: pick its SQL warehouse, curate Unity Catalog table and column metadata, and define relationships so joins like orders-to-customers work. The single most important thing is that Genie answers only as well as the governed, well-described data you give it.
Configuring a Genie Space to use a specific SQL warehouse for query execution
Supplying table and column metadata, comments, and sample questions to improve answer accuracy
Joining related Unity Catalog tables such as orders and customers on shared keys like customer_id
Applying Unity Catalog permissions and row/column security so Genie respects access controls
Watch out for
Common Developing AI/BI Genie Spaces exam traps
- ▸Assuming Genie automatically joins tables; without curated relationships or instructions it may miss the customer_id join and return wrong results.
- ▸Setting the SQL warehouse in the workspace or cluster settings instead of within the Genie Space configuration itself.
- ▸Believing Genie bypasses Unity Catalog security; it inherits permissions, so unsecured tables expose data to all space users.
Question index
All Developing AI/BI Genie Spaces questions (41)
Click any question to see the full explanation, or start a practice session above.
Refer to the exhibit. A developer is configuring a Genie Space. The model is still including discounts in its revenue calculations despite the instruction. What is the most likely cause?
Hard2A data analyst is building an AI/BI Genie space for the marketing team. The team needs to explore data from a Unity Catalog table named `campaign_metrics` and also wants Genie to understand that the column `roi` should always be calculated as `(revenue - cost) / cost`, regardless of how users phrase their questions. The analyst has already added the table to the Genie space. Which action should the analyst take to ensure Genie consistently applies this calculation?
Medium3Refer to the exhibit. An analyst is reviewing the configuration JSON for a Genie Space. Why is the 'instructions' field critical in this scenario?
Medium4Which THREE of the following are essential components of a well-architected AI/BI Genie Space setup?
Hard5An analyst is configuring an AI/BI Genie Space and wants to ensure that the model correctly interprets the term 'revenue' as the sum of the 'sales_amount' column. Which action should the analyst take?
Hard6A business analyst is using an AI/BI Genie Space to explore customer data. They ask, 'What is the average customer age?' The Genie Space returns a result. Which underlying Databricks component does Genie use to execute the generated SQL query?
Easy7An analyst notices that the AI/BI Genie Space is generating queries that take too long to execute. The underlying data is stored in partitioned tables. What is the most effective way to help the Genie generate more performant SQL?
Medium8An analytics team is building an AI/BI Genie space to allow business users to query sales data using natural language. After setting up the base tables, the initial user questions return inaccurate filter values because the LLM struggles to map colloquial region names to the exact string codes stored in the database. What is the most effective feature within AI/BI Genie to resolve this mapping issue without modifying the underlying physical tables?
Medium9Which TWO of the following are best practices for writing instructions in an AI/BI Genie space?
Medium10Who is the primary intended audience for an AI/BI Genie space in a Databricks environment?
Easy11A Genie Space is producing inaccurate results when asked about 'Customer Lifetime Value'. The analyst realizes the AI model is misinterpreting the calculation logic. What is the most effective way to improve the AI's accuracy for this specific business term?
Medium12When designing an AI/BI Genie Space, how can an analyst prevent the model from accessing PII (Personally Identifiable Information) columns in a sensitive table?
Medium13A business user asks a Genie Space, 'Show me the revenue by product.' The model returns an error. What is the most common reason for this failure in a properly configured environment?
Medium14Which primary resource must be granted to users for them to successfully interact with an AI/BI Genie Space to generate insights?
Easy15A 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?
Medium16You are auditing access to several AI/BI Genie Spaces. You discover that a group of users can ask questions but cannot see the underlying source tables in the Catalog Explorer. Is this a functional issue?
Medium17A data analyst is configuring an AI/BI Genie Space to allow business users to query sales data. The analyst needs to ensure the Space uses the most performant and governed data source available in the Unity Catalog. Which configuration should the analyst prioritize?
Medium18A data analyst is tuning an AI/BI Genie space used by the finance department. Users report that Genie sometimes returns plausible but incorrect aggregations, and that questions referencing 'net revenue' produce inconsistent results. The analyst wants to improve grounding and reliability. Which TWO actions should the analyst take? (Choose two.)
Hard19Which TWO actions should an analyst take to improve the accuracy of an AI/BI Genie Space when users report that it frequently hallucinates metric definitions?
Medium20An analyst is configuring an AI/BI Genie Space for a retail dataset. The analyst wants Genie to map the business term "top sellers" to a specific calculation that ranks products by total units sold. Where should the analyst define this mapping?
Medium21A Data Analyst is configuring an AI/BI Genie Space to allow business users to query sales data. The analyst needs to ensure the model understands specific business logic, such as how to calculate 'Net Revenue' from raw columns. Where should the analyst define this logic to ensure Genie consistently applies these business rules across all user queries?
Medium22Why should an analyst use the 'feedback' feature provided in an AI/BI Genie space interface?
Easy23Which THREE features are provided by AI/BI Genie spaces to help business users analyze data independently?
Medium24A data analyst is setting up a new Genie space. Which TWO of the following are prerequisites for the successful creation and usage of a Genie space?
Medium25An 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?
Medium26Refer to the exhibit. The Genie Space output is consistently truncated. What is the most likely cause?
Hard27A data analyst builds an AI/BI Genie Space over a Unity Catalog table named sales.transactions. Business users report that when they ask questions such as "total revenue by region," Genie returns figures that include cancelled orders, which should be excluded. The analyst wants Genie to always apply this filter. What should the analyst do?
Medium28An analyst notices that the Genie space is consistently ignoring a specific column during query generation. What is the most effective way to force the model to consider this column?
Hard29What is the primary implication of granting a user 'Can Use' permission on a Genie space?
Medium30What is the primary purpose of adding 'Instructions' to a Genie space in Databricks?
Easy31A data analyst is creating a new AI/BI Genie Space for the sales team. They want to add a trusted table that contains curated sales data. Which of the following is the correct way to add a table to the Genie Space?
Medium32Which of the following is the best strategy for refining Genie space performance when the model consistently struggles with complex joins?
Hard33An analyst wants to ensure that a Genie space only uses the most recent data for all queries. How can this be achieved?
Medium34An analyst is building an AI/BI Genie space over a Unity Catalog schema containing both `orders` and `customers` tables. Business users often ask questions that require joining the two tables on `customer_id`. During testing, Genie frequently generates queries that join on the wrong column or omit the join entirely, producing inflated row counts. The analyst has already verified that both tables are selected and that column names are clear. Which action is most likely to correct Genie's join behavior?
Hard35What happens if a user submits a question that requires data from a table NOT explicitly defined in the Genie space configuration?
Medium36A data analyst is configuring an AI/BI Genie Space for a marketing team. The team frequently asks questions that require joining multiple tables, such as 'Which campaigns generated the most leads?' and 'What is the conversion rate by channel?' The analyst notices that Genie sometimes produces incorrect joins, leading to inflated numbers. Which TWO actions should the analyst take to improve Genie's join accuracy? (Choose two.)
Hard37Which component of an AI/BI Genie space is responsible for defining the scope of data available to a user and ensuring that the natural language model only references authorized tables?
Medium38A 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?
Medium39An analyst is configuring an AI/BI Genie Space and wants to ensure that the model only uses a specific SQL warehouse for query execution. Where should the analyst configure this setting?
Medium40A 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?
Medium41An 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)
HardOther domains
All Databricks-DA-Assoc exam domains
Frequently asked questions
- What does the Developing AI/BI Genie Spaces domain cover on the Databricks-DA-Assoc exam?
- Be able to configure a Genie Space: pick its SQL warehouse, curate Unity Catalog table and column metadata, and define relationships so joins like orders-to-customers work. The single most important thing is that Genie answers only as well as the governed, well-described data you give it.
- How many questions are in this domain?
- This page lists all 41 Developing AI/BI Genie Spaces questions in the Databricks-DA-Assoc question bank. The actual exam draws from this domain proportionally to its weighting in the official exam blueprint.
- What is the best way to practise this domain?
- Start with a short focused session (10 questions) to identify gaps, then work through explanations. Repeat with a longer session once the weak areas feel solid.
- Can I practise only Developing AI/BI Genie Spaces questions?
- Yes — the session launcher on this page filters questions to this domain only. Choose any session length for inline explanations and scoring.