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:

Cash Flows

The total amount of money being transferred into and out of a business, especially affecting liquidity.

Operating Activity

Activities directly related to the day-to-day operations of a business, including sales of products or services, and expenses.

Bonds Payable

Long-term liabilities representing money owed by a company to bondholders, to be repaid at a future date.

Financing Activities

Transactions that result in changes in the size and composition of the equity capital or borrowings of a company.