Timed Mode Set 4 Question 24

[kenadave110993]

on Timed Mode Set 4, question 24, why we need to take the snapshot, because stopping the instance will keep the storage as it is

24. Question

A company conducts performance testing on a large instance MySQL RDS DB instance twice a week. They use Performance Insights to analyze and fine-tune expensive queries. The company needs to reduce its operational expenses in running the tests without compromising the tests’ integrity.

Which of the following is the most cost-effective solution?

A) Stop the database once the test is done and restart it only when necessary

B) Once the testing is completed, take a snapshot of the database and terminate it. Restore the database from the snapshot when necessary.

• This discussion was modified 2 weeks, 1 day ago by  kenadave110993.

[JR-TutorialsDojo]

Hello kenadave110993,

Thanks for posting here.

Stopping the RDS instance does not eliminate storage costs and has operational limitations, while snapshot + terminate shifts the data to cheaper S3 storage and avoids ongoing RDS charges, making it the most cost‑effective solution for periodic testing.

Please refer to this: https://aws.amazon.com/blogs/database/amazon-rds-snapshot-restore-and-recovery-demystified/

I hope this helps! Let us know if you need further assistance.

Regards,
JR @ Tutorials Dojo

[kenadave110993]

Thank you for the explanation!

[JR-TutorialsDojo]

No worries, Kenadave110993!