nerdexam
Amazon

DBS-C01 · Question #327

A company hosts an online gaming application on AWS. A single Amazon DynamoDB table contains one item for each registered user. The partition key for each item is the user's ID. A daily report…

The correct answer is A. Create a global secondary index (GSI) that uses the user ID as the partition key and the C. Modify the report generator to query the index instead of the table. https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-query-scan.html

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

Question

A company hosts an online gaming application on AWS. A single Amazon DynamoDB table contains one item for each registered user. The partition key for each item is the user's ID. A daily report generator computes the sum totals of two well-known attributes for all items in the table that contain a dimension attribute. As the number of users grows, the report generator takes more time to generate the report. Which combination of steps will minimize the time it takes to generate the report? (Choose two.)

Options

  • ACreate a global secondary index (GSI) that uses the user ID as the partition key and the
  • BCreate a local secondary index (LSI) that uses the user ID as the partition key and the dimension
  • CModify the report generator to query the index instead of the table.
  • DModify the report generator to scan the index instead of the table.
  • EModify the report generator to call the BatchGetItem operation.

How the community answered

(66 responses)
  • A
    55% (36)
  • B
    29% (19)
  • D
    5% (3)
  • E
    12% (8)

Explanation

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-query-scan.html

Topics

#DynamoDB Global Secondary Index (GSI)#Query optimization#Reporting#DynamoDB performance

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DBS-C01 Practice