What is the primary benefit of using User-Defined Functions (UDFs) in SQL for data analysis?

What is the primary benefit of using User-Defined Functions (UDFs) in SQL for data analysis?
A . They enable customization and extension of SQL functionalities for specific data operations.
B . UDFs restrict data analysis to predefined operations.
C . UDFs can only be used with Materialized views.
D . UDFs hinder query optimization.

View Answer

Answer: A

Explanation:

UDFs allow customization and extension of SQL functionalities, enabling specific data operations beyond predefined limits.