A company has an internal reporting application that uses an Amazon RDS for MySQL database. The application is only used by employees during business hours (Monday to Friday, 9 AM to 5 PM). The database is currently running 24/7. What is the MOST cost-effective way to optimize the database costs?

Answer options:

Migrate the database to Amazon DynamoDB.

Purchase a 3-year All Upfront Reserved Instance.

Use AWS Systems Manager or Lambda to automatically stop the RDS instance outside of business hours.

Take a snapshot of the database every evening and delete the instance, then restore it every morning.

How to approach this question

For development or business-hours-only RDS instances, stopping them when not in use is the best cost optimization.

Full Answer

C.Use AWS Systems Manager or Lambda to automatically stop the RDS instance outside of business hours.✓ Correct

Amazon RDS allows you to stop and start your database instances. For workloads that are only used during specific hours (like dev/test or internal business apps), automating the stopping of the instance outside of those hours saves significant compute costs.

Common mistakes

Choosing Reserved Instances. RIs are for steady-state 24/7 workloads.

Question 60 All questions Question 62

Practice the full AWS SAA-C03 Practice Exam 1

65 questions · hints · full answers · grading

More questions from this exam

Q01A company has multiple AWS accounts in an AWS Organizations organization. The security team wants...Medium Q02A solutions architect is designing an application that will run on Amazon EC2 instances. The appl...Easy Q03A company wants to implement a federated identity solution for its employees to access the AWS Ma...Medium Q04A mobile application needs to access Amazon DynamoDB directly to read user-specific data. The app...Hard Q05A company is hosting a web application on Amazon EC2 instances. The application connects to an Am...Medium

View all 65 questions →