AWS Certified Solutions Architect – Associate (SAA-C03) — Question 427

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 ofAmazon 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: A, C

Explanation

Amazon Aurora allows direct migration of an Amazon RDS for MySQL DB snapshot to create a new Aurora MySQL DB cluster. Alternatively, you can upload a logical database dump generated by mysqldump to an Amazon S3 bucket and import those files directly into Aurora. Other options like staging RDS snapshots in S3 or using AWS DMS for static file imports are either unsupported or unnecessarily complex for this migration task.