Which statement best describes partition key and sort key designs of DynamoDB indexes?

Answer options:

A.GSI should have the same partition key as the base table.
B.GSI can have a different partition key and sort key compared to the base table.
C.LSI can have a different partition key and sort key compared to the base table.
D.LSI must have the same sort key compared to the base table.

Answer: B
Option B is CORRECT because a global secondary index is a DynamoDB index with a partition key and a sort key that can differ from those specified on the base table. They are generally used to perform scans and queries on the data based on different partition key criteria. Therefore, Option B is incorrect. A local secondary index (LSI) must have the same partition key, but can have a different sort key. Therefore, Options C and D are incorrect.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-indexes-general.html