Snowflake Architect Certification Data Sharing and Collaboration 1 — Questions and Answers
Question 1: What Snowflake feature allows data providers to share live, read-only data with consumers without copying or moving it?
- Snowflake Data Exchange
- Secure Data Sharing (Correct answer)
- Data Replication
- External Tables
Correct answer: Secure Data Sharing
Secure Data Sharing enables providers to share live data with consumers in real time without physically copying or transferring any data.
Question 2: Which object is the primary container created by a provider to define what data objects are shared with consumer accounts?
- Database
- Schema
- Share (Correct answer)
- Stage
Correct answer: Share
A SHARE object is created by the provider and contains references to databases, schemas, tables, or views to be shared with consumer accounts.
Question 3: What is the role of a 'reader account' in Snowflake Secure Data Sharing?
- An account that monitors shared data usage logs
- A managed account created by a provider for non-Snowflake consumers (Correct answer)
- An account with read-only access to all objects in a Snowflake region
- A trial account for evaluating shared datasets before purchase
Correct answer: A managed account created by a provider for non-Snowflake consumers
Reader accounts are managed Snowflake accounts created and owned by providers to give consumers who lack their own Snowflake account access to shared data.
Question 4: When a consumer account queries shared data in Snowflake, which account is responsible for the compute costs incurred?
- The provider account
- The consumer account (Correct answer)
- Snowflake splits the cost equally between both accounts
- The account that originally created the share object
Correct answer: The consumer account
The consumer account pays for virtual warehouse compute costs when querying shared data, while the provider pays only for storage.
Question 5: Which Snowflake object type allows data sharing with built-in row-level security without exposing the underlying SQL logic to consumers?
- Materialized View
- Secure View (Correct answer)
- External Table
- Dynamic Table
Correct answer: Secure View
Secure Views hide the view definition from consumers and can implement row-level security filters, making them ideal for controlled data sharing.
Question 6: What is the Snowflake Marketplace primarily used for?
- Purchasing additional Snowflake virtual warehouse capacity
- A platform where providers publish data products for consumers to discover and access (Correct answer)
- An internal Snowflake tool for managing ETL pipelines
- A financial exchange platform integrated with Snowflake analytics
Correct answer: A platform where providers publish data products for consumers to discover and access
Snowflake Marketplace is a platform where data providers publish and optionally monetize data products that consumers can discover, request, and use.
Question 7: Which privilege must be granted to a share at the database level before consumer accounts can import and access the shared objects?
- USAGE on the database (Correct answer)
- OWNERSHIP on the database
- IMPORTED PRIVILEGES on the database
- REFERENCES on the database
Correct answer: USAGE on the database
The USAGE privilege on the database and schema must be granted to the share object so consumer accounts can import and navigate the shared database.
