A data provider wants to share data from multiple databases with a data consumer account.
How can this be accomplished?
A.
The data provider needs to create a secure view and grant the USAGE privilege on each database referenced by the secure view.
B.
The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege on each database referenced by the secure view.
C.
The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to a database role to include objects from multiple databases in a share
D.
The data provider needs to create a secure view and must grant the REFERENCE_USAGE privilege on the database where the secure view is created.
Option B is the correct answer because it follows the steps described in the Snowflake documentation for sharing data from multiple databases using secure views. The data provider needs to grant the REFERENCE_USAGE privilege on each database that contains objects referenced by the secure view, and the USAGE privilege only on the database where the secure view is created. Option A is incorrect because it grants the USAGE privilege instead of the REFERENCE_USAGE privilege. Option C is incorrect because it grants the REFERENCE_USAGE privilege to a database role, which is not supported. Option D is incorrectbecause it grants the REFERENCE_USAGE privilege on the wrong database.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit