Data Analyst Associate · Domain 7: Developing, Sharing, and Maintaining AI/BI Genie Agents (Genie Spaces) · 12% of the exam
Task 7.1: Describe the purpose, key features, and components of AI/BI Genie Agents (Genie spaces); Create Genie Agents (Genie spaces) by defining reasonable sample questions and domain-specific instructions, choosing SQL warehouses, curating Unity Catalog datasets (tables, views...), and vetting queries as Trusted Assets
What a Genie Agent is and how it answers, and setting one up with Unity Catalog data, a pro or serverless warehouse, sample questions, instructions and trusted assets.
Study it
Genie Agents: purpose, components and setup
Lesson coming
Sample questions
Try each one before opening the answer. Every option is explained, with the Databricks documentation page that proves it.
Question 1 · choose 1
A store manager types "delete the test orders from last week" into a Genie Agent (the exam guide: Genie space) built on the table main.sales.orders. The manager holds MODIFY on that table. What does the Genie Agent do with the request?
AIt generates and runs a DELETE statement, because the manager holds MODIFY on the table
BIt switches to Agent mode, which can write to tables
CIt answers only with read-only SQL, which runs on the agent's SQL warehouse
DIt forwards the statement to the manager's notebook, where it runs on the manager's compute
Show the answer and why
AIt generates and runs a DELETE statement, because the manager holds MODIFY on the table
Incorrect
Queries that Genie generates are always read-only, whatever privileges the user holds.
BIt switches to Agent mode, which can write to tables
Incorrect
Agent mode handles complex, multi-step questions; it does not make Genie's generated queries writable.
CIt answers only with read-only SQL, which runs on the agent's SQL warehouse
Correct
Genie generates SQL that runs on the agent's SQL warehouse, and generated queries are always read-only.
DIt forwards the statement to the manager's notebook, where it runs on the manager's compute
Incorrect
Genie runs its generated queries on the agent's SQL warehouse, not on the user's notebook compute.
A Genie Agent (formerly Genie Space) is a natural-language interface over Unity Catalog data. In most cases Genie generates a SQL query that runs on the agent's SQL warehouse; generated queries are always read-only, so data changes are not made through it.
A Genie Agent has 92 example SQL queries, 6 Unity Catalog SQL functions and a General instructions text block of 12 paragraphs. The author wants to add more example SQL queries. How many more can she add before reaching the instruction limit?
AOne more
BNone; the agent is already over the limit
CTwo more
DEight more
Show the answer and why
AOne more
Correct
The limit is 100 instructions; each example query and each function counts as one and the whole General instructions block as one: 92 + 6 + 1 = 99.
BNone; the agent is already over the limit
Incorrect
The General instructions block counts as one instruction as a whole, not one per paragraph.
CTwo more
Incorrect
The General instructions text block also counts as one instruction.
DEight more
Incorrect
SQL functions count toward the limit, each as one instruction.
Genie Agents allow 100 instructions per agent. Each example SQL query, each SQL function, and the entire General instructions text block each count as one instruction, so 92 examples, 6 functions and one text block use 99 of the 100.
An analyst is creating a Genie Agent over three Unity Catalog objects: a managed table, a table in a foreign catalog that mirrors a PostgreSQL database, and a materialized view. The only warehouse she can use today is a classic SQL warehouse on which she has CAN MANAGE. What, if anything, must change for the agent to work?
AThe foreign table must first be ingested into a managed table, and the classic warehouse can stay
BShe needs CAN USE on a pro or serverless SQL warehouse; all three objects can be added as they are
CThe materialized view must be replaced by its base tables, because Genie Agents read only tables and views
DNothing; CAN MANAGE on the classic warehouse covers the agent's compute
Show the answer and why
AThe foreign table must first be ingested into a managed table, and the classic warehouse can stay
Incorrect
Genie Agents can use foreign tables, and they need a pro or serverless warehouse, which the classic one is not.
BShe needs CAN USE on a pro or serverless SQL warehouse; all three objects can be added as they are
Correct
Genie Agents work on Unity Catalog managed, external and foreign tables, views, metric views and materialized views, and require a pro or serverless warehouse.
CThe materialized view must be replaced by its base tables, because Genie Agents read only tables and views
Incorrect
Materialized views are among the Unity Catalog objects a Genie Agent can use.
DNothing; CAN MANAGE on the classic warehouse covers the agent's compute
Incorrect
A higher permission does not change the warehouse type: Genie Agents require a pro or serverless SQL warehouse.
A Genie Agent is based on data registered to Unity Catalog, including managed, external and foreign tables, views, metric views and materialized views, up to 50 objects. It requires a pro or serverless SQL warehouse, and the author needs at least CAN USE on the selected warehouse.
A manager gets a useful table of results from a Genie Agent (the exam guide: Genie space) and wants the data as a CSV file. What can she do?
ANothing; Genie answers can only be viewed in the chat
BDownload only the first 1,000 rows shown in the chat
CDownload the results with Copy CSV, up to about 1GB of data
DAsk the agent's author to export the warehouse's query history
Show the answer and why
ANothing; Genie answers can only be viewed in the chat
Incorrect
Responses with generated SQL offer a download of the results as CSV.
BDownload only the first 1,000 rows shown in the chat
Incorrect
The download is not limited to a 1,000-row preview; it allows about 1GB of results.
CDownload the results with Copy CSV, up to about 1GB of data
Correct
Agent users can download up to approximately 1GB of results data as a CSV from the response.
DAsk the agent's author to export the warehouse's query history
Incorrect
She can download the response's results herself.
For responses that include generated SQL, Genie Agent users can download up to approximately 1GB of results data as a CSV, show the generated code, or copy the CSV to the clipboard.
Which Databricks interface is the simplified UI for business users, a single entry point to data and AI without technical concepts such as compute or notebooks?
AThe SQL editor
BCatalog Explorer
CLakeflow Jobs
DGenie One
Show the answer and why
AThe SQL editor
Incorrect
The SQL editor is for writing queries.
BCatalog Explorer
Incorrect
Catalog Explorer explores and manages data objects.
CLakeflow Jobs
Incorrect
Lakeflow Jobs orchestrates tasks.
DGenie One
Correct
Genie One, previously Databricks One, is the simplified UI for business users.
Genie One (previously known as Databricks One) is the simplified Databricks UI for business users: a single entry point for data and AI without navigating compute, queries, models or notebooks.
An author configures sample questions in a Genie Agent's settings. Where do users see them?
AIn the chat window, ready to click
BOnly in the agent's audit log
CIn the SQL warehouse's query history
DIn Catalog Explorer, on each table's page
Show the answer and why
AIn the chat window, ready to click
Correct
Sample questions configured in the agent settings appear in the chat window, and users can click one.
BOnly in the agent's audit log
Incorrect
Sample questions are shown to users in the chat.
CIn the SQL warehouse's query history
Incorrect
Query history lists queries, not configured sample questions.
DIn Catalog Explorer, on each table's page
Incorrect
Sample questions belong to the agent's chat.
Sample questions configured in the agent settings appear in the chat window, and Genie can also generate sample questions from the agent's context to help users start exploring.