Database Selection and Trade Offs Questions

How to evaluate and choose data storage systems and architectures based on workload characteristics and business constraints. Coverage includes differences between relational and nonrelational families such as document stores, key value stores, wide column stores, graph databases, time series databases, and search engines; mapping query patterns and latency requirements to storage options; trade offs between strong consistency and eventual consistency and their impact on availability and complexity; partition key design, replication strategies, and high availability considerations; operational concerns including backups, monitoring, vendor and cost trade offs, migration or hybrid strategies, and when to adopt polyglot persistence. Senior level discussion includes selecting specific managed services and reasoning about expected load patterns, failure modes, and operational burden.

MediumTechnical

0 practiced

Design a data retention and GDPR compliance solution across heterogeneous stores: relational DB, document store, and analytics data lake. Describe how you would discover personal data, propagate deletions or pseudonymization, maintain audit trails, and reconcile delayed or out-of-order deletions across downstream systems.

MediumTechnical

0 practiced

Explain practical implications of eventual consistency for user-facing reads: stale reads, out-of-order updates, and cache coherence. Suggest design patterns to mitigate UX issues such as read-your-writes, session affinity, write-through caches, and tombstone propagation, and when to use each.

HardSystem Design

0 practiced

Design a globally distributed database across three regions for a social app with 100M users that must optimize read locality and provide global eventual consistency. Describe replication topology, conflict resolution approach, leader election, failover behavior, data residency considerations, and how you would measure compliance with an SLA of 99.99% and RPO 5 seconds.

EasyTechnical

0 practiced

When should a customer choose a managed database service versus self-managing databases on VMs or on-prem? Discuss tradeoffs across operational burden, total cost of ownership, customizability, compliance and auditability, upgrade control, and vendor lock-in. Provide decision criteria for a heavily regulated financial firm.

HardTechnical

0 practiced

Compare event sourcing versus change-data-capture for building an auditable system-of-record and read models. Discuss storage implications, replayability, rebuilding projections, storage costs, read model freshness, and operational complexity of running each approach at scale.

Unlock Full Question Bank

Get access to hundreds of Database Selection and Trade Offs interview questions and detailed answers.

Join thousands of developers preparing for their dream job.