Q49Design Cost-Optimized Architectures
An ecommerce application uses a PostgreSQL database that runs on an Amazon EC2 instance. During a monthly sales event, database usage increases and causes database connection issues for the application. Traffic is unpredictable for future monthly sales events, which affects the sales forecast. The company needs to maintain performance when traffic increases unpredictably. Which solution resolves this issue in the **MOST cost-effective** way?
← → navigate · a answer
Community votes
Discussion · 9
A 8
Answer is A.
Aurora Serverless v2 got autoscaling, highly available and cheaper when compared to the other options.
4
C is more expensive if you think the scenario where the traffic is low. You are paying for a larger hardware but not using it. That's why I think A is correct.
A 3
Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Aurora where the database automatically starts up, shuts down, and scales capacity up or down based on your application's needs. This is the least costly option for unpredictable traffic.
A 3
A to autoscaling
A 3
Not B - we can auto-scale the EC2 instance, but not "the [self-managed] PostgreSQL database ON the EC2 instance"
Not C - This does not mention scaling, so it would incur high cost and still it might not be able to keep up with the "unpredictable" spikes
Not D - Redshift is OLAP Data Warehouse
3
A: "he traffic is unpredictable for subsequent monthly sales events" --> serverless
A 2
The correct answer is A
2
Answer is A.
Aurora Serverless v2 got autoscaling, highly available and cheaper when compared to the other options.
C 1
A is probably more expensive than C. Aurora is serverless and fast. But nevertheless it needs DB migration service. Not sure DMS may not be free.