DELETE expression for set removal in DynamoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

Removing an element from a set attribute

Given a DynamoDB item with an attribute colors as a set {"red", "blue", "green"}, which UpdateExpression will remove "blue" from the set?

DynamoDB

UpdateExpression = "DELETE colors :val"
ExpressionAttributeValues = {":val": {"blue"}}

A }}"eulb"{ :"lav:"{ = seulaVetubirttAnoisserpxE htiw "lav: sroloc ETELED" = noisserpxEetadpU

B UpdateExpression = "REMOVE colors["blue"]" with no ExpressionAttributeValues

C UpdateExpression = "SET colors = colors - :val" with ExpressionAttributeValues = {":val": {"blue"}}

D UpdateExpression = "DELETE colors :val" with ExpressionAttributeValues = {":val": {"blue"}}

💡 Hint

Use the DELETE expression with a set value to remove elements from a set attribute.

In DynamoDB, to remove an element from a set attribute, you use the DELETE update expression with the element wrapped in a set. Option D correctly uses DELETE with a set containing "blue". Option D is invalid syntax. Option D uses SET with subtraction which is not valid for sets. Option D uses a list instead of a set, which is invalid.

❓ query_result

intermediate

Effect of DELETE expression on non-existing set element

If you run the following update on a DynamoDB item where tags is a set {"urgent", "todo"} and you try to DELETE "completed" from it, what will be the resulting tags attribute?

DynamoDB

UpdateExpression = "DELETE tags :val"
ExpressionAttributeValues = {":val": {"completed"}}

A The tags set becomes empty {}

B The tags set remains unchanged as {"urgent", "todo"}

C The update fails with a ConditionalCheckFailedException

D The tags set becomes {"completed"}

💡 Hint

Deleting a non-existing element from a set does not cause an error or change.

When you DELETE an element from a set attribute in DynamoDB, if the element does not exist in the set, the set remains unchanged. No error is thrown. So the tags set stays as {"urgent", "todo"}.

📝 Syntax

advanced

Identify the invalid DELETE expression syntax

Which of the following DynamoDB update expressions will cause a syntax error when trying to remove an element from a set attribute items?

A UpdateExpression = "DELETE items :val" with ExpressionAttributeValues = {":val": ["item1"]}

B UpdateExpression = "DELETE items :val" with ExpressionAttributeValues = {":val": {"item1", "item2"}}

C UpdateExpression = "DELETE items :val" with ExpressionAttributeValues = {":val": {"item1"}}

D }}"1meti"{ :"lav:"{ = seulaVetubirttAnoisserpxE htiw "lav: smeti ETELED" = noisserpxEetadpU

💡 Hint

The DELETE expression requires a set type for the value, not a list.

Option A uses a list ["item1"] instead of a set {"item1"} for ExpressionAttributeValues, which causes a syntax error. Options A, C, and D correctly use sets.

❓ optimization

advanced

Efficiently removing multiple elements from a set attribute

You want to remove multiple elements "a", "b", and "c" from a DynamoDB set attribute letters. Which update expression is the most efficient and correct?

A UpdateExpression = "DELETE letters :vals" with ExpressionAttributeValues = {":vals": {"a", "b", "c"}}

B UpdateExpression = "REMOVE letters["a"], letters["b"], letters["c"]" with no ExpressionAttributeValues

C UpdateExpression = "SET letters = letters - :vals" with ExpressionAttributeValues = {":vals": {"a", "b", "c"}}

D UpdateExpression = "DELETE letters :vals" with ExpressionAttributeValues = {":vals": ["a", "b", "c"]}

💡 Hint

Use DELETE with a set containing all elements to remove them in one operation.

Option A correctly uses DELETE with a set of elements to remove multiple items at once. Option A is invalid syntax. Option A uses SET with subtraction which is not valid for sets. Option A uses a list instead of a set, causing an error.

🧠 Conceptual

expert

Understanding DELETE expression behavior on empty sets

If you DELETE elements from a DynamoDB set attribute and the resulting set becomes empty, what happens to the attribute in the item?

A The attribute remains as an empty set

B The update fails with a ValidationException

C The attribute is removed from the item entirely

D The attribute is set to NULL

💡 Hint

DynamoDB does not store empty sets; empty sets are removed automatically.

DynamoDB does not allow empty sets as attribute values. When a DELETE operation removes all elements from a set, the attribute is removed from the item entirely.

Practice

1. What does the DELETE expression do in DynamoDB when used with a set attribute?

easy

A. Deletes the entire item from the table

B. Replaces the set attribute with a new set

C. Adds new elements to the set attribute

D. Removes specific elements from the set without deleting the entire attribute

Solution

1. Step 1: Understand DELETE expression purpose

   The DELETE expression in DynamoDB is used to remove specific elements from a set attribute, not the whole attribute or item.

2. Step 2: Differentiate from other operations

   Unlike DELETE for items or SET for adding, this expression targets only elements inside the set.

3. Final Answer:

   Removes specific elements from the set without deleting the entire attribute -> Option D

4. Quick Check:

   DELETE expression = remove elements from set [OK]

Hint: DELETE removes elements inside sets, not whole items [OK]

Common Mistakes:

• Confusing DELETE expression with deleting entire item
• Thinking DELETE adds elements instead of removing
• Assuming DELETE replaces the whole set attribute

2. Which of the following is the correct syntax to remove the element 'blue' from a set attribute named colors using the DELETE expression in DynamoDB?

easy

A. UpdateExpression: "REMOVE colors :val", ExpressionAttributeValues: {":val": {"SS": ["blue"]}}

B. UpdateExpression: "DELETE colors :val", ExpressionAttributeValues: {":val": {"SS": ["blue"]}}

C. UpdateExpression: "DELETE colors :val", ExpressionAttributeValues: {":val": {"S": "blue"}}

D. UpdateExpression: "SET colors = colors - :val", ExpressionAttributeValues: {":val": {"SS": ["blue"]}}

Solution

1. Step 1: Identify correct UpdateExpression keyword

   To remove elements from a set, DynamoDB uses the DELETE keyword in UpdateExpression.

2. Step 2: Check ExpressionAttributeValues format

   Since colors is a set of strings, the value must be a string set (SS), not a single string (S).

3. Final Answer:

   UpdateExpression: "DELETE colors :val", ExpressionAttributeValues: {":val": {"SS": ["blue"]}} -> Option B

4. Quick Check:

   DELETE + SS type for set removal [OK]

Hint: Use DELETE with SS type for removing set elements [OK]

Common Mistakes:

• Using REMOVE instead of DELETE for set elements
• Using single string (S) instead of string set (SS)
• Using SET or subtraction syntax incorrectly

3. Given a DynamoDB item with attribute tags as a string set: {"red", "green", "blue"}, what will be the value of tags after applying this update?

UpdateExpression: "DELETE tags :vals"
ExpressionAttributeValues: {":vals": {"SS": ["green", "yellow"]}}

medium

A. {"red", "blue"}

B. {"red", "blue", "yellow"}

C. {"green", "yellow"}

D. {"red", "green", "blue", "yellow"}

Solution

1. Step 1: Understand DELETE effect on sets

   The DELETE expression removes only the elements present in the set attribute that match the given values.

2. Step 2: Remove matching elements from the original set

   Original set is {"red", "green", "blue"}. We remove "green" and "yellow". "yellow" is not in the set, so only "green" is removed.

3. Final Answer:

   {"red", "blue"} -> Option A

4. Quick Check:

   Only existing elements removed from set [OK]

Hint: DELETE removes only existing elements, ignores missing ones [OK]

Common Mistakes:

• Assuming DELETE adds elements instead of removing
• Expecting non-existing elements to be added or cause error
• Confusing DELETE with REMOVE which deletes attributes

4. You wrote this update to remove 'apple' from a set attribute fruits but it fails with a syntax error:

UpdateExpression: "DELETE fruits :val"
ExpressionAttributeValues: {":val": {"S": "apple"}}

What is the error and how to fix it?

medium

A. Use string set (SS) type instead of string (S) for ExpressionAttributeValues

B. Change DELETE to REMOVE keyword in UpdateExpression

C. Remove the colon from :val in ExpressionAttributeValues

D. Use SET keyword instead of DELETE in UpdateExpression

Solution

1. Step 1: Identify data type mismatch

   The attribute fruits is a set, so the value to delete must be a set type (SS), not a single string (S).

2. Step 2: Correct ExpressionAttributeValues type

   Change {":val": {"S": "apple"}} to {":val": {"SS": ["apple"]}} to match set type.

3. Final Answer:

   Use string set (SS) type instead of string (S) for ExpressionAttributeValues -> Option A

4. Quick Check:

   Set removal requires SS type, not S [OK]

Hint: Use SS type for sets in ExpressionAttributeValues [OK]

Common Mistakes:

• Using single string (S) instead of string set (SS)
• Confusing DELETE with REMOVE keyword
• Syntax errors from missing colons or wrong JSON format

5. You have a DynamoDB item with attribute features as a string set: {"wifi", "pool", "parking", "gym"}. You want to remove "pool" and "spa" from this set using a single update. Which is the correct approach and expected result?

hard

A. Use SET to assign a new set without "pool" and "spa"; result set is {"wifi", "parking", "gym"}

B. Use REMOVE with ExpressionAttributeValues {":vals": {"SS": ["pool", "spa"]}}; result set is {"wifi", "parking", "gym"}

C. Use DELETE with ExpressionAttributeValues {":vals": {"SS": ["pool", "spa"]}}; result set is {"wifi", "parking", "gym"}

D. Use DELETE with ExpressionAttributeValues {":vals": {"SS": ["pool", "spa"]}}; result set is {"wifi", "parking", "gym", "spa"}

Solution

1. Step 1: Choose correct update operation for set element removal

   DELETE expression is used to remove specific elements from a set attribute.

2. Step 2: Understand effect of removing non-existing elements

   Removing "pool" removes it from the set; "spa" does not exist, so it is ignored.

3. Step 3: Confirm final set value

   After removal, the set is {"wifi", "parking", "gym"}.

4. Final Answer:

   Use DELETE with ExpressionAttributeValues {":vals": {"SS": ["pool", "spa"]}}; result set is {"wifi", "parking", "gym"} -> Option C

5. Quick Check:

   DELETE removes existing elements, ignores missing [OK]

Hint: DELETE removes only existing set elements in one update [OK]

Common Mistakes:

• Using REMOVE which deletes whole attribute
• Expecting non-existing elements to cause errors
• Using SET without proper value assignment