AWS Certified Solutions Architect – Associate (SAA-C02) — Question 578

A company used an Amazon RDS for MySQL DB instance during application testing. Before terminating the DB instance at the end of the test cycle, a solutions architect created two backups. The solutions architect created the first backup by using the mysqldump utility to create a database dump. The solutions architect created the second backup by enabling the final DB snapshot option on RDS termination.
The company is now planning for a new test cycle and wants to create a new DB instance from the most recent backup. The company has chosen a MySQL- compatible edition of Amazon Aurora to host the DB instance.
Which solutions will create the new DB instance? (Choose two.)

Answer options

• A. Import the RDS snapshot directly into Aurora.
• B. Upload the RDS snapshot to Amazon S3. Then import the RDS snapshot into Aurora.
• C. Upload the database dump to Amazon S3. Then import the database dump into Aurora.
• D. Use AWS Database Migration Service (AWS DMS) to import the RDS snapshot into Aurora.
• E. Upload the database dump to Amazon S3. Then use AWS Database Migration Service (AWS DMS) to import the database dump into Aurora.

Correct answer: D, E

Explanation

AWS Database Migration Service (AWS DMS) can be utilized to migrate data from the RDS snapshot into the target Amazon Aurora MySQL-compatible database. Additionally, uploading the database dump to Amazon S3 and using AWS DMS to load that dump into Amazon Aurora is a supported migration path. Other direct migration options without utilizing AWS DMS are either unsupported for these specific formats or do not align with migrating to Aurora MySQL.