DEA-C01 · Question #278
DEA-C01 Question #278: Real Exam Question with Answer & Explanation
The correct answer is A: Configure AWS Database Migration Service (AWS DMS) to continuously replicate data from RDS. AWS DMS with ongoing replication (CDC) continuously streams new RDS for MySQL transactions into Amazon Redshift, providing near real-time freshness with minimal maintenance and transferring only changes instead of full batches. Reports can then run in Redshift joining current and
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
Explanation
AWS DMS with ongoing replication (CDC) continuously streams new RDS for MySQL transactions into Amazon Redshift, providing near real-time freshness with minimal maintenance and transferring only changes instead of full batches. Reports can then run in Redshift joining current and historical data without hourly ETL jobs or S3 staging.
Topics
Community Discussion
No community discussion yet for this question.