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

Snowflake Data Exchange

Answer

Data Replication

Answer

External Tables

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

Database

Answer

Schema

Answer

Stage

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

An account that monitors shared data usage logs

Answer

An account with read-only access to all objects in a Snowflake region

Answer

A trial account for evaluating shared datasets before purchase

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 provider account

Answer

Snowflake splits the cost equally between both accounts

Answer

The account that originally created the share object

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

Materialized View

Answer

External Table

Answer

Dynamic Table

Question 6

What is the Snowflake Marketplace primarily used for?

Accepted Answer

A platform where providers publish data products for consumers to discover and access

Answer

Purchasing additional Snowflake virtual warehouse capacity

Answer

An internal Snowflake tool for managing ETL pipelines

Answer

A financial exchange platform integrated with Snowflake analytics

Question 7

Which privilege must be granted to a share at the database level before consumer accounts can import and access the shared objects?

Accepted Answer

USAGE on the database

Answer

OWNERSHIP on the database

Answer

IMPORTED PRIVILEGES on the database

Answer

REFERENCES on the database