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.
Start practicing
Developing AI/BI Genie Spaces — choose a session length
Free · No account required
Domain overview
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.
Exam objectives
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
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.
Click any question to see the full explanation and answer options, or start a focused practice session above.
An 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?
2Which 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?
3What is the primary purpose of adding 'Instructions' to a Genie space in Databricks?
4A 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?
5An 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?
6Which THREE features are provided by AI/BI Genie spaces to help business users analyze data independently?
7Which of the following is the best strategy for refining Genie space performance when the model consistently struggles with complex joins?
8Who is the primary intended audience for an AI/BI Genie space in a Databricks environment?
9What is the primary implication of granting a user 'Can Use' permission on a Genie space?
10Which TWO of the following are best practices for writing instructions in an AI/BI Genie space?
11An analyst wants to ensure that a Genie space only uses the most recent data for all queries. How can this be achieved?
12What happens if a user submits a question that requires data from a table NOT explicitly defined in the Genie space configuration?
13Why should an analyst use the 'feedback' feature provided in an AI/BI Genie space interface?
14A 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?
15Which primary resource must be granted to users for them to successfully interact with an AI/BI Genie Space to generate insights?
16Refer 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?
17Which 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?
18An 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?
19You 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?
20Which THREE of the following are essential components of a well-architected AI/BI Genie Space setup?
21An 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?
22A 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?
23Refer to the exhibit. The Genie Space output is consistently truncated. What is the most likely cause?
24When designing an AI/BI Genie Space, how can an analyst prevent the model from accessing PII (Personally Identifiable Information) columns in a sensitive table?
25A 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?
26A 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?
27An 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)
28Refer to the exhibit. An analyst is reviewing the configuration JSON for a Genie Space. Why is the 'instructions' field critical in this scenario?
29A 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?
30A 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?
31An 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?
32An 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?
33A 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?
34A 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.)
35A 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?
36A 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?
37An 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?
38A 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.)
39A 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?
40An 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?
41A 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?
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.
The Courseiva Databricks-DA-Assoc question bank contains 41 questions in the Developing AI/BI Genie Spaces domain. Click any question to see the full explanation and answer breakdown.
Start with a 10-question focused session to identify your baseline accuracy in this domain. Read every explanation — even for questions you answer correctly — to understand the reasoning. Once you score consistently above 80%, move to a 20–30 question session to confirm depth before moving to the next domain.
Yes — the session launcher on this page draws questions exclusively from the Developing AI/BI Genie Spaces domain. Choose 10, 20, 30, or 50 questions for a focused session, or click individual questions to review them one by one.
Save your results, see per-domain analytics, and get readiness scores — free, for every certification.
Sign Up FreeFree forever · Every certification included