Correct Answer: C
The correct answer is C. Stored procedures .
In Snowflake, the CALL command is used to execute a stored procedure. Stored procedures can contain procedural logic and can be written in supported languages such as JavaScript, SQL, Python, Java, or Scala, depending on the type of procedure.
Why C is correct:
Stored procedures are invoked using the CALL statement.
Example:
CALL my_procedure();
This runs the stored procedure named my_procedure.
Why the other options are incorrect:
A). System functions are usually invoked in SQL expressions using SELECT or within statements, not with CALL.
B). Tasks are resumed, suspended, or managed using task-related commands, and they run on schedules or task graphs. They are not directly run with CALL.
D). External functions are called like regular SQL functions inside SQL statements, not with the CALL statement.
Official Snowflake documentation reference:
Snowflake documentation describes the CALL command as the command used to execute a stored procedure.
Reference: Snowflake Documentation - CALL; Snowflake Documentation - Stored procedures; SnowPro Core Study Guide - SQL and Snowflake Objects.