Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
In a Spark SQL environment, you are tasked with sharing a SQL UDF (User-Defined Function) across multiple users while ensuring security and ease of access. The solution must comply with organizational policies that restrict direct file sharing and require centralized access control. Considering these constraints, which of the following options best describes the security model for sharing SQL UDFs? Choose the best option.
In a Spark SQL environment, you are tasked with sharing a SQL UDF (User-Defined Function) across multiple users while ensuring security and ease of access. The solution must comply with organizational policies that restrict direct file sharing and require centralized access control. Considering these constraints, which of the following options best describes the security model for sharing SQL UDFs? Choose the best option.
Explanation:
Option B is the correct answer as it describes creating a shared library in a central location, which is a secure and efficient way to share SQL UDFs without distributing files directly to users. Option D is also correct as registering the UDF in a central registry provides a standardized and secure method for sharing, making it the second correct answer when E is available. Option A is incorrect due to security and compliance risks associated with direct file sharing. Option C is incorrect as it may not scale well and poses security risks by granting direct file system access. Option E is included to test the understanding that both centralized sharing methods (B and D) are viable under different scenarios.