DEA-C01 · Question #120
A retail company stores data from a product lifecycle management (PLM) application in an on- premises MySQL database. The PLM application frequently updates the database when transactions occur. The…
The correct answer is B. Run a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously. AWS DMS with a full load plus CDC (Change Data Capture) task is the lowest-effort solution for continuous, near-real-time replication from an on-premises MySQL database to Amazon Redshift. DMS handles the initial full load and then automatically captures and applies ongoing…
Question
A retail company stores data from a product lifecycle management (PLM) application in an on- premises MySQL database. The PLM application frequently updates the database when transactions occur. The company wants to gather insights from the PLM application in near real time. The company wants to integrate the insights with other business datasets and to analyze the combined dataset by using an Amazon Redshift data warehouse. The company has already established an AWS Direct Connect connection between the on- premises infrastructure and AWS. Which solution will meet these requirements with the LEAST development effort?
Options
- ARun a scheduled AWS Glue extract, transform, and load (ETL) job to get the MySQL database
- BRun a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously
- CUse the Amazon AppFlow SDK to build a custom connector for the MySQL database to
- DRun scheduled AWS DataSync tasks to synchronize data from the MySQL database. Set
How the community answered
(22 responses)- A5% (1)
- B77% (17)
- C5% (1)
- D14% (3)
Explanation
AWS DMS with a full load plus CDC (Change Data Capture) task is the lowest-effort solution for continuous, near-real-time replication from an on-premises MySQL database to Amazon Redshift. DMS handles the initial full load and then automatically captures and applies ongoing changes using the database's transaction log-no custom code required. The existing Direct Connect connection provides the network path. Option A (scheduled Glue ETL) introduces batch latency, not near real-time. Option C (AppFlow custom connector) requires significant SDK development work. Option D (DataSync) is designed for file/object transfer, not transactional database replication.
Topics
Community Discussion
No community discussion yet for this question.