AWS Certified Database – Specialty — Question 46

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?

Answer options

• 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

Correct answer: B

Explanation

Option B is correct because using AWS DMS to migrate databases allows for a seamless transition with minimal downtime, meeting the company's requirements. Option A is incorrect as it does not directly address the need to downsize storage effectively. Option C involves more manual steps and potential downtime, while Option D complicates the process unnecessarily by creating a read replica instead of directly addressing the storage reduction.