Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Snowflake COF-C02 Exam - Topic 4 Question 3 Discussion

Actual exam question for Snowflake's COF-C02 exam

Question #: 3
Topic #: 4

[All COF-C02 Questions]

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

ACREATE_SHARE on the account

BSHARE on databases and schemas

CSELECT on tables used by the secure view

DREFERENCE_USAGE on databases

Show Suggested Answer

Suggested Answer: C

by Raul at Dec 08, 2022, 12:37 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Zena

7 months ago

I’m not sure about that, could it be A instead?

upvoted 0 times

...

Kaycee

7 months ago

Agreed, B is the way to go!

upvoted 0 times

...

Alex

8 months ago

Wait, is it really D? That seems off.

upvoted 0 times

...

Delisa

8 months ago

I thought it was C, but B makes more sense.

upvoted 0 times

...

Teddy

8 months ago

It's definitely B, you need to share databases and schemas.

upvoted 0 times

...

Leatha

8 months ago

I’m leaning towards A, but I’m not confident. CREATE_SHARE sounds important, but I’m not sure if it’s the right context for secure views.

upvoted 0 times

...

Cherry

8 months ago

I feel like I saw a question similar to this in our practice exam, and it was about granting privileges for cross-database access. Maybe it’s D?

upvoted 0 times

...

Stefania

8 months ago

I'm not entirely sure, but I remember something about needing SELECT privileges for the tables involved. Could it be C?

upvoted 0 times

...

Billye

8 months ago

I think the answer might be B, since it mentions sharing databases and schemas, which seems relevant for secure views.

upvoted 0 times

...

Renea

8 months ago

Okay, I've got this. Differential backups don't reset the archive bit, but Incremental ones do. That's the key difference between the two. Time to mark my answer.

upvoted 0 times

...

Clarence

8 months ago

I remember a practice question about capacity management that discussed how bottlenecks affect workflow, which makes me lean towards that option.

upvoted 0 times

...

Delsie

9 months ago

I'm pretty confident about this one. Security groups and network ACLs are the key tools for securing instances in a VPC.

upvoted 0 times

...

Dorethea

9 months ago

The question mentions "SHA level of filtering," so I'm thinking the answer is likely one of the higher SHA levels like 512 or 4096.

upvoted 0 times

...