Answer-first summary for fast verification
Answer: 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
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 Amazon RDS uses the PostgreSQL DB engine's built-in replication functionality to create a special type of DB instance called a read replica from a source DB instance. The source DB instance becomes the primary DB instance. Updates made to the primary DB instance are asynchronously copied to the read replica. You can reduce the load on your primary DB instance by routing read queries from your applications to the read replica. Using read replicas, you can elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. For the given use case, you can achieve optimum read performance for SQL queries by using the read-replica endpoint for the read-heavy workload.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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?
A
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
B
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
C
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
D
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