DEA-C01 · Question #278
A retail company stores point-of-sale transaction data in an Amazon RDS for MySQL database. The company maintains historical sales analytics in Amazon Redshift. The company needs to create daily repor
Sign in or unlock DEA-C01 to reveal the answer and full explanation for question #278. The question stem and answer options stay visible for context.
Question
A retail company stores point-of-sale transaction data in an Amazon RDS for MySQL database. The company maintains historical sales analytics in Amazon Redshift. The company needs to create daily reports that combine the current day's transactions with historical sales patterns for trend analysis. The company requires a solution that provides near real-time insights while minimizing data transfer costs and maintenance overhead. Which solution will meet these requirements?
Options
- AConfigure AWS Database Migration Service (AWS DMS) to continuously replicate data from RDS
- BImplement Amazon Redshift federated queries to directly access RDS for MySQL data and join it
- CUse AWS Glue to create an extract, transform, and load (ETL) pipeline that runs every hour to
- DExport RDS for MySQL data to an Amazon S3 bucket on a regular schedule. Use the COPY
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.