DEA-C01 · Question #156
A company is building a data lake for a new analytics team. The company is using Amazon S3 for storage and Amazon Athena for query analysis. All data that is in Amazon S3 is in Apache Parquet…
The correct answer is C. Create an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the. AWS Database Migration Service (DMS) with ongoing replication (full-load + CDC) is the least-effort solution for daily incremental ingestion from Oracle. Since all 70 tables have primary keys, DMS can use Change Data Capture (CDC) to track inserts, updates, and deletes…
Question
A company is building a data lake for a new analytics team. The company is using Amazon S3 for storage and Amazon Athena for query analysis. All data that is in Amazon S3 is in Apache Parquet format. The company is running a new Oracle database as a source system in the company's data center. The company has 70 tables in the Oracle database. All the tables have primary keys. Data can occasionally change in the source system. The company wants to ingest the tables every day into the data lake. Which solution will meet this requirement with the LEAST effort?
Options
- ACreate an Apache Sqoop job in Amazon EMR to read the data from the Oracle database.
- BCreate an AWS Glue connection to the Oracle database. Create an AWS Glue bookmark job to
- CCreate an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the
- DCreate an Oracle database in Amazon RDS. Use AWS Database Migration Service (AWS DMS)
How the community answered
(53 responses)- A4% (2)
- B15% (8)
- C75% (40)
- D6% (3)
Explanation
AWS Database Migration Service (DMS) with ongoing replication (full-load + CDC) is the least-effort solution for daily incremental ingestion from Oracle. Since all 70 tables have primary keys, DMS can use Change Data Capture (CDC) to track inserts, updates, and deletes automatically. DMS has native Oracle source and S3 target endpoints and can write in Parquet format, satisfying all requirements with minimal configuration. Option A (Apache Sqoop on EMR) requires provisioning and managing an EMR cluster. Option B (AWS Glue with bookmarks) requires writing and maintaining ETL scripts for 70 tables. Option D unnecessarily introduces Amazon RDS as an intermediary, adding complexity and cost.
Topics
Community Discussion
No community discussion yet for this question.