Question

Which of the following statements about Amazon DynamoDB secondry indexes is ture?​

Answer 1

HOPE IT HELPS YOU

AWS DynamoDB Secondary Indexes

DynamoDB provides fast access to items in a table by specifying primary key values

DynamoDB Secondary indexes on a table allow efficient access to data with attributes other than the primary key

DynamoDB Secondary indexes

is a data structure that contains a subset of attributes from a table

is associated with exactly one table, from which it obtains its data

requires an alternate key for the index partition key and sort key

additionally can define projected attributes which are copied from the base table into the index along with the primary key attributes

is automatically maintained by DynamoDB

any addition, modification, or deletion of items in the base table, any indexes on that table are also updated to reflect these changes.

helps reduce the size of the data as compared to the main table, depending upon the project attributes and hence helps improve provisioned throughput performance

are automatically maintained as sparse objects. Items will only appear in an index if they exist in the table on which the index is defined, making queries an index very efficient

DynamoDB Secondary indexes supports two types

Global secondary index – an index with a partition key and a sort key that can be different from those on the base table

Local secondary index – an index that has the same partition key as the base table, but a different sort key

DynamoDB Secondary Indexes - GSI vs LSI

Answer 2

Answer:

The correct option is there can be multiple secondary indexes in the tables but all indexes exist when only when the table is created.

Explanation:

• The secondary index is used to hold the subset attributes of the specified table.
• The secondary key index always having the combination of the keys.
• This combination contains sort key and a partition key.

#SPJ2