Examice

Exam SnowPro Core All QuestionsBrowse all questions from this exam

Question 730

How does a Snowflake stored procedure compare to a User-Defined Function (UDF)?

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Correct Answer: B

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

Discussion

Ram9198Option: B

B is correct

MultiCloudIronManOption: B

https://alexandersks.medium.com/difference-between-stored-procedures-and-udfs-snowflake-9e5b93cdb081

singhksOption: B

https://docs.snowflake.com/en/developer-guide/stored-procedures-vs-udfs Multiple UDFs May Be Called With One Statement; a Single Stored Procedure Is Called With One Statement

JG1984

It is true that a single executable statement can call multiple UDFs, but it is also possible to call multiple stored procedures in a single executable statement, as long as they are called in separate statements. CALL proc1(); CALL proc2(); so i think it can be option C

MarcusbragaOption: B

B : call proc1() call proc2() select udf1(), udf2() from table

Rameez1Option: B

Multiple UDFs may be called with one statement; A single stored procedure is called with one statement A single SQL statement can call multiple UDFs. A single SQL statement can call only one stored procedure.