Medium-Hard Evaluate System Design Interview Framework Multiple Choice

A ride-sharing app needs to find all available drivers within 5 km of a rider's location in under 10ms. What is the most appropriate technology?

Evaluate — Tests ability to make judgments and justify decisions.

Answer Options

A PostgreSQL with PostGIS extension and a spatial index
B Redis GEORADIUS command on an in-memory geospatial set
C Elasticsearch with a geo_distance query
D Cassandra with a composite key of (grid_cell, driver_id)

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 20+ more System Design Interview Framework questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the System Design Interview Framework topic (System Design).

Learn System Design Interview Framework → Browse All Questions

More System Design Interview Framework Questions

What does RADIO stand for in the system design interview framework?

Easy

In a 45-minute system design interview, how many minutes should you spend on the Infrastructure (architecture diagram) phase?

Easy

Which of the following is a NON-functional requirement?

Medium-Easy

What HTTP status code should a URL shortener return when redirecting a user from the short URL to the original URL?

Medium-Easy

What is the correct REST URL for retrieving all tweets posted by a specific user?

Medium-Easy