Snowflake SnowPro Certification Practice Test

Which command allows a share to access additional databases containing objects referenced by a view?

1. GRANT ADDITIONAL_USAGE

2. GRANT REFERENCE_USAGE

3. GRANT OBJECT_ACCESS

4. GRANT USAGE_TO_SHARE

The correct answer is: GRANT REFERENCE_USAGE

The correct command that allows a share to access additional databases containing objects referenced by a view is "GRANT REFERENCE_USAGE." When you create a view in Snowflake, it may reference tables or other objects that reside in different databases. To ensure that users or roles accessing the view through the share have the necessary permissions to access all objects that the view references, it is important to use the GRANT REFERENCE_USAGE command. This command provides rights to the share to reference objects in the specified database, facilitating the seamless integration of those referenced objects into queries run against the view. This capability is crucial for maintaining the integrity and usability of the data shared, as it ensures that all necessary underlying data is accessible without requiring additional permission grants for each individual object. Other commands, while they may relate to permissions and access, do not specifically provide the functionality needed for managing references in the context of shared views. Therefore, GRANT REFERENCE_USAGE accurately reflects the permission needed for this scenario.