QuestionQ92

VerifiedData Ingestion and Transformation

A company uses Amazon S3 to build a data lake. It must replicate records from multiple source databases in Apache Parquet format.

Most source databases are hosted on Amazon RDS. However, one source database is an on-premises Microsoft SQL Server Enterprise instance. The company must implement a solution that replicates existing data from every source database and all future changes to the target S3 data lake.

Which solution meets these requirements in the MOST cost-effective way?

Explanation

AWS DMS can run a full-load-and-change-data-capture (CDC) task to migrate existing data and continuously replicate later database changes. With Amazon S3 as the target, DMS can write both full-load and CDC output in Apache Parquet format. DMS also supports ongoing replication from self-managed, on-premises SQL Server sources, as well as supported RDS database sources.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!