New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - 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 1 Question 26 Discussion

Actual exam question for Snowflake's ADA-C01 exam
Question #: 26
Topic #: 1
[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 Phuong at Sep 14, 2024, 05:37 AM

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
Kenny
3 months ago
I disagree, I feel like B should be included.
upvoted 0 times
...
Mary
3 months ago
D seems necessary too, for access to the task.
upvoted 0 times
...
Gladys
3 months ago
Surprised that ownership isn't needed for this!
upvoted 0 times
...
Carman
4 months ago
Definitely agree with A, but not sure about C.
upvoted 0 times
...
Beula
4 months ago
I think A and C are the right choices.
upvoted 0 times
...
Tammara
4 months ago
I believe we should also consider USAGE on the database and schema, but I can't recall if that's necessary for suspending and resuming tasks.
upvoted 0 times
...
Kayleigh
4 months ago
I’m a bit confused about the difference between OWNERSHIP and OPERATE. I think we definitely need to avoid giving too much control to the user.
upvoted 0 times
...
Eric
4 months ago
I remember practicing a similar question where we had to limit user permissions. I feel like OPERATE on the task might be the right choice here.
upvoted 0 times
...
Flo
5 months ago
I think we need to give the user some sort of execute privilege, but I'm not sure if it's EXECUTE TASK or something else.
upvoted 0 times
...
Matthew
5 months ago
This is a good one. The key is finding the right balance between giving the user control over the task while still limiting their ability to make changes. I'd go with EXECUTE TASK and OPERATE.
upvoted 0 times
...
Florencia
5 months ago
I think I've got it! The user needs to be able to suspend and resume the task, so EXECUTE TASK and OPERATE are the two privileges that should be granted.
upvoted 0 times
...
Huey
5 months ago
I'm a bit confused here. The question says the user shouldn't be able to modify the task, but OWNERSHIP would give them that ability. Maybe USAGE on the database and schema is the way to go?
upvoted 0 times
...
Angelyn
5 months ago
Okay, let's see. The user needs to be able to control the task, so EXECUTE TASK seems like a good option. But they also need to be able to suspend and resume it, so OPERATE might be the way to go.
upvoted 0 times
...
Erick
5 months ago
Hmm, this is a tricky one. I'll need to think carefully about the privileges required to suspend and resume the task without allowing any other modifications.
upvoted 0 times
...
Caitlin
1 year ago
This question is so easy, a monkey could answer it. But then again, most of us are probably monkeys in this certification exam anyway.
upvoted 0 times
...
Tasia
1 year ago
Suspend and resume, huh? Sounds like the user needs to be the task master. I'll go with A) and C) for sure.
upvoted 0 times
Edelmira
1 year ago
User 3: A) and C) seem like the right choices for this user's privileges.
upvoted 0 times
...
Dalene
1 year ago
User 2: User should also have C) OPERATE on the task to meet the requirements.
upvoted 0 times
...
Virgina
1 year ago
User 1: I think A) EXECUTE TASK on the task is necessary.
upvoted 0 times
...
...
Elden
1 year ago
I'm not sure about OWNERSHIP on the task. Would that also be necessary for the user to have the required privileges?
upvoted 0 times
...
Carylon
1 year ago
What? No OWNERSHIP? That's just crazy! How else is the user supposed to modify the task if they need to? I'm going with B) and E).
upvoted 0 times
Elke
1 year ago
No, the user shouldn't be able to modify the task, so EXECUTE TASK is not needed.
upvoted 0 times
...
Willard
1 year ago
But what about EXECUTE TASK? Shouldn't that be included?
upvoted 0 times
...
Sueann
1 year ago
Agreed, those privileges should meet the requirements.
upvoted 0 times
...
Dorcas
1 year ago
I think B) and E) are the way to go.
upvoted 0 times
...
...
Deandrea
1 year ago
I agree with Tawna. OPERATE on the task allows suspending and resuming the task, while USAGE on the database and schema ensures access without modifying the task.
upvoted 0 times
...
Tawna
1 year ago
I think the user should have OPERATE on the task and USAGE on the database and schema containing the task.
upvoted 0 times
...
Cherri
1 year ago
Hmm, I think the correct answers are A) EXECUTE TASK and C) OPERATE on the task. The user needs to be able to suspend and resume the task, so they need those privileges.
upvoted 0 times
Emmett
1 year ago
Yes, and they also need OPERATE privilege on the task to meet the requirements.
upvoted 0 times
...
Elli
1 year ago
I agree, the user should have EXECUTE TASK privilege to suspend and resume the task.
upvoted 0 times
...
...

Save Cancel