Which service should a solutions architect use to meet these requirements?

By:
On:
In: SAA-C02
Tagged:
With: 0 Comments
A company’s order fulfillment service uses a MySQL database.The database needs to support a large number of concurrent queries and transactions.Developers are spending time patching and tuning the database.This is causing delays in releasing new product features.The company wants to use cloud-based services to help address this new challenge.The solution must allow the developers to migrate the database with little or no code changes and must optimize performance.

Which service should a solutions architect use to meet these requirements?

Amazon Aurora

Amazon DynamoDB

Amazon ElastiCache

MySQL on Amazon EC2

Explanations:

Amazon Aurora is a MySQL-compatible relational database service that offers high performance and scalability. It is designed to handle a large number of concurrent queries and transactions, and it supports migration with minimal code changes. Additionally, it provides built-in optimizations for performance and availability.

Amazon DynamoDB is a NoSQL database service. Migrating from MySQL to DynamoDB would require significant code changes due to differences in data modeling and query capabilities. It may not be suitable for applications heavily reliant on SQL features.

Amazon ElastiCache is a caching service, not a database. While it can improve performance by caching frequently accessed data, it does not serve as a replacement for a MySQL database and does not support the required SQL features or concurrent transactions.

MySQL on Amazon EC2 would require managing the underlying infrastructure, including patching and tuning. This does not align with the goal of reducing operational overhead and optimizing performance through a managed service.

Leave a Reply

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

5 − 3 =