A financial company has allocated an Amazon RDS MariaDB DB instance with large storage capacity to accommodate migration efforts. Post-migration, the company purged unwanted data from the instance. The company now want to downsize storage to save money. The solution must have the least impact on production and near-zero downtime. Which solution would meet these requirements?
A) Create a snapshot of the old databases and restore the snapshot with the required storage
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
C) Create a new database using native backup and restore
D) Create a new read replica and make it the primary by terminating the existing primary

Question

Quizplus · Accepted Answer

Creating a snapshot of the old databases and restoring the snapshot with the required storage allows the company to downsize storage without impacting production or causing downtime.

A Financial Company Has Allocated an Amazon RDS MariaDB DB