Skip to content

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?

  1. AIt generates and runs a DELETE statement, because the manager holds MODIFY on the table
  2. BIt switches to Agent mode, which can write to tables
  3. CIt answers only with read-only SQL, which runs on the agent's SQL warehouse
  4. 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.

Question 2 · choose 1

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?

  1. AOne more
  2. BNone; the agent is already over the limit
  3. CTwo more
  4. 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.

Question 3 · choose 1

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?

  1. AThe foreign table must first be ingested into a managed table, and the classic warehouse can stay
  2. BShe needs CAN USE on a pro or serverless SQL warehouse; all three objects can be added as they are
  3. CThe materialized view must be replaced by its base tables, because Genie Agents read only tables and views
  4. 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.

Question 4 · choose 1

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?

  1. ANothing; Genie answers can only be viewed in the chat
  2. BDownload only the first 1,000 rows shown in the chat
  3. CDownload the results with Copy CSV, up to about 1GB of data
  4. 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.

Question 5 · choose 1

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?

  1. AThe SQL editor
  2. BCatalog Explorer
  3. CLakeflow Jobs
  4. 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.

Question 6 · choose 1

An author configures sample questions in a Genie Agent's settings. Where do users see them?

  1. AIn the chat window, ready to click
  2. BOnly in the agent's audit log
  3. CIn the SQL warehouse's query history
  4. 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.

Question 7 · choose 1

An analyst creates a new Genie Agent. Which permission does she automatically hold on it?

  1. ACAN VIEW
  2. BCAN MANAGE
  3. CCAN RUN
  4. DNone until an admin grants one
Show the answer and why
  • ACAN VIEW

    Incorrect

    Creators get the highest permission level on their agents.

  • BCAN MANAGE

    Correct

    Genie Agent creators automatically have CAN MANAGE on agents they create.

  • CCAN RUN

    Incorrect

    Creators get more than run access.

  • DNone until an admin grants one

    Incorrect

    Creators receive CAN MANAGE automatically.

Creating or editing a Genie Agent requires at least CAN EDIT on it, and creators automatically have CAN MANAGE on the agents they create.

Practice domain 7 →Practice all domains →