Querying GSI in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to specify the index name when querying a GSI.

DynamoDB

response = table.query(IndexName=[1], KeyConditionExpression=Key('GSIKey').eq('value'))

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

A'TableName'

B'PartitionKey'

C'MyGSI'

D'PrimaryIndex'

Attempts:

3 left

💡 Hint

Common Mistakes

Using the table name instead of the GSI name.

Omitting the IndexName parameter.

Using the primary key name as the index name.

You must specify the exact name of the GSI in the IndexName parameter to query it.

2fill in blank

medium

Complete the code to use the correct key condition expression for the GSI partition key.

DynamoDB

response = table.query(IndexName='MyGSI', KeyConditionExpression=Key('[1]').eq('value'))

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

APrimaryKey

BSortKey

CTableKey

DGSIKey

Attempts:

3 left

💡 Hint

Common Mistakes

Using the table's primary key instead of the GSI key.

Using an attribute not defined in the GSI.

The KeyConditionExpression must use the GSI partition key attribute name.

3fill in blank

hard

Fix the error in the query code by completing the missing parameter to specify the sort key condition.

DynamoDB

response = table.query(IndexName='MyGSI', KeyConditionExpression=Key('GSIKey').eq('value') [1] Key('GSISortKey').lt(100))

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

A|

B&

C+

D,

Attempts:

3 left

💡 Hint

Common Mistakes

Using | instead of &.

Using a comma or plus sign to combine conditions.

Use & to combine multiple conditions in a KeyConditionExpression.

4fill in blank

hard

Fill both blanks to complete the query that filters results after querying the GSI.

DynamoDB

response = table.query(IndexName='MyGSI', KeyConditionExpression=Key('GSIKey').eq('value'), FilterExpression=Attr('[1]').[2]('active'))

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

AStatus

Bbegins_with

Ceq

Dcontains

Attempts:

3 left

💡 Hint

Common Mistakes

Using the wrong attribute name.

Using a string method like contains when exact match is needed.

The filter expression checks if the Status attribute equals 'active'.

5fill in blank

hard

Fill all three blanks to build a query that uses a GSI, filters by attribute, and limits results.

DynamoDB

response = table.query(IndexName=[1], KeyConditionExpression=Key('GSIKey').eq('value'), FilterExpression=Attr([2]).[3]('pending'), Limit=10)

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

A'MyGSI'

B'Category'

Ceq

Dcontains

Attempts:

3 left

💡 Hint

Common Mistakes

Not quoting the index name.

Using contains instead of eq for exact match.

Using wrong attribute name in filter.

This query uses the GSI named 'MyGSI', filters items where Category equals 'pending', and limits the results to 10.

Practice

1. What is the main purpose of querying a Global Secondary Index (GSI) in DynamoDB?

easy

A. To delete items from the table

B. To create a backup of the table

C. To update the primary key of items

D. To find items using an alternate key without scanning the whole table

Solution

1. Step 1: Understand what a GSI is used for

   A GSI allows querying data using a different key than the primary key.

2. Step 2: Identify the main benefit of querying a GSI

   Querying a GSI helps find items quickly without scanning the entire table.

3. Final Answer:

   To find items using an alternate key without scanning the whole table -> Option D

4. Quick Check:

   Query GSI = alternate key search [OK]

Hint: GSI lets you search by different keys fast [OK]

Common Mistakes:

• Confusing GSI query with table scan
• Thinking GSI is for deleting or updating keys
• Assuming GSI creates backups

2. Which of the following is the correct way to specify a GSI name in a DynamoDB query using AWS SDK?

easy

A. query({ TableName: 'MyTable', Index: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } })

B. query({ TableName: 'MyTable', KeyName: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } })

C. query({ TableName: 'MyTable', IndexName: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } })

D. query({ TableName: 'MyTable', GSIName: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } })

Solution

1. Step 1: Recall the correct parameter name for GSI in DynamoDB query

   The correct parameter to specify a GSI is 'IndexName'.

2. Step 2: Check the options for correct syntax

   Only query({ TableName: 'MyTable', IndexName: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } }) uses 'IndexName' correctly with other required fields.

3. Final Answer:

   query({ TableName: 'MyTable', IndexName: 'MyGSI', KeyConditionExpression: 'GSIKey = :val', ExpressionAttributeValues: { ':val': '123' } }) -> Option C

4. Quick Check:

   Use IndexName to specify GSI [OK]

Hint: Use 'IndexName' to specify GSI in query params [OK]

Common Mistakes:

• Using 'KeyName' or 'GSIName' instead of 'IndexName'
• Omitting ExpressionAttributeValues
• Wrong key condition syntax

3. Given a DynamoDB table with a GSI named 'StatusIndex' on attribute 'status', what will the following query return?

query({ TableName: 'Orders', IndexName: 'StatusIndex', KeyConditionExpression: 'status = :s', ExpressionAttributeValues: { ':s': 'shipped' } })

medium

A. All orders with status 'shipped' using the GSI

B. All orders regardless of status

C. An error because 'status' is not the primary key

D. No results because GSI queries are not supported

Solution

1. Step 1: Understand the query parameters

   The query uses 'StatusIndex' GSI with a key condition on 'status' = 'shipped'.

2. Step 2: Determine what the query returns

   It returns all items where 'status' attribute equals 'shipped' using the GSI, which is designed for this attribute.

3. Final Answer:

   All orders with status 'shipped' using the GSI -> Option A

4. Quick Check:

   Query GSI by status = shipped returns matching items [OK]

Hint: Query GSI with key condition returns matching items [OK]

Common Mistakes:

• Thinking GSI query returns all items
• Assuming GSI query causes error if attribute not primary key
• Believing GSI queries are unsupported

4. You wrote this DynamoDB query to use a GSI but get an error:

query({ TableName: 'Products', IndexName: 'CategoryIndex', KeyConditionExpression: 'category = :c', ExpressionAttributeValues: { ':c': 'books' } })

What is the most likely cause of the error?

medium

A. You cannot query a GSI in DynamoDB

B. The attribute 'category' is not the partition key of the GSI 'CategoryIndex'

C. ExpressionAttributeValues is missing a value

D. The table name 'Products' is incorrect

Solution

1. Step 1: Understand GSI key requirements

   When querying a GSI, the KeyConditionExpression must use the GSI's partition key attribute.

2. Step 2: Identify the error cause

   If 'category' is not the partition key of 'CategoryIndex', the query will fail with an error.

3. Final Answer:

   The attribute 'category' is not the partition key of the GSI 'CategoryIndex' -> Option B

4. Quick Check:

   GSI query key must be GSI partition key [OK]

Hint: GSI query key must match GSI partition key [OK]

Common Mistakes:

• Using a non-key attribute in KeyConditionExpression
• Assuming table name typo causes this error
• Believing GSI queries are unsupported

5. You have a DynamoDB table 'Employees' with a GSI named 'DeptIndex' where the partition key is 'department' and sort key is 'hireDate'. You want to find all employees in 'Sales' hired after '2023-01-01'. Which query is correct?

hard

A. query({ TableName: 'Employees', IndexName: 'DeptIndex', KeyConditionExpression: 'department = :d AND hireDate > :h', ExpressionAttributeValues: { ':d': 'Sales', ':h': '2023-01-01' } })

B. query({ TableName: 'Employees', IndexName: 'DeptIndex', KeyConditionExpression: 'department = :d OR hireDate > :h', ExpressionAttributeValues: { ':d': 'Sales', ':h': '2023-01-01' } })

C. query({ TableName: 'Employees', KeyConditionExpression: 'department = :d AND hireDate > :h', ExpressionAttributeValues: { ':d': 'Sales', ':h': '2023-01-01' } })

D. query({ TableName: 'Employees', IndexName: 'DeptIndex', FilterExpression: 'department = :d AND hireDate > :h', ExpressionAttributeValues: { ':d': 'Sales', ':h': '2023-01-01' } })

Solution

1. Step 1: Use the GSI name and correct key condition

   Query must specify 'IndexName' as 'DeptIndex' and use KeyConditionExpression with partition key and sort key conditions.

2. Step 2: Check logical operators and expressions

   KeyConditionExpression supports 'AND' for partition key and sort key conditions; 'OR' is invalid here.

3. Step 3: Verify FilterExpression usage

   FilterExpression filters after query; it cannot replace KeyConditionExpression for keys.

4. Final Answer:

   query({ TableName: 'Employees', IndexName: 'DeptIndex', KeyConditionExpression: 'department = :d AND hireDate > :h', ExpressionAttributeValues: { ':d': 'Sales', ':h': '2023-01-01' } }) -> Option A

5. Quick Check:

   Use KeyConditionExpression with AND on GSI keys [OK]

Hint: Use AND in KeyConditionExpression for partition and sort keys [OK]

Common Mistakes:

• Using OR instead of AND in KeyConditionExpression
• Omitting IndexName for GSI query
• Using FilterExpression instead of KeyConditionExpression for keys