AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 210

Question

A company is using Amazon S3 to build a data lake. The company needs to replicate records from multiple source databases into Apache Parquet format. Most of the source databases are hosted on Amazon RDS. However, one source database is an on-premises Microsoft SQL Server Enterprise instance. The company needs to implement a solution to replicate existing data from all source databases and all future changes to the target S3 data lake. Which solution will meet these requirements MOST cost-effectively?

Accepted Answer

Correct answer: C. The correct answer is C. Option C: Use AWS Database Migration Service (AWS DMS) to replicate existing data and future changes. AWS Database Migration Service migrates databases with minimal downtime. This option delivers the requirement at the lowest cost.

AWS Certified Data Engineer - Associate DEA-C01 — Question 210