You are doing a load testing exercise on your application hosted on AWS. While testing your Amazon RDS MySQL DB instance, you notice that when you hit 100% CPU utilization on it, your application becomes non- responsive. Your application is read-heavy. What are methods to scale your data tier to meet the application's needs? (Choose three.)
A) Add Amazon RDS DB read replicas, and have your application direct read queries to them.
B) Add your Amazon RDS DB instance to an Auto Scaling group and configure your CloudWatch metric based on CPU utilization.
C) Use an Amazon SQS queue to throttle data going to the Amazon RDS DB instance.
D) Use ElastiCache in front of your Amazon RDS DB to cache common queries.
E) Shard your data set among multiple Amazon RDS DB instances.
F) Enable Multi-AZ for your Amazon RDS DB instance.

Question

Quizplus · Accepted Answer

Adding read replicas can distribute the read load, ElastiCache can cache frequent queries reducing database load, and sharding can distribute data across multiple instances to handle more requests.

You Are Doing a Load Testing Exercise on Your Application