AWS Certified Database – Specialty — Question 71

A database specialist needs to review and optimize an Amazon DynamoDB table that is experiencing performance issues. A thorough investigation by the database specialist reveals that the partition key is causing hot partitions, so a new partition key is created. The database specialist must effectively apply this new partition key to all existing and new data.
How can this solution be implemented?

Answer options

• A. Use Amazon EMR to export the data from the current DynamoDB table to Amazon S3. Then use Amazon EMR again to import the data from Amazon S3 into a new DynamoDB table with the new partition key.
• B. Use AWS DMS to copy the data from the current DynamoDB table to Amazon S3. Then import the DynamoDB table to create a new DynamoDB table with the new partition key.
• C. Use the AWS CLI to update the DynamoDB table and modify the partition key.
• D. Use the AWS CLI to back up the DynamoDB table. Then use the restore-table-from-backup command and modify the partition key.

Correct answer: A

Explanation

Option A is correct because it describes the process of exporting data to Amazon S3 and re-importing it into a new table with the updated partition key, effectively transferring all data. Options B and C are incorrect as they do not provide a valid method for changing the partition key directly for existing data, and option D does not allow for changing the partition key through the restore process.