ADD expression for numeric increment in DynamoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the result of this ADD expression?

Given a DynamoDB item with attribute counter initially set to 5, what will be the value of counter after applying this update expression?

UpdateExpression: "ADD counter :inc"
ExpressionAttributeValues: {":inc": 3}

A 3

B 53

C 8

D 5

💡 Hint

ADD increments the numeric attribute by the given value.

The ADD expression increases the numeric attribute by the specified amount. Starting from 5, adding 3 results in 8.

📝 Syntax

intermediate

Which option is the correct syntax for incrementing a numeric attribute using ADD?

Choose the correct UpdateExpression and ExpressionAttributeValues to increment attribute score by 10 in DynamoDB.

A UpdateExpression: "ADD score :val"; ExpressionAttributeValues: {":val": 10}

B UpdateExpression: "SET score = score + :val"; ExpressionAttributeValues: {":val": 10}

C UpdateExpression: "ADD score + 10"; ExpressionAttributeValues: {}

D UpdateExpression: "ADD score :val"; ExpressionAttributeValues: {":val": "10"}

💡 Hint

ADD requires a numeric value in ExpressionAttributeValues.

Option A uses the correct syntax with ADD and a numeric value. Option A uses SET which is valid but not ADD. Option A is invalid syntax. Option A uses a string instead of a number.

❓ optimization

advanced

Why is using ADD better than SET for numeric increments in DynamoDB?

Consider two update expressions to increment attribute visits by 1:

1) SET visits = visits + :inc
2) ADD visits :inc

Which statement about their behavior is correct?

A SET is atomic and faster because it uses addition in the expression.

B ADD is atomic and faster because it directly increments without reading the current value.

C Both are equally atomic and perform the same internally.

D ADD can only decrement, so SET is better for increments.

💡 Hint

Think about atomicity and performance of ADD vs SET.

ADD is designed for atomic increments and does not require reading the current value, making it more efficient and safer for concurrent updates.

🔧 Debug

advanced

What error occurs with this ADD expression?

Given this update expression:

UpdateExpression: "ADD total :val"
ExpressionAttributeValues: {":val": "5"}

What error will DynamoDB raise?

A SyntaxError: Invalid UpdateExpression

B No error, update succeeds

C TypeError: Cannot add string to number

D ValidationException: The provided value is not a number

💡 Hint

Check the data type of the value used with ADD.

ADD requires a numeric value. Providing a string causes a ValidationException from DynamoDB.

🧠 Conceptual

expert

What happens if the attribute does not exist when using ADD to increment?

If you use the update expression ADD clicks :inc with :inc = 1 on an item that does not have the attribute clicks, what will be the result?

A The attribute <code>clicks</code> is created with value 1

B The update fails with a ConditionalCheckFailedException

C The attribute is created with value 0

D The attribute remains missing and no change occurs

💡 Hint

Think about how ADD behaves with missing numeric attributes.

ADD creates the attribute with the increment value if it does not exist, initializing it to that number.