ADD expression for numeric increment in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to increment the attribute 'count' by 1 using the ADD expression.

DynamoDB

UpdateExpression='ADD count [1]'

Drag options to blanks, or click blank then click option'

A'1'

B:one

Cplus 1

D1

Attempts:

3 left

💡 Hint

Common Mistakes

Using quotes around the number, which makes it a string.

Using a placeholder like ':one' without defining it.

The ADD expression in DynamoDB increments a numeric attribute by the given number. The number must be a numeric literal without quotes.

2fill in blank

medium

Complete the code to increment the attribute 'score' by the value of the variable ':inc' using the ADD expression.

DynamoDB

UpdateExpression='ADD score [1]'

Drag options to blanks, or click blank then click option'

A5

B:inc

C'inc'

Dinc

Attempts:

3 left

💡 Hint

Common Mistakes

Using the variable name without colon.

Using quotes around the placeholder.

When using a variable in the ADD expression, you must use a placeholder starting with a colon, like ':inc'.

3fill in blank

hard

Fix the error in the UpdateExpression to correctly increment 'visits' by 2.

DynamoDB

UpdateExpression='ADD visits [1]'

Drag options to blanks, or click blank then click option'

A'2'

Btwo

C2

D:two

Attempts:

3 left

💡 Hint

Common Mistakes

Using a string '2' instead of number 2.

Using an undefined placeholder.

The ADD expression requires a numeric literal without quotes to increment by a fixed number.

4fill in blank

hard

Fill both blanks to increment 'likes' by the placeholder value and define the placeholder in ExpressionAttributeValues.

DynamoDB

UpdateExpression='ADD likes [1]'
ExpressionAttributeValues={{'[2]': 3}}

Drag options to blanks, or click blank then click option'

A:inc

B:val

C:likes

D:num

Attempts:

3 left

💡 Hint

Common Mistakes

Using different placeholder names in UpdateExpression and ExpressionAttributeValues.

Forgetting the colon ':' in placeholder names.

The placeholder used in UpdateExpression must match the key in ExpressionAttributeValues. Here, ':inc' is used in both places.

5fill in blank

hard

Fill all three blanks to increment 'points' by a variable, define the placeholder, and use the correct attribute name.

DynamoDB

UpdateExpression='ADD [1] [2]'
ExpressionAttributeValues={{'[3]': 10}}

Drag options to blanks, or click blank then click option'

Apoints

B:pts

C:points

Dscore

Attempts:

3 left

💡 Hint

Common Mistakes

Using a different attribute name than 'points'.

Mismatch between placeholder in expression and attribute values.

The attribute name is 'points'. The placeholder ':pts' is used in UpdateExpression and defined in ExpressionAttributeValues.

Practice

1. What does the ADD expression do in DynamoDB when updating a numeric attribute?

easy

A. It increases or decreases the numeric attribute by a specified value without reading the current value first.

B. It replaces the numeric attribute with a new value directly.

C. It deletes the numeric attribute from the item.

D. It multiplies the numeric attribute by a specified value.

Solution

1. Step 1: Understand the ADD expression purpose

   The ADD expression in DynamoDB is used to increment or decrement numeric attributes by adding a value.

2. Step 2: Compare with other operations

   Unlike SET which replaces values, ADD modifies the existing numeric value by adding to it without reading it first.

3. Final Answer:

   It increases or decreases the numeric attribute by a specified value without reading the current value first. -> Option A

4. Quick Check:

   ADD expression updates numeric attributes by adding value [OK]

Hint: ADD changes numbers by adding without reading current value [OK]

Common Mistakes:

• Thinking ADD replaces the value instead of adding
• Confusing ADD with DELETE operation
• Assuming ADD multiplies the number

2. Which of the following is the correct syntax to increment a numeric attribute score by 5 using the ADD expression in DynamoDB UpdateExpression?

easy

A. SET score ADD 5

B. SET score = score + 5

C. ADD score '5'

D. ADD score :inc

Solution

1. Step 1: Recall DynamoDB UpdateExpression syntax for ADD

   The ADD expression requires the attribute name followed by a placeholder for the value, like ADD score :inc.

2. Step 2: Check other options for syntax errors

   SET score = score + 5 uses SET with arithmetic which is invalid. ADD score '5' uses a string literal which is invalid for ADD. SET score ADD 5 mixes SET and ADD incorrectly.

3. Final Answer:

   ADD score :inc -> Option D

4. Quick Check:

   Correct ADD syntax uses attribute and value placeholder [OK]

Hint: Use ADD attribute :value with placeholder for increment [OK]

Common Mistakes:

• Using SET with arithmetic instead of ADD
• Using a string literal instead of numeric placeholder
• Mixing SET and ADD keywords incorrectly

3. Given the following DynamoDB update code snippet:

UpdateExpression: "ADD inventory :inc",
ExpressionAttributeValues: {":inc": 3}

If the current inventory value is 7, what will be the new value after the update?

medium

A. 3

B. Error: Cannot add without reading value

C. 10

D. 7

Solution

1. Step 1: Understand ADD increments current value

   The ADD expression adds the given value (3) to the existing attribute value (7).

2. Step 2: Calculate the new value

   7 + 3 = 10, so the new inventory value will be 10.

3. Final Answer:

   10 -> Option C

4. Quick Check:

   7 + 3 = 10 after ADD update [OK]

Hint: ADD adds value to current number, no read needed [OK]

Common Mistakes:

• Assuming ADD replaces value instead of adding
• Thinking ADD requires reading current value first
• Choosing the original value instead of updated

4. You wrote this DynamoDB update:

UpdateExpression: "ADD count :val",
ExpressionAttributeValues: {":val": "2"}

But it fails with a validation error. What is the most likely cause?

medium

A. The attribute name 'count' is reserved and cannot be used.

B. The value for :val is a string instead of a number.

C. ADD expression cannot be used with numeric attributes.

D. ExpressionAttributeValues must not use colons in keys.

Solution

1. Step 1: Check the type of ExpressionAttributeValues

   The value for :val is given as a string "2" instead of a numeric type.

2. Step 2: Understand ADD requires numeric values

   ADD expression only works with numbers, so passing a string causes a validation error.

3. Final Answer:

   The value for :val is a string instead of a number. -> Option B

4. Quick Check:

   ADD needs numeric value, not string [OK]

Hint: Ensure increment value is numeric, not string [OK]

Common Mistakes:

• Passing increment as string instead of number
• Misunderstanding reserved words error
• Incorrectly formatting ExpressionAttributeValues keys

5. You want to decrement a user's loginAttempts count by 1 using DynamoDB's ADD expression. Which UpdateExpression and ExpressionAttributeValues correctly achieve this?

hard

A. UpdateExpression: "ADD loginAttempts :dec", ExpressionAttributeValues: {":dec": -1}

B. UpdateExpression: "ADD loginAttempts '-1'", ExpressionAttributeValues: {}

C. UpdateExpression: "SET loginAttempts = loginAttempts - 1", ExpressionAttributeValues: {}

D. UpdateExpression: "ADD loginAttempts :dec", ExpressionAttributeValues: {":dec": 1}

Solution

1. Step 1: Use ADD with a negative number to decrement

   To decrease a numeric attribute, ADD accepts a negative value as the increment.

2. Step 2: Check syntax correctness

   UpdateExpression: "ADD loginAttempts :dec", ExpressionAttributeValues: {":dec": -1} correctly uses a placeholder :dec with value -1, which is valid syntax.

3. Step 3: Eliminate incorrect options

   UpdateExpression: "ADD loginAttempts '-1'", ExpressionAttributeValues: {} uses a string literal '-1' which is invalid for ADD. UpdateExpression: "SET loginAttempts = loginAttempts - 1", ExpressionAttributeValues: {} uses SET with arithmetic which is not allowed. UpdateExpression: "ADD loginAttempts :dec", ExpressionAttributeValues: {":dec": 1} adds +1, which increments instead of decrementing.

4. Final Answer:

   UpdateExpression: "ADD loginAttempts :dec", ExpressionAttributeValues: {":dec": -1} -> Option A

5. Quick Check:

   Use ADD with negative value to decrement [OK]

Hint: Use ADD with negative number placeholder to decrement [OK]

Common Mistakes:

• Trying to use SET with arithmetic expressions
• Using string literal for decrement value
• Using positive number to decrement