Which actions should a solutions architect take to resolve these performance issues?
(Choose two.)
Turn on auto scaling for the DB instance.
Create a read replica for the DB instance. Configure the application to send read traffic to the read replica.
Convert the DB instance to a Multi-AZ DB instance deployment. Configure the application to send read traffic to the standby DB instance.
Create an Amazon ElastiCache cluster. Configure the application to cache query results in the ElastiCache cluster.
Configure the Auto Scaling group subnets to ensure that the EC2 instances are provisioned in the same Availability Zone as the DB instance.
Explanations:
Auto scaling for the DB instance only adjusts the compute capacity, but it doesn’t help in reducing the read load or improve performance for high read traffic.
Creating a read replica offloads read traffic from the primary DB instance, improving performance during high traffic periods by distributing the read load.
Converting to a Multi-AZ DB instance helps with failover and availability, but it does not provide a way to offload read traffic, as the standby is only for failover.
Using Amazon ElastiCache to cache query results reduces the load on the database by storing frequently accessed data in memory, improving application performance.
The placement of EC2 instances in the same Availability Zone as the DB instance does not impact database performance. EC2 instances should be distributed across AZs for high availability.
I estimate that the answer is:
Create a read replica for the DB instance. Configure the application to send read traffic to the read replica.
If I had to guess, I’d say the answer is:
Create a read replica for the DB instance. Configure the application to send read traffic to the read replica.