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.
HardTechnical
0 practiced
Design an end-to-end exactly-once processing pipeline: producers write events to Kafka topics, stream processing enriches events, and final results are written to an external PostgreSQL transactional store. Describe patterns for handling retries, idempotency, transactional writes, stateful joins, and how to ensure consistency under failures.
MediumTechnical
0 practiced
Design an approach to deduplicate messages consumed from RabbitMQ where producers may retry and network blips cause duplicate deliveries. Discuss idempotent consumers, deduplication caches (TTL), and whether broker-side features can help.
MediumTechnical
0 practiced
You must implement an order management access pattern in DynamoDB: lookups by order_id, queries for recent orders by customer_id, and batched processing by status. Propose a single-table design including primary key schema, GSIs, attribute layout, and discuss consistency, capacity planning, and item size limits.
MediumTechnical
0 practiced
Given schema:products(product_id PK, name text, category text, tags text[], price numeric, created_at timestamptz)And queries:1) Find products by tag and sort by price asc2) Find recently added products in a categoryDesign PostgreSQL indexes to support both queries on 10M rows. Explain index types, multi-column vs expression indexes, and maintenance costs.
EasyTechnical
0 practiced
Design a DynamoDB partition key strategy for a social-media feed system where users have widely varying follower counts (1 to 10M). Explain how you avoid hot partitions, support fan-out reads for feeds, and enable efficient feed generation for both high- and low-fanout users.
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.