[Solved] Consider a DynamoDB table with OrderId as the partition key and OrderDate as the sort key. What is the issue with this query?KeyConditionExpression = "OrderDate = :date" | AWS

AWS - DynamoDB

Consider a DynamoDB table with OrderId as the partition key and OrderDate as the sort key. What is the issue with this query?

KeyConditionExpression = "OrderDate = :date"

AThe query syntax is correct and will return all matching items.

BThe sort key cannot be used in KeyConditionExpression.

CThe attribute name <code>OrderDate</code> is invalid for queries.

DThe query must include the partition key in the KeyConditionExpression.

Step-by-Step Solution

Solution:

Step 1: Understand KeyConditionExpression requirements
Queries require the partition key to be specified in the KeyConditionExpression.
Step 2: Analyze given expression
The expression only filters on the sort key OrderDate, missing the partition key OrderId.
Step 3: Conclusion
Without the partition key, the query is invalid and will fail.
Final Answer:
The query must include the partition key in the KeyConditionExpression. -> Option D
Quick Check:
Partition key mandatory in query condition [OK]

Quick Trick: Queries require partition key condition [OK]

Common Mistakes:

MISTAKES

Master "DynamoDB" in AWS

9 interactive learning modes - each teaches the same concept differently

More AWS Quizzes

Consider a DynamoDB table with OrderId as the partition key and OrderDate as the sort key. What is the issue with this query?