AWS Technical Essentials Practice Exam 2025 – Complete Preparation Guide

When considering the number of secondary indexes that can be defined on a table with a composite primary key in Amazon DynamoDB, the correct understanding is that you can create multiple secondary indexes. A composite primary key consists of both a partition key and a sort key, allowing for a flexible way to access data.

Secondary indexes, which can be either global or local, provide alternative query capabilities to access the data based on different criteria. This means that you can create as many secondary indexes as required, depending on the data access patterns and requirements of your application. By creating multiple secondary indexes, you ensure that your application can optimize read operations across various access patterns without affecting the performance of the primary key.

The other options suggest a limitation in the number of secondary indexes that can be defined, which is not aligned with the capabilities of Amazon DynamoDB, where you have the flexibility to create multiple indexes as needed to support various query scenarios.