ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 26 - DVA-C01 discussion

Report
Export

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
Answers
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
Answers
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
Answers
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
Answers
D.
Configure a hash index on the office Identifier attribute and no range index
Suggested answer: B

Explanation:

https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/HowItWorks.CoreComponents.htmlPartition key and sort key – Referred to as a composite primary key, this type of key is composed oftwo attributes. The first attribute is the partition key, and the second attribute is the sort key.

DynamoDB uses the partition key value as input to an internal hash function. The output from the hash function determines the partition (physical storage internal to DynamoDB) in which the item will be stored. All items with the same partition key value are stored together, in sorted order by sort key value.

asked 16/09/2024
FOTIS FOURLIAS
47 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first