Design a Column-Queryable KV Database
Company: Snapchat
Role: Software Engineer
Category: System Design
Difficulty: medium
Interview Round: Onsite
Overview: This question evaluates understanding of distributed storage architectures, secondary indexing and queryability for sparse, column-oriented key-value stores, including competencies in data modeling, sharding, replication, consistency, and schema evolution.