Quick Answer
The correct approach is to use the Query operation with a KeyConditionExpression that specifies the partition key and a range condition on the sort key. This is because DynamoDB’s Query API is purpose-built to retrieve items sharing the same partition key, and when a sort key like ‘timestamp’ is defined, you can apply comparison operators (e.g., BETWEEN, >=, <=) directly within the KeyConditionExpression to filter by a date range. On the AWS Certified Data Engineer Associate DEA-C01 exam, this scenario tests your understanding of DynamoDB’s access patterns and the critical distinction between Query and Scan—a common trap is attempting a Scan with a filter, which is inefficient and costly. Remember that Query is always the optimal choice when you know the partition key and need to narrow results by sort key attributes. Memory tip: “Partition pinpoints, sort key sorts”—the partition key gets you to the right group, and the sort key condition trims the results.
This DEA-C01 practice question tests your understanding of data store management. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A company has a DynamoDB table with a partition key of 'user_id' and a sort key of 'timestamp'. They need to query all items for a user within a date range. Which query operation should be used?
BatchGetItem with multiple keys
Why wrong: BatchGetItem retrieves specific items, not a range query.
Query with KeyConditionExpression on partition key and sort key
Query is efficient for this access pattern.
GetItem with both partition and sort key
Why wrong: GetItem retrieves a single item, not a range.
Scan with FilterExpression
Why wrong: Scan reads all items, which is expensive and slow.
Answer choices
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
Query with KeyConditionExpression on partition key and sort key
The Query operation in DynamoDB is designed to retrieve items based on a specific partition key and an optional sort key condition. Since the table has a partition key of 'user_id' and a sort key of 'timestamp', using Query with a KeyConditionExpression that filters on the partition key (user_id) and a range condition on the sort key (timestamp) is the most efficient and correct approach to get all items for a user within a date range.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Answer analysis
For each option: why learners choose it and why it is or isn't the right answer here.
BatchGetItem with multiple keys
Why it's wrong here
BatchGetItem retrieves specific items, not a range query.
Query with KeyConditionExpression on partition key and sort key
Why this is correct
Query is efficient for this access pattern.
Related concept
Read the scenario before looking for a memorised answer.
GetItem with both partition and sort key
Why it's wrong here
GetItem retrieves a single item, not a range.
Scan with FilterExpression
Why it's wrong here
Scan reads all items, which is expensive and slow.
Common exam traps
The trap here is that candidates often confuse BatchGetItem with Query, thinking BatchGetItem can handle range queries, but BatchGetItem only retrieves items by exact primary key values and cannot filter by sort key conditions.
Detailed technical explanation
DynamoDB's Query operation uses the underlying index's sorted data structure to efficiently locate items with the same partition key and then applies the sort key condition (e.g., BETWEEN, >, <) to return only the matching range. This leverages the table's local secondary index or primary key index to avoid a full table scan, and the results are returned in sorted order by the sort key, which is ideal for time-series data like timestamps. In real-world scenarios, this pattern is commonly used for activity logs or IoT sensor data where you need to retrieve records for a specific user within a time window.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Data Store Management — study guide chapter
Learn the concepts, then practise the questions
Data Store Management practice questions
Targeted practice on this topic area only
All DEA-C01 questions
1,786 questions across all exam domains
AWS Certified Data Engineer Associate DEA-C01 study guide
Full concept coverage aligned to exam objectives
DEA-C01 practice test guide
How to use practice tests most effectively before exam day
Related practice questions
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
Practise DEA-C01 questions linked to Data Ingestion and Transformation.
Practise DEA-C01 questions linked to Data Operations and Support.
Practise DEA-C01 questions linked to Data Security and Governance.
Practise DEA-C01 questions linked to Data Store Management.
Practise DEA-C01 questions linked to DEA-C01 fundamentals.
Practise DEA-C01 questions linked to DEA-C01 scenario.
Practise DEA-C01 questions linked to DEA-C01 troubleshooting.
Practice this exam
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Data Store Management — This question tests Data Store Management — Read the scenario before looking for a memorised answer..
The correct answer is: Query with KeyConditionExpression on partition key and sort key — The Query operation in DynamoDB is designed to retrieve items based on a specific partition key and an optional sort key condition. Since the table has a partition key of 'user_id' and a sort key of 'timestamp', using Query with a KeyConditionExpression that filters on the partition key (user_id) and a range condition on the sort key (timestamp) is the most efficient and correct approach to get all items for a user within a date range.
Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.
Read the scenario before looking for a memorised answer.
About these practice questions
Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →
Keep practising
Last reviewed: Jun 24, 2026
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.
Question Discussion
Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.
Sign in to join the discussion.