Answer: REFERENCE_USAGE on databases

The correct answer is D (REFERENCE_USAGE on databases) because when sharing secure views that reference data across multiple databases, the REFERENCE_USAGE privilege must be granted on each referenced database to allow the secure view to access data from those databases. This is explicitly documented in Snowflake's data sharing documentation for multiple databases. The community discussion shows 100% consensus on answer D with multiple comments referencing the official documentation and explaining that REFERENCE_USAGE is required on databases referenced by secure views (but not on the database where the secure view itself is created). Other options are incorrect: CREATE_SHARE (A) is for creating shares, not for cross-database references; SHARE (B) is for sharing objects, not for cross-database access; SELECT (C) provides data access but doesn't enable cross-database references for secure views in the context of data sharing.

Author: LeetQuiz Editorial Team