AWS Certified Data Engineer - Associate DEA-C01 — Topic 1 Question 259

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?

Accepted Answer

Correct answer: B. The correct answer is B. Option B: Implement Amazon Redshift federated queries to directly access RDS for MySQL data and join it with existing Redshift tables in a single query. Amazon RDS is a managed relational database that handles patching, backups and failover. Amazon Redshift is a managed petabyte-scale data warehouse for complex analytical queries. This option meets the real-time / low-latency performance requirement.

AWS Certified Data Engineer - Associate DEA-C01 — Question 259