U.S. Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ADA-C01 Exam - Topic 3 Question 50 Discussion

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).
C) OPERATE on the task and D) USAGE on the database and schema containing the task
A) EXECUTE TASK on the task
B) OWNERSHIP on the task
E) OWNERSHIP on the database and schema containing the task

Snowflake ADA-C01 Exam - Topic 3 Question 50 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 50
Topic #: 3
[All ADA-C01 Questions]

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).

Show Suggested Answer Hide 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:

0/2000 characters
Submit Cancel
German
1 day ago
Wait, can they really suspend without ownership?
upvoted 0 times
...
Callie
2 months ago
I think D is also important for context.
upvoted 0 times
...
Gregoria
2 months ago
A and C are the right choices!
upvoted 0 times
...
Gertude
3 months ago
I’m a bit confused about the difference between OPERATE and EXECUTE TASK. I hope I remember the right combination for this scenario!
upvoted 0 times
...
Alishia
3 months ago
This question feels familiar; I think we practiced something similar where we had to limit user permissions without giving them ownership.
upvoted 0 times
...
Cristy
3 months ago
I'm not entirely sure, but I remember something about needing USAGE on the database and schema for tasks to work properly.
upvoted 0 times
...
Benedict
3 months 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
...

Save Cancel