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

Alberta

6 months ago

Ha! Granting the OWNERSHIP privilege on the database? That's like giving the keys to the kingdom. Definitely not that one.

upvoted 0 times

Becky

5 months ago

B) Grant the OWNERSHIP privilege on the schema.

upvoted 0 times

...

Teri

5 months ago

C) Grant the MANAGE GRANTS global privilege.

upvoted 0 times

...

Melissa

6 months ago

A) Grant the OWNERSHIP privilege on the schema.

upvoted 0 times

...

Daniel

6 months ago

This is a tricky one. I'm leaning towards D, since granting ALL privileges on the schema would give the user the necessary permissions.

upvoted 0 times

...

Georgiana

7 months 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

Vanda

6 months ago

User3: I believe it's C) Grant the MANAGE GRANTS global privilege.

upvoted 0 times

...

Vallie

6 months ago

User2: I'm not sure, I was leaning towards B) Grant the OWNERSHIP privilege on the database.

upvoted 0 times

...

Detra

6 months ago

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

upvoted 0 times

...

Tomas

7 months 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

Lawanda

6 months 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

...

Lasandra

6 months ago

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

upvoted 0 times

...

Stephanie

7 months ago

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

upvoted 0 times

...

Galen

7 months 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

7 months ago

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

upvoted 0 times

...

Rikki

7 months ago

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

upvoted 0 times

...

Meghann

7 months 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

8 months ago

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

upvoted 0 times

...

Meghann

8 months ago

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

upvoted 0 times

...