Why CRUD operations are foundational in DynamoDB - Challenge Your Understanding

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding CRUD basics in DynamoDB

Which of the following best explains why CRUD operations are foundational in DynamoDB?

A CRUD operations allow you to create, read, update, and delete data, which covers all basic ways to manage information in a database.

B CRUD operations are only used for creating data and do not support reading or deleting data.

C CRUD operations are advanced features that only apply to relational databases, not DynamoDB.

D CRUD operations are used to design the database schema but do not affect data manipulation.

💡 Hint

Think about the main actions you do when working with any data storage.

CRUD stands for Create, Read, Update, and Delete. These are the four basic operations that let you manage data in DynamoDB or any database.

❓ query_result

intermediate

Result of a DynamoDB PutItem operation

What will be the result of this DynamoDB PutItem operation if the item already exists?

{
  TableName: "Users",
  Item: { "UserID": { S: "123" }, "Name": { S: "Alice" } }
}

A The existing item with UserID '123' will be replaced with the new item.

B The operation will update only the 'Name' attribute without replacing the entire item.

C The new item will be added alongside the existing item, creating duplicates.

D The operation will fail with a ConditionalCheckFailedException.

💡 Hint

Consider what PutItem does by default when the key already exists.

PutItem replaces the entire item if the primary key already exists in the table.

📝 Syntax

advanced

Correct syntax for updating an item in DynamoDB

Which of the following is the correct syntax to update the 'Age' attribute to 30 for a user with UserID '123'?

A

{
  TableName: "Users",
  Key: { "UserID": { S: "123" } },
  UpdateExpression: "SET Age = age",
  ExpressionAttributeValues: { ":age": 30 }
}

B

{
  TableName: "Users",
  Key: { "UserID": "123" },
  UpdateExpression: "SET Age = 30"
}

C

{
  TableName: "Users",
  Key: { "UserID": { S: "123" } },
  UpdateExpression: "SET Age = :age",
  ExpressionAttributeValues: { ":age": { N: "30" } }
}

D

{
  TableName: "Users",
  Key: { "UserID": { S: "123" } },
  UpdateExpression: "Age = 30"
}

💡 Hint

Remember to use ExpressionAttributeValues with the correct data types and the SET keyword in UpdateExpression.

Option C correctly uses UpdateExpression with SET and ExpressionAttributeValues with the number type.

❓ optimization

advanced

Optimizing read operations in DynamoDB

You want to read multiple items by their primary keys efficiently. Which DynamoDB operation is best suited for this?

A Use Query operation without specifying keys to get all items.

B Use multiple GetItem calls in a loop to fetch each item individually.

C Use Scan operation to read all items and filter the needed keys in your code.

D Use BatchGetItem to retrieve multiple items in a single request.

💡 Hint

Think about how to reduce the number of requests when fetching many items.

BatchGetItem lets you retrieve multiple items by keys in one request, making it efficient.

🔧 Debug

expert

Identifying the error in a DeleteItem request

What error will this DeleteItem request cause?

{
  TableName: "Users",
  Key: { "UserID": "123" }
}

A ConditionalCheckFailedException because no condition was specified.

B ValidationException because the key attribute value is missing the data type wrapper.

C ResourceNotFoundException because the table does not exist.

D No error; the item will be deleted successfully.

💡 Hint

Check how DynamoDB expects key attribute values to be formatted.

DynamoDB requires attribute values to be wrapped with their data types, like { S: "123" } for strings.