exam questions

Exam AWS Certified Developer Associate All Questions

View all questions & answers for the AWS Certified Developer Associate exam

Exam AWS Certified Developer Associate topic 1 question 440 discussion

Exam question from Amazon's AWS Certified Developer Associate
Question #: 440
Topic #: 1
[All AWS Certified Developer Associate Questions]

A company has an application that provides blog hosting services to its customers. The application includes an Amazon DynamoDB table with a primary key. The primary key consists of the customers’ UserName as a partition key and the NumberOfBlogs as a sort key. The application stores the TotalReactionsOnBlogs as an attribute on the same DynamoDB table.

A developer needs to implement an operation to retrieve the top 10 customers based on the greatest number of reactions on their blogs. This operation must not consume the DynamoDB table’s existing read capacity.

What should the developer do to meet these requirements in the MOST operationally efficient manner?

  • A. For the existing DynamoDB table, create a new global secondary index (GSI) that has the UserName as a partition key and the TotalReactionsOnBlogs as a sort key.
  • B. For the existing DynamoDB table, create a new local secondary index (LSI) that has the UserName as a partition key and the TotalReactionsOnBlogs as a sort key.
  • C. Back up and restore the DynamoDB table to a new DynamoDB table. Create a new global secondary index (GSI) that has the UserName as a partition key and the TotalReactionsOnBlogs as a sort key. Delete the old DynamoDB table.
  • D. Back up and restore the DynamoDB table to a new DynamoDB table. Create a new local secondary index (LSI) that has the UserName as a partition key and the TotalReactionsOnBlogs as a sort key. Delete the old DynamoDB table.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
tieyua
2 years, 3 months ago
Selected Answer: A
While A is the only possible pick, the question seems poorly worded. It's sounded like trying to query users with highest reactions across board, but the solution is only good for top 10 blogs for any given user.
upvoted 1 times
...
pancman
2 years, 3 months ago
Selected Answer: A
A local secondary index can only be created when you are creating your table. It's not possible to do it later. Since the question is asking for the most efficient solution, we need the Global Secondary Index.
upvoted 2 times
...
JagpreetLM10
2 years, 3 months ago
Selected Answer: A
A fr sure
upvoted 1 times
...
breathingcloud
2 years, 3 months ago
Selected Answer: A
Its A , global secondary index
upvoted 1 times
...
Phinx
2 years, 3 months ago
Selected Answer: A
Global secondary index does not consume the main table's capacity.
upvoted 1 times
...
JagpreetLM10
2 years, 3 months ago
Selected Answer: A
A as read capacity shouldn't be consumed.
upvoted 1 times
...
KT_Yu
2 years, 3 months ago
Selected Answer: A
This operation must not consume the DynamoDB table’s existing read capacity. Therefore, creating GSI is the only option. A is correct because GSL can be created at any time.
upvoted 1 times
KT_Yu
2 years, 3 months ago
Opps, I think I am more agreeing on C
upvoted 1 times
KT_Yu
2 years, 3 months ago
could be A again!
upvoted 1 times
...
...
...
DrCloud
2 years, 3 months ago
Selected Answer: D
-- Local secondary indexes on a table are created when the table is created. -- A local secondary index maintains an alternate sort key for a given partition key value. -- When you query a local secondary index, the number of read capacity units consumed depends on how the data is accessed. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/LSI.html
upvoted 2 times
Phinx
2 years, 3 months ago
LSI will consume the capacity of the base table. The statement states that it should not consume the capacity of the main table.
upvoted 2 times
...
DrCloud
2 years, 2 months ago
Correct Ans: A. Sorry about it!
upvoted 1 times
...
tony554556
2 years, 3 months ago
C is not one of the MOST operationally efficient manner
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago