Snowflake Exam COF-R02 Topic 4 Question 43 Discussion

Actual exam question for Snowflake's COF-R02 exam

Question #: 43
Topic #: 4

[All COF-R02 Questions]

What privilege should a user be granted to change permissions for new objects in a managed access schema?

AGrant the OWNERSHIP privilege on the schema.

BGrant the OWNERSHIP privilege on the database.

CGrant the MANAGE GRANTS global privilege.

DGrant ALL privileges on the schema.

Show Suggested Answer

Suggested Answer: C

by Magnolia at Sep 14, 2024, 10:57 AM

Limited Time Offer

25%

Off

Get Premium COF-R02 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Georgiana

5 days ago

Hmm, I'm not sure about this one. I was thinking B might be the correct answer, but now I'm second-guessing myself.

upvoted 0 times

...

Tomas

20 days ago

I'm pretty sure it's C. Granting the MANAGE GRANTS global privilege would allow the user to change permissions for new objects in the schema.

upvoted 0 times

Stephanie

6 days ago

I think it's A. Granting the OWNERSHIP privilege on the schema should do the trick.

upvoted 0 times

...

Galen

7 days ago

I agree with you, C is the correct answer. Granting the MANAGE GRANTS global privilege is the way to go.

upvoted 0 times

...

Denise

11 days ago

No, I believe it's D. Granting ALL privileges on the schema would give the user the necessary permissions.

upvoted 0 times

...

Rikki

14 days ago

I think it's A. Granting the OWNERSHIP privilege on the schema should do the trick.

upvoted 0 times

...

Meghann

30 days ago

But granting ALL privileges seems too broad, it could lead to security risks. I still think A) is the best option.

upvoted 0 times

...

Fairy

1 months ago

I disagree, I believe the correct answer is D) Grant ALL privileges on the schema.

upvoted 0 times

...

Meghann

1 months ago

I think the answer is A) Grant the OWNERSHIP privilege on the schema.

upvoted 0 times

...