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?
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.

Question

Quizplus · Accepted Answer

The burstable instance family is designed for workloads that experience unpredictable and varying demands, and can handle momentary spikes in latency. It provides the flexibility to burst CPU and memory usage beyond the base capacity for short periods of time, without incurring additional charges. This makes it a cost-effective solution for workloads that do not require consistent high performance, such as development and reporting.

A Software Development Company Is Using Amazon Aurora MySQL DB