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