Question 680
For this Snowflake situation — Two companies want joint audience-overlap metrics without revealing each other's underlying customer-level identifiers. — the team adopts: Evaluate a supported Snowflake data clean room with approved templates and aggregation restrictions. Which ongoing practice BEST limits the same problem recurring?
Explanation
Correct Answer
The relevant ongoing safeguard is: Audit collaboration templates and data-usage policies before each partner onboarding. It controls the recurring exposure associated with this mechanism: Data clean rooms enable governed collaborative analytics while limiting direct disclosure of raw participant data. The original action, evaluate a supported Snowflake data clean room with approved templates and aggregation restrictions., still needs operational checks when the environment or workload changes.
Incorrect Answers
That safeguard is relevant to: Live shares preserve the provider's ability to manage access; exported copies cannot be centrally recalled. The current failure instead follows from: Data clean rooms enable governed collaborative analytics while limiting direct disclosure of raw participant data. Its prevention measure is “Audit collaboration templates and data-usage policies before each partner onboarding”.
This routine guards against another mechanism: Time Travel is bounded by object type, edition, configured retention, and elapsed time. The recurring exposure in the current case is: Data clean rooms enable governed collaborative analytics while limiting direct disclosure of raw participant data. The matching preventive check is “Audit collaboration templates and data-usage policies before each partner onboarding”.
The suggested review tracks a different technical risk: Zero-copy cloning uses shared underlying micro-partition references initially, with later changes driving divergence. Here the sustained control must address: Data clean rooms enable governed collaborative analytics while limiting direct disclosure of raw participant data. Choose “Audit collaboration templates and data-usage policies before each partner onboarding”.