Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 30 discussion

Answer C, you still pay for storage when an RDS database is stopped

C - Create a manual Snapshot of DB and shift to S3- Standard and Restore form Manual Snapshot when required. Not A - By stopping the DB although you are not paying for DB hours you are still paying for Provisioned IOPs , the storage for Stopped DB is more than Snapshot of underlying EBS vol. and Automated Back ups . Not D - Is possible but not MOST cost effective, no need to run the RDS when not needed.

B is right i think

An RDS instance can be stopped for up to seven days so it cannot be A. "The instance stops running, up to a maximum of 7 consecutive days." https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html

La opción A es la más rentable porque detiene la instancia de base de datos cuando no se está utilizando, ahorrando los costos de cómputo, y luego se reinicia cuando sea necesario, sin comprometer el rendimiento durante las pruebas.

The correct answer is: C. Create a snapshot when tests are completed. Terminate the DB instance and restore the snapshot when required. Explanation: This solution is the most cost-effective because it allows the development team to: Save Costs by Terminating the Instance: When the DB instance is not in use (28 out of 30 days), terminating it eliminates the costs associated with running a live instance. You only pay for storage costs associated with the snapshot, which is significantly lower than the cost of keeping a running instance. Restoring a Snapshot: Restoring from a snapshot is straightforward and brings the database back with the same data and configuration as before. It’s a good practice when dealing with periodic, resource-intensive tasks like the monthly tests.

Ans C – take Snapshots and restore them, because otherwise you're still paying for RDS storage.

C. This option allows you to save on costs by only paying for storage of the snapshot when the DB instance is terminated. When needed again, you can restore the DB instance from the snapshot, which is a cost-effective way to handle infrequent but resource-intensive tasks.

Most cost effective is to create a snapshot and get rid of the DB instance after testing. Note that A is not correct option as While your database instance is stopped, you are charged for provisioned storage, manual snapshots and automated backup storage within your specified retention window, but not for database instance hours.

A Since the tests only run once a month for 48 hours, this approach minimizes costs while still retaining the same compute and memory attributes when the instance is restarted. when Snapshot resorte i new config

My question is: isn't this DB collecting new data during the testing period ( 48 hrs.) ? after the snapshot is taken ? stop and restore db from the snapshot is the most cost effective but I think some data might be lost in between, so wouldn't be feasible !

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_StopInstance.html

Answer C because, You can stop a DB instance for up to seven days. If you don't manually start your DB instance after seven days, your DB instance is automatically started so that it doesn't fall behind any required maintenance updates. So, the "auto starting" behaviour is expected. If you rarely use the database, BEST option is to Snapshot and Delete the database. Then, when you need it again, you could launch a new database from the Snapshot. Amazon RDS is not intended to be stopped for long periods.

DB is used one a month for 48 hours only so there is no point in keeping it up for rest of the month. B: more cost D: not allowed to reduce computing power A: It will work but C is much cheaper as instance is not only stopped but terminated.

Answer-C

Option A (Stop and Restart) is less operationally complex and provides a quicker way to resume the database. It's suitable if the primary concern is operational simplicity and quick availability. Option C (Snapshot, Terminate, and Restore) may offer higher cost savings, especially if the instance is large and expensive to run, as you're avoiding charges for the time the instance is down. However, it comes with higher operational complexity and longer lead times to bring the database back online. In Amazon RDS, you do incur charges for a DB instance even when it's stopped. This is a key distinction from Amazon EC2, where you are not charged for instance hours while an EC2 instance is stopped. For RDS, the charges related to the instance's storage and backups continue to accrue even when the instance itself is not running.

It is C Amazon RDS allows you to easily stop and start your database instances ONLY for up to seven days at a time. So Snapshot and Restore is proper solution.