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.
Snowflake Architect Certification Data Sharing and Collaboration 1
What Snowflake feature allows data providers to share live, read-only data with consumers without copying or moving it?