An application uses DynamoDB to store data. Compliance audit requirements state that all data must be retained for 90 days. What is the optimal solution for these requirements?

Answer options:

A.Enable and configure point-in-time recovery (PITR) on the DynamoDB table.
B.Enable DynamoDB Streams on the DynamoDB table. Create a Firehose stream to load the data into an S3 bucket. Create a Lambda function to poll the DynamoDB stream and deliver batch records from streams to Firehose.
C.Create a Lambda function to initiate an on-demand snapshot of the DynamoDB table.Trigger the Lambda function using CloudWatch Events.
D.Enable and configure DynamoDB backups.

Answer: B
Option A is incorrect because DynamoDB table PITR only stores data for a maximum of 35 days.
Option B is CORRECT because S3 offers the most cost-effective long-term storage solution. Using native integration capabilities such as DynamoDB streams and Kinesis Firehose streams is the simplest and most cost-effective solution to this requirement.
Option C is incorrect because DynamoDB does not have snapshot capability.
Option D is incorrect because DynamoDB does not have automated backup functionality.It is only possible to initiate an on-demand backup.To automate the process, it would require additional solution components such as Lambda functions. Further, it is not the most cost-optimal solution as it requires the storage of additional metadata such as GSI’s, LSI’s, etc.
Reference:
https://aws.amazon.com/blogs/database/automatically-archive-items-to-s3-using-dynamodb-time-to-live-with-aws-lambda-and-amazon-kinesis-firehose/