An Application Stores Payroll Information Nightly in DynamoDB for a Large

Multiple Choice

An application stores payroll information nightly in DynamoDB for a large number of employees across hundreds of offices. Item attributes consist of individual name, office identifier, and cumulative daily hours. Managers run reports for ranges of names working in their office. One query is. "Return all Items in this office for names starting with A through E". Which table configuration will result in the lowest impact on provisioned throughput for this query?

A) Configure the table to have a hash index on the name attribute, and a range index on the office identifier
B) Configure the table to have a range index on the name attribute, and a hash index on the office identifier
C) Configure a hash index on the name attribute and no range index
D) Configure a hash index on the office Identifier attribute and no range index