[Solved] Given a DynamoDB table with UserId as partition key and Timestamp as sort key, what will the following query return?Query: Get all items where UserId = '123' and Timestamp > '2023-01-01' | AWS

AWS - DynamoDB

Given a DynamoDB table with UserId as partition key and Timestamp as sort key, what will the following query return?

Query: Get all items where UserId = '123' and Timestamp > '2023-01-01'

AAll items with UserId '123' regardless of Timestamp

BAll items with UserId '123' and Timestamp after '2023-01-01'

CAll items with Timestamp after '2023-01-01' regardless of UserId

DAn error because sort key cannot be used in queries

Step-by-Step Solution

Solution:

Step 1: Understand query conditions
Query filters items by partition key equality and sort key condition (greater than).
Step 2: Apply conditions to result
Only items with UserId '123' and Timestamp after '2023-01-01' are returned.
Final Answer:
All items with UserId '123' and Timestamp after '2023-01-01' -> Option B
Quick Check:
Query filters by partition and sort key conditions [OK]

Quick Trick: Query requires partition key equality and optional sort key condition [OK]

Common Mistakes:

Master "DynamoDB" in AWS

9 interactive learning modes - each teaches the same concept differently

More AWS Quizzes

Given a DynamoDB table with UserId as partition key and Timestamp as sort key, what will the following query return?