Q38 — AWS SAA-C03 Ch.10

Question 38 of 100 | ← Chapter 10

Q638. A company runs an application that uses Amazon RDS for PostgreSQL. The application receives traffic only on weekdays during business hours. The company wants to optimize costs and reduce operational overhead based on this usage.Which solution will meet these requirements?

Correct Answer: A. Use the Instance Scheduler on AWS to configure start and stop schedules

Explanation

To optimize costs and reduce operational overhead for an Amazon RDS for PostgreSQL database based on weekday business hour traffic, the most suitable solution is:A. Use the Instance Scheduler on AWS to configure start and stop schedules. The Instance Scheduler is a service provided by AWS that allows you to automate the start and stop schedules of EC2 instances and RDS database instances. By configuring the Instance Scheduler, you can set specific start and stop schedules for the Amazon RDS for PostgreSQL database to align with the weekday business hours when the application receives traffic. This way, the database will only be operational during the required hours, reducing costs associated with running it 24/7.Option B is not the best choice for this scenario:B. Turning off automatic backups and creating weekly manual snapshots of the database can lead to data loss and is not recommended. Automatic backups provide point-in-time recovery options and are essential for data protection and disaster recovery purposes. Creating manual snapshots once a week might not be sufficient to ensure data integrity and availability.Option C is not the best choice either:C. Creating a custom AWS Lambda function to start and stop the database based on minimum CPU utilization can be complex and may not align with the specific weekday business hour traffic pattern. Relying solely on CPU utilization might not accurately reflect the database's usage pattern and could result in unnecessary downtime or increased costs if the utilization thresholds are not set correctly.Option D is not relevant to the given scenario:D. Purchasing All Upfront reserved DB instances is a pricing option for Amazon RDS that involves making a full upfront payment for reserved instances to achieve cost savings. However, it does not address the requirement of optimizing costs based on weekday business hour traffic.Therefore, option A is the most appropriate choice for optimizing costs and reducing operational overhead for an Amazon RDS for PostgreSQL database in this scenario.