Snowflake Certification Practice Test

What must Data Sharing Consumers do to query shared objects?

1. Create a new Snowflake account

2. Use the ACCOUNTADMIN role to create a database based on the share

3. Set up their own data warehouse

4. Only query their own objects

The correct answer is: Use the ACCOUNTADMIN role to create a database based on the share

To query shared objects in Snowflake, Data Sharing Consumers must utilize the ACCOUNTADMIN role to create a database based on the share. This process is essential because, in a data-sharing scenario within Snowflake, the provider shares data via a share object, and the consumer needs to create a database within their own Snowflake environment that references this shared data. By leveraging the ACCOUNTADMIN role, the consumer gains the required privileges to create and manage this shared database properly. This step allows the consumer to access and query the data provided by the share as if it were part of their own Snowflake environment. Establishing a new database based on the share ensures that consumers can integrate and interact with the shared data seamlessly in their workflows. This action distinguishes the Snowflake architecture, emphasizing its capability for efficient data sharing without the necessity of duplicating or moving data across different environments.