Exam AWS Certified Solutions Architect - Professional SAP-C02 topic 1 question 105 discussion

B. Performing a one-time migration of the database cluster to Amazon RDS, and creating several additional read replicas to handle the load during end of month. This is the optimal solution as migrating the database to Amazon RDS will provide the ability to easily scale read replicas for handling increased read traffic during the end of the month. Additionally, RDS will manage the underlying infrastructure and provide automatic backups, software patching, and monitoring, which will reduce the operational overhead for the company. Option A may help but it will not be sufficient to handle the heavy load, option C and D are not efficient solutions to han

B. Performing a one-time migration of the database cluster to Amazon RDS, and creating several additional read replicas to handle the load during end of month.

B, include read replicas

Option B -> Reporting workload = higher read operation ==> Solution RDS read replica.

I go with D

I vote D To solve heavy IO issue, I think both option B and D both works.But the question demands for to "handle the month-end load with the LEAST impact on performance" , Option B create the new read replicas during end of month seems too complicated, you'll need to seperate read/write traffic from application at the end of the month.

Reporting is also an important hint. Only read operations are needed here; so read replicas would server the purpose

all other sections not applicable i guess specially D its so funny. Each month none of technical person doesnt want to do like this task.

B of cpourse

it slows down during the final three days of each month due to month-end reporting then hight read in database == solution add read replicas B

Performing a one-time migration

B is the best solution