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.

Stopping an RDS instance does not reduce costs significantly because you still pay for the storage and some management overhead. Additionally, stopping and starting an RDS instance can take time and may not be as efficient as terminating and restoring from a snapshot.

you still pay for storage when an RDS database is stopped

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