Data Engineer Interview Question

What problem do table formats like Iceberg and Delta Lake solve that plain Parquet on object storage does not?

What the interviewer is probing, how to structure your answer, and a spoken example you can adapt.

Quick answer

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

Spoken example, first person

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 works

Follow-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

Rehearse the hard questions before they are asked

Practise with a live copilot, then walk in ready. A $29 Session Pass gets you through the interview with no subscription and no lock-in.

Get GhostPilot