Question 1,035 of 1,663
DBS-C01 Workload-Specific Database Design Practice Question
A company is designing a database for a ride-sharing application that requires real-time location updates and driver-passenger matching. The database must support geospatial queries to find nearby drivers within a radius. The expected throughput is 10,000 writes per second and 5,000 reads per second. The company wants a fully managed solution with low latency. The application team has experience with PostgreSQL. Which database design should they choose?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Use Amazon Aurora PostgreSQL with the PostGIS extension and use read replicas for scaling reads.
Amazon Aurora PostgreSQL supports PostGIS for geospatial queries, can scale to handle the throughput with write replicas and auto-scaling, and is fully managed. Option B (DynamoDB) is not ideal for geospatial queries; it requires complex partitioning. Option C (DynamoDB with GSI) still not good for radius queries. Option D (RDS MySQL) has geospatial support but may not scale as well as Aurora.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Use Amazon Aurora PostgreSQL with the PostGIS extension and use read replicas for scaling reads.
Why this is correct
Aurora PostgreSQL with PostGIS provides geospatial support, scalability, and managed service.
- ✗
Use Amazon DynamoDB with a geospatial library to encode locations into a partition key.
Why it's wrong here
DynamoDB lacks native geospatial query support and requires workarounds.
- ✗
Use Amazon DynamoDB with a global secondary index on a geohash attribute for proximity queries.
Why it's wrong here
Geohash is approximate and may not meet precision requirements; also not fully managed for geospatial.
- ✗
Use Amazon RDS for MySQL with spatial indexes and Multi-AZ deployment.
Why it's wrong here
RDS MySQL may not handle the required throughput as easily as Aurora.
Quick reference
AAA Protocol Comparison
| Protocol | Port(s) | Encryption | Transport | Primary Use |
|---|---|---|---|---|
| RADIUS | 1812 / 1813 | Password only | UDP | Network access control |
| TACACS+ | 49 | Full packet | TCP | Device administration |
| Diameter | 3868 | Full session | TCP / SCTP | Carrier / mobile networks |
| 802.1X | — | EAP-based | Layer 2 | Port-based access control |
TACACS+ encrypts the entire packet; RADIUS only encrypts the password field — a key exam distinction.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Last reviewed: Jun 20, 2026
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.