A Database Specialist Needs to Review and Optimize an Amazon

question 19

Multiple Choice

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?

• 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.

---

Definitions:

Run Button

A graphical button in software that initiates the execution of a program or query.

Close

The action to terminate an application window, document, or file.

Macro

A set of instructions or a script that automates repetitive tasks in software applications.

Command Button

A user interface element that triggers an action or command when clicked by the user.