Question 571 · 1017 in bank
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. The traffic is unpredictable for subsequent monthly sales events, which impacts the sales forecast. The company needs to maintain performance when there is an unpredictable increase in traffic. Which solution resolves this issue in the MOST cost-effective way?
Show answer
Answer: A
Explanation
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
Source: Adapted from community discussion — pentium75