Plain Parquet files in a bucket give you no transactions, so a reader can see a half written directory and a failed job leaves partial data. Table formats add a metadata layer with atomic commits and snapshot isolation, so writes appear all at once. They also bring schema evolution, row level updates and deletes, time travel to previous snapshots, and file pruning through statistics rather than directory listing.
Why interviewers ask this
Lakehouse formats are now the default on most new platforms, and interviewers want to know whether you understand what they fix rather than just that they are popular. Strong answers name atomicity and snapshot isolation first, mention that Iceberg's hidden partitioning removes the fragile partition path convention, and note compaction as ongoing maintenance.
How to structure your answer
- State the concrete pain of raw Parquet directories.
- Explain the metadata layer and atomic snapshot commits.
- List the capabilities that unlock: updates, deletes, time travel, evolution.
- Mention hidden partitioning versus directory conventions.
- Add the maintenance cost: compaction and snapshot expiry.
Example answer
With plain Parquet the table is really just a directory convention, so there is no atomicity. If a job dies halfway, readers see partial data, and there is no way to update or delete a single row without rewriting whole partitions by hand. Table formats fix that with a metadata layer. A commit swaps a pointer to a new snapshot atomically, so readers either see the old state or the new one, never a mixture, and you get time travel almost for free because old snapshots still exist. That last part saved us once when a bad transform overwrote a mart and we recovered by querying the previous snapshot rather than restoring from backups. The other thing I like about Iceberg specifically is hidden partitioning, where the table tracks the partition transform itself, so an analyst filtering on a timestamp gets pruning without knowing the layout. The cost is maintenance: you need scheduled compaction of small files and snapshot expiry, or metadata grows without bound.
Walking into this interview soon? GhostPilot listens to your live call, spots the question the moment it is asked, and puts a structured answer on your screen in real time. Try it on your next mock, or grab a $29 Session Pass, no subscription, for the real thing.
See how it worksFollow-up questions to expect
- How do copy on write and merge on read differ for updates?
- What breaks if you never expire old snapshots?
- How would you migrate an existing Parquet table to Iceberg?
Related data engineer questions
Your interviewer will ask their own version of this. Paste your actual job description into the free Question Predictor and get the 20 questions that role is most likely to ask, with what each one is really probing.
Predict my questions