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?

Topic #: - All AWS Certified Database - Specialty Questions

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.

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

Suggested Answer:

Share this post

Join the Discussion