Which solution will meet these requirements MOST cost-effectively?
Deploy a self-managed database on Amazon EC2 instances by using open source software. Use Spot Instances for cost optimization. Configure automated backups to Amazon S3.
Use Amazon RDS. Use on-demand capacity mode for the database with General Purpose SSD storage. Configure automatic backups with a retention period of 7 days.
Use Amazon Aurora Serverless for the database. Use serverless capacity scaling. Configure automated backups to Amazon S3.
Deploy a self-managed NoSQL database on Amazon EC2 instances. Use Reserved Instances for cost optimization. Configure automated backups directly to Amazon S3 Glacier Flexible Retrieval.
Explanations:
Deploying a self-managed database on EC2 requires significant maintenance and management overhead, which may lead to higher long-term costs despite using Spot Instances. Automated backups to S3 require manual configuration, adding complexity.
While Amazon RDS is a managed service with automatic backups, using on-demand capacity mode may not be the most cost-effective for scaling, especially with variable traffic. It may lead to higher costs compared to serverless options.
Amazon Aurora Serverless automatically scales with application traffic and is cost-effective, as you only pay for the capacity used. It also provides automated backups to S3, meeting both scalability and backup requirements efficiently.
A self-managed NoSQL database on EC2 adds complexity and operational overhead. While Reserved Instances can reduce costs, the management burden and the need for manual backup configurations make it less cost-effective compared to managed solutions.
As far as I can tell, the answer is:
Use Amazon Aurora Serverless for the database. Use serverless capacity scaling. Configure automated backups to Amazon S3.