Reviewed by Aditya Kumar · Last reviewed 2026-03-24
Snowflake caching: metadata, query result (per warehouse), local disk. Time Travel: historical data, default 1 day (configurable up to 90). Fail-safe: 7-day backup after Time Travel. Snowpipe: continuous load from S3/GCS/Blob. Materialized views: pre-computed, auto-refresh. Use:...
Snowflake caching: metadata, query result (per warehouse), local disk. Time Travel: historical data, default 1 day (configurable up to 90). Fail-safe: 7-day backup after Time Travel. Snowpipe: continuous load from S3/GCS/Blob. Materialized views: pre-computed, auto-refresh. Use: cache for repeated queries; Time Travel for recovery; Snowpipe for streaming load. Why it matters: Design choices compound at scale—wrong approach can cause 100× overhead. Scalability trade-offs: Profile before optimizing; validate on sample then full. Cost implications: Suboptimal choices multiply at billion-row scale.
Red Flag: 24/7 warehouse with low utilization. Pro-Move: 'Auto-suspend 5min saved 55% compute; sized by concurrency not peak.'
According to DataEngPrep.tech, this is one of the most frequently asked SQL interview questions, reported at 1 company. DataEngPrep.tech maintains an editor-reviewed database of 1,863 data engineering interview questions across 7 categories.