Improve RDS Performance for Real-Time Geospatial Data

SAA-C03 By islever Editorial Last updated

Design high-performing and elastic compute solutions.

Short answer

D Deploy an Amazon ElastiCache for Redis cluster in front of the existing DB instance to handle rapid updates and retrieval using its in-memory speed and geospatial features.

Question

A company has deployed a multiplayer game for mobile devices. The game requires live location tracking of players based on latitude and longitude. The data store for the game must support rapid updates and retrieval of locations. The game uses an Amazon RDS for PostgreSQL DB instance with read replicas to store the location data. During peak usage periods, the database is unable to maintain the performance that is needed for reading and writing updates. The game's user base is increasing rapidly. What should a solutions architect do to improve the performance of the data tier?
  1. Take a snapshot of the existing DB instance. Restore the snapshot with Multi-AZ enabled.
  2. Migrate from Amazon RDS to Amazon OpenSearch Service with OpenSearch Dashboards.
  3. Deploy Amazon DynamoDB Accelerator (DAX) in front of the existing DB instance. Modify the game to use DAX.
  4. Deploy an Amazon ElastiCache for Redis cluster in front of the existing DB instance. Modify the game to use Redis. Correct Answer

Key Takeaways

The core trap is confusing DAX (a DynamoDB-specific accelerator) with general-purpose caching; candidates must recognize that DAX cannot sit in front of RDS, while Redis supports both high-speed caching and geospatial data structures.

This question addresses improving the performance of an Amazon RDS for PostgreSQL database handling high-frequency geospatial updates by deploying a caching layer. The correct solution leverages ElastiCache for Redis to offload read/write traffic and utilize its native geospatial capabilities.

Common mistake: Many learners incorrectly choose Option C (DAX) because they associate 'accelerator' with performance improvement, failing to realize that DAX is exclusively designed for Amazon DynamoDB and cannot be used with RDS.

Expert Analysis

Why the Answer Is Correct

Option D is the only technically viable solution among the choices. Deploying Amazon ElastiCache for Redis in front of the existing RDS instance allows the application to cache frequently accessed location data, significantly reducing database load. Furthermore, Redis has built-in support for geospatial indexes (GeoHash), making it ideal for latitude/longitude tracking scenarios as noted by community member Dantecito.

Why the Other Options Are Wrong

Option A (Multi-AZ) provides high availability and disaster recovery, not performance scaling for reads/writes. Option B (OpenSearch) involves a complete database migration rather than optimizing the current tier. Option C is invalid because Amazon DynamoDB Accelerator (DAX) is strictly for DynamoDB; it cannot connect to or accelerate an RDS PostgreSQL instance, a point clarified by user Jacky_S who noted "AWS DynamoDB is a DBaaS" and thus incompatible with this setup.

Community Comment Notes

The community largely agrees on D, with some confusion initially surrounding DAX. User f07ed8f argued that ElastiCache only helps reads, but Redis also handles writes efficiently in this pattern. User Rhydian25 correctly pointed out that DAX is for NoSQL/DynamoDB, not relational databases like PostgreSQL. The consensus highlights that ElastiCache provides the microsecond latencies needed for real-time gaming updates.

Official Reference

These links open the official vendor documentation in a new tab.

Exam Strategy

Always match the service name to its compatible database engine: DAX goes with DynamoDB, not RDS. When seeing 'geospatial' and 'high performance' together, consider Redis's native Geo commands alongside caching benefits.

Frequently Asked Questions

Can I use DAX to accelerate RDS PostgreSQL?

No. DAX is exclusively for Amazon DynamoDB. It cannot connect to or cache data from RDS instances.

Why is Multi-AZ not the right answer for performance?

Multi-AZ ensures high availability and failover capability, but it does not increase read/write throughput or reduce latency for application requests.

More SAA-C03 FAQ →

Community Votes

D
74%
C
26%

74% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 12 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 12

  1. Rhydian25 👍 7 Answered D
    Why are people voting for C? PostgreSQL is a relational DB. DynamoDB is NoSQL. It makes no sense
  2. f07ed8f 👍 4 Answered C
    Vote for C (DAX) as ElastiCache for Redis cluster only helps on read operation but not white.
  3. sirajtr47 👍 4
    Performance >> Amazon ElastiCache for Redis cluster
  4. Scheldon 👍 2 Answered D
    AnswerD ElastiCache is a fully managed, in-memory caching service that provides microsecond read and write latencies that support flexible, real-time use cases. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/creating-elasticache-cluster-with-RDS-settings.html
  5. Jacky_S 👍 2 Answered D
    The answer C is not making any sense with "Deploy Amazon DynamoDB Accelerator (DAX) in front of the existing DB instance.", because AWS DynamoDB is a DBaaS.
Show 7 more comments
  1. sheilawu 👍 2 Answered C
    " writing updates" so it shoud be DAX.
  2. Dantecito 👍 1 Answered D
    To add more to all the answer Redis has built-in support for geospatial data, making it ideal for updates and retrieval of locations.
  3. MatAlves 👍 1 Answered D
    Refer to a public discussion thread on this question
  4. ug56c 👍 1 Answered D
    Amazon ElastiCache for Redis for RDS
  5. Lin878 👍 1 Answered D
    I confuse, Is DAX working with RDS?
  6. FZA24 👍 2 Answered D
    D looks correct
  7. Andy_09 👍 2
    Looks correct

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

S3 Multi-Region Access Point and Replication Strategy

S-grade

Securing NLB with Security Groups for Minimal Change

S-grade

Most Cost-Effective 7-Year Retention for EBS Snapshots?

S-grade

AWS Forecast vs SageMaker for Time-Series Prediction

S-grade

Practice All SAA-C03 Questions

Access 120 questions with complete answers and detailed explanations.

View Full SAA-C03 Practice Test →

← Back to SAA-C03 Study Guide