Index projection types (ALL, KEYS_ONLY, INCLUDE) in DynamoDB - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to set the projection type to include all attributes in a DynamoDB index.

DynamoDB

Projection: { ProjectionType: "[1]" }

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

AALL

BINCLUDE

CNONE

DKEYS_ONLY

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing KEYS_ONLY will only include key attributes, not all.

Selecting INCLUDE requires specifying non-key attributes explicitly.

Setting ProjectionType to ALL includes all attributes from the table in the index.

2fill in blank

medium

Complete the code to set the projection type to include only the index keys in a DynamoDB index.

DynamoDB

Projection: { ProjectionType: "[1]" }

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

AKEYS_ONLY

BNONE

CINCLUDE

DALL

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing ALL includes all attributes, not just keys.

INCLUDE requires specifying attributes explicitly.

Setting ProjectionType to KEYS_ONLY includes only the index and primary keys in the index.

3fill in blank

hard

Fix the error in the projection type to include specific non-key attributes in a DynamoDB index.

DynamoDB

Projection: { ProjectionType: "[1]", NonKeyAttributes: ["Attribute1", "Attribute2"] }

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

AKEYS_ONLY

BINCLUDE

CALL

DNONE

Attempts:

3 left

💡 Hint

Common Mistakes

Using ALL ignores NonKeyAttributes because it includes everything.

KEYS_ONLY does not allow specifying extra attributes.

ProjectionType must be set to INCLUDE to specify non-key attributes explicitly.

4fill in blank

hard

Fill both blanks to define a DynamoDB index projection that includes only keys and specific attributes.

DynamoDB

Projection: { ProjectionType: "[1]", NonKeyAttributes: ["[2]"] }

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

AINCLUDE

BALL

CAttributeX

DKEYS_ONLY

Attempts:

3 left

💡 Hint

Common Mistakes

Using KEYS_ONLY with NonKeyAttributes causes errors.

ALL projection type ignores NonKeyAttributes.

Use INCLUDE to specify non-key attributes like AttributeX in the projection.

5fill in blank

hard

Fill all three blanks to define a DynamoDB index projection with INCLUDE type and two specific non-key attributes.

DynamoDB

Projection: { ProjectionType: "[1]", NonKeyAttributes: ["[2]", "[3]"] }

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

AKEYS_ONLY

BAttributeA

CAttributeB

DINCLUDE

Attempts:

3 left

💡 Hint

Common Mistakes

Using KEYS_ONLY projection with NonKeyAttributes causes errors.

Forgetting to list all desired attributes in NonKeyAttributes.

Set ProjectionType to INCLUDE and list the non-key attributes AttributeA and AttributeB to include them in the index.