SOA-C03 · Question #122
A company's reporting job that used to run in 15 minutes is now taking an hour to run. An application generates the reports. The application runs on Amazon EC2 instances and extracts data from an Amaz
The correct answer is B. Deploy an RDS read replica. Update the reporting job to query the reader endpoint.. A read replica offloads read traffic from the primary RDS instance to a separate replica, improving both performance (by reducing read load and IOPS on the primary) and availability (the replica can also be promoted in a failure scenario). Pointing the reporting job to the reader
Question
A company’s reporting job that used to run in 15 minutes is now taking an hour to run. An application generates the reports. The application runs on Amazon EC2 instances and extracts data from an Amazon RDS for MySQL database. A CloudOps engineer checks the Amazon CloudWatch dashboard for the RDS instance and notices that the Read IOPS metrics are high, even when the reports are not running. The CloudOps engineer needs to improve the performance and the availability of the RDS instance. Which solution will meet these requirements?
Options
- AConfigure an Amazon ElastiCache cluster in front of the RDS instance. Update the reporting job
- BDeploy an RDS read replica. Update the reporting job to query the reader endpoint.
- CCreate an Amazon CloudFront distribution. Set the RDS instance as the origin. Update the
- DIncrease the size of the RDS instance.
How the community answered
(46 responses)- A11% (5)
- B83% (38)
- C2% (1)
- D4% (2)
Explanation
A read replica offloads read traffic from the primary RDS instance to a separate replica, improving both performance (by reducing read load and IOPS on the primary) and availability (the replica can also be promoted in a failure scenario). Pointing the reporting job to the reader endpoint ensures that heavy reporting reads no longer compete with the primary’s transactional workload, reducing query latency and speeding up the reports.
Topics
Community Discussion
No community discussion yet for this question.