AWS Certified Data Engineer - Associate DEA-C01Demo

By Amazon · Question Mode

QuestionQ246

Data Ingestion and Transformation

A retail company must implement a solution that captures data updates from multiple Amazon Aurora MySQL databases. The company must make those updates available for analytics in near real time. The solution must be serverless and need minimal maintenance.

Which solution meets these requirements with the LEAST operational overhead?

  • A Set up AWS Database Migration Service (AWS DMS) tasks that perform schema conversions for each database. Load the changes into Amazon Redshift Serverless.
  • B Use Amazon Managed Streaming for Apache Kafka (Amazon MSK) Connect with Debezium connectors to load data into Amazon Redshift Serverless.
  • C Use AWS Database Migration Service (AWS DMS) to set up binary log replication to Amazon Kinesis Data Streams. Load the data into Amazon Redshift Serverless after schema conversion.
  • D Use Aurora zero-ETL integrations with Amazon Redshift Serverless for each database to load Aurora MySQL changes in Amazon Redshift Serverless.
Explanation

Aurora zero-ETL integrations are fully managed and automatically replicate Aurora MySQL transactional changes into an Amazon Redshift target, including a Redshift Serverless namespace. They provide fresher, near-real-time analytics data without requiring the operation of a separate ETL, streaming, connector, or change-data-capture pipeline.

Learn more

Community Discussion

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