Sharding & Partitioning
Range by time
Audit logs are append-only; admins query “events between T1 and T2.” Writes never update old rows. Compare hash sharding vs range sharding by month for this workload. Which do you pick and what hotspot appears on the latest range?
Intermediate drill question.