QuestionQ93

VerifiedData Ingestion and Transformation

A company produces reports from 30 tables in an Amazon Redshift data warehouse. Its data source is an operational Amazon Aurora MySQL database containing 100 tables. At present, the company refreshes all Aurora data into Amazon Redshift hourly, causing report-generation delays.

Which combination of steps meets these requirements with the LEAST operational overhead?

Choose two
Explanation

An Aurora MySQL zero-ETL integration provides managed, continuous replication into Amazon Redshift, and data filters can limit replication to the required tables. The integration requires a destination database to be created in Amazon Redshift; that database contains the replicated Aurora data for querying. This avoids operating DMS replication tasks or scheduled Glue jobs.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!