Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A financial company runs a 500 GB on-premises MySQL 5.7 database that produces about 1,000 write transactions per second. The data engineering team must ingest every change into Amazon Kinesis Data Streams within 1 minute so a downstream application can perform near-real-time analytics. The solution must let the team replay the data if the consumer application fails and should require the least operational effort. Which approach meets these requirements?

  • Create an AWS DMS replication instance with a MySQL source endpoint and a Kinesis Data Streams target endpoint. Configure a full-load-plus-CDC task, enable StreamMode, specify a partition-key expression, and set the stream retention period to 24 hours.

  • Set up AWS DataSync to copy hourly database backups to Amazon S3 and launch an Amazon EMR cluster that streams the copied files into Amazon Kinesis Data Streams.

  • Use AWS DMS to migrate the database to Amazon S3 with a full-load-only task. Configure Amazon S3 event notifications to start an AWS Glue job that writes new objects to Kinesis Data Streams.

  • Deploy an AWS Lambda function that reads MySQL binary logs by using the mysqlbinlog utility and publishes each event to Amazon Kinesis Data Streams. Trigger the function on a fixed schedule with Amazon EventBridge.

AWS Certified Data Engineer Associate DEA-C01
Data Ingestion and Transformation
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot