Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 528

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

Stored procedures can execute database operations while UDFs cannot.

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

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

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.

Correct Answer: A

Stored procedures have the capability to execute a wide range of database operations, including data manipulation and transactional control, while User-Defined Functions (UDFs) are limited and primarily used to return a single value based on input parameters. UDFs cannot perform operations that modify the database state, such as Insert, Update, or Delete operations.

Discussion

bibisaOption: A

Stored Procedures Can Access the Database; UDFs May Not

SimbajagnoleOption: A

https://docs.snowflake.com/en/sql-reference/stored-procedures-overview#differences-between-stored-procedures-and-udfs

Dalo

https://docs.snowflake.com/en/developer-guide/stored-procedures-vs-udfs#udfs-may-not-access-the-database-stored-procedures-can

_yyuktaOption: A

A. Stored procedures can execute database operations while UDFs cannot

MultiCloudIronManOption: A

Correct