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

37 practiced

Outline a migration plan to extract a billing module from a monolithic RDBMS into a microservice owning its own database. Include data migration approach, options for dual-write versus CDC, maintaining transactional boundaries, verifying data correctness, cutover strategy, rollback paths, and how you measure success.

HardSystem Design

45 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.

HardTechnical

59 practiced

You detect silent data corruption in a distributed database cluster. Walk through immediate containment actions, forensic validation checks to quantify corruption scope, repair and restore strategies, communication to stakeholders, regulatory obligations, and long-term preventative measures to avoid recurrence.

MediumTechnical

32 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.

EasyTechnical

37 practiced

Explain differences between full backups, incremental backups, snapshots, and point-in-time recovery (PITR). For a transactional OLTP database with 99.95% SLA and RPO 15 minutes, recommend a backup and retention approach and explain operational tradeoffs and testing you would perform.

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.