Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 440 discussion

A,C A because the snapshot is already stored in AWS. C because you dont need a migration tool going from MySQL to MySQL. You would use the MySQL utility.

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

c + e is correct

Answer B is out, why upload to S3? This is to call the most recent backup, answer D & E are out to use AWS Database Migration Service (AWS DMS).

AWS DMS does not support migrating data directly from an RDS snapshot. DMS can migrate data from a live RDS instance or from a database dump, but not from a snapshot. Also dump can be migrated to aurora using sql client.

If you can use option A - "Import the RDS snapshot directly into Aurora", why go S3 in option C ? Non sense, A and C cannot co-exist

A per https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.RDSMySQL.Snapshot.html C per https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.ExtMySQL.html

A and B

Similar : https://repost.aws/knowledge-center/aurora-postgresql-migrate-from-rds

A and C

Either import the RDS snapshot directly into Aurora or upload the database dump to Amazon S3, then import the database dump into Aurora.

AC: - store dump in s3 then upload to aurora - no need to store snapshot in s3 because is in AWS already

C and E are the solutions that can restore the backups into Amazon Aurora. The RDS DB snapshot contains backup data in a proprietary format that cannot be directly imported into Aurora. The mysqldump database dump contains SQL statements that can be imported into Aurora after uploading to S3. AWS DMS can migrate the dump file from S3 into Aurora.

Amazon RDS for MySQL --> Amazon Aurora MySQL-compatible. * mysqldump, database dump --> (C) Upload to Amazon S3, Import dump to Aurora. * DB snapshot --> (A) Import RDS Snapshot directly Aurora. The correct word should be "migration". "Use console to migrate the DB snapshot and create an Aurora MySQL DB cluster with the same databases as the original MySQL DB instance." Exclude B, because no need upload DB snapshot to Amazon S3. Exclude D, because no need Migration service. Exclude E, because no need Migration service. Use exclusion method is more easy for this question. Related links: - Amazon RDS create database snapshot https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CreateSnapshot.html - https://aws.amazon.com/rds/aurora/

CE Since the backup created by the solutions architect was a database dump using the mysqldump utility, it cannot be directly imported into Aurora using RDS snapshots. Amazon Aurora has its own specific backup format that is different from RDS snapshots

Migrating data from MySQL by using an Amazon S3 bucket You can copy the full and incremental backup files from your source MySQL version 5.7 database to an Amazon S3 bucket, and then restore an Amazon Aurora MySQL DB cluster from those files. This option can be considerably faster than migrating data using mysqldump, because using mysqldump replays all of the commands to recreate the schema and data from your source database in your new Aurora MySQL DB cluster. By copying your source MySQL data files, Aurora MySQL can immediately use those files as the data for an Aurora MySQL DB cluster. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Migrating.ExtMySQL.html

BE Upload the RDS snapshot to Amazon S3. Then import the RDS snapshot into Aurora. Upload the database dump to Amazon S3. Then use AWS Database Migration Service (AWS DMS) to import the database dump into Aurora