Which DynamoDB API call will meet these requirements with the MINIMUM impact on the database?
BatchGetItem
GetItem
Scan
Query
Explanations:
BatchGetItem allows the retrieval of multiple specific items from one or more tables in a single API call, minimizing the number of requests and reducing the load on the database.
GetItem retrieves a single item from a table by its primary key. It does not support fetching multiple items in one call, thus not meeting the requirement.
Scan reads every item in a table, which is inefficient for retrieving specific items and can lead to high read capacity usage. It is not suitable for this use case.
Query retrieves items based on primary key values and requires a specific key or index to be provided. It cannot fetch multiple arbitrary items in a single call like BatchGetItem can.