Deep dive
Expanding on the short answer — what usually matters in practice:
- Context (tags): db-migration, expand-contract, deployment, rollback
- Scaling: what scales horizontally vs vertically, where bottlenecks appear.
- Reliability: retries/circuit breakers/idempotency, observability (logs/metrics/traces).
- Evolution: keep changes cheap (boundaries, contracts, tests).
- Explain the "why", not just the "what" (intuition + consequences).
- Trade-offs: what you gain/lose (time, memory, complexity, risk).
- Edge cases: empty inputs, large inputs, invalid inputs, concurrency.
Examples
A tiny example (an explanation template):
// Example: discuss trade-offs for "how-do-you-introduce-a-breaking-database-change-"
function explain() {
// Start from the core idea:
// Use expand/contract: first add new schema (nullable column/new table) and deploy code that
}
Common pitfalls
- Too generic: no concrete trade-offs or examples.
- Mixing average-case and worst-case (e.g., complexity).
- Ignoring constraints: memory, concurrency, network/disk costs.
Interview follow-ups
- When would you choose an alternative and why?
- What production issues show up and how do you diagnose them?
- How would you test edge cases?