SAP-C02 Continuous Improvement for Existing Solutions Practice Question

Correct answer & explanation

To implement the solution of offloading read traffic using an RDS read replica, three steps are necessary. First, create a read replica from the source DB instance (option B), which provides a separate read-only copy of the database. Second, modify the application to send read-only queries to the read replica endpoint (option C); otherwise, the replica won't be utilized. Third, configure the read replica to be in a different Availability Zone for high availability (option E). While not strictly required for basic read offloading, this step enhances fault tolerance and is considered a necessary part of the solution to ensure high availability of the read replica. Option A is incorrect because placing the read replica in the same AZ does not provide high availability and is not a necessary step. Option D is incorrect because Multi-AZ is a feature for the primary instance, not for read replicas, and enabling it on a read replica is not supported.