nerdexam
AmazonAmazon

DEA-C01 · Question #155

DEA-C01 Question #155: Real Exam Question with Answer & Explanation

Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #155. The question stem and answer options stay visible for context.

Data Ingestion and Transformation

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.

Unlock DEA-C01 to see the answer

You've previewed enough free DEA-C01 questions. Unlock DEA-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Data Ingestion#Change Data Capture#AWS DMS#Operational Efficiency
Full DEA-C01 PracticeBrowse All DEA-C01 Questions