Q62 — AWS SAA-C03 Ch.11

Question 62 of 100 | ← Chapter 11

Q762. A company runs a web application on Amazon EC2 instances in an Auto Scaling group. The application uses a database that runs on an Amazon RDS for PostgreSQL DB instance. The application performs slowly when traffic increases. The database experiences a heavy read load during periods of high traffic.Which actions should a solutions architect take to resolve these performance issues? (Choose two.)

Correct Answer: B. Create a read replica for the DB instance. Configure the application to send read traffic to the read replica., D. Create an Amazon ElastiCache cluster. Configure the application to cache query results in the ElastiCache cluster.

Explanation

To resolve the performance issues in the given scenario, the following two actions should be taken:B. Create a read replica for the DB instance. Configure the application to send read traffic to the read replica.D. Create an Amazon ElastiCache cluster. Configure the application to cache query results in the ElastiCache cluster.Action B: Create a read replica for the DB instance. Configure the application to send read traffic to the read replica:By creating a read replica for the Amazon RDS for PostgreSQL DB instance, you can offload the heavy read load from the primary DB instance to the replica. This helps improve the application's performance during periods of high traffic. By configuring the application to send read traffic to the read replica, you ensure that the replica handles the read operations while the primary DB instance can focus on write operations.Action D: Create an Amazon ElastiCache cluster. Configure the application to cache query results in the ElastiCache cluster:By creating an Amazon ElastiCache cluster, you can leverage an in-memory cache to store frequently accessed or computationally expensive query results. By configuring the application to cache query results in the ElastiCache cluster, you reduce the need for repeated database queries, which improves the application's performance by reducing the load on the database.Here's why the other options are not the most suitable choices:Option A: Turning on auto scaling for the DB instance does not directly address the performance issues related to heavy read load. Auto scaling helps with scaling the number of instances based on demand, but in this case, the focus should be on offloading read operations to a read replica.Option C: Converting the DB instance to a Multi-AZ deployment and sending read traffic to the standby DB instance does provide high availability and failover capabilities but does not directly address the performance issues. The standby instance is intended for failover rather than offloading read operations.Option E: Configuring the Auto Scaling group subnets to ensure the EC2 instances are provisioned in the same Availability Zone as the DB instance may improve network latency but does not directly address the heavy read load issue. The primary concern here is offloading the read operations to a read replica and leveraging caching.Therefore, the most appropriate actions to resolve the performance issues in the given scenario are B: Create a read replica for the DB instance. Configure the application to send read traffic to the read replica, and D: Create an Amazon ElastiCache cluster. Configure the application to cache query results in the ElastiCache cluster.