You are working on a web application whose database was created by a DB admin who is no longer working with your company. The manager has asked you to handle the database administration. You are working on a new reporting feature for which you need to query a DynamoDB table, and the attributes you need to query upon are not set as Partition Key and Sort Key. What is the best way to solve this problem?

Answer options:

A.Clone the existing table and change the Partition and Sort Key during the table creation process.
B.Create a Local Secondary Index with required attributes as Partition and Sort Key.
C.Create Global Secondary Index and set required attributes as Partition and Sort Key.
D.Edit the table and change the existing Partition and Sort Key to the required ones.

Correct Answer: C
Using Global Secondary Index, you can create a different pair of Partition and Sort key even after table creation for better search performance.
Option A is incorrect: This is not the best practice as you are duplicating the data unnecessarily.
Option B is incorrect: Local Secondary Index only supports additional Sort Key and cannot be created after the table has been created.
Option D is incorrect: DynamoDB does not support this feature as of writing this question.
Reference:
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GSI.html