In a DynamoDB single-table design, if items have PK = 'CUSTOMER#456' and SK values like 'INVOICE#2023-05' and 'INVOICE#2023-06', what will a query with KeyConditionExpression: PK = :pk AND begins_with(SK, :skPrefix) return when :pk = 'CUSTOMER#456' and :skPrefix = 'INVOICE#2023-'?

medium📝 query result Q4 of 15

DynamoDB - Access Patterns and Query Optimization

In a DynamoDB single-table design, if items have PK = 'CUSTOMER#456' and SK values like 'INVOICE#2023-05' and 'INVOICE#2023-06', what will a query with KeyConditionExpression: PK = :pk AND begins_with(SK, :skPrefix) return when :pk = 'CUSTOMER#456' and :skPrefix = 'INVOICE#2023-'?

AOnly the invoice with SK exactly matching 'INVOICE#2023-'

BAll invoices for customer 456 from 2023, including May and June

CAll items with PK 'CUSTOMER#456' regardless of SK

DNo items, because begins_with cannot be used with SK

Step-by-Step Solution

Solution:

Step 1: Understand begins_with on SK
The begins_with function filters sort keys starting with the given prefix.
Step 2: Apply to given SK values
SK values 'INVOICE#2023-05' and 'INVOICE#2023-06' both start with 'INVOICE#2023-'.
Final Answer:
All invoices for customer 456 from 2023, including May and June -> Option B
Quick Check:
Check SK prefixes match [OK]

Quick Trick: begins_with matches all SK starting with prefix [OK]

Common Mistakes:

MISTAKES

Assuming begins_with matches exact SK only
Ignoring the prefix filtering on SK
Thinking begins_with cannot be used with sort keys

Master "Access Patterns and Query Optimization" in DynamoDB

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions

More DynamoDB Quizzes

In a DynamoDB single-table design, if items have PK = 'CUSTOMER#456' and SK values like 'INVOICE#2023-05' and 'INVOICE#2023-06', what will a query with KeyConditionExpression: PK = :pk AND begins_with(SK, :skPrefix) return when :pk = 'CUSTOMER#456' and :skPrefix = 'INVOICE#2023-'?

Step 1: Understand begins_with on SK

Step 2: Apply to given SK values

Final Answer:

Quick Check:

Want More Practice?