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

Scarlet

7 days ago

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

upvoted 0 times

...

Christiane

12 days ago

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

upvoted 0 times

...

Vincenza

16 days 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

20 days 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

22 days ago

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

upvoted 0 times

...