Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Choosing Row vs Column Formats

MediumPipelines00:00
I
Practice interviewer
Your interviewer
In session
I
Interviewer

Welcome to your interview.

The question is on your right: Choosing Row vs Column Formats. Take a moment with it first.

Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.

You need to log in / sign up to chat or submit.

Problem

Scenario

You're planning a new data pipeline and need to pick storage formats for different stages of the flow. Some data will be moved between services, and some will be queried later for analytics.

Question

What factors do you consider when choosing between row-oriented (e.g., Avro) and column-oriented (e.g., Parquet) storage formats?