SAA-C03 Exam - Question 730

Question

A package delivery company has an application that uses Amazon EC2 instances and an Amazon Aurora MySQL DB cluster. As the application becomes more popular, EC2 instance usage increases only slightly. DB cluster usage increases at a much faster rate.

The company adds a read replica, which reduces the DB cluster usage for a short period of time. However, the load continues to increase. The operations that cause the increase in DB cluster usage are all repeated read statements that are related to delivery details. The company needs to alleviate the effect of repeated reads on the DB cluster.

Which solution will meet these requirements MOST cost-effectively?

Examice · Accepted Answer

As the application experiences a high volume of repeated read statements related to delivery details, implementing an Amazon ElastiCache for Redis cluster is the most cost-effective solution. This approach would efficiently cache the repeated read results, thereby alleviating the load on the main DB cluster without incurring the additional costs associated with multiple read replicas or auto-scaling. A cache layer like Redis improves read performance and reduces the demand on the database, meeting the requirements most cost-effectively.

Andy_09 · Answer

Option A

BillaRanga · Answer

The question says, "The operations that cause the increase in DB cluster usage are all **repeated read statements** that are related to delivery details." - Read statements mean we can cache the results - hence, we need No read-replicas; we need only a cache layer to improve the performance..   Also, Adding read replicas costs money. The requirement is to meet them MOST cost-effectively

Kezuko · Answer

"repeated read statements" -> Cache layer

sandordini · Answer

A. Although Redis is not typically cheap, the question statement clearly shouts for a cached solution, which is Redis... Also, that's the only long-term solution, as we don't know anything about the volumes, scale of trends, etc...

Scheldon · Answer

AnswerA

Scheldon · Answer

AnswerC

After topic reconsideration I will go with Aurora autoscaling

To meet your connectivity and workload requirements, Aurora Auto Scaling dynamically adjusts the number of Aurora Replicas (reader DB instances) provisioned for an Aurora DB cluster. Aurora Auto Scaling is available for both Aurora MySQL and Aurora PostgreSQL. Aurora Auto Scaling enables your Aurora DB cluster to handle sudden increases in connectivity or workload. When the connectivity or workload decreases, Aurora Auto Scaling removes unnecessary Aurora Replicas so that you don't pay for unused provisioned DB instances.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html

SAA-C03 Exam - Question 730

Discussion