Answer-first summary for fast verification
Answer: Migrate the PostgreSQL database to Amazon Aurora Serverless v2.
## Explanation **Correct Answer: A - Migrate the PostgreSQL database to Amazon Aurora Serverless v2.** **Why this is the most cost-effective solution:** 1. **Serverless Architecture**: Amazon Aurora Serverless v2 automatically scales database capacity up and down based on actual workload demands. It can scale to hundreds of thousands of transactions per second in fractions of a second. 2. **Cost Optimization**: With unpredictable traffic patterns, Aurora Serverless v2 only charges for the database capacity actually consumed, measured in Aurora Capacity Units (ACUs). This is much more cost-effective than: - Option B: Auto-scaling EC2 instances still requires paying for provisioned capacity even when not fully utilized - Option C: Larger RDS instance types mean paying for peak capacity 24/7 - Option D: Amazon Redshift is a data warehousing solution, not suitable for transactional ecommerce workloads 3. **Performance Maintenance**: Aurora Serverless v2 can handle sudden traffic spikes automatically without manual intervention, ensuring performance during unpredictable monthly sales events. 4. **PostgreSQL Compatibility**: Aurora Serverless v2 is PostgreSQL compatible, so migration is straightforward. **Why other options are not optimal:** - **Option B**: While auto-scaling EC2 instances can help, it's less efficient than serverless scaling and requires more management overhead. - **Option C**: Using a larger RDS instance type means over-provisioning and paying for capacity that's only needed during peak events. - **Option D**: Amazon Redshift is designed for analytical workloads, not transactional ecommerce applications. It would require significant architectural changes and wouldn't solve the connection issues effectively. **Key AWS Concepts:** - **Aurora Serverless v2**: Provides automatic scaling with pay-per-use pricing - **Cost Optimization**: Right-sizing resources and using serverless architectures for unpredictable workloads - **Database Performance**: Maintaining performance during traffic spikes without over-provisioning
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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?
A
Migrate the PostgreSQL database to Amazon Aurora Serverless v2.
B
Enable auto scaling for the PostgreSQL database on the EC2 instance to accommodate increased usage.
C
Migrate the PostgreSQL database to Amazon RDS for PostgreSQL with a larger instance type.
D
Migrate the PostgreSQL database to Amazon Redshift to accommodate increased usage.