Waymo·Software Engineer·Onsite - System Design / Architecture
- How would you decide between a relational database, a NoSQL store, and a columnar warehouse for storing large volumes of data?
- Given a set of access patterns, how would you design the schema including entities, relationships, indexes, and partitioning keys?
- How do you balance schema and storage design for a workload that needs to support both real-time writes and heavy analytics queries?
“This is the kind of question where you think you know the answer until you're actually saying it out loud.”