Answer-first summary for fast verification
Answer: A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
The correct answer is B based on Snowflake documentation and community consensus. A single executable statement (CALL statement) can only invoke one stored procedure at a time, as shown in examples like 'CALL proc1()'. In contrast, a single SQL statement can call multiple User-Defined Functions (UDFs) simultaneously, such as 'SELECT udf1(), udf2() FROM table'. This distinction is clearly documented in Snowflake's developer guide comparing stored procedures vs. UDFs. Option A is incorrect because it states a single statement can call two stored procedures. Option C is incorrect because while multiple SQL statements can call the same UDFs, the key comparison is about how many can be called in a single statement. Option D is misleading as it focuses on multiple statements rather than the single statement comparison requested.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What are the differences between a Snowflake stored procedure and a User-Defined Function (UDF)?
A
A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.
B
A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
C
A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.
D
Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.
No comments yet.