nerdexam
AmazonAmazon

DBS-C01 · Question #139

DBS-C01 Question #139: Real Exam Question with Answer & Explanation

Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #139. The question stem and answer options stay visible for context.

Submitted by hans_de· Mar 6, 2026Workload-Specific Database Design

Question

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?

Options

  • AAdd a global secondary index on Invoice ID to the existing table.
  • BAdd a local secondary index on Invoice ID to the existing table.
  • CRecreate the table by using the latest snapshot while adding a local secondary index on Invoice
  • DUse the partition key and a FilterExpression parameter with a filter on Invoice ID for all queries.

Unlock DBS-C01 to see the answer

You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#DynamoDB indexing#Local secondary index#Strongly consistent reads#Querying DynamoDB
Full DBS-C01 PracticeBrowse All DBS-C01 Questions