SAA-C03 Q674 · Database

Question

A company has a web application with sporadic usage patterns. Usage is heavy at the beginning of each month, moderate weekly, and unpredictable during the week. The application uses a MySQL database and must move to AWS without database modifications. Which solution will meet these requirements?

Accepted Answer

MySQL-compatible Amazon Aurora Serverless (C) is the best solution because it satisfies every requirement:

1. **MySQL compatibility without modifications**: Aurora Serverless is MySQL-compatible (and PostgreSQL-compatible). The application can connect to it using standard MySQL drivers and protocols — no code or schema changes needed.

2. **Sporadic and unpredictable usage patterns**: This is the killer requirement. Aurora Serverless automatically scales capacity up and down based on actual database load. It can even **scale to zero** (in Serverless v1) or scale down to a very small capacity (in Serverless v2) during periods of no activity. This perfectly matches the described pattern: heavy at month start → moderate weekly → unpredictable intra-week.

3. **Cost efficiency**: You pay only

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🔒 Security

🎯 Exam Tips