Snowflake SnowPro Core

Ultimate access to all questions.

What is the difference between a stored procedure and a User-Defined Function (UDF) in Snowflake?

Exam-Like

A

Stored procedures can execute database operations while UDFs cannot.

63.6%

B

Returning a value is required in a stored procedure while returning values in a UDF is optional.

18.2%

Loading comments...

C

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

9.1%

D

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

9.1%

Powered ByGPT-5.2