ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 476 - SAA-C03 discussion

Report
Export

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? (Select TWO.)

A.
Import the RDS snapshot directly into Aurora.
Answers
A.
Import the RDS snapshot directly into Aurora.
B.
Upload the RDS snapshot to Amazon S3. Then import the RDS snapshot into Aurora.
Answers
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.
Answers
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.
Answers
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.
Answers
E.
Upload the database dump to Amazon S3. Then use AWS Database Migration Service (AWS DMS) to import the database dump into Aurora.
Suggested answer: A, C

Explanation:

These answers are correct because they meet the requirements of creating a new DB instance from the most recent backup and using a MySQL-compatible edition of Amazon Aurora to host the DB instance. You can import the RDS snapshot directly into Aurora if the MySQL DB instance and the Aurora DB cluster are running the same version of MySQL. For example, you can restore a MySQL version 5.6 snapshot directly to Aurora MySQL version 5.6, but you can't restore a MySQL version 5.6 snapshot directly to Aurora MySQL version 5.7. This method is simple and requires the fewest number of steps. You can upload the database dump to Amazon S3 and then import the database dump into Aurora if the MySQL DB instance and the Aurora DB cluster are running different versions of MySQL. For example, you can import a MySQL version 5.6 database dump into Aurora MySQL version 5.7, but you can't restore a MySQL version 5.6 snapshot directly to Aurora MySQL version 5.7. This method is more flexible and allows you to migrate across different versions of MySQL.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Import.html

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Dump.html

asked 16/09/2024
AN KANGWOOK
46 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first