An Amazon DynamoDB table is populated with a large amount of data from an application capturing client data from various servers across various regions. Which of the following is a preferred option for deletion of old items in a DynamoDB table?

Answer options:

A.Schedule a cron Job during off peak hours to delete unwanted items.
B.Run Periodic jobs to delete old items.
C.Pre-Create a DynamoDB table with specific time.
D.Enable TTL on each item to automatically delete old items.

Correct Answer – D
Amazon DynamoDB TTL can delete items in a DynamoDB table based upon the TTL values you specify. TTL is specified as a timestamp for items in a table. This is an easier way of deleting old items & thus freeing up space & saving cost.
Option A is incorrect as although this will work. But additional admin work will be required to create & run jobs.
Option B is incorrect as this will require additional manual jobs to run to delete old items.
Option C is incorrect. This will require adding additional logic in an application to switch over to new tables after a specific time for which DynamoDB tables are pre-created.
For more information on TTL for DynamoDB, refer to the following URLs-
https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/howitworks-ttl.html
https://aws.amazon.com/blogs/database/automatically-archive-items-to-s3-using-dynamodb-time-to-live-with-aws-lambda-and-amazon-kinesis-firehose/