Level 8 - PrincipalScenario-Based Questionsm1 distributed data architecture
Shard Key Choice for Marketplace Orders
Design scenario: marketplace_orders has 2B rows/year. Reads are mostly seller_id + recent date. Propose shard key, one index, one trade-off.
Schema Context
marketplace_orders(order_id, seller_id, buyer_id, created_at, status, total_amount)