You need to design a database that will store and efficiently query ten billion rows of transactional data with requirements for sub-second query response times on common access patterns. Walk through your complete design approach.

Sample answer preview

Designing a database for ten billion rows with sub-second query requirements is a fundamentally different exercise from designing for millions of rows. At this scale, every design decision has amplified consequences, and multiple strategies must work together to achieve…