How can stored procedures be beneficial in data analysis using SQL?

How can stored procedures be beneficial in data analysis using SQL?
A . Stored procedures are limited to read-only operations.
B . Stored procedures can’t be used in conjunction with UDFs.
C . They allow execution of repetitive tasks, enhancing data analysis efficiency.
D . Stored procedures cannot handle large data sets effectively.

View Answer

Answer: C

Explanation:

Stored procedures aid in data analysis by enabling the execution of repetitive tasks, thereby enhancing efficiency.