Exam AWS Certified Data Engineer - Associate DEA-C01 topic 1 question 210 discussion

Exam question from Amazon's AWS Certified Data Engineer - Associate DEA-C01

Question #: 210
Topic #: 1

[All AWS Certified Data Engineer - Associate DEA-C01 Questions]

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?

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.

Show Suggested Answer

Suggested Answer: C 🗳️

by AnsonCert at June 7, 2025, 8:41 a.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

AnsonCert

1 week, 5 days ago

Selected Answer: C

AWS DMS provides full support of replicating records from RDS and on-premises SQL Server in Full Load, CDC, Full Load + CDC. Also, DMS supports converting data to Parquet format and sends to S3 for building data lake. So DMS can provides both replication and CDC, all in a single service.

upvoted 1 times

...