Exam AWS Certified Database - Specialty topic 1 question 78 discussion

https://aws.amazon.com/premiumsupport/knowledge-center/rds-db-storage-size/"After you create an Amazon RDS DB instance, you can't modify the allocated storage size of the DB instance to decrease the total storage space it uses. To decrease the storage size of your DB instance, create a new DB instance that has less provisioned storage size. Then, migrate your data into the new DB instance using one of the following methods: Use the database engine's native dump and restore method. Note: This method causes some downtime. Use AWS Database Migration Service (AWS DMS) for minimal downtime."

A. Create a snapshot of the old databases and restore the snapshot with the required storage (Downtime ) B. Create a new RDS DB instance with the required storage and move the databases from the old instances to the new instance using AWS DMS ( no downtime) C. Create a new database using native backup and restore (Downtime like A) D. Create a new read replica and make it the primary by terminating the existing primary (wont change the storage)

Its not D because For replication to operate effectively, each Read Replica should have the same amount of compute & storage resources as the source DB instance.

B. When you create a read replica you cannot set the storage size... so D is incorrect.

B Almost no downtime > AWS DMS

Isn't A?

Answer is B. You cannot downsize the database storage size on RDS.

Almost no downtime > AWS DMS : Option B

D is not correct because, You cannot set the size of the read replica, which is always same as the master.

B is correct. D is close, however, you don't make the read replica the primary by terminating the existing primary. "Create a new read replica and make it the primary by terminating the existing primary"

D can be an option too. Read replicas can have different storage size and Read replicas will have less impact on production as compared to DMS.

B looks correct according to BillyMadaison's link. Not my initial answer though

Ans: B

B looks to be the correct answer

Yes. B is the answer snapshot will retain same size. DB needs to be recreated and DMS is for near zero

B is corect

B is correct