QuestionQ30

VerifiedData Ingestion and Transformation

A retail company stores point-of-sale transaction data in an Amazon RDS for MySQL database. Historical sales analytics are maintained in Amazon Redshift. The company must create daily reports that combine the current day’s transactions with historical sales patterns for trend analysis. The solution must deliver near-real-time insights while minimizing data-transfer costs and maintenance overhead.

Which solution meets these requirements?

Explanation

Amazon Redshift federated queries can query live data in Amazon RDS for MySQL and join it with data stored in Amazon Redshift. This makes current operational transactions available for reporting without first replicating or loading them into Redshift, which supports near-real-time analysis while avoiding the data movement and ongoing pipeline maintenance of DMS, ETL, or S3-based loading.

Learn more

Community Discussion

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