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?
AMigrate the PostgreSQL database to Amazon Aurora Serverless v2.
BEnable auto scaling for the PostgreSQL database on the EC2 instance to accommodate increased usage.
CMigrate the PostgreSQL database to Amazon RDS for PostgreSQL with a larger instance type.
DMigrate the PostgreSQL database to Amazon Redshift to accommodate increased usage.