Snowflake Architect Certification Data Sharing and Collaboration

Question 1

What Snowflake feature allows data providers to share live, read-only data with consumers without copying or moving it?

Accepted Answer

Secure Data Sharing

Answer

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?

Accepted Answer

Share

Answer

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?

Accepted Answer

A managed account created by a provider for non-Snowflake consumers

Answer

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?

Accepted Answer

The consumer account

Answer

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?

Accepted Answer

Secure View

Answer

Secure Views hide the view definition from consumers and can implement row-level security filters, making them ideal for controlled data sharing.

Snowflake Architect Certification Practice Test

Snowflake Architect Certification Practice Test

Snowflake Architect Certification Data Sharing and Collaboration