🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 10 hours remaining!

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A mobile gaming company ingests about 20,000 JSON session events per second from players worldwide. Data engineers must store the events so that the latest session for any player can be retrieved in less than 10 ms while writes remain single-digit milliseconds. Traffic varies widely during promotions, and the team wants to avoid manual capacity planning. Which storage solution best meets these performance and operational requirements?

  • Create a DynamoDB table with playerId as the partition key, use on-demand capacity mode, and add a two-node DAX cluster for caching.

  • Write the events to Amazon S3 in Parquet format and query the latest session with Amazon Athena using hourly partitions.

  • Store events in an Amazon RDS MySQL Multi-AZ instance configured with 20,000 provisioned IOPS and a read replica for scaling reads.

  • Stream the data directly into an Amazon Redshift cluster using the native streaming ingestion API and define playerId as the sort key.

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.

Bash, the Crucial Exams Chat Bot
AI Bot