SnowPro Core Certification — Question 709

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

Answer options

• 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.

Correct answer: B

Explanation

The correct answer is B because a single SQL statement can only invoke one stored procedure, whereas it can call multiple UDFs within that same statement. Options A, C, and D incorrectly suggest different capabilities regarding the number of stored procedures or UDFs that can be called within a single executable statement.