Q18 — AWS SAA-C03 Ch.11

Question 18 of 100 | ← Chapter 11

Q718. 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?

Correct Answer: A. Migrate the PostgreSQL database to Amazon Aurora Serverless v2.

Explanation

To resolve the issue of database connection issues and maintain performance during unpredictable increases in traffic for an ecommerce application using a PostgreSQL database running on an Amazon EC2 instance, the most cost-effective solution is:A. Migrate the PostgreSQL database to Amazon Aurora Serverless v2.Option A provides a cost-effective solution that addresses the issue:- Migrate to Amazon Aurora Serverless v2: Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora that automatically adjusts the database capacity based on application workload. Aurora Serverless v2 introduces enhancements such as instant scaling, faster scaling, and pause/resume capabilities, making it a suitable choice for handling unpredictable increases in traffic.By migrating the PostgreSQL database to Aurora Serverless v2, the database capacity will automatically scale up or down based on the workload, ensuring that performance is maintained during peak traffic periods without the need for manual intervention. This eliminates the database connection issues and provides a cost-effective way to handle varying traffic patterns.Option B suggests enabling auto scaling for the PostgreSQL database on the EC2 instance. While auto scaling can help with managing the compute capacity of the EC2 instance, it does not address the database performance directly. The underlying PostgreSQL database may still experience connection issues during peak traffic periods.Option C suggests migrating the PostgreSQL database to Amazon RDS for PostgreSQL with a larger instance type. While upgrading to a larger instance type can provide additional compute resources, it may not be the most cost-effective solution. Additionally, manually adjusting the instance size may not be suitable for handling unpredictable traffic patterns.Option D suggests migrating the PostgreSQL database to Amazon Redshift. However, Amazon Redshift is a data warehousing solution and may not be the most appropriate choice for an ecommerce application's operational database needs. It is designed for analytics and reporting workloads, rather than transactional workloads.Therefore, the most cost-effective solution to resolve the issue and maintain performance during unpredictable increases in traffic is A: Migrate the PostgreSQL database to Amazon Aurora Serverless v2. This solution leverages the auto-scaling capabilities of Aurora Serverless v2 to dynamically adjust the database capacity and handle varying traffic patterns, ensuring consistent performance for the ecommerce application.