Reviewed by Aditya Kumar · Last reviewed 2026-03-24
Delta format: Built on Parquet with transaction log (ACID), time travel, and upserts. Supports MERGE, DELETE, UPDATE. Parquet: Immutable columnar format; append-only; no built-in ACID. Delta adds: schema enforcement, compaction, change data feed. Storage: Both columnar; Delta...
Delta format: Built on Parquet with transaction log (ACID), time travel, and upserts. Supports MERGE, DELETE, UPDATE. Parquet: Immutable columnar format; append-only; no built-in ACID. Delta adds: schema enforcement, compaction, change data feed. Storage: Both columnar; Delta adds _delta_log. Querying: Delta supports point-in-time reads; Parquet is file-atom. Use Delta for mutable tables, pipelines needing upserts; Parquet for immutable batches. 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: Generic textbook answers. Pro-Move: 'At scale we measured X, implemented Y, achieved Z%—validated and iterated.'
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.