Snowflake Architect Certification Data Sharing and Collaboration 3

Question 1

In Snowflake's data sharing model, how are storage costs allocated between the provider and consumer?

Accepted Answer

Only the provider pays for storage; consumers pay only for compute when querying

Answer

Both accounts are charged proportionally for shared data storage

Answer

Only the consumer is charged for storing the shared data snapshot

Answer

Storage costs are eliminated entirely for shared data in both accounts

Question 2

Which DDL command does a Snowflake architect use to list all outbound shares created in and inbound shares available to the current account?

Accepted Answer

SHOW SHARES

Answer

DESCRIBE SHARES

Answer

LIST SHARES

Answer

SELECT * FROM SNOWFLAKE.ACCOUNT_USAGE.SHARES

Question 3

A Snowflake architect wants to share data with an external organization that has no Snowflake account. What is the recommended approach?

Accepted Answer

Create a reader account for the external organization

Answer

Export the data to Amazon S3 and grant the organization IAM access

Answer

Use Snowflake External Tables pointing to the organization's cloud storage

Answer

Convert the data to CSV files and deliver via SFTP

Question 4

Starting from which Snowflake edition can an account act as a data sharing provider using Secure Data Sharing?

Accepted Answer

Standard Edition

Answer

Enterprise Edition

Answer

Business Critical Edition

Answer

Virtual Private Snowflake only

Question 5

What is the primary security advantage of sharing a Secure View rather than sharing the underlying base table directly?

Accepted Answer

Secure Views allow providers to filter rows and columns, limiting exactly what data consumers can access

Answer

Secure Views execute queries faster than base tables for consumers

Answer

Secure Views automatically encrypt query results with consumer-managed keys

Answer

Secure Views reduce the provider's storage costs for shared datasets

Question 6

In Snowflake's data sharing architecture, what does the term 'zero-copy' specifically mean?

Accepted Answer

No data is physically duplicated — consumers access provider data live via shared metadata pointers

Answer

Data is shared with zero encryption overhead for maximum query performance

Answer

Shared data incurs zero storage cost in the provider account

Answer

Consumer queries run without consuming any virtual warehouse credits

Question 7

Which schema in the SNOWFLAKE system database provides providers with visibility into how consumers are querying their shared data?

Accepted Answer

SNOWFLAKE.DATA_SHARING_USAGE

Answer

SNOWFLAKE.INFORMATION_SCHEMA

Answer

SNOWFLAKE.ACCOUNT_USAGE

Answer

SNOWFLAKE.READER_ACCOUNT_USAGE