Question 1 of 18
A good shard key distributes load and co-locates data used by common requests. TenantId matches both the access pattern and the desired distribution. Source basis: Sharding horizontally partitions data across independent stores. A shard key determines placement and should distribute load while supporting common access patterns.
Strong Interview Answer
The shard key should distribute data based on the tenant's access patterns, ensuring that requests for the same tenant are routed to the same shard. This minimizes data movement and improves query performance. This approach aligns with the core principle of sharding, which is to partition data based on access patterns to optimize query execution.
What to Listen For
- shard key
- tenantId
- access patterns
- data distribution
Caution
This question is a straightforward explanation of sharding and does not require any complex troubleshooting or comparison.