Courseiva

Databricks-DA-Assoc Developing AI/BI Genie Spaces Practice Question

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?

⚠ Common exam trap

The trap here is thinking that the SQL warehouse can be set via a SQL statement or in global admin settings, when it is actually configured per Genie Space.

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

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 analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

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

    Why it's wrong here

    There is no Genie tab in the workspace admin console for warehouse selection. The admin console manages workspace-level settings, but SQL warehouse assignment for Genie Spaces is done within each Space's configuration. This option incorrectly assumes a centralized admin setting, which does not exist.

  • ✗

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

    Why it's wrong here

    The SQL query editor is for writing and testing queries, not for configuring the Space's default warehouse. Adding a USE WAREHOUSE statement would only affect the current session in the editor, not the queries generated by Genie for users. The warehouse must be set in the Space settings.

  • ✓

    In the Genie Space settings, under the SQL warehouse section.

    Why this is correct

    The Genie Space settings include a section to select the SQL warehouse that the Space will use for query execution. By specifying a warehouse here, the analyst ensures that all queries generated by Genie run on that warehouse. This is the correct place to configure the compute resource, providing control over performance and cost.

  • ✗

    In the Unity Catalog metastore settings.

    Why it's wrong here

    Unity Catalog metastore settings manage data governance, permissions, and metadata, not compute resources. SQL warehouse selection is not configured at the metastore level. This option is incorrect because it confuses data governance with query execution configuration. The warehouse is chosen per Genie Space, not globally.

About these practice questions

Courseiva writes every Databricks-DA-Assoc question from scratch — 291 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written and reviewed by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

Last reviewed September 2026 · checked against the official Databricks exam blueprint

This Databricks-DA-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DA-Assoc exam.