Q39 — AWS SAA-C03 Ch.14

Question 39 of 100 | ← Chapter 14

Q1039. A company is developing a new application that uses a relational database to store user data and application configurations. The company expects the application to have steady user growth. The company expects the database usage to be variable and read-heavy, with occasional writes.The company wants to cost-optimize the database solution. The company wants to use an AWS managed database solution that will provide the necessary performance.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: B. Deploy the database on Amazon Aurora Serverless to automatically scale the database capacity based on actual usage to accommodate the workload.

Explanation

To meet the requirements of developing a new application with a relational database that is variable and read-heavy, with occasional writes, while also being cost-effective, the best solution is:B. Deploy the database on Amazon Aurora Serverless to automatically scale the database capacity based on actual usage to accommodate the workload.Explanation:\1. Amazon Aurora Serverless: - Aurora Serverless automatically adjusts database capacity based on application needs, which is ideal for variable workloads. This feature allows the database to dynamically scale up during peak usage times and scale down during periods of low activity, optimizing costs.\2. Cost Optimization: - With Aurora Serverless, you pay only for the database resources consumed during active use, making it cost-effective for applications with unpredictable workloads, such as the one described.\3. Performance: - Aurora provides high performance and availability for relational databases, capable of handling read-heavy workloads efficiently. It is designed for high throughput and low latency, making it suitable for applications expecting steady user growth.Evaluation of Other Options:A. Deploy the database on Amazon RDS with Provisioned IOPS SSD storage: - While this option ensures consistent performance, it may not be the most cost-effective for variable workloads since you would be paying for provisioned IOPS regardless of actual usage, leading to higher costs during low usage periods.C. Deploy the database on Amazon DynamoDB with on-demand capacity mode: - Although DynamoDB is highly scalable and cost-effective for variable workloads, it is a NoSQL database. Since the requirement specifies a relational database, this option may not fit the application's needs.D. Deploy the database on Amazon RDS with magnetic storage and use read replicas: - Magnetic storage is generally slower and may not provide the performance needed for a read-heavy application. Additionally, the use of read replicas can incur additional costs and complexity, especially if the main database is not optimized for performance.Conclusion:Option B is the most suitable and cost-effective solution for the application, providing the necessary performance while allowing for automatic scaling based on actual usage.