Question #1967
A company needs to replicate ongoing data changes from an on-premises Microsoft SQL Server database to Amazon RDS for SQL Server. The volume of data being replicated fluctuates significantly throughout the day. The company intends to use AWS Database Migration Service (AWS DMS) and wants the replication instance to automatically adjust its capacity based on the workload without manual intervention.
Which solution will meet these requirements?
Configure the AWS DMS replication instance with a Multi-AZ deployment to ensure high availability and redundancy during replication.
Create an AWS DMS Serverless replication task to dynamically provision and scale resources based on the replication workload.
Use Amazon EC2 Auto Scaling to adjust the replication instance's compute capacity in response to changes in data volume.
Deploy the AWS DMS replication instance using AWS Lambda to analyze and scale resources automatically during peak periods.
Explanation
The correct answer is B because AWS DMS Serverless is designed to dynamically provision and scale compute resources automatically based on the replication workload. This eliminates the need for manual capacity adjustments, aligning with the requirement to handle fluctuating data volumes.
- Option A (Multi-AZ deployment) ensures high availability but does not scale compute capacity.
- Option C (EC2 Auto Scaling) is irrelevant because AWS DMS replication instances are managed services and not EC2 instances.
- Option D (Lambda) cannot directly scale AWS DMS replication instances, as they require instance-type changes, which are not automated via Lambda.
Key Points:
- Use AWS DMS Serverless for auto-scaling replication workloads.
- Multi-AZ provides redundancy, not scalability.
- DMS replication instances are managed; EC2 Auto Scaling/Lambda cannot adjust their capacity.
Answer
The correct answer is: B