AWS Certified Solutions Architect – Associate (SAA-C03)Design High-Performing ArchitecturesMedium
A startup is launching a new mobile application that expects rapid, unpredictable growth in user traffic. The application uses a relational database. The database must be highly available, automatically scale its compute and storage capacity without downtime, and only incur costs for the resources consumed. Which AWS database service meets these requirements?
- AAmazon RDS for MySQL with Multi-AZ
- BAmazon DynamoDB
- CAmazon Redshift Serverless
- DAmazon Aurora Serverless v2
Show answer & explanationAnswer & explanation
Correct answer: D. Amazon Aurora Serverless v2
Amazon Aurora Serverless v2 is designed for unpredictable, spiky workloads. It automatically scales compute and memory capacity in fine-grained increments, providing capacity exactly when needed, and scales down to zero when not in use (for v1), offering cost-effectiveness and high availability for relational databases without requiring manual provisioning or management.
Why the other options are wrong
- A. Amazon RDS for MySQL with Multi-AZ provides high availability but requires manual scaling of compute capacity and doesn't scale storage automatically in the same serverless manner.
- B. Amazon DynamoDB is a NoSQL database, not relational, and while it scales automatically, it doesn't fit the 'relational database' requirement.
- C. Amazon Redshift Serverless is a data warehousing solution, not a transactional relational database for operational applications.
Amazon Aurora Serverless v2
An on-demand, auto-scaling configuration for Amazon Aurora that automatically adjusts compute capacity for highly variable or unpredictable workloads.
- Scales compute and memory instantly and granularly.
- Pay-per-second for active usage.
- Maintains high availability and durability of Aurora.
Memory trick: Aurora serverless for relational growth, scale with grace.