AWS Certified Database – Specialty — Question 70

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?

Answer options

• A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
• B. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
• C. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
• D. Change the DB clusters to the burstable instance family.

Correct answer: A

Explanation

Creating new Aurora Serverless DB clusters allows the company to handle unpredictable workloads efficiently without major rework, as these clusters automatically scale based on demand. Upgrading to a larger DB cluster (option B) may not effectively manage variable loads and can incur higher costs. Using existing DB clusters and stopping/starting them (option C) does not address latency spikes effectively. Changing to burstable instances (option D) might not provide the necessary performance during peak usage times.