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.