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

medium📝 Predict Output Q13 of 15

AWS - DynamoDB

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

Query: KeyConditionExpression = "CustomerId = :cid AND InvoiceDate > :date"

Assuming :cid is '123' and :date is '2023-01-01'.

AAll invoices for customer '123' regardless of date.

BAll invoices for customer '123' with dates after January 1, 2023.

CAll invoices for all customers with dates after January 1, 2023.

DAll invoices with dates before January 1, 2023.

Step-by-Step Solution

Solution:

Step 1: Understand KeyConditionExpression
The query filters items where partition key CustomerId equals '123' and sort key InvoiceDate is greater than '2023-01-01'.
Step 2: Interpret the filter effect
This returns all invoices for customer '123' with InvoiceDate after January 1, 2023.
Final Answer:
All invoices for customer '123' with dates after January 1, 2023. -> Option B
Quick Check:
Partition key = '123' AND sort key > '2023-01-01' [OK]

Quick Trick: Partition key filters customer, sort key filters date range [OK]

Common Mistakes:

MISTAKES

Master "DynamoDB" in AWS

9 interactive learning modes - each teaches the same concept differently

Want More Practice?

15+ quiz questions · All difficulty levels · Free

More AWS Quizzes