Which service would alleviate the database load issue and offer virtually unlimited scalability for the future?

By:
On:
In: SAA-C02
Tagged:
With: 0 Comments
A user owns a MySQL database that is accessed by various clients who expect, at most, 100 ms latency on requests.Once a record is stored in the database, it is rarely changed.Clients only access one record at a time.Database access has been increasing exponentially due to increased client demand.The resultant load will soon exceed the capacity of the most expensive hardware available for purchase.The user wants to migrate to AWS, and is willing to change database systems.

Which service would alleviate the database load issue and offer virtually unlimited scalability for the future?

Amazon RDS

Amazon DynamoDB

Amazon Redshift

AWS Data Pipeline

Explanations:

Amazon RDS is a managed relational database service, but it is still bound by the underlying hardware limits, and it does not provide the level of scalability required for exponential growth in the user’s case.

Amazon DynamoDB is a fully managed NoSQL database designed for low-latency, high-throughput workloads. It can scale virtually infinitely and would handle the increasing load effectively.

Amazon Redshift is a data warehouse service, optimized for complex queries and analytics, not for real-time transactional workloads with low-latency access.

AWS Data Pipeline is a service for moving and transforming data between AWS services, not a database. It does not address the need for high-performance, low-latency database access.

Leave a Reply

Your email address will not be published. Required fields are marked *

9 + 4 =