How can the database team achieve this with the LEAST operational overhead?
Implement Amazon DynamoDB Accelerator (DAX) on the DynamoDB table. Use Amazon EventBridge (Amazon CloudWatch Events) to poll the DynamoDB table and drop items after 15 days
Turn on DynamoDB Streams for the DynamoDB table to push the data from DynamoDB to another storage location. Use AWS Lambda to poll and terminate items older than 15 days.
Turn on the TTL feature for the DynamoDB table. Use the TTL attribute as a timestamp and set the expiration of items to 15 days
Create an AWS Lambda function to poll the list of DynamoDB tables every 15 days. Drop the existing table and create a new table
Explanations:
Implementing DAX improves read performance but does not address data expiration. Using EventBridge to drop items after 15 days adds unnecessary complexity and operational overhead.
DynamoDB Streams capture changes to items but require additional setup and Lambda functions to manage deletion, adding operational overhead.
The TTL (Time to Live) feature automatically expires items based on a timestamp, removing data after 15 days with minimal operational overhead.
Creating a new table every 15 days introduces significant complexity and overhead compared to using the TTL feature, which automatically handles data expiration.
I opine that the answer is:
Turn on the TTL feature for the DynamoDB table. Use the TTL attribute as a timestamp and set the expiration of items to 15 days