Snowflake COF-C02 Exam - Topic 4 Question 5 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 5
Topic #: 4

[All COF-C02 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 Alishia at Dec 07, 2022, 03:51 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Vanesa

4 months ago

Wait, ALL privileges? That sounds risky!

upvoted 0 times

...

Paola

4 months ago

I agree with A, that’s the standard approach.

upvoted 0 times

...

Oliva

4 months ago

C seems too broad for just changing permissions.

upvoted 0 times

...

Nydia

4 months ago

I think B could work too, but not sure.

upvoted 0 times

...

Janna

4 months ago

Definitely A, OWNERSHIP on the schema is key.

upvoted 0 times

...

Odette

5 months ago

I’m confused about the difference between schema and database privileges. I need to think more about whether OWNERSHIP is specific enough for this question.

upvoted 0 times

...

Denae

5 months ago

Granting ALL privileges sounds too broad for just changing permissions. I’m leaning towards OWNERSHIP, but I could be wrong.

upvoted 0 times

...

Jade

5 months ago

I remember a similar question where we discussed the importance of schema privileges. I feel like option A could be correct.

upvoted 0 times

...

Shenika

5 months ago

I think the OWNERSHIP privilege on the schema might be the right choice, but I'm not entirely sure.

upvoted 0 times

...

Dortha

5 months ago

Okay, let me break this down. The key is that the inputs are not critical but difficult to quantify and random. I think the best answer is B, noise.

upvoted 0 times

...

Graham

5 months ago

This one seems pretty straightforward. The Change Control functional component is all about managing the change lifecycle, so I'm guessing the answer is the Change Control data object.

upvoted 0 times

...

Dortha

5 months ago

I think the main responsibility of a grand jury is to find probable cause, which makes me wonder if option D could be misleading in some way.

upvoted 0 times

...

Blair

5 months ago

This is a tricky one. I think the test environment should be considered when writing the test strategy, since that's when you're planning out the overall testing approach.

upvoted 0 times

...