A company that has multiple offices uses an Amazon DynamoDB table to store employee payroll information. Item attributes consist of employee names, office identifiers, and cumulative daily hours worked. The most frequently used query extracts a report of an alphabetical subset of employees for a specific office.
Which design of the DynamoDB table primary key will have the MINIMUM performance impact?

Question

A company that has multiple offices uses an Amazon DynamoDB table to store employee payroll information. Item attributes consist of employee names, office identifiers, and cumulative daily hours worked. The most frequently used query extracts a report of an alphabetical subset of employees for a specific office.

Which design of the DynamoDB table primary key will have the MINIMUM performance impact?

Tarnauceanu Diana · Accepted Answer

Partition key on the employee name and sort key on the office identifier

Tarnauceanu Diana · Answer

Partition key on the office identifier and sort key on the employee name

Tarnauceanu Diana · Answer

Partition key on the employee name

Tarnauceanu Diana · Answer

Partition key on the office identifier

Question list

List of questions

Question 1

(0)

Question 2

(0)

Question 3

(0)

Question 4

(0)

Question 5

(0)

Question 6

(0)

Question 7

(0)

Question 8

(0)

Question 9

(0)

Question 10

(0)

Related questions

Question 529 - DVA-C01 discussion

Suggested answer: B

0 comments