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

- Free Preparation Discussions

Snowflake COF-C02 Exam - Topic 4 Question 3 Discussion

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
C) SELECT on tables used by the secure view
A) CREATE_SHARE on the account
B) SHARE on databases and schemas
D) REFERENCE_USAGE on databases

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?

Show Suggested Answer Hide Answer
Suggested Answer: C

Contribute your Thoughts:

0/2000 characters
Zena
9 months ago
I’m not sure about that, could it be A instead?
upvoted 0 times
...
Kaycee
9 months ago
Agreed, B is the way to go!
upvoted 0 times
...
Alex
9 months ago
Wait, is it really D? That seems off.
upvoted 0 times
...
Delisa
10 months ago
I thought it was C, but B makes more sense.
upvoted 0 times
...
Teddy
10 months ago
It's definitely B, you need to share databases and schemas.
upvoted 0 times
...
Leatha
10 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
10 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
10 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
10 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
10 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
10 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
10 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
10 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
...

Save Cancel