AWS Certified Data Engineer – Associate (DEA-C01) — Question 196

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?

Answer options

• A. Use one AWS Glue job to replicate existing data. Use a second AWS Glue job to replicate future changes.
• B. Use AWS Database Migration Service (AWS DMS) to replicate existing data. Use AWS Glue jobs to replicate future changes.
• C. Use AWS Database Migration Service (AWS DMS) to replicate existing data and future changes.
• D. Use AWS Glue jobs to replicate existing data. Use Amazon Kinesis Data Streams to replicate future changes.

Correct answer: C

Explanation

The correct answer is C because AWS Database Migration Service (AWS DMS) is designed to efficiently handle both initial data loads and ongoing replication of changes, making it a comprehensive solution. Options A and B do not provide a unified approach for both data replication needs, while option D introduces unnecessary complexity by using Kinesis for future changes instead of a single service.