Which statement is true about calling stored procedures in Snowflake?

• A. You must use CALL to execute a stored procedure
• B. You can chain multiple calls in a single CALL
• C. You can call a stored procedure in a SELECT
• D. You can call multiple procedures in a single CALL statement

Answer: (A)

Calling a stored procedure in Snowflake is done with the CALL statement. This is the explicit command Snowflake uses to execute the procedural code inside a procedure, passing any required arguments. A SELECT is intended for querying data and cannot trigger a procedure; the results of a procedure aren’t obtained via a simple SELECT rowset. Also, you can’t bundle multiple procedure calls into a single CALL statement—each CALL runs one procedure. If you need to run several procedures, you’d issue separate CALL statements (or have one procedure call others internally). So the correct approach is to use CALL to initiate the stored procedure.