SAA-C03 · Question #83
A company uses Amazon RDS for PostgreSQL to run its applications in the us-east-1 Region. The company also uses machine learning (ML) models to forecast annual revenue based on neat real-time reports.
The correct answer is D. Create a read replica in us-east-1. Configure the reports to be generated from the read replica.. To improve the performance of the primary RDS PostgreSQL database during business hours and reduce the load, the best solution is to create aread replicain the same region (us-east-1). This will offload the read-heavy operations (like generating reports) to the replica, reducing
Question
A company uses Amazon RDS for PostgreSQL to run its applications in the us-east-1 Region. The company also uses machine learning (ML) models to forecast annual revenue based on neat real-time reports. The reports are generated by using the same RDS for PostgreSQL database. The database performance slows during business hours. The company needs to improve database performance. Which solution will meet these requirements MOST cost-effectively?
Options
- ACreate a cross-Region read replica. Configure the reports to be generated from the read replica.
- BActivate Multi-AZ DB instance deployment for RDS for PostgreSQL. Configure the reports to be
- CUse AWS Data Migration Service (AWS DMS) to logically replicate data lo a new database.
- DCreate a read replica in us-east-1. Configure the reports to be generated from the read replica.
How the community answered
(28 responses)- B4% (1)
- C7% (2)
- D89% (25)
Explanation
To improve the performance of the primary RDS PostgreSQL database during business hours and reduce the load, the best solution is to create aread replicain the same region (us-east-1). This will offload the read-heavy operations (like generating reports) to the replica, reducing the burden on the primary instance, which improves overall performance. Additionally, read replicas provide near real- time replication, making them ideal for real-time reporting use cases. Option A (cross-Region read replica): This adds unnecessary latency for real-time reporting and increased costs due to cross-region data transfer. Option B (Multi-AZ): Multi-AZ deployments are for high availability and disaster recovery but won't offload the read traffic, as the standby database cannot serve read requests. Option C (AWS DMS replication): This adds complexity and is not as cost-effective as using an RDS read replica for the same region.
Community Discussion
No community discussion yet for this question.