Databricks Data Engineer Associate Question 205
Select 3You are tasked with creating a SQL User-Defined Function (UDF) in Databricks that needs to be shared across multiple users in your workspace. Which of the following statements correctly describe the security model for sharing SQL UDFs in Databricks?
- A
SQL UDFs are stored in the Unity Catalog and follow the same permission model as other Unity Catalog objects.
- B
Permissions for SQL UDFs can be granted at the function level to control access.
- C
SQL UDFs are automatically accessible to all workspace users once created, without requiring any additional permissions.
- D
To use a shared SQL UDF, a user must have the appropriate permissions on both the UDF and the underlying objects it references.
- E
SQL UDFs created in a database can only be accessed by the creator and cannot be shared with others.
Show answer and explanation
Correct answers: A, B, D
Explanation
The security model for SQL UDFs in Databricks is tightly integrated with the Unity Catalog. This model ensures that UDFs are governed by the same fine-grained access controls as other Unity Catalog objects. Permissions can be granted at the UDF level and must also align with the permissions on any underlying objects the UDF references. This ensures proper governance and security when sharing UDFs across users.
- A. Correct.
Correct: SQL UDFs in Databricks are managed within the Unity Catalog, and their access is governed by the permission model of Unity Catalog, which includes fine-grained access control.
- B. Correct.
Correct: Permissions for SQL UDFs can be explicitly granted at the function level, allowing administrators to control who can execute or modify the UDF.
- C. Incorrect.
Incorrect: SQL UDFs are not automatically accessible to all users. Access must be granted explicitly through permissions.
- D. Correct.
Correct: Users must have the appropriate permissions on both the UDF itself and any underlying objects (e.g., tables) that the UDF references to ensure proper security.
- E. Incorrect.
Incorrect: SQL UDFs can be shared with others if permissions are granted. They are not restricted to access by only the creator.