Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

An e-commerce company ingests about 100 000 clickstream events per second. Data engineers must store each event with minimal latency and allow customer-support dashboards to fetch the most recent 30 days of events for a single user in milliseconds. The solution must require little operational overhead and automatically remove data older than 30 days. Which storage option best fits these access patterns and requirements?

  • Insert events into an Amazon RDS for PostgreSQL instance with multiple read replicas and schedule daily purges of old rows.

  • Stream events into an Amazon Redshift cluster with sort keys on user ID and event time for analytical queries.

  • Write events as Parquet files to Amazon S3 partitioned by date and query them with Amazon Athena on demand.

  • Store events in an Amazon DynamoDB table keyed by user ID and timestamp, enable on-demand capacity, and configure TTL for 30-day expiry.

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