Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Test 3 — 15 Questions

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Configure the Genie Space to use a certified, high-performance Delta table registered in Unity Catalog.. Genie Spaces rely on Delta tables registered in Unity Catalog to provide natural language insights. By pointing the Genie Space to a curated, high-quality Delta table rather than a raw landing zone table, the analyst ensures that the AI model produces accurate, governed results. This setup is crucial for maintaining data integrity and performance while enabling self-service analytics for non-technical stakeholders who interact with the Genie interface.

Answer

Link the Genie Space directly to a JSON file located in an external cloud storage bucket.

Answer

Upload a static CSV file containing sales history directly into the Genie Space interface.

Answer

Point the Genie Space to a temporary View that contains no documented column descriptions or metadata.

Question 2

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?

Accepted Answer

Update the Genie Space instructions with clear, natural language definitions for the calculation.. Providing clear instructions in the Genie Space instructions field allows developers to define business-specific logic that the AI might not inherently understand. By embedding these definitions directly into the Genie configuration, you constrain the AI's query generation process to adhere to pre-approved business formulas. This is essential for ensuring that multiple users get consistent answers for complex metrics, regardless of how they phrase their natural language questions.

Answer

Modify the underlying Delta table data to include a pre-computed column for every possible metric.

Answer

Restrict access to the Genie Space so only the senior data architect can run queries.

Answer

Rename all columns in the Unity Catalog table to match the exact wording of the user's questions.

Question 3

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)

Accepted Answer

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

Enable 'auto-query' for all users to maximize data exploration.

Answer

Grant all users the 'Owner' role on the Genie Space to allow for maximum customization.

Answer

Remove all constraints and indexes to allow the AI to move faster.

Question 4

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

Accepted Answer

It ensures the AI correctly implements the required join logic between the two datasets.. The 'instructions' field serves as a critical bridge between natural language and technical SQL execution. Without this specific guidance, the Genie model might attempt to join tables incorrectly or ignore necessary filtering logic. By explicitly defining the join strategy, the analyst ensures that the AI consistently uses the standard business join keys, preventing the generation of incorrect, unoptimized, or cross-joined results that would compromise data accuracy.

Answer

It automatically generates a visualization for the user whenever a query is run.

Answer

It forces the user to provide a region ID every time they ask a question.

Answer

It caches the results of the query to improve performance for future users.

Question 5

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?

Accepted Answer

In the Genie Space configuration, navigate to the Data tab and add the table from the Unity Catalog.. To add a table to an AI/BI Genie Space, you must use the Genie Space configuration interface. The Data tab allows you to select tables and views from Unity Catalog, ensuring the Space has access to the correct data sources. This is the only supported method that integrates the table with the natural language query engine, providing accurate and secure responses.

Answer

Use the Databricks SQL query editor to run a CREATE TABLE statement.

Answer

Use the Databricks CLI to run 'databricks genie add-table' with the table name.

Answer

Create a Databricks notebook that reads the table and register it as a temporary view.

Question 6

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?

Accepted Answer

Create a view in Unity Catalog that filters out cancelled orders, and point the Genie Space at that view.. The most reliable way to enforce a permanent business rule is to define it in the data layer. A Unity Catalog view that filters out cancelled orders ensures every Genie-generated query respects the rule. Instructions and user prompts are not guaranteed to add the filter, and compute resources do not apply data logic.

Answer

Create a SQL warehouse that only returns rows where status is not cancelled.

Answer

Ask business users to include "excluding cancelled orders" in every question.

Answer

Add an instruction to the Genie Space telling it to filter out cancelled orders.

Question 7

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?

Accepted Answer

Add a synonym 'revenue' to the 'sales_amount' column in the Genie Space's semantic configuration.. The correct approach is to add a synonym in the Genie Space's semantic configuration. This feature allows analysts to map business terms to specific columns, ensuring the model understands that 'revenue' refers to 'sales_amount'. Synonyms are part of the Space's semantic layer and are used during natural language to SQL translation, leading to more accurate and consistent results.

Answer

Create a view that renames 'sales_amount' to 'revenue' and add that view to the Genie Space.

Answer

Add a column comment to the 'sales_amount' column in Unity Catalog that says 'This is revenue'.

Answer

In the Genie Space instructions, write a note that says 'revenue means sales_amount'.

Question 8

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?

Accepted Answer

In the Genie Space's instructions, add a definition: "top sellers" means products ranked by total units sold.. Genie Space instructions are designed to capture business glossary definitions and calculation rules. Defining "top sellers" as products ranked by total units sold directly in the instructions gives Genie the semantic knowledge to generate correct SQL for that phrase, without altering the data model.

Answer

Create a Unity Catalog function named top_sellers and reference it in the Genie Space.

Answer

Add a comment to the units_sold column stating that it is used for top sellers.

Answer

Create a metric view that pre-calculates top sellers and add it to the Genie Space.

Question 9

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?

Accepted Answer

Configure the Genie Space with instructions and sample queries. Genie Spaces are configured with natural language instructions and sample queries to teach the model business-specific terminology and calculations. This allows Genie to correctly interpret terms like 'revenue' as a formula and 'last quarter' as a relative time period, enabling accurate responses to ad-hoc questions.

Answer

Set up a scheduled job to refresh the data and update statistics

Answer

Add table and column descriptions in the Unity Catalog

Answer

Create a view in Databricks SQL that pre-calculates revenue and filters for last quarter

Question 10

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Define foreign key relationships in the Unity Catalog. To improve Genie's join accuracy, the analyst should define foreign key relationships in Unity Catalog and provide sample queries with correct joins. These actions give Genie the necessary metadata and examples to understand table relationships and generate accurate SQL, reducing errors like Cartesian products or mismatched keys.

Answer

Enable caching for the tables used in the Genie Space

Answer

Increase the compute cluster size for the Genie Space

Answer

Restrict the Genie Space to a single table to avoid joins

Question 11

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?

Accepted Answer

Databricks SQL warehouse. AI/BI Genie Spaces rely on Databricks SQL warehouses to execute the SQL queries generated from natural language. The SQL warehouse provides the necessary compute and is optimized for BI workloads, ensuring fast and reliable results. Other components like Spark clusters or notebooks are not used for this purpose.

Answer

Apache Spark cluster

Answer

Delta Live Tables pipeline

Answer

Databricks notebook

Question 12

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?

Accepted Answer

Add instructions in the Genie Space that define the formulas for year-over-year growth and profit margin. Providing instructions that define the formulas for year-over-year growth and profit margin allows Genie to understand and apply these calculations consistently. This method is flexible and handles various phrasings, ensuring accurate results for executives' ad-hoc questions without being limited to pre-defined views or exact terminology.

Answer

Create a view that pre-calculates year-over-year growth and profit margin

Answer

Train a custom machine learning model to predict the metrics

Answer

Restrict the Genie Space to only answer questions that include the exact metric names

Question 13

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?

Accepted Answer

In the Genie Space settings, under the SQL warehouse section.. To specify the SQL warehouse for a Genie Space, the analyst must use the Genie Space settings. There, they can select the desired warehouse from available options. This configuration ensures that all natural language queries are executed on the chosen warehouse, providing control over performance, cost, and permissions.

Answer

In the Databricks workspace admin console, under the Genie tab.

Answer

In the SQL query editor of the Genie Space, by adding a USE WAREHOUSE statement.

Answer

In the Unity Catalog metastore settings.

Question 14

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

Accepted Answer

Add a general instruction in the Genie space that defines net revenue as gross revenue minus returns and discounts.. Inconsistent results for a business term like net revenue are best resolved by encoding the definition explicitly and demonstrating it. General instructions provide the textual rule, while example SQL queries show the exact joins and arithmetic. Together they ground the model's interpretation and reduce plausible-but-incorrect outputs. Compute scaling and access restrictions do not address semantic ambiguity.

Answer

Remove all tables except one from the Genie space so the model has fewer choices.

Answer

Switch the Genie space to use a larger SQL warehouse so the model has more compute for reasoning.

Answer

Restrict the space to read-only access for all users so no one can modify the underlying data.

Question 15

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?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Add an instruction that defines "open tickets" as tickets where status = 'Open'.. The most direct fix is to add an instruction defining "open tickets" as tickets where status = 'Open'. This teaches Genie the business term and ensures it applies the correct filter when generating SQL, without restricting the data for other questions.

Answer

Add a comment to the status column listing all possible values.

Answer

Create a view that filters tickets to only those with status = 'Open' and add it to the Genie Space.

Answer

Rename the status column to ticket_status.