A company is migrating its on-premises database to Amazon RDS for MySQL. The company has read-heavy workloads, and wants to make sure it re-factors its code to achieve optimum read performance for its queries. How can this objective be met?
A.
Add database retries to effectively use RDS with vertical scaling.
B.
Use RDS with multi-AZ deployment.
C.
Add a connection string to use an RDS read replica for read queries.
D.
Add a connection string to use a read replica on an EC2 instance.
I found the reasoning:
Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. Source: https://aws.amazon.com/rds/features/read-replicas/?nc1=h_ls
The best way to refactor the client code is to insert pointers to Read Replica databases in order to not overload the main database in case we need to query the database. The correct answer is C
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
YashBindlish
Highly Voted 3 years, 7 months agojavibq92
3 years, 4 months agoawscertified
Highly Voted 3 years, 6 months agosumanshu
Most Recent 4 months, 1 week agorushi0611
1 year, 9 months agorcaliandro
1 year, 10 months agoKT_Yu
2 years, 3 months agosichilam
2 years, 3 months agohaazybanj
2 years, 6 months agostatsu26
3 years agoVAG1595
3 years, 5 months agowils3
3 years, 5 months agoVishaka1995
3 years, 6 months agocodeScalable
3 years, 6 months agosaeidp
3 years, 6 months agoipindado2020
3 years, 6 months agowackyGuru
3 years, 6 months agoMannyC
3 years, 6 months ago