Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A logistics company streams 50,000 vehicle telemetry records per second into AWS. The application must read the latest records for a given vehicle ID in less than 5 ms, automatically purge data older than 7 days, and retain the expired data in Amazon S3 for long-term analytics. Which storage configuration best meets these access and retention requirements with the least operational overhead?

  • Insert the records into an Amazon RDS PostgreSQL database with a composite primary key; schedule a daily DELETE job for aged rows and export snapshots to S3.

  • Load the data into an Amazon Redshift cluster, run a nightly DELETE on rows older than 7 days, and UNLOAD the deleted data to S3 for retention.

  • Store the records in a DynamoDB table with vehicleId as the partition key and timestamp as the sort key, enable DynamoDB TTL for 7 days, and use DynamoDB export to Amazon S3 for archive.

  • Deliver the stream directly to Amazon S3 using Kinesis Data Firehose, query recent data with Amazon Athena, and apply an S3 Lifecycle rule to transition objects after 7 days.

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