DeleteItem in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to delete an item from the DynamoDB table named 'Users' using the primary key 'UserId'.

DynamoDB

response = table.delete_item(Key={'UserId': [1])

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

AUserId

B'123'

C'UserId'

D123

Attempts:

3 left

💡 Hint

Common Mistakes

Using the key name instead of the key value.

Omitting quotes around string key values.

The key value must be a string matching the primary key value. Here, '123' is the correct string format.

2fill in blank

medium

Complete the code to delete an item from the 'Products' table where the primary key 'ProductId' equals 456.

DynamoDB

response = dynamodb.Table('Products').delete_item(Key=[1])

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

A{'ProductId': 456}

B{'ProductId': '456'}

C{'Id': 456}

D{'ProductId': 'ProductId'}

Attempts:

3 left

💡 Hint

Common Mistakes

Using string quotes around numeric key values.

Using wrong attribute names in the key dictionary.

The key dictionary must use the correct primary key name and the value type must match the table schema. Here, 456 is a number, so no quotes.

3fill in blank

hard

Fix the error in the code to delete an item from the 'Orders' table with 'OrderId' 789.

DynamoDB

response = table.delete_item(Key=[1])

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

A{'OrderId': 789}

B{'OrderId': '789'}

C{OrderId: 789}

D{'orderid': 789}

Attempts:

3 left

💡 Hint

Common Mistakes

Using unquoted attribute names causing syntax errors.

Using wrong case for attribute names.

Using string instead of integer for numeric keys.

The key dictionary must have the attribute name as a string matching the exact case and the value type matching the schema. 'OrderId' with integer 789 is correct.

4fill in blank

hard

Fill both blanks to delete an item from the 'Employees' table where 'EmployeeId' is 101 and return all old attributes.

DynamoDB

response = table.delete_item(Key=[1], ReturnValues=[2])

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

A{'EmployeeId': 101}

BALL_OLD

C'ALL_OLD'

DNONE

Attempts:

3 left

💡 Hint

Common Mistakes

Passing ReturnValues without quotes causing errors.

Using wrong key dictionary format.

The Key must be a dictionary with the correct attribute and value. ReturnValues must be the string 'ALL_OLD' to get the old item back.

5fill in blank

hard

Fill all three blanks to delete an item from the 'Books' table with 'ISBN' '978-3-16-148410-0', conditionally only if 'InStock' is true, and return the old attributes.

DynamoDB

response = table.delete_item(Key=[1], ConditionExpression=[2], ReturnValues=[3])

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

A{'ISBN': '978-3-16-148410-0'}

BAttr('InStock').eq(True)

C'ALL_OLD'

DAttr('InStock') == True

Attempts:

3 left

💡 Hint

Common Mistakes

Using Python equality operator instead of Attr.eq() in ConditionExpression.

Passing ReturnValues without quotes.

Incorrect key dictionary format.

The Key must be a dictionary with the ISBN string. ConditionExpression uses the Attr helper with eq(True) to check InStock. ReturnValues must be 'ALL_OLD' as a string.

Practice

1. What does the DeleteItem operation do in DynamoDB?

easy

A. Deletes all items in a table

B. Reads an item from the table

C. Updates an item in the table

D. Removes a single item from a table using its primary key

Solution

1. Step 1: Understand the purpose of DeleteItem

   DeleteItem is designed to remove exactly one item identified by its primary key from a DynamoDB table.

2. Step 2: Compare with other operations

   Unlike update or read operations, DeleteItem specifically removes the item and does nothing if the item does not exist.

3. Final Answer:

   Removes a single item from a table using its primary key -> Option D

4. Quick Check:

   DeleteItem removes one item [OK]

Hint: DeleteItem removes by primary key only [OK]

Common Mistakes:

• Thinking DeleteItem deletes multiple items
• Confusing DeleteItem with UpdateItem
• Assuming DeleteItem reads data

2. Which of the following is the correct syntax to delete an item with primary key {"UserId": "123"} from a DynamoDB table named Users using AWS SDK for JavaScript v3?

easy

A. await client.deleteItem({ TableName: "Users", Key: { UserId: "123" } });

B. await client.send(new DeleteItemCommand({ TableName: "Users", Key: { UserId: { S: "123" } } }));

C. client.delete({ TableName: "Users", Key: { UserId: { S: "123" } } });

D. await client.send(new DeleteCommand({ TableName: "Users", Key: { UserId: "123" } }));

Solution

1. Step 1: Identify correct AWS SDK v3 syntax

   In AWS SDK v3 for JavaScript, DeleteItemCommand is used with client.send and the Key attribute must specify the data type (S for string).

2. Step 2: Check each option

   await client.send(new DeleteItemCommand({ TableName: "Users", Key: { UserId: { S: "123" } } })); correctly uses DeleteItemCommand with Key including data type. Distractors use incorrect method names like deleteItem or delete, omit data types, lack await or send, or use DeleteCommand which is not valid.

3. Final Answer:

   await client.send(new DeleteItemCommand({ TableName: "Users", Key: { UserId: { S: "123" } } })); -> Option B

4. Quick Check:

   Correct command and key format = await client.send(new DeleteItemCommand({ TableName: "Users", Key: { UserId: { S: "123" } } })); [OK]

Hint: Use DeleteItemCommand with typed Key in AWS SDK v3 [OK]

Common Mistakes:

• Omitting data type in Key
• Using wrong command name
• Not awaiting the promise

3. Given the following DynamoDB table Products with primary key ProductId, what will be the result of this DeleteItem operation?

await client.send(new DeleteItemCommand({
  TableName: "Products",
  Key: { ProductId: { S: "P100" } }
}));

Assuming the item with ProductId = "P100" exists.

medium

A. The item with ProductId "P100" is removed from the table

B. The item is updated with empty attributes

C. An error is thrown because DeleteItem cannot delete existing items

D. Nothing happens because DeleteItem only works on non-existing items

Solution

1. Step 1: Understand DeleteItem behavior on existing items

   DeleteItem removes the specified item if it exists, identified by the primary key.

2. Step 2: Analyze the given operation

   The command targets ProductId "P100" which exists, so the item will be deleted from the table.

3. Final Answer:

   The item with ProductId "P100" is removed from the table -> Option A

4. Quick Check:

   DeleteItem removes existing item = The item with ProductId "P100" is removed from the table [OK]

Hint: DeleteItem removes existing item by key [OK]

Common Mistakes:

• Thinking DeleteItem updates instead of deletes
• Assuming DeleteItem throws error if item exists
• Believing DeleteItem does nothing on existing items

4. You wrote this code to delete an item but it throws an error:

await client.send(new DeleteItemCommand({
  TableName: "Orders",
  Key: { OrderId: "O123" }
}));

What is the most likely cause of the error?

medium

A. The Key attribute must specify data types like { S: "O123" }

B. TableName is incorrect and must be lowercase

C. DeleteItemCommand cannot be awaited

D. OrderId is not a valid primary key

Solution

1. Step 1: Check the Key format in DeleteItemCommand

   In DynamoDB SDK, the Key must specify attribute values with their data types, e.g., { S: "O123" } for string.

2. Step 2: Identify the error cause

   The code uses { OrderId: "O123" } without data type, causing a validation error.

3. Final Answer:

   The Key attribute must specify data types like { S: "O123" } -> Option A

4. Quick Check:

   Key requires data type = The Key attribute must specify data types like { S: "O123" } [OK]

Hint: Always include data types in Key for DeleteItem [OK]

Common Mistakes:

• Omitting data types in Key
• Assuming TableName case matters
• Not awaiting async calls

5. You want to delete an item only if it exists and has the attribute Status set to "Pending". Which DeleteItem parameter should you use to ensure this conditional delete?

hard

A. Use KeyConditionExpression to filter the item

B. Use ReturnValues: "ALL_OLD" to check the old item

C. Use ConditionExpression: "Status = :val" with ExpressionAttributeValues: { ":val": { S: "Pending" } }

D. Use UpdateExpression to set Status to null before deleting

Solution

1. Step 1: Understand conditional deletes in DynamoDB

   DeleteItem supports a ConditionExpression to delete only if the condition is true.

2. Step 2: Apply condition to Status attribute

   Using ConditionExpression "Status = :val" with ExpressionAttributeValues specifying "Pending" ensures deletion only if Status is "Pending".

3. Step 3: Evaluate other options

   ReturnValues returns old data but does not conditionally delete. KeyConditionExpression is for queries, not deletes. UpdateExpression is for updates, not deletes.

4. Final Answer:

   Use ConditionExpression: "Status = :val" with ExpressionAttributeValues: { ":val": { S: "Pending" } } -> Option C

5. Quick Check:

   Conditional delete uses ConditionExpression = Use ConditionExpression: "Status = :val" with ExpressionAttributeValues: { ":val": { S: "Pending" } } [OK]

Hint: Use ConditionExpression to delete conditionally [OK]

Common Mistakes:

• Using KeyConditionExpression in DeleteItem
• Confusing ReturnValues with conditions
• Trying to update before delete