Conditional expressions in DynamoDB - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ query_result

intermediate

What is the output of this conditional expression in DynamoDB?

Consider a DynamoDB table with an item having attribute age = 30. Which conditional expression will evaluate to true for this item?

DynamoDB

ConditionExpression: "age >= :min_age",
ExpressionAttributeValues: {":min_age": {"N": "25"}}

A Evaluates to true because 30 >= 25

B Evaluates to false because 30 is not less than 25

C Syntax error due to missing attribute name

D Evaluates to false because 30 equals 25

💡 Hint

Check if the attribute value meets the condition compared to the provided value.

The condition age >= :min_age checks if the attribute age is greater than or equal to 25. Since 30 is greater than 25, the condition is true.

📝 Syntax

intermediate

Which conditional expression syntax is valid in DynamoDB?

Identify the valid conditional expression syntax for checking if attribute status equals active.

A

ConditionExpression: "status equals :val",
ExpressionAttributeValues: {":val": {"S": "active"}}

B

ConditionExpression: "status == :val",
ExpressionAttributeValues: {":val": {"S": "active"}}

C

ConditionExpression: "status := :val",
ExpressionAttributeValues: {":val": {"S": "active"}}

D

ConditionExpression: "status = :val",
ExpressionAttributeValues: {":val": {"S": "active"}}

💡 Hint

Remember DynamoDB uses single equals = for equality in condition expressions.

DynamoDB condition expressions use = for equality. Double equals ==, equals, or := are invalid syntax.

❓ optimization

advanced

Which conditional expression is more efficient for checking multiple attribute values?

You want to check if attribute category is either books or electronics. Which conditional expression is more efficient?

A

ConditionExpression: "category = :books AND category = :electronics",
ExpressionAttributeValues: {":books": {"S": "books"}, ":electronics": {"S": "electronics"}}

B

ConditionExpression: "category BETWEEN :books AND :electronics",
ExpressionAttributeValues: {":books": {"S": "books"}, ":electronics": {"S": "electronics"}}

C

ConditionExpression: "category IN (:books, :electronics)",
ExpressionAttributeValues: {":books": {"S": "books"}, ":electronics": {"S": "electronics"}}

D

ConditionExpression: "category = :books OR category = :electronics",
ExpressionAttributeValues: {":books": {"S": "books"}, ":electronics": {"S": "electronics"}}

💡 Hint

Consider which expression is simpler and more readable for multiple values.

The IN operator is more efficient and clearer for checking if an attribute matches any value in a list. Using OR works but is longer. AND and BETWEEN are incorrect here.

🔧 Debug

advanced

Why does this conditional expression cause an error?

Given the expression below, why does DynamoDB return a syntax error?

DynamoDB

ConditionExpression: "attribute_exists(#sz) AND #sz = :val",
ExpressionAttributeNames: {"#sz": "size"},
ExpressionAttributeValues: {":val": {"S": "active"}}

A Because <code>attribute_exists</code> cannot be combined with other conditions using AND

B Because <code>size</code> is a reserved word and needs to be replaced with an expression attribute name

C Because <code>ExpressionAttributeValues</code> is missing a value for <code>:size</code>

D Because <code>attribute_exists</code> requires a value to compare

💡 Hint

Check if any attribute names are reserved keywords in DynamoDB.

size is a reserved word in DynamoDB. To use it in expressions, you must use an expression attribute name placeholder like #sz and define it in ExpressionAttributeNames.

🧠 Conceptual

expert

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

When you perform a PutItem or UpdateItem with a conditional expression that evaluates to false, what is the result?

A The write operation is aborted and DynamoDB returns a <code>ConditionalCheckFailedException</code>

B The write operation proceeds but logs a warning internally

C The write operation ignores the condition and updates the item anyway

D The write operation retries automatically until the condition is true

💡 Hint

Think about how DynamoDB enforces conditions to maintain data integrity.

If the condition is false, DynamoDB stops the write and returns a ConditionalCheckFailedException to indicate the condition was not met.