SnowPro Core Certification — Question 336

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

Answer options

• A. CREATE_SHARE on the account
• B. SHARE on databases and schemas
• C. SELECT on tables used by the secure view
• D. REFERENCE_USAGE on databases

Correct answer: D

Explanation

The correct answer is D because the REFERENCE_USAGE privilege is necessary for secure views to access objects across multiple databases. The other options do not provide the necessary permissions for cross-database references; CREATE_SHARE relates to creating shares, SHARE on databases and schemas is too broad, and SELECT only allows access to specific tables rather than the necessary cross-database referencing.