What can the Database Specialist do to reduce the overall cost?
Create a new attribute in each table to track the expiration time and create an AWS Glue transformation to delete entries more than 2 days old.
Create a new attribute in each table to track the expiration time and enable DynamoDB Streams on each table.
Create a new attribute in each table to track the expiration time and enable time to live (TTL) on each table.
Create an Amazon CloudWatch Events event to export the data to Amazon S3 daily using AWS Data Pipeline and then truncate the Amazon DynamoDB table.
Explanations:
AWS Glue transformations are not designed to manage TTL or automatically delete old records in DynamoDB.
DynamoDB Streams capture changes in data but do not provide automatic deletion or expiration of old data.
Time to Live (TTL) is a native DynamoDB feature that automatically deletes expired items based on a timestamp attribute, reducing manual overhead.
Exporting data to S3 and truncating the table via CloudWatch Events and Data Pipeline is complex and not an efficient solution for managing TTL in DynamoDB.
To the best of my knowledge, the answer is:
Create a new attribute in each table to track the expiration time and enable time to live (TTL) on each table.