🔥 40% Off Crucial Exams Memberships — This Week Only

3 days, 8 hours remaining!
Crucial Exams

AWS Certified Data Engineer Associate DEA-C01 Practice Question

A team ingests IoT telemetry into a DynamoDB table that uses device_id as the partition key and event_time as the sort key. Six months later, product managers request dashboards that aggregate events by firmware_version across all devices. The solution must keep the existing workload online, avoid full table scans, and minimize additional cost and operational overhead. Which change to the current data model best meets these requirements?

  • Provision a second DynamoDB table keyed by firmware_version and replicate updates from the original table by using DynamoDB Streams and AWS Lambda.

  • Create a local secondary index that uses firmware_version as the sort key while retaining device_id as the partition key.

  • Export the DynamoDB table to Amazon S3 and load the data into an Amazon Redshift cluster, then run SQL queries for the dashboards.

  • Add a global secondary index with firmware_version as the partition key and event_time as the sort key, projecting only the attributes required for the dashboards.

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