New Year Sale ! 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 Exam ADA-C01 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:

Submit Cancel
Caitlin
3 months 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
3 months 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
2 months ago
User 3: A) and C) seem like the right choices for this user's privileges.
upvoted 0 times
...
Dalene
2 months ago
User 2: User should also have C) OPERATE on the task to meet the requirements.
upvoted 0 times
...
Virgina
2 months ago
User 1: I think A) EXECUTE TASK on the task is necessary.
upvoted 0 times
...
...
Elden
3 months 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
4 months 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
2 months ago
No, the user shouldn't be able to modify the task, so EXECUTE TASK is not needed.
upvoted 0 times
...
Willard
2 months ago
But what about EXECUTE TASK? Shouldn't that be included?
upvoted 0 times
...
Sueann
3 months ago
Agreed, those privileges should meet the requirements.
upvoted 0 times
...
Dorcas
3 months ago
I think B) and E) are the way to go.
upvoted 0 times
...
...
Deandrea
4 months 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
4 months 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
4 months 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
4 months ago
Yes, and they also need OPERATE privilege on the task to meet the requirements.
upvoted 0 times
...
Elli
4 months ago
I agree, the user should have EXECUTE TASK privilege to suspend and resume the task.
upvoted 0 times
...
...

Save Cancel