A Database Specialist Is Designing a New Database Infrastructure for a Ride

A Database Specialist is designing a new database infrastructure for a ride hailing application. The application data includes a ride tracking system that stores GPS coordinates for all rides. Real-time statistics and metadata lookups must be performed with high throughput and microsecond latency. The database should be fault tolerant with minimal operational overhead and development effort. Which solution meets these requirements in the MOST efficient way?

A) Use Amazon RDS for MySQL as the database and use Amazon ElastiCache
B) Use Amazon DynamoDB as the database and use DynamoDB Accelerator
C) Use Amazon Aurora MySQL as the database and use Aurora's buffer cache
D) Use Amazon DynamoDB as the database and use Amazon API Gateway