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-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?

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 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:

Submit Cancel

Amalia

9 months ago

Yeah, but without the right share, it won't work at all!

upvoted 0 times

...

Rose

9 months ago

C is crucial too, can't access tables without SELECT.

upvoted 0 times

...

Paulina

9 months ago

Wait, is it really B? That seems too simple.

upvoted 0 times

...

Huey

10 months ago

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

upvoted 0 times

...

Chara

10 months ago

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

upvoted 0 times

...

Micheal

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

...

Marquetta

10 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

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

...

Shala

11 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

11 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

11 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

11 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

11 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

2 years 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

2 years 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

2 years ago

Let's double check the documentation to be sure. It might be A, CREATE_SHARE on the account.

upvoted 0 times

...

Jin

2 years ago

I see where you're coming from, but I still think it's B. SHARE on databases and schemas.

upvoted 0 times

...

Jerry

2 years 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

2 years ago

No, I'm pretty sure it's D. You need REFERENCE_USAGE on the databases.

upvoted 0 times

...

Laticia

2 years ago

I think it's actually C. You need SELECT on the tables used by the secure view.

upvoted 0 times

...

Leana

2 years 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

2 years 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

2 years ago

Hmm, I think D might be the right answer here. REFERENCE_USAGE on the databases should do the trick.

upvoted 0 times

...

Christiane

2 years ago

C is the way to go! You need SELECT on the tables, not some fancy privileges.

upvoted 0 times

Lezlie

2 years 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

2 years ago

Yeah, you're right. Without SELECT on tables, secure views won't be able to reference data.

upvoted 0 times

...

Myra

2 years ago

I think C is the correct answer. SELECT on tables is necessary for secure views.

upvoted 0 times

...

...

Vincenza

2 years 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

2 years 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

2 years ago

I think the privilege that must be granted is C) SELECT on tables used by the secure view.

upvoted 0 times

...