SnowPro Core Certification — Question 294

Which statement is true about running tasks in Snowflake?

Answer options

• A. A task can be called using a CALL statement to run a set of predefined SQL commands.
• B. A task allows a user to execute a single SQL statement/command using a predefined schedule.
• C. A task allows a user to execute a set of SQL commands on a predefined schedule.
• D. A task can be executed using a SELECT statement to run a predefined SQL command.

Correct answer: B

Explanation

Option B is correct because a task in Snowflake is designed to execute a single SQL statement or command on a defined schedule. Options A and D are incorrect as they refer to using CALL and SELECT statements, which are not the appropriate methods for executing tasks. Option C is also incorrect because it describes a task executing multiple SQL commands, whereas a task is meant for a single command.