InterviewSam
Log inStart free
Interview questions
Sharding, replication & partitioningHardSDE-3

In a partitioned database, what is the difference between a local secondary index and a global secondary index? What are the trade-offs for reads and writes?

Asked at
AmazonGoogle

Think first

Answer out loud as you would in the room — clarify, give numbers, name the trade-off — then compare with the model answer.

Go deeper

Design a distributed key-value store (like DynamoDB) Lesson: SQL vs NoSQL: choosing the store

Saved on this device. Create a free account to keep it on every device.

Practise this with Sam

A real mock interview, out loud, with an honest scorecard. Free to start.

Start free