Answer-first summary for fast verification
Answer: Upload the database dump to Amazon S3. Then import the database dump into Aurora., Upload the database dump to Amazon S3. Then use AWS Database Migration Service (AWS DMS) to import the database dump into Aurora.
## Explanation **Correct Answers: C and E** ### Why C is correct: 1. **Database dump (mysqldump)**: The mysqldump utility creates a logical backup in SQL format. 2. **S3 storage**: Uploading the database dump to Amazon S3 provides a secure, durable storage location. 3. **Import into Aurora**: Amazon Aurora MySQL-compatible edition supports importing data from SQL dump files stored in S3 using the `mysql` command-line tool or AWS Database Migration Service. ### Why E is correct: 1. **Database dump to S3**: Same as above - the mysqldump file needs to be stored in S3. 2. **AWS DMS**: AWS Database Migration Service can migrate data from various sources, including SQL dump files in S3, to Amazon Aurora. 3. **DMS flexibility**: AWS DMS provides a managed service for database migration with features like schema conversion, data validation, and ongoing replication. ### Why other options are incorrect: **A: Import the RDS snapshot directly into Aurora.** - ❌ **Incorrect**: RDS snapshots are specific to RDS and cannot be directly imported into Aurora. Aurora uses its own snapshot format. **B: Upload the RDS snapshot to Amazon S3. Then import the RDS snapshot into Aurora.** - ❌ **Incorrect**: RDS snapshots are stored in AWS-managed storage, not directly accessible as files. Even if you could export them to S3, Aurora cannot import RDS snapshot formats directly. **D: Use AWS Database Migration Service (AWS DMS) to import the RDS snapshot into Aurora.** - ❌ **Incorrect**: AWS DMS cannot directly import RDS snapshots. DMS migrates data from live database sources, not from snapshot files. ### Key Points: 1. **RDS snapshots vs. Database dumps**: - RDS snapshots: Physical backups stored in AWS-managed storage, specific to RDS - Database dumps: Logical backups in SQL format, portable across different database engines 2. **Migration paths**: - From RDS MySQL to Aurora MySQL: Use logical backups (mysqldump) or AWS DMS - Aurora cannot directly restore from RDS snapshots 3. **Best practice**: For migrating from RDS MySQL to Aurora, AWS recommends using AWS DMS or logical backups with mysqldump.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
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.)
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.
No comments yet.