As an AWS Solutions Architect, you are designing a new Java application in EC2 with a relational database deployed in RDS. During proof of concept, it has been found that the database encounters an extended number of write operations at certain times and cannot handle the load. Which of the following options is appropriate to improve the write performance?

Answer options:

A.Add a read replica to the RDS DB instance.
B.Replace AWS RDS with DynamoDB.C.Use SQS to queue the database writes.
D.Use SNS to send notification for the missed database writes and then add them manually at a later stage.

Correct Answer – C
SQS Queues can be used to cache the pending database writes so that the database can handle the load properly.
For more information on AWS SQS, please refer to the URL below:
https://aws.amazon.com/sqs/faqs/
Option A is incorrect because read replica cannot help on the write requests.
Option B is incorrect because DynamoDB is non-relational however the application needs a relational database.
Option D is incorrect because adding the missed write operation back manually is not a suitable approach.