Snowflake

15 questions

Architecture, virtual warehouses, time travel, streams & tasks. Master Snowflake for your cloud data warehouse interviews.

1JuniorArchitectureCapital OneAdobeComcast

Multi-Cluster Shared Data Architecture

Explain Snowflake's architecture. How does it separate storage, compute, and cloud services?

🔒
2JuniorArchitectureNetflixDoorDashInstacart

Virtual Warehouse Sizing and Auto-Suspend

How do you choose the right virtual warehouse size? Explain auto-suspend and auto-resume.

🔒
3SeniorPerformanceCapital OneAdobeSnowflake

Micro-Partitions and Clustering Keys

Explain micro-partitions in Snowflake. When and how would you define clustering keys?

🔒
4SeniorPerformanceSnowflakeCapital OneDoorDash

Result Caching (Three Levels)

Describe the three levels of caching in Snowflake. How does each improve query performance?

🔒
5JuniorArchitectureNetflixCapital OneSnowflake

Time Travel and Fail-Safe

What is Time Travel in Snowflake? How does it work with Fail-Safe?

🔒
🔒 10 more premium questions
Upgrade to PRO — ₹1,499/month
6JuniorArchitectureSnowflakeDoorDashInstacart🔒 Premium

Zero-Copy Cloning

What is zero-copy cloning in Snowflake? What are practical use cases?

🧠 What they're really testing
🔒
7SeniorData SharingSnowflakeCapital OneHealthcare companies🔒 Premium

Data Sharing

How does Snowflake Data Sharing work? What's the difference between direct sharing and the Snowflake Marketplace?

🧠 What they're really testing
🔒
8SeniorStreams & TasksNetflixDoorDashCapital One🔒 Premium

Snowpipe Auto-Ingest

How does Snowpipe work for continuous data loading? Compare it with batch COPY INTO.

🧠 What they're really testing
🔒
9SeniorStreams & TasksCapital OneSnowflakeAdobe🔒 Premium

Streams for Change Data Capture

How do Snowflake Streams work for CDC? Walk me through a practical implementation.

🧠 What they're really testing
🔒
10SeniorArchitectureAmazonGoogleSnowflakeConsulting firms🔒 Premium

Snowflake vs Redshift vs BigQuery

Compare Snowflake, Redshift, and BigQuery. When would you choose each?

🧠 What they're really testing
🔒
11SeniorPerformanceEvery Snowflake customer🔒 Premium

Cost Optimization Strategies

Your Snowflake bill doubled last month. Walk me through how you'd investigate and optimize costs.

🧠 What they're really testing
🔒
12SeniorData SharingNetflixCapital OneAdobe🔒 Premium

External Tables and Stages

Explain Snowflake stages and external tables. When would you use an external table vs COPY INTO?

🧠 What they're really testing
🔒
13SeniorPerformanceCapital OneDoorDashSnowflake🔒 Premium

Materialized Views

How do materialized views work in Snowflake? When are they worth the cost?

🧠 What they're really testing
🔒
14LeadPerformanceSnowflakeCapital OneAdobe🔒 Premium

Snowpark for Python

What is Snowpark and when would you use it instead of SQL or external Spark?

🧠 What they're really testing
🔒
15SeniorStreams & TasksSnowflakeCapital OneDoorDash🔒 Premium

Tasks for Scheduling

How do Snowflake Tasks work? How do you build a task tree for a multi-step ETL pipeline?

🧠 What they're really testing
🔒