Index capacity and cost in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the type of index when creating a DynamoDB table.

DynamoDB

TableName: 'Music',
KeySchema: [
  { AttributeName: 'Artist', KeyType: 'HASH' },
  { AttributeName: 'SongTitle', KeyType: 'RANGE' }
],
GlobalSecondaryIndexes: [{
  IndexName: 'GenreIndex',
  KeySchema: [
    { AttributeName: 'Genre', KeyType: 'HASH' }
  ],
  Projection: { ProjectionType: 'ALL' },
  ProvisionedThroughput: {
    ReadCapacityUnits: 5,
    WriteCapacityUnits: 5
  },
  IndexType: '[1]'
}]

Drag options to blanks, or click blank then click option'

AGLOBAL

BPRIMARY

CSECONDARY

DLOCAL

Attempts:

3 left

💡 Hint

Common Mistakes

Confusing local and global index types.

Using PRIMARY as an index type which is invalid.

The correct index type for a global secondary index is GLOBAL. Local secondary indexes use LOCAL.

2fill in blank

medium

Complete the code to set the read capacity units for a DynamoDB table.

DynamoDB

ProvisionedThroughput: {
  ReadCapacityUnits: [1],
  WriteCapacityUnits: 10
}

Drag options to blanks, or click blank then click option'

A-1

B0

Cnull

D5

Attempts:

3 left

💡 Hint

Common Mistakes

Setting capacity units to zero or negative values.

Using null instead of a number.

Read capacity units must be a positive integer. 5 is a valid value.

3fill in blank

hard

Fix the error in the code by choosing the correct attribute to project in the index.

DynamoDB

Projection: {
  ProjectionType: '[1]'
}

Drag options to blanks, or click blank then click option'

AALL

BKEYS_ONLY

CINCLUDE

DNONE

Attempts:

3 left

💡 Hint

Common Mistakes

Using NONE which is invalid.

Confusing INCLUDE with ALL.

The ALL projection type includes all attributes from the base table in the index.

4fill in blank

hard

Fill both blanks to correctly define the provisioned throughput for a global secondary index.

DynamoDB

ProvisionedThroughput: {
  ReadCapacityUnits: [1],
  WriteCapacityUnits: [2]
}

Drag options to blanks, or click blank then click option'

A10

B5

C20

D0

Attempts:

3 left

💡 Hint

Common Mistakes

Setting capacity units to zero.

Using the same value for both read and write units without reason.

Read capacity units are set to 5 and write capacity units to 10 for balanced throughput.

5fill in blank

hard

Fill all three blanks to create a dictionary that maps index names to their read capacity units, filtering only indexes with read capacity greater than 5.

DynamoDB

index_read_capacity = {index['IndexName']: index['ProvisionedThroughput']['ReadCapacityUnits'] for index in indexes if index['ProvisionedThroughput']['ReadCapacityUnits'] [1] [2]

filtered_index_read_capacity = {k: v for k, v in index_read_capacity.items() if v [3] 5}

Drag options to blanks, or click blank then click option'

A>

B10

C>=

D<

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' causing wrong filtering.

Using '>=' when only '>' is needed.

The first condition filters indexes with read capacity units greater than 10, and the second filters those with values greater than 5.

Practice

1. What is the main reason to use indexes in DynamoDB?

easy

A. To speed up query performance by allowing efficient data access

B. To reduce the storage size of the table

C. To automatically backup data

D. To encrypt data at rest

Solution

1. Step 1: Understand the purpose of indexes

   Indexes in DynamoDB are designed to speed up queries by providing alternate ways to access data efficiently.

2. Step 2: Eliminate unrelated options

   Options about storage size, backup, and encryption are unrelated to index functionality.

3. Final Answer:

   To speed up query performance by allowing efficient data access -> Option A

4. Quick Check:

   Indexes improve query speed = B [OK]

Hint: Indexes speed queries, not reduce storage or backup [OK]

Common Mistakes:

• Thinking indexes reduce storage cost
• Confusing indexes with backup features
• Assuming indexes encrypt data

2. Which of the following is the correct way to specify a Global Secondary Index (GSI) in a DynamoDB table creation JSON?

easy

A. {
"LocalSecondaryIndexes": [
{
"IndexName": "MyGSI",
"KeySchema": [
{"AttributeName": "UserId", "KeyType": "HASH"}
],
"Projection": {"ProjectionType": "ALL"}
}
]
}

B. {
"GlobalSecondaryIndexes": [
{
"IndexName": "MyGSI",
"KeySchema": [
{"AttributeName": "UserId", "KeyType": "HASH"}
],
"Projection": {"ProjectionType": "ALL"},
"ProvisionedThroughput": {"ReadCapacityUnits": 5, "WriteCapacityUnits": 5}
}
]
}

C. {
"GlobalSecondaryIndexes": {
"IndexName": "MyGSI"
}
}

D. {
"Indexes": [
{
"Name": "MyGSI"
}
]
}

Solution

1. Step 1: Identify correct GSI syntax

   Global Secondary Indexes require an array under "GlobalSecondaryIndexes" with full details: IndexName, KeySchema, Projection, and ProvisionedThroughput.

2. Step 2: Compare options

   { "GlobalSecondaryIndexes": [ { "IndexName": "MyGSI", "KeySchema": [ {"AttributeName": "UserId", "KeyType": "HASH"} ], "Projection": {"ProjectionType": "ALL"}, "ProvisionedThroughput": {"ReadCapacityUnits": 5, "WriteCapacityUnits": 5} } ] } correctly uses "GlobalSecondaryIndexes" as an array with all required fields. Others use wrong keys or incomplete structures.

3. Final Answer:

   { "GlobalSecondaryIndexes": [ { "IndexName": "MyGSI", "KeySchema": [ {"AttributeName": "UserId", "KeyType": "HASH"} ], "Projection": {"ProjectionType": "ALL"}, "ProvisionedThroughput": {"ReadCapacityUnits": 5, "WriteCapacityUnits": 5} } ] } -> Option B

4. Quick Check:

   GSI syntax requires array with full details = A [OK]

Hint: GSIs need full details in GlobalSecondaryIndexes array [OK]

Common Mistakes:

• Using LocalSecondaryIndexes instead of GlobalSecondaryIndexes
• Providing object instead of array for GSIs
• Omitting ProvisionedThroughput for GSIs

3. Given a DynamoDB table with a provisioned write capacity of 10 units and a Global Secondary Index (GSI) with 5 write capacity units, what is the total write capacity units consumed when writing one item to the table and the GSI?

medium

A. 5 units

B. 10 units

C. 15 units

D. 20 units

Solution

1. Step 1: Understand write capacity consumption

   Writing one item consumes write capacity units on the main table plus on each index that is updated.

2. Step 2: Add main table and GSI write units

   Main table uses 10 units, GSI uses 5 units, total = 10 + 5 = 15 units.

3. Final Answer:

   15 units -> Option C

4. Quick Check:

   Total write capacity = main + GSI = 15 [OK]

Hint: Add main table and index write units for total cost [OK]

Common Mistakes:

• Counting only main table write units
• Counting only GSI write units
• Multiplying instead of adding capacities

4. You notice your DynamoDB table's write capacity is being exceeded even though your application writes only a few items per second. Which of the following is the most likely cause related to indexes?

medium

A. You have a Global Secondary Index with high write capacity units causing extra cost

B. You forgot to create any indexes

C. Your table has no read capacity units set

D. You are using Local Secondary Indexes which do not affect write capacity

Solution

1. Step 1: Analyze write capacity usage

   Writes to the table also consume write capacity on GSIs, increasing total usage.

2. Step 2: Identify cause of exceeded capacity

   If GSIs have high write capacity or many writes, they can cause capacity to be exceeded even if main table writes are low.

3. Final Answer:

   You have a Global Secondary Index with high write capacity units causing extra cost -> Option A

4. Quick Check:

   GSIs increase write capacity usage = C [OK]

Hint: Check GSIs for hidden write capacity usage [OK]

Common Mistakes:

• Assuming no indexes means no extra capacity
• Confusing read and write capacity units
• Thinking Local Secondary Indexes increase write capacity

5. You want to optimize costs for a DynamoDB table with a Global Secondary Index (GSI). The table has 20 write capacity units and the GSI has 10 write capacity units. If your application writes 5 items per second, how can you reduce costs without affecting query performance on the GSI?

hard

A. Disable the table's write capacity units

B. Remove the GSI to save all index costs

C. Increase the table write capacity units to 30

D. Reduce the GSI write capacity units to 5 and enable auto scaling

Solution

1. Step 1: Understand cost drivers

   Write capacity units on both table and GSI affect cost. Reducing GSI units lowers cost but must still handle write load.

2. Step 2: Apply auto scaling and adjust capacity

   Reducing GSI write units to match actual writes (5) and enabling auto scaling balances cost and performance.

3. Final Answer:

   Reduce the GSI write capacity units to 5 and enable auto scaling -> Option D

4. Quick Check:

   Lower GSI units + auto scaling = cost optimization [OK]

Hint: Match GSI capacity to writes and use auto scaling [OK]

Common Mistakes:

• Removing GSI and losing query performance
• Increasing table capacity unnecessarily
• Disabling write capacity causing failures