Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A manufacturing company ingests tens of millions of IoT sensor records per hour from 5,000 machines. Engineers need to query a single machine's readings for any 24-hour period with sub-second latency. Data must be kept in a hot tier for 30 days and then automatically moved to low-cost storage and later exported to Amazon S3 for offline analytics. Which AWS managed data store provides the simplest and most cost-effective solution?

  • Ingest the stream into Amazon Kinesis Data Streams with extended retention and use Kinesis Data Analytics for queries; archive the stream to Amazon S3 with Kinesis Data Firehose.

  • Store the data in an Amazon DynamoDB table using the machine ID as the partition key and a timestamp sort key, enable TTL to delete items after 30 days, and stream expired items to Amazon S3 with AWS Lambda.

  • Load the data into an Amazon RDS for PostgreSQL instance with range-partitioned tables on date and schedule automated backups to Amazon S3 for long-term storage.

  • Use Amazon Timestream, keeping 30 days of data in memory, letting it roll to the magnetic store afterward, and schedule automatic exports of historical data to Amazon S3.

AWS Certified Data Engineer Associate DEA-C01
Data Store Management
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