Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?

Steven created the task, what additional privileges required by Steven on the task so that he can suspend or resume the tasks?

A. Steven is already owner of the task; he can execute the task & suspend/resume the task without any additional privileges.

B. In addition to the task owner, a Steven Role must have OPERATE privilege on the task so that he can suspend or resume the task.

C. Steven must have SUSPEND privilege on the task so that he can suspend or resume the task.

D. Steven needs to have Global Managed RESUME privilege by TASK administrator.

View Answer

Answer: A

Explanation:

For Snowflake tasks:

The owner of the task can suspend, resume, or modify the task.

The role that owns a task can grant privileges on that task to other roles.

Given the choices:

A. Steven is already the owner of the task; he can execute the task & suspend/resume the task without any additional privileges.

This is correct. As the owner of the task, Steven has the necessary privileges to operate on it.

B. In addition to the task owner, a Steven Role must have OPERATE privilege on the task so that he can suspend or resume the task.

This statement would be relevant if Steven wasn’t the owner but was trying to operate on it through a different role. The OPERATE privilege allows a role to perform operational commands (like SUSPEND and RESUME) on tasks that the role does not own.

C. Steven must have SUSPEND privilege on the task so that he can suspend or resume the task.

This is not accurate. Snowflake does not have a specific "SUSPEND" privilege. The relevant privilege is "OPERATE".

D. Steven needs to have Global Managed RESUME privilege by TASK administrator.

This is not accurate. Snowflake does not have a "Global Managed RESUME privilege".

Given the details provided, the correct answer is:

A. Steven is already the owner of the task; he can execute the task & suspend/resume the task without any additional privileges.