Back to Prep Library
Category Blueprint

System Design Interview Library

High-scale engineering, system architecture & database sharding

Questions52
Views35.6k
Upvotes2.6k
Filter

Question Catalog

(52 visible)
System Design· System Design

What is the difference between REST and GraphQL?

1.1k78
medium
System Design· System Design

What is the difference between horizontal and vertical scaling?

1.1k8
medium
System Design· System Design

When would you choose SQL vs NoSQL?

1.1k48
medium
System Design· System Design

What is idempotency and why does it matter?

1.0k28
medium
System Design· System Design

How do distributed systems detect node failures?

97917
medium
System Design· System Design

How do you approach back-of-the-envelope capacity estimation?

95136
medium
System Design· System Design

What is database connection pooling?

88552
medium
System Design· System Design

What is the publish-subscribe pattern?

87255
medium
System Design· System Design

What are the three pillars of observability?

83520
medium
System Design· System Design

What is consistent hashing?

82177
medium
System Design· System Design

What is an API gateway?

80863
medium
System Design· System Design

What is a load balancer and what strategies does it use?

76645
medium
System Design· System Design

When would you use WebSockets vs polling vs SSE?

71166
medium
System Design· System Design

When do you use a read replica vs a cache?

70578
medium
System Design· System Design

Why prefer stateless services and how do you handle sessions?

56629
medium
System DesignMicrosoft· Low-Level Design2023

Explain database indexing and B-trees

533250
medium
System Design· System Design

What is database replication?

53373
medium
System Design· System Design

What is the difference between optimistic and pessimistic locking?

45158
medium
System Design· System Design

What is a CDN and how does it work?

44770
medium
System Design· System Design

What is the difference between throttling and rate limiting?

31728
medium
System Design· System Design

What are blue-green and canary deployments?

28530
medium
System Design· System Design

What is a message queue and why use one?

27246
medium
System Design· System Design

How does caching improve system performance?

18343
medium
System Design· System Design

What indexing strategies improve database performance?

1076
medium
System Design· System Design

What is backpressure and how do you handle it?

10416
medium
System Design· System Design

What is a Bloom filter and when is it useful?

9366
medium
System DesignGoogle· System Design2024, 2023, 2021

Design a URL shortener (TinyURL)

1.9k134
hard
System Design· System Design

How do you design for high availability?

1.2k5
hard
System Design· System Design

What is leader election in distributed systems?

1.2k75
hard
System Design· System Design

How would you design a news feed system?

1.2k34
hard
System Design· System Design

How would you design a distributed cache?

1.2k37
hard
System Design· System Design

How would you design a notification system?

1.1k35
hard
System Design· System Design

How do you make a payment system reliable against retries?

99368
hard
System Design· System Design

How would you design a real-time chat system?

87630
hard
System Design· System Design

How would you design a file storage service like Dropbox?

87365
hard
System Design· System Design

What are event sourcing and CQRS?

82312
hard
System Design· System Design

How would you design a 'nearby drivers' / proximity search?

82271
hard
System Design· System Design

How would you design Twitter's timeline at scale?

76753
hard
System Design· System Design

What is the CAP theorem?

76259
hard
System Design· System Design

How would you design a typeahead/autocomplete system?

65532
hard
System Design· System Design

What is database sharding?

65138
hard
System Design· System Design

What is two-phase commit and its drawbacks?

64964
hard
System Design· System Design

How would you design a rate limiter?

54580
hard
System Design· System Design

How would you design an analytics/metrics pipeline?

52312
hard
System Design· System Design

How would you design a URL shortener like TinyURL?

51038
hard
System Design· System Design

What is a write-ahead log (WAL)?

50334
hard
System Design· System Design

What are the trade-offs of microservices vs a monolith?

49621
hard
System Design· System Design

What is the circuit breaker pattern?

33144
hard
System Design· System Design

What is the difference between strong and eventual consistency?

30214
hard
System Design· System Design

How would you design a distributed key-value store?

21946
hard
System Design· System Design

What is a read/write quorum?

11216
hard
System Design· System Design

What is the saga pattern for distributed transactions?

4073
hard

Difficulty Distribution

Easy0 (0%)
Medium26 (50%)
Hard26 (50%)

Hiring Companies

Tested Topics

#scalability#database#idempotency#caching#indexing#consistency#api#rest

Study Guide

Understand CAP theorem trade-offs, request distribution via load balancing, caching consistency, and distributed sharding algorithms.