SAA-C03 · Question #804
A company uses a general-purpose instance class Amazon RDS for MySQL DB instance. The company has configured the DB instance in a Multi-AZ configuration across two Availability Zones as part of the…
The correct answer is C. Add an RDS read replica. Update the reporting job to query the replica endpoint. Adding an RDS read replica offloads read-heavy workloads, such as reporting queries, from the primary DB instance. The reporting job can query the read replica, minimizing performance impact on the production application while maintaining data consistency.
Question
A company uses a general-purpose instance class Amazon RDS for MySQL DB instance. The company has configured the DB instance in a Multi-AZ configuration across two Availability Zones as part of the company’s production application. The company’s finance team needs to run SQL queries against the DB instance to generate reports. Customers have reported significant performance issues with the application during report generation. A solutions architect needs to minimize the effect of the reporting job on the DB instance. Which solution will meet these requirements?
Options
- ACreate a proxy in Amazon RDS Proxy. Update the reporting job to query the proxy endpoint.
- BUpdate the RDS DB instance configuration to use three Availability Zones.
- CAdd an RDS read replica. Update the reporting job to query the replica endpoint.
- DChange the RDS configuration from a general-purpose instance class to a memory-optimized
How the community answered
(42 responses)- A10% (4)
- B17% (7)
- C71% (30)
- D2% (1)
Explanation
Adding an RDS read replica offloads read-heavy workloads, such as reporting queries, from the primary DB instance. The reporting job can query the read replica, minimizing performance impact on the production application while maintaining data consistency.
Community Discussion
No community discussion yet for this question.