Q43 — AWS SAA-C03 Ch.13

Question 43 of 100 | ← Chapter 13

Q943. An application gives a company's users the ability to access product data. The product data is stored on an Amazon RDS for MySQL DB instance. The company has isolated an application performance slowdown and wants to separate read traffic from write traffic.A solutions architect needs to optimize the application's performance quickly.Which solution will meet these requirements with the LEAST operational overhead?

• A. Create a new DB instance to serve read traffic. Use an Elastic Load Balancing (ELB) load balancer to distribute traffic between DB instances.
• B. Change the existing database configuration to a Multi-AZ DB instance deployment with one replica.Serve the read requests from the standby DB instance.
• C. Create a new DB instance to serve read traffic. Use AWS Database Migration Service (AWS DMS) to synchronize data between the DB instances.
• D. Create read replicas for the DB instance. Configure the read replicas with the same compute and storage resources as the source DB instance. ✓

Correct Answer: D. Create read replicas for the DB instance. Configure the read replicas with the same compute and storage resources as the source DB instance.

Explanation

The solution that meets the requirements with the LEAST operational overhead is:D. Create read replicas for the DB instance. Configure the read replicas with the same compute and storage resources as the source DB instance.Here's why:Minimal Configuration: Creating read replicas is a straightforward process within the RDS console. You don't need to create separate DB instances or manage complex configurations.Automatic Synchronization: Read replicas are automatically synchronized with the primary DB instance, ensuring data consistency.Read-Only Access: Read replicas are designed for read-only operations, allowing you to offload read traffic from the primary instance without impacting write operations.