Answer: A task allows a user to execute a single SQL statement/command using a predefined schedule.

The correct answer is B based on Snowflake's official documentation and the community consensus. According to Snowflake documentation, a task can execute any one of the following: a single SQL statement, a call to a stored procedure, or procedural logic using Snowflake Scripting. While some community members suggested C (multiple SQL statements) by referencing SnowSQL delimiter workarounds, this is not the standard or intended use of tasks. The official documentation clearly states tasks are designed for single SQL operations, stored procedure calls, or procedural logic blocks. Option A is incorrect because tasks are not called using CALL statements, and option D is incorrect because tasks are not executed using SELECT statements. The community discussion shows 84% support for B with the highest upvoted comments referencing official documentation that supports single SQL statement execution.

Author: LeetQuiz Editorial Team