AWS Certified Database – Specialty — Question 87

A company is running an on-premises application comprised of a web tier, an application tier, and a MySQL database tier. The database is used primarily during business hours with random activity peaks throughout the day. A database specialist needs to improve the availability and reduce the cost of the MySQL database tier as part of the company's migration to AWS.
Which MySQL database option would meet these requirements?

Answer options

• A. Amazon RDS for MySQL with Multi-AZ
• B. Amazon Aurora Serverless MySQL cluster
• C. Amazon Aurora MySQL cluster
• D. Amazon RDS for MySQL with read replica

Correct answer: B

Explanation

The correct answer is B, Amazon Aurora Serverless MySQL cluster, as it automatically adjusts capacity based on demand, making it cost-effective for variable workloads. Option A, Amazon RDS for MySQL with Multi-AZ, provides high availability but does not optimize costs for fluctuating usage. Option C, Amazon Aurora MySQL cluster, offers high performance but may not be as cost-efficient as the serverless option for sporadic workloads. Option D, Amazon RDS for MySQL with read replica, enhances read performance but does not address availability and cost for the primary database.