Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

Exam AWS Certified Database - Specialty topic 1 question 95 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 95
Topic #: 1

[All AWS Certified Database - Specialty Questions]

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.

Show Suggested Answer

Suggested Answer: A 🗳️

by std2021 at April 1, 2021, 8:57 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

shantest1

Highly Voted 3 years, 8 months ago

A. Answer Use EMR to copy to S3 and use EMR to create new table.

upvoted 9 times

...

Suresh108

Highly Voted 3 years, 8 months ago

AAAA for me as well. https://aws.amazon.com/premiumsupport/knowledge-center/back-up-dynamodb-s3/ EMR to backup and restore

upvoted 5 times

...

aviathor

Most Recent 2 years ago

Selected Answer: A

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. Most Voted xB. DynamoDB is not a valid source for AWS DMS xC. The partition key cannot be modified xD. Although you can choose to restore a DynamoDB table without the secondary indexes, the partition key cannot be modifier during restore

upvoted 3 times

...

ninjalight25

2 years, 3 months ago

Selected Answer: C

To apply the new partition key to all existing and new data in a DynamoDB table, the AWS CLI can be used to update the table and modify the partition key

upvoted 1 times

...

lollyj

2 years, 5 months ago

Selected Answer: B

I believe DMS works with DynamoDB and is a simpler solution compared to EMR. Dynamodb can be a source for DMS. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.DynamoDB.html

upvoted 2 times

Kanwar_89

2 years, 5 months ago

Dynamodb can be a target , but not a source -- Hence A

upvoted 1 times

...

Chirantan

2 years, 11 months ago

Is it possible to change partition key in DynamoDB? No. Once the table is setup, you cannot modify its Key Schema. You can only provision a new table, move data there, and then remove the first table

upvoted 5 times

...

novice_expert

3 years, 1 month ago

Selected Answer: A

https://aws.amazon.com/premiumsupport/knowledge-center/back-up-dynamodb-s3/ DynamoDB to S3 is possible by EMR, AWS Glue, or AWS Data Pipeline.

upvoted 3 times

...

tugboat

3 years, 3 months ago

Selected Answer: A

DynamoDB cannot be a source for DMS. Per -https://dynobase.com/dynamodb-keys/ Is it possible to change partition key in DynamoDB? No. Once the table is setup, you cannot modify its Key Schema. You can only provision a new table, move data there, and then remove the first table. Per - https://aws.amazon.com/premiumsupport/knowledge-center/back-up-dynamodb-s3/ To customize the process of creating backups, you can use use Amazon EMR, AWS Glue, or AWS Data Pipeline. So, using EMR is the only valid option.

upvoted 3 times

...