Home / Data Analyst practice test / Developing, Sharing, and Maintaining AI/BI Genie spaces / Question

Databricks Data Analyst Associate · free practice question

A data analyst wants to add a complex SQL function to a Genie space so that Genie can invoke it as a verified trusted asset when answering specific business…

Exam-style question on Developing, Sharing, and Maintaining AI/BI Genie spaces from the free Data Analyst practice test, with the answer and a full explanation below.

Updated November 10, 2026

Developing, Sharing, and Maintaining AI/BI Genie spaces

A data analyst wants to add a complex SQL function to a Genie space so that Genie can invoke it as a verified trusted asset when answering specific business questions. Where must this function be registered before it can be added to the Genie space?

  1. AIt must be saved as a .sql file in the Databricks workspace file browser under the author's user folder, and then referenced by relative path from within the Genie space's SQL Queries configuration tab
  2. BIt must be created inside the Genie space editor itself using the Built-in Function Builder, which compiles and sandboxes the function logic within the Genie space's private execution context
  3. CIt must be uploaded as a Python UDF jar into the SQL warehouse's external libraries configuration so that Genie can dynamically load and invoke it at query runtime through the warehouse compute layer
  4. DIt must be hosted in a Databricks Repos Git-tracked SQL file and linked to the Genie space via its repository URL, allowing Genie to pull and compile the function definition at each invocation
  5. EIt must be registered as a Unity Catalog SQL table function first; only after that registration can it be added to a Genie space as a trusted asset under Configure > Instructions > SQL Queries
Answer & explanation

Correct answer: E

WHY E: Databricks documentation explicitly states that SQL functions used as trusted assets in Genie must be registered in Unity Catalog. The function is a Unity Catalog securable object, and once registered, a user with at least CAN EDIT permission on the Genie space can add it via Configure > Instructions > SQL Queries. WHY NOT A: Saving a .sql file in the workspace file browser does not register it as a Unity Catalog function; Genie cannot reference workspace-path SQL files as callable trusted assets. WHY NOT B: There is no Built-in Function Builder inside the Genie space editor; functions must be created externally and then registered in Unity Catalog before being added to the space. WHY NOT C: Python UDF jars in library configurations are not the mechanism for Genie trusted assets; Genie trusted asset functions must be SQL table functions registered in Unity Catalog. WHY NOT D: Linking a Repos SQL file by URL does not make it a callable Unity Catalog function; Unity Catalog registration is required specifically so the function is a governed, executable object with proper permissions.

Take the full Data Analyst practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Analyst Associate practice test. Take it and get a section-by-section score.

Start the free test →