COF-C03 Data Collaboration Practice Question

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  Create a direct share and add the consumer account; Snowflake automatically replicates the data to the consumer's region.

  Why it's wrong here

  Direct shares do not automatically replicate data across regions. A share is a metadata construct that references objects in the provider's account, and the consumer reads the data from the provider's region. Cross-region access would incur higher latency and potentially data egress costs. Automatic replication to the consumer's region is not a built-in behavior of direct shares.

• ✓

  Use database replication to create a replica of the database in the consumer's region, then share the replica with the consumer.

  Why this is correct

  Snowflake supports replicating databases across regions and accounts. The provider can create a secondary database in the consumer's region, keep it synchronized with the primary, and then create a share on the secondary database. The consumer mounts the share from their own region, achieving low-latency access. This is the standard approach for cross-region sharing with performance requirements.

• ✗

  Configure a private data exchange and add the consumer; data exchanges replicate data to all member regions automatically.

  Why it's wrong here

  Data exchanges are containers for sharing within a specific region and do not automatically replicate data across regions. A private data exchange is scoped to the region where it is created. To share across regions with low latency, the provider must replicate the database to the consumer's region and then share the replica, regardless of whether a data exchange is used.

• ✗

  Create a listing on the Snowflake Marketplace and have the consumer request it; Marketplace listings are always served from the consumer's region.

  Why it's wrong here

  Marketplace listings do not automatically serve data from the consumer's region. A listing is a packaging of a share, and the underlying data still resides in the provider's region unless the provider replicates it. The Marketplace does not perform cross-region replication on behalf of the provider. Therefore, this approach would not provide low-latency access for the consumer.