A retail company is in the process of migrating its on-premises database to Amazon RDS for PostgreSQL. The company experiences heavy read workloads and the development team is exploring ways to refactor the existing code to achieve optimal read performance for SQL queries. They aim to minimize both the current and future development effort required.

Which solution will best meet this requirement while ensuring the least amount of current and future development effort?

Exam-Like

Set up Amazon RDS in the multi-AZ configuration with a single standby instance. Refactor the application code so that the queries use the standby instance endpoint

10.6%

Configure Elasticache for Redis to act as a caching layer for Amazon RDS. Refactor the application code so that the queries use the Elasticache for Redis endpoint

17.0%

Set up Amazon RDS with one or more read replicas. Refactor the application code so that the queries use the endpoint for the read replicas

55.3%

Configure Elasticache for Memcached to act as a caching layer for Amazon RDS. Refactor the application code so that the queries use the Elasticache for Memcached endpoint

17.0%

AWS Certified Developer - Associate

Get started today

Comments