Salesforce Decode
Salesforcedecode
Back to questions
Data CloudArchitect (Hardest)zero-copysnowflakedata-share

Architect zero-copy data share for Snowflake analytics consumers

Real World Scenario

Enterprise analytics team wants Data Cloud calculated insights in Snowflake without nightly CSV exports duplicating storage and breaking freshness SLAs.

Expected Answer

• Evaluate Data Cloud data share or zero-copy patterns to Snowflake where supported • Define which objects are share-eligible vs must remain in boundary for compliance • Row-level filters on share for regional data residency • Document freshness: near-real-time vs batch share refresh expectations • Cost model: share egress vs compute in Data Cloud vs Snowflake • Governance: revoke share access when employee offboards via IAM integration • Fallback batch export only for objects not share-supported

Follow-Up Questions & Answers

Click to expand — each follow-up includes a direct, interview-ready answer

Main difference: use case and scale. Evaluate Data Cloud data share or zero-copy patterns to Snowflake where supported. Define which objects are share-eligible vs must remain in boundary for compliance. Pick based on your integration pattern and team capability. Zero-copy is architecture negotiation between marketing ops and data platform — define SLA before pipe dreams. Document the decision in an ADR and align with enterprise standards.

Architect Perspective

Zero-copy is architecture negotiation between marketing ops and data platform — define SLA before pipe dreams.