QuestionQ30
VerifiedData Ingestion and TransformationA 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?
Community Discussion