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.

Practice

1. What does the CRUD acronym stand for in database operations?

easy

A. Calculate, Remove, Upload, Download

B. Create, Read, Update, Delete

C. Copy, Run, Undo, Drop

D. Connect, Retrieve, Use, Delete

Solution

1. Step 1: Understand each letter in CRUD

   CRUD stands for the four basic operations to manage data: Create, Read, Update, and Delete.

2. Step 2: Match the correct full form

   Among the options, only Create, Read, Update, Delete correctly lists these four operations.

3. Final Answer:

   Create, Read, Update, Delete -> Option B

4. Quick Check:

   CRUD = Create, Read, Update, Delete [OK]

Hint: Remember CRUD as the four main data actions [OK]

Common Mistakes:

• Confusing CRUD with unrelated terms
• Mixing up the order of operations
• Thinking CRUD includes 'Copy' or 'Calculate'

2. Which of the following is the correct syntax to add a new item in DynamoDB using the AWS SDK?

easy

A. dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } })

B. dynamodb.getItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

C. dynamodb.deleteItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

D. dynamodb.updateItem({ TableName: 'Users', Key: { 'UserId': { S: '123' } } })

Solution

1. Step 1: Identify the operation to add a new item

   Adding a new item uses the putItem method in DynamoDB.

2. Step 2: Match the correct syntax

   dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } }) uses putItem with the correct parameters to add an item.

3. Final Answer:

   dynamodb.putItem({ TableName: 'Users', Item: { 'UserId': { S: '123' } } }) -> Option A

4. Quick Check:

   Adding item = putItem [OK]

Hint: Use putItem to create new data in DynamoDB [OK]

Common Mistakes:

• Using getItem or deleteItem to add data
• Confusing Key with Item in parameters
• Missing TableName or Item fields

3. Given the following DynamoDB operation, what will be the result?

const params = { TableName: 'Books', Key: { 'ISBN': { S: '978-1234567890' } } };
const data = await dynamodb.getItem(params).promise();
console.log(data.Item);

medium

A. It will cause a syntax error

B. It will delete the item with ISBN '978-1234567890'

C. It will update the item with ISBN '978-1234567890'

D. It will print the item with ISBN '978-1234567890' if it exists

Solution

1. Step 1: Understand the getItem operation

   The getItem method retrieves an item by its key from the table.

2. Step 2: Analyze the code output

   The code logs data.Item, which will be the item with the given ISBN if it exists, or undefined if not.

3. Final Answer:

   It will print the item with ISBN '978-1234567890' if it exists -> Option D

4. Quick Check:

   getItem returns item data [OK]

Hint: getItem fetches data; console.log prints it [OK]

Common Mistakes:

• Thinking getItem deletes or updates data
• Assuming syntax error due to async/await
• Confusing Key with Item in parameters

4. You wrote this DynamoDB update code but it throws an error:

const params = {
  TableName: 'Users',
  Key: { 'UserId': { S: 'abc123' } },
  UpdateExpression: 'set Age = :age',
  ExpressionAttributeValues: { ':age': 30 }
};
await dynamodb.updateItem(params).promise();

What is the likely cause of the error?

medium

A. ExpressionAttributeValues must use DynamoDB types like { ':age': { N: '30' } }

B. UpdateExpression should be 'update Age = :age'

C. Key should be inside Item property

D. TableName is missing

Solution

1. Step 1: Check ExpressionAttributeValues format

   DynamoDB expects attribute values to be typed, e.g., numbers as { N: '30' }.

2. Step 2: Identify the error cause

   The code uses a plain number 30 instead of the typed format, causing a validation error.

3. Final Answer:

   ExpressionAttributeValues must use DynamoDB types like { ':age': { N: '30' } } -> Option A

4. Quick Check:

   Use typed values in ExpressionAttributeValues [OK]

Hint: Always wrap values with DynamoDB types in updates [OK]

Common Mistakes:

• Using raw JS values instead of typed DynamoDB values
• Wrong UpdateExpression syntax
• Misplacing Key inside Item

5. You want to delete a user from a DynamoDB table only if their account is inactive. Which approach correctly combines CRUD operations to achieve this safely?

hard

A. Use putItem to overwrite the user with an empty item

B. Use updateItem to set AccountStatus to 'deleted' without conditions

C. Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive'

D. Use getItem to read then deleteItem without conditions

Solution

1. Step 1: Understand safe deletion with conditions

   To delete only if a condition is met, use deleteItem with a ConditionExpression.

2. Step 2: Evaluate options for correctness

   Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive' uses deleteItem with a condition to delete only inactive accounts, which is safe and efficient.

3. Final Answer:

   Use deleteItem with a ConditionExpression checking if AccountStatus = 'inactive' -> Option C

4. Quick Check:

   Conditional delete = deleteItem + ConditionExpression [OK]

Hint: Use ConditionExpression to safely delete items [OK]

Common Mistakes:

• Deleting without checking account status
• Using updateItem to delete data
• Overwriting with putItem instead of deleting