Snowflake SnowPro Certification Practice Test

What is the command to allow a share to have access to databases and views?

1. GRANT VIEW

2. GRANT ACCESS

3. GRANT USAGE

4. GRANT SHARE

The correct answer is: GRANT USAGE

The command that allows a share to have access to databases and views is "GRANT USAGE." This command is important because it explicitly provides the necessary permissions for external accounts to access specific database objects, such as databases, schemas, tables, and views. When you use "GRANT USAGE," you allow the shared accounts to see and work with these objects without granting them full ownership or control. This ensures that the shared entities can perform necessary operations while maintaining security and integrity of the data. The other options do not provide the appropriate command for sharing access. For instance, "GRANT VIEW" typically refers to granting permissions on views but doesn't address the broader requirement of sharing access at the database level. "GRANT ACCESS" is not a recognized command within Snowflake SQL syntax, and "GRANT SHARE" does not exist because sharing in Snowflake is facilitated through a dedicated sharing mechanism rather than a simple grant command. Hence, using "GRANT USAGE" is the correct approach to ensure external users can utilize the shared databases and views effectively.