New Year Sale 2026! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake COF-R02 Exam - Topic 4 Question 41 Discussion

Actual exam question for Snowflake's COF-R02 exam
Question #: 41
Topic #: 4
[All COF-R02 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

by Glenna at Sep 13, 2024, 08:48 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Amalia
3 months ago
Yeah, but without the right share, it won't work at all!
upvoted 0 times
...
Rose
3 months ago
C is crucial too, can't access tables without SELECT.
upvoted 0 times
...
Paulina
3 months ago
Wait, is it really B? That seems too simple.
upvoted 0 times
...
Huey
4 months ago
I thought it was D, but B makes more sense.
upvoted 0 times
...
Chara
4 months ago
It's definitely B, you need to share databases and schemas.
upvoted 0 times
...
Micheal
4 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
...
Marquetta
4 months ago
I feel like I saw a similar question in our practice tests, and I think it was about granting privileges for views. Maybe it's D?
upvoted 0 times
...
Rene
4 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
...
Shala
5 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
...
Lavera
5 months ago
I've got it! The answer is B. Secure views need the SHARE privilege on the databases and schemas they use to access data from multiple sources. That's the privilege that allows them to reference data across different databases.
upvoted 0 times
...
Aja
5 months ago
I'm a little confused on this one. Is it something to do with the CREATE_SHARE privilege on the account? Or maybe the REFERENCE_USAGE on the databases? I'll have to think about this one a bit more.
upvoted 0 times
...
Allene
5 months ago
Okay, I'm pretty sure the answer is B. Secure views need the SHARE privilege on the databases and schemas they reference, right? That makes the most sense to me.
upvoted 0 times
...
Selma
5 months ago
Hmm, this is a tricky one. I think the key is to focus on the privileges needed for a secure view to access data across multiple databases. Let me think this through...
upvoted 0 times
...
Carma
1 year ago
Wait, wait, wait... is the answer just 'all of the above'? I mean, you need a little bit of everything, right? What a wild question!
upvoted 0 times
...
Adelina
1 year ago
This is a tricky one, but I'm gonna go with B. Gotta have the SHARE privilege on those databases and schemas, you know?
upvoted 0 times
Xenia
1 year ago
Let's double check the documentation to be sure. It might be A, CREATE_SHARE on the account.
upvoted 0 times
...
Jin
1 year ago
I see where you're coming from, but I still think it's B. SHARE on databases and schemas.
upvoted 0 times
...
Jerry
1 year ago
Definitely, having the SHARE privilege on databases and schemas is crucial for secure views to work properly across multiple databases.
upvoted 0 times
...
Dorothea
1 year ago
No, I'm pretty sure it's D. You need REFERENCE_USAGE on the databases.
upvoted 0 times
...
Laticia
1 year ago
I think it's actually C. You need SELECT on the tables used by the secure view.
upvoted 0 times
...
Leana
1 year ago
Yeah, I agree. Without the SHARE privilege on databases and schemas, secure views wouldn't be able to access data from multiple databases.
upvoted 0 times
...
Lavonda
1 year ago
I think you're right, B is the correct answer. SHARE privilege is needed on databases and schemas for secure views to reference data.
upvoted 0 times
...
...
Scarlet
1 year ago
Hmm, I think D might be the right answer here. REFERENCE_USAGE on the databases should do the trick.
upvoted 0 times
...
Christiane
1 year ago
C is the way to go! You need SELECT on the tables, not some fancy privileges.
upvoted 0 times
Lezlie
1 year ago
So, the key is to make sure the secure views have the necessary privileges on the tables they need to access.
upvoted 0 times
...
Kathrine
1 year ago
Yeah, you're right. Without SELECT on tables, secure views won't be able to reference data.
upvoted 0 times
...
Myra
1 year ago
I think C is the correct answer. SELECT on tables is necessary for secure views.
upvoted 0 times
...
...
Vincenza
1 year ago
I'm not sure, but I think it could also be D) REFERENCE_USAGE on databases. This privilege might also be needed for secure views to access data across multiple databases.
upvoted 0 times
...
Allene
1 year ago
I agree with Cammy. Without SELECT privilege on the tables, the secure view won't be able to reference data in multiple databases.
upvoted 0 times
...
Cammy
1 year ago
I think the privilege that must be granted is C) SELECT on tables used by the secure view.
upvoted 0 times
...

Save Cancel