Technology Selection & Deep Technical Knowledge Questions
Deep understanding of specific technologies relevant to complex system design. Master databases (PostgreSQL, Cassandra, DynamoDB, Elasticsearch), message queues (Kafka, RabbitMQ), caching systems (Redis), search engines, and frameworks. Understand their strengths, weaknesses, trade-offs, operational characteristics, scaling patterns, and common pitfalls. Be able to justify technology choices based on specific system requirements.
HardSystem Design
0 practiced
Design a near-real-time analytics pipeline that consumes CDC from Postgres and writes transformed events to a low-latency OLAP store. Choose components (e.g., Debezium, Kafka, Flink, ClickHouse), explain exactly-once concerns, schema evolution, backpressure handling, and how you'd run reprocess/backfill safely.
MediumTechnical
0 practiced
Create a migration plan to move a large Postgres monolith to a sharded cluster with minimal downtime. Include steps for schema changes, dual writes (if needed), data backfill, cutover, verification, and rollback strategies. Mention automation and verification tooling you would use.
MediumSystem Design
0 practiced
Design a low-latency leaderboard with frequent updates and range queries (top-K per region) choosing among Redis sorted sets, Postgres, Cassandra, or Elasticsearch. Discuss how to ensure consistency under concurrent updates and how to scale writes/reads.
MediumSystem Design
0 practiced
Design a storage and search solution for a product catalog with 50M products needing faceted filters, sort by popularity, and near-real-time updates. Compare using Postgres + materialized views, Elasticsearch, or a hybrid approach. Explain indexing, consistency, and refresh strategies.
EasyTechnical
0 practiced
Describe primary key selection and use of foreign keys in a relational database. Then explain how to map those relational concepts when modeling data in a NoSQL system like DynamoDB or Cassandra, highlighting trade-offs in queryability and join avoidance.
Unlock Full Question Bank
Get access to hundreds of Technology Selection & Deep Technical Knowledge interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.