Index projection types (ALL, KEYS_ONLY, INCLUDE) in DynamoDB - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the ALL projection type mean in DynamoDB indexes?

The ALL projection type means that all attributes from the source table are copied into the index. This allows queries on the index to access any attribute without fetching from the main table.

beginner

What attributes are included when using the KEYS_ONLY projection type?

The KEYS_ONLY projection type includes only the primary key attributes of the main table and the index keys. No other attributes are copied into the index.

intermediate

Explain the INCLUDE projection type in DynamoDB indexes.

The INCLUDE projection type copies the primary key attributes plus any additional specified non-key attributes into the index. This lets you include only the attributes you need for your queries.

intermediate

Why might you choose KEYS_ONLY projection over ALL?

Choosing KEYS_ONLY reduces storage and write costs because fewer attributes are copied into the index. It is useful when queries only need keys to fetch full items later.

intermediate

How does the INCLUDE projection type help optimize query performance?

By including only specific non-key attributes, INCLUDE projection reduces index size and cost compared to ALL, while still allowing queries to get needed data directly from the index without extra fetches.

Which projection type copies all attributes from the main table into the index?

A ALL

B KEYS_ONLY

C INCLUDE

D NONE

The ALL projection type copies every attribute from the main table into the index.

If you want an index to include only the primary key attributes and no others, which projection type should you use?

A ALL

B INCLUDE

C KEYS_ONLY

D PARTIAL

KEYS_ONLY projection includes only the primary key attributes of the table and index.

Which projection type allows you to specify extra non-key attributes to include in the index?

A ALL

B INCLUDE

C NONE

D KEYS_ONLY

INCLUDE projection lets you add specific non-key attributes to the index.

What is a main benefit of using KEYS_ONLY projection?

A Automatically indexes all attributes

B Includes all attributes

C Faster writes than ALL

D Lower storage and write costs

KEYS_ONLY reduces storage and write costs by copying fewer attributes.

Which projection type would you choose to optimize index size but still include some needed attributes?

A INCLUDE

B ALL

C KEYS_ONLY

D FULL

INCLUDE projection balances size and attribute availability by including only selected attributes.

Describe the differences between ALL, KEYS_ONLY, and INCLUDE projection types in DynamoDB indexes.

Think about how much data each projection type copies into the index.

Explain when you might choose each projection type for a DynamoDB index.

Consider query needs and cost trade-offs.