CertKeen

SnowPro Advanced: Architect · Free practice question 3 of 10

Secure data sharing

A data provider wants to share a curated view of its customer data with an external partner who has their own Snowflake account, without physically copying the data. Which approach is the Snowflake-native way?

  1. A.Create a Reader Account for the partner and grant them credentials.
  2. B.Create a secure view and grant it via a Snowflake Share; the partner mounts the share as a database in their own account.
  3. C.Use replication to copy the view's underlying tables to the partner's account nightly.
  4. D.Export the view's rows to S3 and grant the partner pre-signed URLs.
Show answer and explanation

Correct answer: B. Create a secure view and grant it via a Snowflake Share; the partner mounts the share as a database in their own account.

Why: Snowflake Secure Data Sharing lets two accounts in compatible regions share objects with zero data copy — the consumer mounts the share and queries live. Reader Accounts are for consumers who don't have their own Snowflake account. Replication is for cross-region availability, not partner sharing. Exporting to S3 defeats the no-copy requirement.

More free SnowPro Advanced: Architect questions