Conditional expressions in DynamoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a conditional expression in DynamoDB?

A conditional expression is a way to specify a condition that must be true for a write operation (like PutItem, UpdateItem, or DeleteItem) to succeed. It helps prevent overwriting or deleting data unintentionally.

beginner

How do you use a conditional expression to check if an attribute exists before updating it?

You use the function attribute_exists(attributeName) in the condition expression. For example, ConditionExpression: "attribute_exists(#pid)" with ExpressionAttributeNames: {"#pid": "ProductID"} ensures the item exists before updating.

beginner

What happens if a conditional expression evaluates to false during a write operation?

The write operation fails and DynamoDB returns a ConditionalCheckFailedException. This means the data is not changed because the condition was not met.

beginner

Name two logical operators you can use in DynamoDB conditional expressions.

You can use AND and OR to combine multiple conditions in a conditional expression.

beginner

How can you check if an attribute does NOT exist in a DynamoDB item using a conditional expression?

Use the function attribute_not_exists(attributeName). For example, ConditionExpression: "attribute_not_exists(#oid)" with ExpressionAttributeNames: {"#oid": "OrderID"} ensures the attribute is missing before proceeding.

What does a conditional expression do in DynamoDB?

A Checks if a condition is true before performing a write operation

B Automatically backs up data

C Indexes data for faster queries

D Encrypts data at rest

Conditional expressions ensure that a write operation only happens if the specified condition is true.

Which function checks if an attribute exists in a DynamoDB item?

A attribute_present()

B attribute_missing()

C attribute_exists()

D attribute_found()

The function attribute_exists() returns true if the attribute is present in the item.

What error does DynamoDB return if a conditional expression fails?

A ProvisionedThroughputExceededException

B ItemNotFoundException

C ValidationException

D ConditionalCheckFailedException

When a conditional expression evaluates to false, DynamoDB returns ConditionalCheckFailedException.

Which logical operator can you use to combine conditions in DynamoDB conditional expressions?

A AND

B NOT

C XOR

D NAND

AND is a logical operator used to combine multiple conditions in DynamoDB conditional expressions.

How do you check that an attribute does NOT exist before inserting a new item?

A attribute_exists(attributeName)

B attribute_not_exists(attributeName)

C attribute_missing(attributeName)

D attribute_null(attributeName)

attribute_not_exists(attributeName) returns true if the attribute is missing, useful to avoid overwriting existing items.

Explain what a conditional expression is in DynamoDB and why it is useful.

Think about how you can protect your data from accidental changes.

Describe how to use attribute_exists and attribute_not_exists functions in conditional expressions.

These functions help control when updates or inserts happen.

Practice

1. What is the main purpose of using ConditionExpression in a DynamoDB operation?

easy

A. To create a new table automatically

B. To speed up the query execution

C. To ensure the operation only happens if certain conditions are met

D. To backup data before updating

Solution

1. Step 1: Understand what ConditionExpression does

   ConditionExpression is used to specify rules that must be true for the operation to proceed.

2. Step 2: Identify the purpose in data safety

   This helps prevent unwanted changes by checking conditions before updating or deleting.

3. Final Answer:

   To ensure the operation only happens if certain conditions are met -> Option C

4. Quick Check:

   ConditionExpression controls operation execution [OK]

Hint: ConditionExpression controls when changes happen [OK]

Common Mistakes:

• Thinking it speeds up queries
• Confusing with table creation
• Assuming it backs up data

2. Which of the following is the correct syntax to use a conditional expression that checks if attribute status equals active in a DynamoDB update?

easy

A. ConditionExpression: "status = 'active'"

B. ConditionExpression: "status != 'active'"

C. ConditionExpression: "status == active"

D. ConditionExpression: "#s = :active" with ExpressionAttributeNames and ExpressionAttributeValues

Solution

1. Step 1: Recognize reserved word handling

   Since status can be a reserved word, use placeholders like #s and :active.

2. Step 2: Correct syntax for equality check

   The expression must use single equals = and placeholders, not direct attribute names or double equals.

3. Final Answer:

   ConditionExpression: "#s = :active" with ExpressionAttributeNames and ExpressionAttributeValues -> Option D

4. Quick Check:

   Use placeholders for reserved words [OK]

Hint: Use placeholders (#, :) for reserved words in conditions [OK]

Common Mistakes:

• Using double equals (==) instead of single equals (=)
• Not using placeholders for reserved words
• Using wrong inequality operator

3. Given this DynamoDB update command snippet:

UpdateExpression: "SET #qty = :newQty"
ConditionExpression: "#qty < :maxQty"
ExpressionAttributeNames: {"#qty": "quantity"}
ExpressionAttributeValues: {":newQty": 10, ":maxQty": 20}

What happens if the current quantity is 25?

medium

A. The update fails because condition is false

B. The update throws a syntax error

C. The update ignores the condition and sets quantity to 10

D. The update succeeds and sets quantity to 10

Solution

1. Step 1: Understand the condition check

   The condition requires current quantity to be less than 20 for update to proceed.

2. Step 2: Compare current quantity with maxQty

   Since current quantity is 25, which is not less than 20, the condition fails.

3. Final Answer:

   The update fails because condition is false -> Option A

4. Quick Check:

   Condition false blocks update [OK]

Hint: Update only if condition is true, else it fails [OK]

Common Mistakes:

• Assuming update ignores condition
• Thinking condition causes syntax error
• Believing update always succeeds

4. You wrote this DynamoDB update:

UpdateExpression: "SET total = :p"
ConditionExpression: "total > :min"
ExpressionAttributeValues: {":p": 100, ":min": 50}

But it returns a validation error. What is the likely cause?

medium

A. Using total directly without placeholder in ConditionExpression

B. Using incorrect operator in ConditionExpression

C. Missing ExpressionAttributeNames for reserved word total

D. Missing comma in ExpressionAttributeValues

Solution

1. Step 1: Check if total is reserved

   total is a reserved word in DynamoDB, so it must use a placeholder like #pr.

2. Step 2: Identify missing placeholder usage

   The ConditionExpression uses total directly, causing validation error.

3. Final Answer:

   Using total directly without placeholder in ConditionExpression -> Option A

4. Quick Check:

   Reserved words need placeholders [OK]

Hint: Always use placeholders for reserved words in conditions [OK]

Common Mistakes:

• Ignoring reserved word rules
• Assuming operators cause error
• Overlooking syntax in ExpressionAttributeValues

5. You want to update a user's score only if the current score is less than 100 and the status is active. Which is the correct ConditionExpression to use?

hard

A. "score < 100 AND status = 'active'" without placeholders

B. "#sc < :maxScore AND #st = :activeStatus" with ExpressionAttributeNames {"#sc": "score", "#st": "status"} and ExpressionAttributeValues {":maxScore": 100, ":activeStatus": "active"}

C. "score <= 100 OR status = 'active'" with placeholders

D. "#sc > :maxScore AND #st = :activeStatus" with placeholders

Solution

1. Step 1: Use placeholders for reserved words

   Both score and status can be reserved, so use #sc and #st.

2. Step 2: Combine conditions correctly

   Use AND to require both conditions: score less than 100 and status equals active.

3. Step 3: Use correct operators and values

   Use < for less than, and equals = for status check with placeholders for values.

4. Final Answer:

   "#sc < :maxScore AND #st = :activeStatus" with ExpressionAttributeNames {"#sc": "score", "#st": "status"} and ExpressionAttributeValues {":maxScore": 100, ":activeStatus": "active"} -> Option B

5. Quick Check:

   Use AND with placeholders for multiple conditions [OK]

Hint: Use AND and placeholders for multiple conditions [OK]

Common Mistakes:

• Using OR instead of AND
• Not using placeholders for reserved words
• Using wrong comparison operators