AWS Certified Data Engineer Associate DEA-C01 Practice Question
An online retailer is migrating a 100-GB MySQL OLTP database to AWS. Read traffic can spike 20x for a few hours during flash sales, then falls below 10% most of the day. The team requires sub-50 ms latency and wants to minimize cost by avoiding over-provisioning. Which Amazon RDS configuration best meets these needs?
Amazon Aurora MySQL provisioned cluster with one writer and two Aurora Replicas sized for flash-sale traffic.
Amazon Aurora Serverless v2 (MySQL-compatible) cluster with a minimum and maximum Aurora Capacity Unit range.
Amazon RDS for MySQL primary instance with read replicas that are added or removed by an Auto Scaling policy.
Amazon RDS for MySQL Multi-AZ deployment with Provisioned IOPS storage sized for peak demand.
Aurora Serverless v2 automatically and quickly adjusts capacity in fine-grained increments, so the cluster can scale up during flash-sale spikes and scale back down when demand subsides. It keeps six copies of data across three Availability Zones, giving Multi-AZ availability without an additional standby instance, and is billed per second for the resources actually consumed. A provisioned Aurora cluster or a Multi-AZ RDS for MySQL deployment must be sized for peak load and incurs fixed instance charges even when demand is low. Standard RDS for MySQL read replicas do not scale automatically as quickly and still require provisioning for peak, so they do not meet the cost-optimization and rapid-scaling goals as effectively.
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 Amazon Aurora Serverless v2?
Open an interactive chat with Bash
What are Aurora Capacity Units (ACUs) used in Aurora Serverless v2?
Open an interactive chat with Bash
Why does Aurora Serverless v2 eliminate the need for over-provisioning?
Open an interactive chat with Bash
AWS Certified Data Engineer Associate DEA-C01
Data Store Management
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 $11.99
$11.99/mo
Billed monthly, Cancel any time.
$19.99 after promotion ends
3 Month Pass
$44.99 $26.99
$8.99/mo
One time purchase of $26.99, Does not auto-renew.
$44.99 after promotion ends
Save $18!
MOST POPULAR
Annual Pass
$119.99 $71.99
$5.99/mo
One time purchase of $71.99, Does not auto-renew.
$119.99 after promotion ends
Save $48!
BEST DEAL
Lifetime Pass
$189.99 $113.99
One time purchase, Good for life.
Save $76!
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .