AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ93

Data 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
  • A Use AWS Database Migration Service (AWS DMS) to create a replication task. Select only the required tables.
  • B Create a database in Amazon Redshift that uses the integration.
  • C Create a zero-ETL integration in Amazon Aurora. Select only the required tables.
  • D Use query editor v2 in Amazon Redshift to access the data in Aurora.
  • E Create an AWS Glue job to transfer each required table. Run an AWS Glue workflow to initiate the jobs every 5 minutes.
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!