Snowflake ADA-C01 Exam - Topic 3 Question 50 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 50
Topic #: 3

An Administrator has a user who needs to be able to suspend and resume a task based on the current virtual warehouse load, but this user should not be able to modify the task or start a new run.

What privileges should be granted to the user to meet these requirements? (Select TWO).

AEXECUTE TASK on the task

BOWNERSHIP on the task

COPERATE on the task

DUSAGE on the database and schema containing the task

EOWNERSHIP on the database and schema containing the task

Show Suggested Answer

Suggested Answer: C, D

The user needs the OPERATE privilege on the task to suspend and resume it, and the USAGE privilege on the database and schema containing the task to access it1.The EXECUTE TASK privilege is not required for suspending and resuming a task, only for triggering a new run1. The OWNERSHIP privilege on the task or the database and schema would allow the user to modify or drop the task, which is not desired.

by Alexis at Apr 05, 2026, 10:26 PM

Limited Time Offer

25%

Off

Get Premium ADA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Benedict

7 hours ago

I think we need to give the user some level of control over the task, so maybe EXECUTE TASK and OPERATE?

upvoted 0 times

...