AWS Certified Data Engineer Associate · Free Practice Question Medium
Question 35
A large SQL Server database on RDS contains historical transaction data. A process is needed to automate the following requirements: regularly identify data older than 3 months, and export the old data to an S3 bucket for long-term, cost-effective storage.
Which of the following options can be used to automate this export from SQL Server to S3 and perform lifecycle management in Amazon S3 to build a solution with the least operational overhead? (Select two)
-
A
Use AWS Database Migration Service (DMS) to set up a task that runs periodically to migrate data older than 3 months from your RDS instance to an S3 bucket
-
B
Write an AWS Lambda function that identifies and exports old data from RDS to S3. Trigger the Lambda function through Amazon CloudWatch RDS Events
-
C
For cost optimization, configure S3 lifecycle rules to transition archived data to Amazon S3 Intelligent-Tiering
-
D
For cost optimization, configure S3 lifecycle rules to transition archived data to Amazon S3 Glacier Deep Archive
-
E
Configure AWS Step Functions to create an automation workflow. The workflow will call DataSync to sync the database files to the Amazon S3 bucket
Reveal correct answers
Correct answers: A, D
Explanation
Correct options:
Use AWS Database Migration Service (DMS) to set up a task that runs periodically to migrate data older than 3 months from your RDS instance to an S3 bucket
For cost optimization, configure S3 lifecycle rules to transition archived data to Amazon S3 Glacier Deep Archive
AWS Database Migration Service (AWS DMS) is a managed migration and replication service that helps you move your databases and analytics workloads to AWS quickly and securely. The source database remains fully operational during the migration, minimizing downtime to applications that rely on the database.
Use AWS Database Migration Service (DMS) to set up a task that runs periodically (e.g. weekly) to migrate data older than 3 months from your RDS instance to an S3 bucket. DMS supports homogeneous migrations between SQL Server and S3.
For cost optimization, configure S3 lifecycle rules to transition archived data to Amazon S3 Glacier Deep Archive.
Incorrect options:
Write an AWS Lambda function that identifies and exports old data from RDS to S3. Trigger the Lambda function through Amazon CloudWatch RDS Events - An RDS event indicates a change in the Amazon RDS environment. RDS events cannot be triggered for data changes. Amazon RDS records events that relate to the following resources: DB instances, DB parameter groups, DB security groups, DB snapshots, RDS Proxy events, and Blue/green deployment events.
Configure AWS Step Functions to create an automation workflow. The workflow will call DataSync to sync the database files to the Amazon S3 bucket - This is unnecessarily complex. Also, the step function itself will need a trigger.
For cost optimization, configure S3 lifecycle rules to transition archived data to Amazon S3 Intelligent-Tiering - The S3 Intelligent-Tiering storage class is designed to optimize storage costs by automatically moving data to the most cost-effective access tier when access patterns change, without operational overhead or impact on performance. S3 Intelligent-Tiering is not suited for long-term archival of data.
References:
https://docs.aws.amazon.com/AmazonS3/latest/userguide/storage-class-intro.html
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
