Multiple actions in one update in DynamoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the result of this DynamoDB update expression?

Given a DynamoDB item with attributes {"count": 5, "tags": ["red", "blue"]}, what will be the value of the item after applying this update expression?

UpdateExpression: "SET count = count + :inc ADD tags :newTags"
ExpressionAttributeValues: {":inc": 3, ":newTags": {"SS": ["green"]}}

A {"count": 8, "tags": ["red", "blue", "green"]}

B {"count": 8, "tags": ["green"]}

C {"count": 3, "tags": ["red", "blue", "green"]}

D {"count": 5, "tags": ["red", "blue"]}

💡 Hint

Remember that ADD adds elements to a set attribute without removing existing ones.

The SET action increments 'count' by 3, changing it from 5 to 8. The ADD action adds 'green' to the 'tags' set, which already contains 'red' and 'blue', resulting in all three tags.

📝 Syntax

intermediate

Which update expression syntax is valid for multiple actions?

Which of the following DynamoDB update expressions correctly combines multiple actions in one statement?

A SET price = :p ADD tags :t REMOVE description

B SET price = :p, ADD tags :t REMOVE description

C SET price = :p; ADD tags :t; REMOVE description

D SET price = :p ADD tags :t, REMOVE description

💡 Hint

Multiple actions are separated by spaces, not commas or semicolons.

In DynamoDB, multiple update actions are combined in one UpdateExpression separated by spaces, without commas or semicolons.

❓ optimization

advanced

Optimizing multiple attribute updates in one request

You want to update three attributes in a DynamoDB item: increment 'views' by 1, add 'new' to a set attribute 'labels', and remove the attribute 'temp'. Which approach is most efficient?

A Send three separate UpdateItem requests, one for each action.

B Use one UpdateItem request with UpdateExpression: 'SET views = views + :inc; ADD labels :newLabels; REMOVE temp'.

C Use one UpdateItem request with UpdateExpression: 'SET views = views + :inc, ADD labels :newLabels, REMOVE temp'.

D Use one UpdateItem request with UpdateExpression: 'SET views = views + :inc ADD labels :newLabels REMOVE temp'.

💡 Hint

Minimize network calls by combining actions in one request with correct syntax.

Combining all actions in one UpdateExpression separated by spaces reduces network overhead and is syntactically correct.

🔧 Debug

advanced

Why does this multiple-action update fail?

You run this update expression:

UpdateExpression: "SET score = score + :val ADD tags :newTags REMOVE tags"
ExpressionAttributeValues: {":val": 10, ":newTags": {"SS": ["urgent"]}}

It returns a validation error. What is the cause?

A The SET action cannot increment a numeric attribute.

B The ADD action requires a numeric value, not a set.

C You cannot ADD and REMOVE the same attribute in one update.

D ExpressionAttributeValues is missing a value for :val.

💡 Hint

Think about conflicting actions on the same attribute in one update.

DynamoDB does not allow ADD and REMOVE actions on the same attribute in a single update request.

🧠 Conceptual

expert

Understanding atomicity of multiple actions in one update

When you perform multiple actions (SET, ADD, REMOVE) in a single DynamoDB UpdateItem request, which statement is true about the operation?

A Each action is applied independently; some may succeed while others fail.

B All actions are applied atomically; either all succeed or none are applied.

C Only the first action is guaranteed to succeed; others are best-effort.

D Actions are queued and applied sequentially with possible partial updates.

💡 Hint

Think about DynamoDB's consistency and atomicity guarantees for UpdateItem.

DynamoDB applies all update actions in a single UpdateItem request atomically, ensuring data integrity.