QuestionQ47

VerifiedData Ingestion and Transformation

A company uses an Amazon RDS for Oracle database to store data for an ecommerce application. The company requires a solution that makes 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 in the MOST cost-effective manner?

Explanation

AWS DMS can capture changes from an Oracle source and publish selected table records to Amazon Kinesis Data Streams. AWS Lambda can consume Kinesis records and call a REST API with near-real-time processing. A separate AWS DMS task can perform a full load and ongoing change data capture for all tables to Amazon S3, providing low-cost durable storage for future analytics without operating a PostgreSQL database or Redshift cluster.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!