AWS Certified Solutions Architect - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
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.)
Other
Community
UAnonymous
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.
Explanation:
Explanation
Correct Answers: C and E
Why C is correct:
- Database dump (mysqldump): The mysqldump utility creates a logical backup in SQL format.
- S3 storage: Uploading the database dump to Amazon S3 provides a secure, durable storage location.
- Import into Aurora: Amazon Aurora MySQL-compatible edition supports importing data from SQL dump files stored in S3 using the
mysqlcommand-line tool or AWS Database Migration Service.
Why E is correct:
- Database dump to S3: Same as above - the mysqldump file needs to be stored in S3.
- AWS DMS: AWS Database Migration Service can migrate data from various sources, including SQL dump files in S3, to Amazon Aurora.
- 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:
-
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
-
Migration paths:
- From RDS MySQL to Aurora MySQL: Use logical backups (mysqldump) or AWS DMS
- Aurora cannot directly restore from RDS snapshots
-
Best practice: For migrating from RDS MySQL to Aurora, AWS recommends using AWS DMS or logical backups with mysqldump.
Comments
Loading comments...