ARA-C01 Question 158
Single answerCross-Cloud Auto-FulfillmentA data provider publishes a Snowflake listing from an account in AWS us-east-1. Several strategic consumers use Snowflake in Azure West Europe and Google Cloud europe-west4, and the provider wants those consumers to receive the data with minimal operational effort while avoiding manual per-cloud replication steps for every database update. The provider also wants to keep the listing available to same-region AWS consumers. Which approach best meets these requirements?
- A
Enable Cross-Cloud Auto-Fulfillment for the listing so Snowflake automatically manages the required replication and refresh of shared data to supported consumer regions and clouds.
- B
Create one direct share per consumer account and ask each consumer to set up external stages that copy the provider's shared tables into their own cloud region.
- C
Convert the listing to a private data exchange listing, because private exchanges automatically replicate data across all clouds without additional configuration.
- D
Use database replication manually to each target region and cloud, and create separate listings from each replica because listings cannot use Cross-Cloud Auto-Fulfillment.
- E
Instruct consumers in Azure and Google Cloud to query the provider's AWS us-east-1 database over cross-cloud secure data sharing, because secure sharing works natively across clouds without replication.
Show answer and explanation
Correct answer: A
Explanation
The best answer is to enable Cross-Cloud Auto-Fulfillment for the listing. This feature is intended for providers who want to distribute listings to consumers across supported Snowflake regions and cloud platforms without manually managing separate replication topologies for each target environment. Snowflake automates the fulfillment workflow behind the listing, reducing administrative overhead and making the data product easier to operate at scale.
Why the other choices are less appropriate: direct shares are not a substitute for cross-cloud listing fulfillment; private data exchanges control who can discover listings but do not inherently provide automatic cross-cloud replication; manual replication may be valid but is more operationally intensive and does not align with the scenario's requirement; and secure data sharing alone does not transparently span clouds without fulfillment.
This aligns with Snowflake best practices for data distribution through listings: use listings for governed data products and use Cross-Cloud Auto-Fulfillment when consumers span multiple supported clouds/regions and the provider wants Snowflake to handle fulfillment logistics.
- A. Correct.
Correct. Cross-Cloud Auto-Fulfillment is designed for listings so providers can offer data products to consumers in other supported regions and clouds without manually creating and maintaining every replica for fulfillment. Snowflake handles the underlying replication/refresh needed to deliver the shared data to eligible consumer locations while continuing to support consumers in the provider's local region as well.
- B. Incorrect.
Incorrect. Direct shares do not solve the cross-cloud fulfillment requirement in this scenario, and consumers should not need to build custom external-stage copy pipelines just to consume a listing. This option adds operational burden and changes the consumption pattern from governed data sharing/listing access to manual data movement.
- C. Incorrect.
Incorrect. A private data exchange is a distribution model, not a mechanism that automatically provides cross-cloud replication for all data. Exchange type does not itself guarantee automatic cross-cloud fulfillment. Cross-Cloud Auto-Fulfillment is the relevant feature for listings when provider and consumer are on different supported clouds/regions.
- D. Incorrect.
Incorrect. Manual database replication and separate listings may work in some architectures, but it does not best meet the stated goal of minimal operational effort and avoiding manual per-cloud replication steps for each update. The statement that listings cannot use Cross-Cloud Auto-Fulfillment is false.
- E. Incorrect.
Incorrect. Native secure data sharing works within the same cloud/region constraints and does not let Azure or Google Cloud consumers directly query data hosted only in AWS without replication/fulfillment. Cross-cloud access for listings requires a fulfillment mechanism such as Cross-Cloud Auto-Fulfillment for supported scenarios.