Snowflake Exam COF-R02 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

Carma

10 months 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

10 months 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

9 months ago

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

upvoted 0 times

...

Jin

9 months ago

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

upvoted 0 times

...

Jerry

9 months 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

9 months ago

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

upvoted 0 times

...

Laticia

9 months ago

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

upvoted 0 times

...

Leana

9 months 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

10 months 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

10 months ago

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

upvoted 0 times

...

Christiane

10 months ago

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

upvoted 0 times

Lezlie

9 months 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

10 months ago

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

upvoted 0 times

...

Myra

10 months ago

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

upvoted 0 times

...

Vincenza

11 months 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

11 months 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

11 months ago

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

upvoted 0 times

...