A nightly batch job loads 1 million new records into a DynamoDB table. The records are only needed for one hour, and the table needs to be empty by the next night's batch job. Which is the MOST efficient and cost-effective method to provide an empty table?
A) Use DeleteItem using a ConditionExpression . Use DeleteItem using a ConditionExpression .
B) Use BatchWriteItem to empty all of the rows. BatchWriteItem to empty all of the rows.
C) Write a recursive function that scans and calls out DeleteItem . Write a recursive function that scans and calls out
D) Create and then delete the table after the task has completed.

Question

Quizplus · Accepted Answer

Use DeleteItem using a ConditionExpression is the most efficient and cost-effective method to provide an empty table. This is because it only deletes the records that match the condition expression, which in this case is all of the records in the table. This is more efficient than using BatchWriteItem, which would require multiple API calls to delete all of the records in the table. It is also more efficient than writing a recursive function that scans and calls out DeleteItem, which would require multiple API calls for each record in the table. Finally, it is more efficient than creating and then deleting the table after the task has completed, which would require two API calls.

A Nightly Batch Job Loads 1 Million New Records into a DynamoDB