Exam AWS Certified Solutions Architect - Professional topic 1 question 937 discussion

Using mysqldump. For me its tempting: have been using it for decades. But it does not reduce operational overhead. Where should it be executed btw. and how do you create a secure tunnel for the stream(doable with simple ssh but think about the "operational overhead" ...) or where do you store the dumps as streaming is pipe plumbing... Data in relational Databases in general is more read more than written. This is also the case if the database is used by the backend which is not uncommon. That the data that was stored in the database is backend data does not imply that it is written more then read. Hence read replica should be fine. A is perfect. Just imagine an architect suggest C on the job ... on time fail.

Amazon Aurora is a fully managed, high-performance relational database with low latency and high availability. It supports MySQL and can be easily scaled. The global database feature allows you to create a single, low-latency database across multiple AWS Regions, making it a great fit for this use case. By using native MySQL tools to migrate existing databases, the company can minimize the amount of development effort required to make the application highly available.

A - available across multiple aws regions and has read replicas for improved scaling. - Initially thoguht this was the right answer. C - This appears to be the most correct answer - B - Wrong database platform - Solution will require MySQL / Aurora D - Not scalable and requires operational overhead

For choosing between 'A' & 'C', is the DMS service more effort that 'MySQL Tools ~ mysqlimport utility' ? There is no mention of saving costs and 'Amazon RDS for MySQL' supports cross-region replica. So why should we discount 'A' ?

I agree Aurora would be more beneficial (C), but I would be skeptical about an SA Pro exam answer with mysql > aurora shift without DMS

A or C but why Dynamo DB? The solution must require the least possible development effort. Should the answer be A?

C no doubts

Answer is C: Aurora (C) is far better than MySQL RDS (A). In Option C, DMS isn't mentioned. However, native MySQL tool (mysqldump utility) is fine for migration as per below FAQ from AWS. How can I migrate from MySQL to Amazon Aurora and vice versa? If you want to migrate from MySQL to Amazon Aurora (and vice versa), you have several options: You can use the standard mysqldump utility to export data from MySQL and mysqlimport utility to import data to Amazon Aurora, and vice-versa. You can also use Amazon RDS’s DB Snapshot migration feature to migrate an Amazon RDS for MySQL DB Snapshot to Amazon Aurora using the AWS Management Console. Migration to Aurora completes for most customers in under an hour, though the duration depends on format and data set size. For more information see Best Practices for Migrating MySQL Databases to Amazon Aurora.

C Amazon Aurora offers higher availability zone, global replication and compatability to existing on-premise DB