Courseiva

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.

41 questions5 easy26 medium10 hard

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.

1

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?

Hard
2

A 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?

Medium
3

Refer to the exhibit. An analyst is reviewing the configuration JSON for a Genie Space. Why is the 'instructions' field critical in this scenario?

Medium
4

Which THREE of the following are essential components of a well-architected AI/BI Genie Space setup?

Hard
5

An 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?

Hard
6

A 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?

Easy
7

An 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?

Medium
8

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?

Medium
9

Which TWO of the following are best practices for writing instructions in an AI/BI Genie space?

Medium
10

Who is the primary intended audience for an AI/BI Genie space in a Databricks environment?

Easy
11

A 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?

Medium
12

When designing an AI/BI Genie Space, how can an analyst prevent the model from accessing PII (Personally Identifiable Information) columns in a sensitive table?

Medium
13

A 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?

Medium
14

Which primary resource must be granted to users for them to successfully interact with an AI/BI Genie Space to generate insights?

Easy
15

A 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?

Medium
16

You 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?

Medium
17

A 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?

Medium
18

A 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.)

Hard
19

Which 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?

Medium
20

An 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?

Medium
21

A 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?

Medium
22

Why should an analyst use the 'feedback' feature provided in an AI/BI Genie space interface?

Easy
23

Which THREE features are provided by AI/BI Genie spaces to help business users analyze data independently?

Medium
24

A 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?

Medium
25

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?

Medium
26

Refer to the exhibit. The Genie Space output is consistently truncated. What is the most likely cause?

Hard
27

A 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?

Medium
28

An 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?

Hard
29

What is the primary implication of granting a user 'Can Use' permission on a Genie space?

Medium
30

What is the primary purpose of adding 'Instructions' to a Genie space in Databricks?

Easy
31

A 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?

Medium
32

Which of the following is the best strategy for refining Genie space performance when the model consistently struggles with complex joins?

Hard
33

An analyst wants to ensure that a Genie space only uses the most recent data for all queries. How can this be achieved?

Medium
34

An 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?

Hard
35

What happens if a user submits a question that requires data from a table NOT explicitly defined in the Genie space configuration?

Medium
36

A 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.)

Hard
37

Which 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?

Medium
38

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?

Medium
39

An 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?

Medium
40

A 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?

Medium
41

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)

Hard

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.
databricks-data-analyst-associate DATABRICKS-DATA-ANALYST-ASSOCIATE developing ai bi genie spaces Practice Questions