Snowflake SnowPro Certification Practice Test 2025 – Complete Exam Prep Guide

Question: 1 / 400

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

GRANT ADDITIONAL_USAGE

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.

Get further explanation with Examzify DeepDiveBeta

GRANT OBJECT_ACCESS

GRANT USAGE_TO_SHARE

Next Question

Report this question

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy