Bird
Raised Fist0
DynamoDBquery~20 mins

Fine-grained access control in DynamoDB - Practice Problems & Coding Challenges

Choose your learning style10 modes available
Challenge - 5 Problems
🎖️
Fine-grained Access Master
Get all challenges correct to earn this badge!
Test your skills under time pressure!
❓ query_result
intermediate
2:00remaining
What is the output of this DynamoDB query with fine-grained access control?

Consider a DynamoDB table Orders with items having attributes OrderID, UserID, and Status. A fine-grained access control policy restricts users to see only orders where UserID matches their own ID.

The following query is run by user with UserID = 'user123':

Scan Orders with FilterExpression: UserID = :uid
ExpressionAttributeValues: { ':uid': 'user123' }

Given the table data:

  • {OrderID: 1, UserID: 'user123', Status: 'shipped'}
  • {OrderID: 2, UserID: 'user456', Status: 'pending'}
  • {OrderID: 3, UserID: 'user123', Status: 'delivered'}

What will be the result of this query?

A[{OrderID: 1, UserID: 'user123', Status: 'shipped'}, {OrderID: 3, UserID: 'user123', Status: 'delivered'}]
B[{OrderID: 1, UserID: 'user123', Status: 'shipped'}, {OrderID: 2, UserID: 'user456', Status: 'pending'}, {OrderID: 3, UserID: 'user123', Status: 'delivered'}]
C[]
D[{OrderID: 2, UserID: 'user456', Status: 'pending'}]
Attempts:
2 left
💡 Hint

Think about which items match the filter expression for the user's ID.

🧠 Conceptual
intermediate
1:30remaining
Which DynamoDB feature enables fine-grained access control at the item level?

Which of the following DynamoDB features allows you to restrict user access to specific items based on their attributes?

AProvisioned Throughput settings
BDynamoDB Streams
CGlobal Secondary Indexes
DIAM policies with condition keys on item attributes
Attempts:
2 left
💡 Hint

Think about how AWS IAM can control access based on item content.

📝 Syntax
advanced
2:30remaining
Which IAM policy snippet correctly restricts access to items with partition key 'UserID' equal to the user's ID?

Given a DynamoDB table with partition key UserID, which IAM policy snippet correctly enforces fine-grained access control so that users can only access their own items?

A{ "Effect": "Allow", "Action": "dynamodb:GetItem", "Resource": "arn:aws:dynamodb:region:account-id:table/Orders" }
B{ "Effect": "Allow", "Action": "dynamodb:GetItem", "Resource": "arn:aws:dynamodb:region:account-id:table/Orders", "Condition": { "ForAllValues:StringEquals": { "dynamodb:LeadingKeys": "${aws:username}" } } }
C{ "Effect": "Allow", "Action": "dynamodb:Query", "Resource": "arn:aws:dynamodb:region:account-id:table/Orders", "Condition": { "StringEquals": { "dynamodb:Attributes": "UserID" } } }
D{ "Effect": "Allow", "Action": "dynamodb:Scan", "Resource": "arn:aws:dynamodb:region:account-id:table/Orders", "Condition": { "StringEquals": { "dynamodb:LeadingKeys": "user123" } } }
Attempts:
2 left
💡 Hint

Look for the condition that matches the partition key to the user's identity dynamically.

🔧 Debug
advanced
2:30remaining
Why does this fine-grained access control policy fail to restrict access properly?

A developer wrote this IAM policy to restrict access to items with UserID matching the user's ID, but users can still access all items:

{
  "Effect": "Allow",
  "Action": "dynamodb:GetItem",
  "Resource": "arn:aws:dynamodb:region:account-id:table/Orders",
  "Condition": {
    "StringEquals": {
      "dynamodb:LeadingKeys": "user123"
    }
  }
}

Why does this policy fail to enforce fine-grained access control?

AThe resource ARN is missing the index specification required for fine-grained access control.
BThe action 'dynamodb:GetItem' does not support conditions on 'dynamodb:LeadingKeys'.
CThe condition uses a fixed value 'user123' instead of a variable, so it only allows access to that user, but others are unrestricted.
DThe policy is missing the 'Effect': 'Deny' statement to block other accesses.
Attempts:
2 left
💡 Hint

Consider how the condition value affects different users.

❓ optimization
expert
3:00remaining
How to optimize fine-grained access control for a DynamoDB table with multiple user roles?

You have a DynamoDB table Documents with items containing DocID, OwnerID, and Role attributes. You want to enforce fine-grained access control so that:

  • Owners can read and write their own documents.
  • Users with role 'editor' can read all documents but write only their own.
  • Users with role 'viewer' can only read documents they own.

Which approach best optimizes this access control using IAM policies?

ACreate separate IAM policies for each role using condition keys on <code>OwnerID</code> and <code>Role</code> attributes with <code>dynamodb:LeadingKeys</code> and <code>dynamodb:Attributes</code> conditions.
BUse a single IAM policy allowing all actions on the table and enforce access control only in application code.
CGrant full table access to all users and rely on DynamoDB Streams to audit unauthorized access.
DUse Global Secondary Indexes to separate documents by role and assign policies based on index access.
Attempts:
2 left
💡 Hint

Think about how IAM policies can use conditions to differentiate roles and ownership.

Practice

(1/5)
1. What is the main purpose of fine-grained access control in DynamoDB?
easy
A. To automatically backup data
B. To speed up query performance
C. To restrict access to specific items based on keys
D. To encrypt data at rest

Solution

  1. Step 1: Understand fine-grained access control concept

    Fine-grained access control limits access to individual items or attributes in a DynamoDB table.
  2. Step 2: Identify the main purpose

    This control is used to restrict access based on keys, ensuring users see only their data.
  3. Final Answer:

    To restrict access to specific items based on keys -> Option C
  4. Quick Check:

    Fine-grained access control = restrict by keys [OK]
Hint: Focus on access control by keys, not performance or encryption [OK]
Common Mistakes:
  • Confusing access control with encryption
  • Thinking it improves query speed
  • Assuming it manages backups
2. Which IAM policy condition key is used to enforce fine-grained access control in DynamoDB?
easy
A. dynamodb:LeadingKeys
B. dynamodb:TableName
C. dynamodb:Attributes
D. dynamodb:EncryptionEnabled

Solution

  1. Step 1: Identify IAM condition keys for DynamoDB

    DynamoDB uses specific condition keys in IAM policies to control access.
  2. Step 2: Match condition key for fine-grained access

    The key dynamodb:LeadingKeys restricts access based on partition key values.
  3. Final Answer:

    dynamodb:LeadingKeys -> Option A
  4. Quick Check:

    Fine-grained access uses dynamodb:LeadingKeys [OK]
Hint: Remember 'LeadingKeys' controls item-level access [OK]
Common Mistakes:
  • Choosing TableName which controls table-level access
  • Confusing Attributes with keys
  • Selecting unrelated encryption keys
3. Given this IAM policy snippet, which items can the user access?
{
  "Effect": "Allow",
  "Action": "dynamodb:GetItem",
  "Resource": "arn:aws:dynamodb:us-east-1:123456789012:table/Orders",
  "Condition": {
    "ForAllValues:StringEquals": {
      "dynamodb:LeadingKeys": ["user123"]
    }
  }
}
medium
A. All items in the Orders table
B. Only items with partition key 'user123'
C. Items with any partition key except 'user123'
D. No items, because the policy is invalid

Solution

  1. Step 1: Analyze the IAM policy condition

    The condition restricts access to items where the partition key matches 'user123'.
  2. Step 2: Determine accessible items

    Only items with partition key 'user123' are accessible; others are denied.
  3. Final Answer:

    Only items with partition key 'user123' -> Option B
  4. Quick Check:

    Condition limits to 'user123' keys [OK]
Hint: Check the LeadingKeys value to find accessible items [OK]
Common Mistakes:
  • Assuming access to all items
  • Thinking policy denies all access
  • Ignoring the condition block
4. You wrote this IAM policy to restrict access to items with partition key 'user456', but users still access other items:
{
  "Effect": "Allow",
  "Action": "dynamodb:GetItem",
  "Resource": "arn:aws:dynamodb:us-east-1:123456789012:table/Orders",
  "Condition": {
    "StringEquals": {
      "dynamodb:LeadingKeys": "user456"
    }
  }
}

What is the likely error?
medium
A. Action should be dynamodb:Query instead of GetItem
B. Resource ARN is incorrect
C. Effect should be Deny instead of Allow
D. Condition should use ForAllValues:StringEquals with an array

Solution

  1. Step 1: Check condition syntax for dynamodb:LeadingKeys

    The condition expects an array with ForAllValues:StringEquals, not a single string with StringEquals.
  2. Step 2: Understand impact of incorrect condition

    Using StringEquals with a string causes the condition to be ignored, allowing broader access.
  3. Final Answer:

    Condition should use ForAllValues:StringEquals with an array -> Option D
  4. Quick Check:

    Use ForAllValues:StringEquals and array for LeadingKeys [OK]
Hint: Use ForAllValues:StringEquals with array for LeadingKeys [OK]
Common Mistakes:
  • Using StringEquals with a string instead of array
  • Incorrect ARN format
  • Confusing action types
  • Changing Effect to Deny unnecessarily
5. You want to allow users to read only their own orders in a DynamoDB table where the partition key is 'UserId'. Which IAM policy condition correctly enforces this fine-grained access control for user 'alice'?
hard
A. { "ForAllValues:StringEquals": { "dynamodb:LeadingKeys": ["alice"] } }
B. { "StringEquals": { "dynamodb:Attributes": ["alice"] } }
C. { "ForAnyValue:StringEquals": { "dynamodb:LeadingKeys": ["alice"] } }
D. { "StringLike": { "dynamodb:LeadingKeys": "alice*" } }

Solution

  1. Step 1: Identify correct condition operator for exact key match

    For fine-grained access, ForAllValues:StringEquals with an array ensures all keys match exactly.
  2. Step 2: Evaluate options for correct syntax and semantics

    { "ForAllValues:StringEquals": { "dynamodb:LeadingKeys": ["alice"] } } uses correct operator and array format; others use wrong keys or operators.
  3. Final Answer:

    { "ForAllValues:StringEquals": { "dynamodb:LeadingKeys": ["alice"] } } -> Option A
  4. Quick Check:

    Exact key match needs ForAllValues:StringEquals with array [OK]
Hint: Use ForAllValues:StringEquals with array for exact user keys [OK]
Common Mistakes:
  • Using dynamodb:Attributes instead of LeadingKeys
  • Using StringEquals without array
  • Using StringLike which allows wildcards
Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard