The correct answer is B. OPERATE .
The OPERATE privilege on a task allows a role to suspend or resume that task. This is different from privileges used to create, monitor, or execute tasks.
Why B is correct:
To manually suspend or resume a task, the role must have the OPERATE privilege on the task.
Example concept:
GRANT OPERATE ON TASK my_task TO ROLE my_role;
After receiving this privilege, the role can perform actions such as:
ALTER TASK my_task SUSPEND;
ALTER TASK my_task RESUME;
Why the other options are incorrect:
A). MONITOR allows viewing task details and history, but it does not allow suspending or resuming the task.
C). CREATE TASK allows creating tasks in a schema, but it does not automatically allow operating an existing task.
D). EXECUTE TASK is an account-level privilege required for task execution, but it is not the privilege used to suspend or resume a task.
Official Snowflake documentation reference:
Snowflake documentation explains that the OPERATE privilege on a task enables suspending and resuming the task.
Reference: Snowflake Documentation - Task privileges; Snowflake Documentation - GRANT < privileges
> ; SnowPro Core Study Guide - SQL and Snowflake Objects.