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 129 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 129
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company's ecommerce website uses Amazon DynamoDB for purchase orders. Each order is made up of a Customer ID and an Order ID. The DynamoDB table uses the Customer ID as the partition key and the Order ID as the sort key.
To meet a new requirement, the company also wants the ability to query the table by using a third attribute named Invoice ID. Queries using the Invoice ID must be strongly consistent. A database specialist must provide this capability with optimal performance and minimal overhead.
What should the database administrator do to meet these requirements?

A. Add a global secondary index on Invoice ID to the existing table.
B. Add a local secondary index on Invoice ID to the existing table.
C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID.
D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Show Suggested Answer

Suggested Answer: C 🗳️

by shantest1 at April 3, 2021, 3:22 a.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, 10 months ago

C. Answer

upvoted 10 times

...

jove

Highly Voted 3 years, 8 months ago

Selected Answer: C

Answer is C ; - It has to be a local secondary index - Secondary indexes can only be created when the table is created.

upvoted 5 times

...

jitesh_k

Most Recent 1 year, 8 months ago

What is wrong with D?

upvoted 1 times

...

Pranava_GCP

1 year, 10 months ago

Selected Answer: C

C. Recreate table while adding a local secondary index - strongly consistent has to be local secondary index - adding a local secondary index requires recreating of the table

upvoted 1 times

...

Pankaj24hrs

2 years, 3 months ago

C Due to clause "minimal overhead". if you obtain 100KB of data in step 1 and filter it down to 10KB in step 2, you'll use the read capacity units for 100KB of data instead of the 10KB that was filtered down. Further, a 1MB limit is applied to all operations, regardless of the read capacity units on a table.

upvoted 1 times

...

SeemaDataReader

2 years, 3 months ago

Selected Answer: D

A. Add a global secondary index on Invoice ID to the existing table. - GSI doesn't support strong consistency B. Add a local secondary index on Invoice ID to the existing table. - LSI can be added only while creating the table. LSI Partition key has to be same as the main table's partition key i.e customer id C. Recreate the table by using the latest snapshot while adding a local secondary index on Invoice ID. - LSI Partition key has to be same as the main table's partition key i.e customer id D. Use the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries. filter queries can be strongly consistent. If you require strongly consistent reads, set the ConsistentRead parameter to true in the Query request. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Query.html

upvoted 4 times

yyy

2 years, 3 months ago

Ans is D. You are right, C is wrong

upvoted 1 times

...

novice_expert

3 years, 3 months ago

Selected Answer: C

Queries that make use of the Invoice ID must be very consistent => recreate table, as Local secondary index can only be created while creating the Dynamodb table. global secondary indexes are eventual consistent only

upvoted 2 times

...

GMartinelli

3 years, 8 months ago

Selected Answer: C

Option C

upvoted 3 times

...

ChauPhan

3 years, 9 months ago

Why not A?. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/GSI.html

upvoted 2 times

faramawi

3 years, 9 months ago

According to below link "Strongly consistent reads are not supported on global secondary indexes" https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.ReadConsistency.html

upvoted 2 times

...

Hits_23

3 years, 10 months ago

C is correct, as Local secondary index can only be created while creating the Dynamodb table. and query needs to use third attribute on top of primary and sort key, so Local Secondary index has primary and sort key as well as the third attribute. Global secondary index can be created without primary and sort key

upvoted 1 times

...