Question #959
A company wants to migrate its MySQL database to AWS. The company's database usage is sporadic and unpredictable.
MySQL on Amazon EC2
Amazon RDS for MySQL
Amazon Aurora MySQL-Compatible Edition
Amazon Aurora Serverless (MySQL-Compatible)
Explanation
The correct answer is D: Amazon Aurora Serverless (MySQL-Compatible).
Why D is Correct:
- Automatic Scaling: Aurora Serverless automatically adjusts database capacity based on application demand, making it ideal for sporadic and unpredictable workloads. It scales compute and memory resources seamlessly, eliminating the need for manual provisioning.
- Cost-Efficiency: You only pay for the database resources consumed during active periods, avoiding costs associated with over-provisioning.
- Managed Service: AWS handles maintenance, backups, and patching, reducing operational overhead.
Why Others Are Incorrect:
- A (MySQL on EC2): Requires manual scaling and management of EC2 instances, which is impractical for unpredictable workloads.
- B (RDS for MySQL): Uses provisioned instances, requiring manual scaling adjustments, leading to potential over/under-provisioning.
- C (Aurora MySQL): While scalable, it relies on fixed-capacity instances unless paired with Serverless, which is explicitly offered in option D.
Key Points:
- Aurora Serverless is designed for variable workloads.
- Eliminates manual scaling and reduces costs for unpredictable usage patterns.
- Fully managed, unlike EC2 or standard RDS/Aurora.
Answer
The correct answer is: D