Q46 — AWS SAA-C03 Ch.14

Question 46 of 100 | ← Chapter 14

Q1046. A company is launching a new application that requires a structured database to store user profiles, application settings, and transactional data. The database must be scalable with application traffic and must offer backups.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: C. Use Amazon Aurora Serverless for the database. Use serverless capacity scaling. Configure automated backups to Amazon S3.

Explanation

To meet the requirements for a structured database that is scalable, offers backups, and is cost-effective for storing user profiles, application settings, and transactional data, the best solution is:C. Use Amazon Aurora Serverless for the database. Use serverless capacity scaling. Configure automated backups to Amazon S3.Explanation:\1. Amazon Aurora Serverless: - Aurora Serverless automatically adjusts the database's capacity based on the application's current needs, allowing it to scale seamlessly with traffic fluctuations. This is especially beneficial for applications with variable workloads.\2. Cost-Effectiveness: - With Aurora Serverless, you only pay for the resources you actually use, which makes it a cost-effective solution compared to provisioning fixed resources that might not be fully utilized.\3. Automated Backups: - Aurora provides automated backups and point-in-time recovery, ensuring that your data is safe and can be restored when needed. This meets the requirement for having backups without needing extensive management.Evaluation of Other Options:A. Deploy a self-managed database on Amazon EC2 instances: - While this option may offer initial cost savings, it introduces significant operational overhead, such as managing and maintaining the database software, handling scaling, and configuring backups. This can lead to higher long-term costs.B. Use Amazon RDS with on-demand capacity mode: - While RDS is a good choice for structured databases and offers automated backups, using on-demand capacity may not be the most cost-effective solution for applications with variable traffic patterns compared to Aurora Serverless, which can scale more flexibly.D. Deploy a self-managed NoSQL database on Amazon EC2 instances: - This option does not align with the requirement for a structured database, as NoSQL databases are typically not designed for relational data. Additionally, managing a self-hosted database increases operational overhead and complexity.Conclusion:Option C is the most suitable solution, providing a scalable, cost-effective, and fully managed database solution that meets all the requirements for the new application.