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 range index on the name attribute, and a hash index on the
office identifier
B.
Configure a hash index on the name attribute and no range index
C.
Configure the table to have a hash index on the name attribute, and a range index on the
office identifier
D.
Configure a hash index on the office Identifier attribute and no range index
A
1
0
C because the hash will be the name and the range is the office
0
2
A correct sorry
0
0
A Configure the table to have a range index on the name attribute, and a hash index on the
office identifier
0
0
C
A composite key with UserID as the partition key and the timestamp as the sort key would be best. The other answers offer non-standard key configurations.
0
1
A
0
0