Q22 — AWS SAA-C03 Ch.3

Question 22 of 65 | ← Chapter 3

Q152. 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 fora new test cycle and wants to create anew 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? (Select TWO.)

Correct Answer: A. Import the RDS snapshot directly into Aurora., C. Upload the database dump to Amazon S3. Then import the database dump into Aurora.

Explanation

Option A is a valid solution because Amazon Aurora is compatible with MySQL. It allows users to restore data from an RDS snapshot without any additional steps, which makes it easy to create a new Aurora DB instance. Option C is also a valid solution because the solutions architect created a backup using the mysqldump utility to create a database dump. The database dump can be uploaded to Amazon S3 and then imported into an Aurora DB instance using the mysql command-line utility. This approach requires some manual steps but provides more flexibility than directly importing an RDS snapshot into Aurora. Options B, D, and E are not valid solutions because they involve additional steps that are not necessary in this scenario. Uploading the RDS snapshot to S3 (option B) or using AWS Database Migration Service (options D and E) may be useful in other scenarios but are not needed to create a new DB instance from the backups that were already created.