nerdexam
Amazon

DEA-C01 · Question #280

A company uses an Amazon RDS for Oracle database to store data for an ecommerce application. The company needs a solution to make the data in all tables available for future analytics. The solution…

The correct answer is C. Set up one AWS Database Migration Service (AWS DMS) task to stream the. AWS DMS can stream change data from the Oracle customer_complaints table to Kinesis Data Streams for near real-time processing by a Lambda that calls the REST API, while a separate DMS task delivers all tables to Amazon S3 for future analytics. This achieves both streaming and…

Data Ingestion and Transformation

Question

A company uses an Amazon RDS for Oracle database to store data for an ecommerce application. The company needs a solution to make the data in all tables available for future analytics. The solution must process data from a table named customer_complaints in near real time by using a REST API. Which solution will meet these requirements MOST cost-effectively?

Options

  • AUse AWS Database Migration Service (AWS DMS) to replicate the Oracle database to an
  • BCreate a task in AWS Database Migration Service (AWS DMS) to replicate the Oracle database
  • CSet up one AWS Database Migration Service (AWS DMS) task to stream the
  • DCreate a read replica of the Amazon RDS for Oracle database. Configure an AWS Lambda

How the community answered

(25 responses)
  • A
    12% (3)
  • B
    16% (4)
  • C
    68% (17)
  • D
    4% (1)

Explanation

AWS DMS can stream change data from the Oracle customer_complaints table to Kinesis Data Streams for near real-time processing by a Lambda that calls the REST API, while a separate DMS task delivers all tables to Amazon S3 for future analytics. This achieves both streaming and batch needs with minimal infrastructure and cost.

Topics

#AWS DMS#Kinesis Data Streams#Real-time data ingestion#Data lake architecture

Community Discussion

No community discussion yet for this question.

Full DEA-C01 Practice