A data provider wants to share data from multiple databases with a data consumer account. How can this be accomplished?

The correct answer is B. The data provider needs to create a secure view and grant the REFERENCE_USAGE privilege. 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 view is created.

Data Sharing and Collaboration

Question

Options

AThe data provider needs to create a secure view and grant the USAGE privilege on each
BThe data provider needs to create a secure view and grant the REFERENCE_USAGE privilege
CThe data provider needs to create a secure view and grant the REFERENCE_USAGE privilege to
DThe data provider needs to create a secure view and must grant the REFERENCE_USAGE

How the community answered

(61 responses)

A
7% (4)
B
75% (46)
C
15% (9)
D
3% (2)

Explanation

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 view is created.

Topics

#multi-database sharing#REFERENCE_USAGE#secure views#data provider

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice