Prev Next

Database / Snowflake Interview Questions

How does Snowflake compare to BigQuery and Redshift in architecture and pricing model?

These three platforms dominate cloud data warehousing and each represents a distinct architectural philosophy.

Snowflake uses multi-cluster shared-data architecture: explicit Virtual Warehouses (MPP clusters) read from cloud object storage. Available on AWS, Azure, and GCP. Compute billed per credit-second while running; storage billed per TB/month compressed. Customers manage warehouse sizing and concurrency configuration.

BigQuery (Google Cloud only) is fully serverless — there are no clusters or warehouses to provision. The Dremel engine allocates compute slots automatically per query. Default pricing: on-demand (per TB of data scanned), or capacity pricing (flat-rate slot reservations). BigQuery abstracts all infrastructure; you just run SQL.

Amazon Redshift uses shared-nothing node clusters. RA3 nodes (modern Redshift) separate storage to S3 and compute to nodes, partially approaching Snowflake's model. Billed per node-hour (provisioned) or per RPU-second (Redshift Serverless). Deeper AWS service integration. Requires cluster sizing decisions (node type, count) and maintenance (vacuuming, sort/dist key tuning).

Snowflake vs BigQuery vs Redshift
DimensionSnowflakeBigQueryRedshift
ArchitectureMulti-cluster shared-dataServerless (Dremel)Shared-nothing cluster (RA3)
Cloud platformsAWS, Azure, GCPGCP onlyAWS only
Compute modelVirtual Warehouses (user-managed)Fully serverless, auto-slot allocationProvisioned nodes or Serverless RPU
Compute billingCredits/second while warehouse runsPer TB scanned (on-demand) or slotsNode-hours or RPU-seconds
Storage billingPer TB/month compressedPer TB/month in GCSPer TB/month in S3 (RA3)
Idle compute costZero when warehouse suspendedZero (serverless)Full node-hour cost if always-on
Cross-cloud supportYes (replicate across clouds)NoNo
Semi-structured dataNative VARIANT typeNative JSON/ARRAY typesSUPER type (limited)
Which cloud data warehouse platform charges users based on bytes of data scanned per query in its default on-demand pricing mode?
Which platform requires you to choose a node type and cluster node count rather than a warehouse T-shirt size?

More Related questions...

What is Snowflake and how does its multi-cluster, shared-data architecture differ from traditional data warehouses? What are the three layers of Snowflake's architecture (Storage, Compute, Cloud Services) and what does each do? What is a Virtual Warehouse in Snowflake and how does it scale independently of storage? What is the difference between Snowflake's columnar storage and row-based storage in traditional RDBMS? What is the Snowflake Cloud Services layer and what components does it manage? What are micro-partitions in Snowflake and how do they enable automatic data clustering? What is data clustering in Snowflake and when should you define a clustering key? What is the difference between Snowflake Standard, Enterprise, Business Critical, and Virtual Private Snowflake edition? How does Snowflake handle multi-cloud deployment and cross-cloud replication? What is Snowflake's separation of compute from storage and what billing advantages does it provide? What are the stages in Snowflake (internal vs external) and how do you use them for data loading? How does the COPY INTO command work and what file formats does it support? What is Snowpipe and how does it enable continuous / serverless data ingestion? What is the difference between bulk loading with COPY INTO and micro-batch loading with Snowpipe? How does Snowflake handle semi-structured data (JSON, Avro, Parquet, ORC) with the VARIANT type? What are Snowflake Dynamic Tables and how do they differ from regular tables and views? What is Time Travel in Snowflake and how does it work (retention period, UNDROP, AT/BEFORE)? What is Fail-safe in Snowflake and how does it differ from Time Travel? What is the Snowflake Query Profile and how do you use it to diagnose slow queries? What is result caching in Snowflake and under what conditions does it apply? What is the metadata cache (Cloud Services layer cache) and how does it speed up queries? What is a clustering key and how does it reduce partition pruning cost for large tables? What are Snowflake Materialized Views and when should you use them over regular views? What is the difference between a Snowflake View, Materialized View, and Dynamic Table? How do you optimize query performance in Snowflake (warehouse sizing, clustering, pruning, result cache)? What are Snowflake Streams and how do they implement Change Data Capture (CDC)? What are Snowflake Tasks and how do you schedule SQL transformations with them? How does Snowflake implement Role-Based Access Control (RBAC) and what are the system-defined roles? What is column-level security in Snowflake (Dynamic Data Masking and Column-level Security policies)? What is Row Access Policy in Snowflake and how does it implement row-level security? How does Snowflake encrypt data at rest and in transit? What is Snowflake's Tri-Secret Secure model and when is it used? What are Snowflake Object Tags and Data Classification and how do they support governance? What is the Snowflake Access History feature and how does it support audit and compliance? What is Snowflake Secure Data Sharing and how does it work without copying data? What is the Snowflake Data Marketplace and what types of data products are available? What are Snowflake Data Clean Rooms and what privacy problems do they solve? What is Snowpark and how does it allow Python/Java/Scala code to run inside Snowflake? What are Snowflake Native Apps and how does the Native App Framework work? What are Snowflake External Tables and when would you use them over internal tables? What is Snowflake's multi-cluster warehouse and how does it handle concurrency auto-scaling? What is Resource Monitor in Snowflake and how do you use it to control credit consumption? How does Snowflake support ELT patterns and how does it compare to ETL? What are common Snowflake anti-patterns and performance pitfalls to avoid? How does Snowflake compare to BigQuery and Redshift in architecture and pricing model?
Show more question and Answers...

CouchDB Interview Questions

Comments & Discussions

Interviews Questions

About Javapedia.net

Javapedia.net is for Java and J2EE developers, technologist and college students who prepare of interview. Also this site includes many practical examples.

This site is developed using J2EE technologies by Steve Antony, a senior Developer/lead at one of the logistics based company.

Follow Javapedia updates

contact: javatutorials2016[at]gmail[dot]com

Kindly consider donating for maintaining this website. Thanks.

Copyright © 2026, javapedia.net, all rights reserved. · .

DMCA.com Protection Status