nerdexam
AmazonAmazon

DEA-C01 · Question #120

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

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

Data Ingestion and Transformation

Question

A retail company stores data from a product lifecycle management (PLM) application in an on- premises MySQL database. The PLM application frequently updates the database when transactions occur. The company wants to gather insights from the PLM application in near real time. The company wants to integrate the insights with other business datasets and to analyze the combined dataset by using an Amazon Redshift data warehouse. The company has already established an AWS Direct Connect connection between the on- premises infrastructure and AWS. Which solution will meet these requirements with the LEAST development effort?

Options

  • ARun a scheduled AWS Glue extract, transform, and load (ETL) job to get the MySQL database
  • BRun a full load plus CDC task in AWS Database Migration Service (AWS DMS) to continuously
  • CUse the Amazon AppFlow SDK to build a custom connector for the MySQL database to
  • DRun scheduled AWS DataSync tasks to synchronize data from the MySQL database. Set

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

#Database Migration Service (DMS)#Change Data Capture (CDC)#On-premises Integration#Redshift
Full DEA-C01 PracticeBrowse All DEA-C01 Questions