DEA-C01 Data Store Management Practice Question
Network Topology
An application uses the 'orders' DynamoDB table with the schema and provisioned throughput shown in the exhibit. The application frequently queries by customer_id (range key) without specifying the order_id (partition key). What is the most likely impact on performance?
⚠ Common exam trap
Watch out — candidates often assume the sort key alone can be used for efficient queries, forgetting that DynamoDB's indexing requires the partition key to be specified for a Query operation.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Queries will require a full table scan, consuming significant read capacity.
The application queries by customer_id (the sort key) without specifying order_id (the partition key). In DynamoDB, a Query operation requires the partition key to be specified; without it, the only way to retrieve items is a full table Scan, which reads every item in the table. This consumes read capacity proportional to the entire table size, leading to high latency and cost.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Queries will require a full table scan, consuming significant read capacity.
Why this is correct
Without partition key, DynamoDB scans the entire table.
- ✗
Queries will be throttled because the table does not have a global secondary index.
Why it's wrong here
Throttling may occur due to high read consumption, but not directly due to missing GSI.
- ✗
Queries will be fast because the sort key is indexed.
Why it's wrong here
The sort key is only efficient within a partition key.
- ✗
Queries will cause hot partitions on the table.
Why it's wrong here
Hot partitions are caused by uneven access patterns, not by missing partition key.
Go deeper
Related to this question
About these practice questions
Courseiva writes every DEA-C01 question from scratch — 1,711 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DEA-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DEA-C01 exam.