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

27 days 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

Melissa

11 days ago

A) Grant the OWNERSHIP privilege on the schema.

upvoted 0 times

...

Daniel

30 days 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

1 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

7 days ago

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

upvoted 0 times

...

Vallie

14 days ago

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

upvoted 0 times

...

Detra

16 days ago

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

upvoted 0 times

...

Tomas

2 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

18 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

...

Lasandra

23 days 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

1 months ago

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

upvoted 0 times

...

Galen

1 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

1 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

1 months ago

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

upvoted 0 times

...

Meghann

2 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

2 months ago

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

upvoted 0 times

...

Meghann

2 months ago

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

upvoted 0 times

...