A new data lake on Amazon S3 will be queried with Amazon Athena. An on-premises Oracle database with 70 tables (all with primary keys) is the source; data changes occasionally. The company wants to ingest the tables daily into the lake with the least effort. Which solution should they use?
Choose an answer
Tap an option to check your answer.
Correct answer: Create an AWS Database Migration Service (AWS DMS) task for ongoing replication. Set the Oracle database as the source. Set Amazon S3 as the target. Configure the task to write the data in Parquet format..
Why this is the answer
The correct answer is to use AWS DMS. AWS DMS is designed for migrating and continuously replicating databases, making it ideal for ingesting data from an on-premises Oracle database to Amazon S3 with minimal effort. It supports ongoing replication and can write directly to S3 in Parquet format, which is efficient for Athena queries. Using Apache Sqoop on Amazon EMR would require managing an EMR cluster and writing custom Sqoop jobs, which is more effort than DMS. AWS Glue bookmarks are suitable for incremental loads but require developing and maintaining Glue jobs, and DMS offers a more managed solution for this specific scenario. Migrating to Amazon RDS and using Lambda triggers is overly complex for daily ingestion and would involve managing an additional database instance and custom code.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed