Query with sort key conditions in DynamoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of a sort key condition in a DynamoDB query?

A sort key condition helps filter the results within a partition by specifying criteria on the sort key, such as equality, range, or prefix matching.

beginner

Which operator would you use to find items where the sort key is greater than a certain value?

You would use the '>' operator in the KeyConditionExpression to find items with a sort key greater than the specified value.

intermediate

Explain the difference between '=' and 'begins_with' in sort key conditions.

'=' checks for exact match of the sort key value, while 'begins_with' checks if the sort key starts with a specified prefix, allowing partial matching.

intermediate

Can you use multiple conditions on the sort key in a single DynamoDB query?

Yes, you can combine conditions using operators like BETWEEN to specify a range or multiple criteria on the sort key.

beginner

What happens if you omit the sort key condition in a DynamoDB query on a table with a composite primary key?

If you omit the sort key condition, the query will return all items with the specified partition key, which might be a large result set.

Which of the following is a valid sort key condition in DynamoDB?

A SortKey = :value

B SortKey != :value

C SortKey LIKE '%value%'

D SortKey CONTAINS :value

DynamoDB supports '=' for exact match on sort key, but does not support '!=' or SQL LIKE syntax in KeyConditionExpression.

What does the 'begins_with' function do in a sort key condition?

A Checks if the sort key starts with a value

B Checks if the sort key ends with a value

C Checks if the sort key contains a value anywhere

D Checks if the sort key equals a value

'begins_with' checks if the sort key starts with the specified prefix.

Which operator allows you to query items with sort keys between two values?

A LIKE

B IN

C BETWEEN

D NOT BETWEEN

'BETWEEN' is used to specify a range condition on the sort key.

If you want to query items with sort key greater than 100, which condition is correct?

A SortKey = :val

B SortKey >= :val

C SortKey < :val

D SortKey > :val

'>' operator filters items with sort key greater than the given value.

Can you use 'contains' in a KeyConditionExpression for sort key?

A Yes, it works like 'begins_with'

B No, 'contains' is not allowed in KeyConditionExpression

C Yes, but only for partition key

D Yes, but only with numeric sort keys

'contains' is not supported in KeyConditionExpression; it can be used in FilterExpression instead.

Describe how to use sort key conditions in a DynamoDB query to filter results within a partition.

Think about how you can specify exact or range matches on the sort key.

Explain the difference between filtering with sort key conditions and using FilterExpression in DynamoDB queries.

Consider when DynamoDB applies each filter and how it affects efficiency.