DEA-C01 · Question #225
A retail company stores order information in an Amazon Aurora table named Orders. The company needs to create operational reports from the Orders table with minimal latency. The Orders table…
The correct answer is B. Use the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a. Aurora's zero-ETL integration with Redshift automatically and continuously streams data changes from the Orders table into a Redshift table with virtually no setup or maintenance. You can then define a materialized view in Redshift to join that replicated Orders table with…
Question
A retail company stores order information in an Amazon Aurora table named Orders. The company needs to create operational reports from the Orders table with minimal latency. The Orders table contains billions of rows, and over 100,000 transactions can occur each second. A marketing team needs to join the Orders data with an Amazon Redshift table named Campaigns in the marketing team's data warehouse. The operational Aurora database must not be affected. Which solution will meet these requirements with the LEAST operational effort?
Options
- AUse AWS Database Migration Service (AWS DMS) Serverless to replicate the Orders table to
- BUse the Aurora zero-ETL integration with Amazon Redshift to replicate the Orders table. Create a
- CUse AWS Glue to replicate the Orders table to Amazon Redshift. Create a materialized view in
- DUse federated queries to query the Orders table directly from Aurora. Create a materialized view
How the community answered
(40 responses)- A3% (1)
- B75% (30)
- C8% (3)
- D15% (6)
Explanation
Aurora's zero-ETL integration with Redshift automatically and continuously streams data changes from the Orders table into a Redshift table with virtually no setup or maintenance. You can then define a materialized view in Redshift to join that replicated Orders table with Campaigns. This approach ensures minimal impact on the production Aurora workload and requires far less operational effort than building and managing your own ETL or replication pipelines.
Topics
Community Discussion
No community discussion yet for this question.