ARA-C01 Question 144
Single answerSharing using Snowflake Data Clean RoomsA retail company wants to collaborate with an advertising partner to measure campaign overlap and audience insights without exposing either party's underlying customer-level data. The solution must let both parties contribute data, allow only approved analysis patterns, and prevent either side from directly querying the other party's raw tables. Which Snowflake design best meets these requirements?
- A
Create a standard secure data share from the retailer to the advertiser and grant the advertiser access only to secure views over customer tables.
- B
Use Snowflake Data Clean Rooms so both parties can link approved datasets and run governed analysis templates that return only policy-controlled results.
- C
Replicate the retailer's customer database to the advertiser's account using database replication, then restrict access with masking policies.
- D
Create an external function that sends both companies' customer data to a third-party service for matching and then writes the results back to Snowflake.
Show answer and explanation
Correct answer: B
Explanation
The best answer is to use Snowflake Data Clean Rooms. This capability is intended for scenarios such as advertising measurement, audience overlap, and partner collaboration where organizations want to derive joint insights without revealing raw data. Compared with standard data sharing, clean rooms add governance over how data can be used, including restricting analysis methods and limiting outputs to approved result sets. This makes them a strong architectural choice when both privacy protection and controlled cross-party analytics are required. In Snowflake best practices and product guidance, clean rooms are positioned specifically for secure data collaboration use cases rather than simple one-way data distribution, replication, or custom external processing.
- A. Incorrect.
Incorrect. Secure shares and secure views can limit direct exposure, but they do not provide the full collaboration model required here. The scenario requires both parties to contribute data into a governed environment, restrict analyses to approved patterns, and avoid direct access to raw tables from either side. Standard sharing is primarily provider-to-consumer and is not the best fit for bilateral privacy-preserving collaboration.
- B. Correct.
Correct. Snowflake Data Clean Rooms are designed for privacy-enhancing collaboration scenarios where multiple parties contribute data and execute controlled analyses without exposing raw underlying data to one another. They support governed collaboration patterns, including restricting what analyses can be run and controlling what results are returned, which directly matches the business and architectural requirements in the scenario.
- C. Incorrect.
Incorrect. Database replication copies database objects to another account or region for availability and distribution use cases, not privacy-preserving analytics collaboration. Even with masking policies, replication would still move the provider's data into the partner environment, which is not aligned with the requirement to prevent either party from directly querying the other's raw tables.
- D. Incorrect.
Incorrect. Sending customer data to an external third-party service increases data exposure and operational risk, and it bypasses the governed in-platform collaboration controls Snowflake provides. This option also conflicts with the requirement to keep collaboration controlled within Snowflake and avoid exposing underlying customer-level data unnecessarily.