Answer – C
This question asks for an option that can be used to reduce the load on the DynamoDB database. The option has to be scalable.
In such a scenario, the best option to use is SQS, because it is scalable and cost-efficient as well.
Option A is incorrect because adding more databases will not reduce the load on the existing DynamoDB database. Also, this is not a cost-efficient solution.
Option B is incorrect because increasing the write capacity is an expensive option.
Option C is CORRECT because it uses SQS to assist in taking over the load from storing the data in DynamoDB, and it is scalable and cost-efficient.
Option D is incorrect because the MultiAZ configuration is not going to help reduce the load. In fact, it will affect the performance as the records in DynamoDB would get replicated in multiple availability zones.
More information on SQS:
When the idea comes for scalability, then SQS is the best option. Normally DynamoDB is scalable, but since one is looking for a cost-effective solution, the messaging in SQS can help manage the situation mentioned in the question.
Amazon Simple Queue Service (SQS) is a fully-managed message queuing service for reliably communicating among distributed software components and microservices - at any scale. Building applications from individual components that perform a discrete function improves scalability and reliability and is the best practice design for modern applications. SQS makes it simple and cost-effective to decouple and coordinate the components of a cloud application. Using SQS, you can send, store, and receive messages between software components at any volume, without losing messages or requiring other services to be always available.
For more information on SQS, please refer to the below URL-
https://aws.amazon.com/sqs/