AWS Certified CloudOps Engineer Associate SOA-C03 Practice Question
A company hosts a MySQL 5.7 database on Amazon RDS. Most queries are reads, and unpredictable marketing campaigns cause brief 10-fold read-traffic spikes several times per month. Management wants the database layer to scale automatically for these events and release capacity afterward to control cost. They must avoid application changes and keep write latency unchanged. What is the MOST cost-effective solution?
Convert the RDS instance to a Multi-AZ deployment to automatically provision additional compute capacity during traffic spikes.
Enable Amazon RDS storage autoscaling on the existing MySQL instance and set the maximum storage size to cover peak demand.
Launch multiple MySQL read replicas behind an RDS Proxy during campaigns and manually delete the replicas when traffic subsides.
Migrate the database to Amazon Aurora MySQL and configure Aurora Auto Scaling to add or remove Aurora Replicas in the cluster based on average CPU utilization.
Aurora Auto Scaling can add or remove Aurora Replicas in an Aurora MySQL DB cluster based on CloudWatch metrics through Application Auto Scaling. Because Aurora uses a shared storage volume, adding replicas is quick and does not affect write performance on the primary instance. Migrating from Amazon RDS for MySQL to Aurora MySQL typically requires little or no application modification, so the requirement to avoid code changes is met.
Storage Auto Scaling only increases disk capacity and does not address read throughput. Creating and deleting MySQL read replicas manually is neither automatic nor operationally efficient. Converting to a Multi-AZ deployment improves availability but does not provide additional read capacity or elastic scaling. Therefore, migrating to Aurora MySQL with Aurora Auto Scaling is the most cost-effective way to meet the stated requirements.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Aurora Auto Scaling?
Open an interactive chat with Bash
How does Aurora differ from RDS MySQL in scalability?
Open an interactive chat with Bash
What is CloudWatch and how does it relate to Aurora Auto Scaling?
Open an interactive chat with Bash
AWS Certified CloudOps Engineer Associate SOA-C03
Reliability and Business Continuity
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .