DEA-C01 · Question #155
A company maintains a data warehouse in an on-premises Oracle database. The company wants to build a data lake on AWS. The company wants to load data warehouse tables into Amazon S3 and synchronize…
The correct answer is A. Use an AWS Database Migration Service (AWS DMS) full load plus CDC job to load tables that. The most operationally efficient solution to load on-premises Oracle data into Amazon S3, performing an initial full load and daily incremental synchronization, is to use AWS DMS.
Question
A company maintains a data warehouse in an on-premises Oracle database. The company wants to build a data lake on AWS. The company wants to load data warehouse tables into Amazon S3 and synchronize the tables with incremental data that arrives from the data warehouse every day. Each table has a column that contains monotonically increasing values. The size of each table is less than 50 GB. The data warehouse tables are refreshed every night between 1 AM and 2 AM. A business intelligence team queries the tables between 10 AM and 8 PM every day. Which solution will meet these requirements in the MOST operationally efficient way?
Options
- AUse an AWS Database Migration Service (AWS DMS) full load plus CDC job to load tables that
- BUse an AWS Glue Java Database Connectivity (JDBC) connection. Configure a job bookmark for
- CUse an AWS Database Migration Service (AWS DMS) full load migration to load the data
- DUse AWS Glue to load a full copy of the data warehouse tables into Amazon S3 every day.
How the community answered
(26 responses)- A58% (15)
- B23% (6)
- C8% (2)
- D12% (3)
Why each option
The most operationally efficient solution to load on-premises Oracle data into Amazon S3, performing an initial full load and daily incremental synchronization, is to use AWS DMS.
AWS Database Migration Service (AWS DMS) is specifically designed for migrating databases to AWS. A full load plus Change Data Capture (CDC) job will perform an initial full transfer of all existing data to S3 and then continuously replicate subsequent changes, ensuring daily incremental synchronization using the monotonically increasing column for efficient tracking.
While AWS Glue with JDBC and job bookmarks can handle incremental data, AWS DMS is a specialized service for database migration and replication that often provides a more streamlined and operationally efficient approach for continuous data synchronization directly from a database.
An AWS DMS full load migration without CDC would only perform the initial transfer and would not provide the daily incremental synchronization required.
Using AWS Glue to load a full copy of 50 GB tables every day into Amazon S3 would be highly inefficient and incur unnecessary compute and storage costs, especially when only incremental changes are needed after the initial load.
Concept tested: AWS DMS for full load and CDC to S3
Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Task.CDC.html
Topics
Community Discussion
No community discussion yet for this question.