Walk me through how you would choose between a cloud warehouse like Snowflake or BigQuery and a lakehouse setup for a new analytics platform.

What the interviewer is looking for

• This question tests cloud data platforms. Compares warehouses, lakehouses and open table formats in terms of workload, cost model, governance and team skills rather than hype.
• Strong answers: Considers workloads, open table formats like Iceberg or Delta, cost model, governance, machine learning needs and team skills.
• Likely follow-up: What would make you revisit that decision a year later?

Another way it may be asked: A company is starting fresh and asks you whether to use a warehouse or a lakehouse. What would you weigh up before recommending one?

A structure to follow: Answer, explain, example, limits

1. Step 1

   Answer

   Give your direct answer in the first sentence so the interviewer knows where you are going.

2. Step 2

   Explain

   Say how it works or why you would do it that way, in plain words before jargon.

3. Step 3

   Example

   Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

4. Step 4

   Limits

   Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Reciting a definition without showing you have applied it.
• Using terms you cannot explain if asked a level deeper.
• Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Related questions

• Can you explain the difference between a fact table and a dimension table, and when you would use each?
• If you had to load a daily file from a partner into a warehouse, how would you make sure running the job twice doesn't create duplicate rows?
• What checks would you put on a new data source before analysts start relying on it?
• Tell me about a time a Spark or similar distributed job was slow or failing. How did you find the cause and what did you change?
• How do you structure dependencies and retries in an orchestration tool like Airflow or Dagster so that one failure doesn't cascade into a mess?

Browse all questions