A retailer stores product lifecycle management data in an on-premises MySQL database that receives frequent updates. The company wants near-real-time insights integrated with other datasets and analyzed in Amazon Redshift. A Direct Connect link to AWS is already in place. Which solution requires the least development effort?
Choose an answer
Tap an option to check your answer.
Correct answer: Run a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously replicate the MySQL database changes. Set Amazon Redshift as the destination for the task..
Why this is the answer
AWS DMS is designed for migrating and continuously replicating databases, including from on-premises MySQL to Amazon Redshift. Its Change Data Capture (CDC) capability ensures near-real-time synchronization of updates with minimal development effort, as it handles the replication process natively. Scheduled AWS Glue jobs would require custom scripting for CDC and managing state, increasing development effort and potentially latency. Amazon AppFlow is primarily for SaaS applications and lacks native MySQL database connectors for this use case, making a custom connector complex and high effort. AWS DataSync is for file and object storage synchronization, not for direct database replication to Redshift.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed