A Company's Ecommerce Website Uses Amazon DynamoDB for Purchase Orders

question 78

Multiple Choice

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.

---

Definitions:

Ethical Soundness

The quality of being morally correct and making decisions based on strong ethical principles and reasoning.

Ethical Standards

Guidelines that dictate the conduct considered acceptable and morally right in a professional or organizational setting.

Organization's Stakeholders

Individuals or groups that have an interest in the success and decisions of an organization, including employees, customers, suppliers, and shareholders.

Search For Alternatives

The stage in decision-making processes where different options or courses of action are identified and explored.