You are working as a Senior Software Developer for a large pharmaceutical company. Your lead has asked you to work on a new module in which you need to query a DynamoDB table with multiple Partition Key values at once and store the result in CSV format on S3. Which operation will you use to achieve the same?

Answer options:

A.Scan
B.Query
C.GetItem
D.BatchGetItem

Correct Answer: D
BatchGetItem API allows you to pass multiple Partition Key values in a single request.
Option A is incorrect: Scan API does not query table using Partition or Sort Key in request. It fetches all records from the table.
Option B is incorrect: Query API does not support querying table using a multiple Partition Key values.
Option C is incorrect: GetItem API only accepts a single Partition or Sort key for querying data. Unlike Query operation, GetItem API requires passing of both Partition and Sort Key in the request.
Reference: https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_BatchGetItem.html