Databricks Data Engineer Associate Question 203
Single answerA data engineering team is using Databricks to create and manage SQL User-Defined Functions (UDFs). They want to ensure the security and proper sharing of these UDFs within their organization. Which of the following statements about the security model for sharing SQL UDFs in Databricks is correct?
- A
SQL UDFs are accessible only to the creator and cannot be shared with other users.
- B
SQL UDFs can be shared with other users in the same workspace by assigning appropriate permissions to the function.
- C
SQL UDFs are automatically available to all users in the workspace without requiring additional permissions.
- D
SQL UDFs can be shared with users across workspaces as long as the users have the appropriate cluster permissions.
Show answer and explanation
Correct answer: B
Explanation
Databricks implements a security model for SQL UDFs that ensures they are only accessible to users with the appropriate permissions. By sharing UDFs within the same workspace through proper permission assignments, organizations can maintain secure and controlled access to these functions. UDFs are not automatically accessible to all users, nor can they be shared across workspaces.
- A. Incorrect.
Incorrect: SQL UDFs can be shared with other users in the workspace by configuring appropriate permissions. They are not restricted to the creator only.
- B. Correct.
Correct: SQL UDFs in Databricks can be shared within the same workspace by assigning the required permissions to the UDF. This ensures security and controlled access.
- C. Incorrect.
Incorrect: SQL UDFs are not automatically available to all users in the workspace. Permissions need to be explicitly configured to allow sharing.
- D. Incorrect.
Incorrect: SQL UDFs cannot be shared across workspaces. They are limited to the workspace where they are created, and permissions must be managed within that workspace.