Q39 — AWS SAA-C03 Ch.13

Question 39 of 100 | ← Chapter 13

Q939. A company wants to replicate existing and ongoing data changes from an on-premises Oracle database to Amazon RDS for Oracle. The amount of data to replicate varies throughout each day.The company wants to use AWS Database Migration Service (AWS DMS) for data replication. The solution must allocate only the capacity that the replication instance requires.Which solution will meet these requirements?

Correct Answer: B. Create an AWS DMS Serverless replication task to analyze and replicate the data while provisioning the required capacity.

Explanation

The solution that meets the requirements is:B. Create an AWS DMS Serverless replication task to analyze and replicate the data while provisioning the required capacity.Here's why:Serverless Architecture: AWS DMS Serverless replication tasks automatically provision the necessary resources based on the workload, eliminating the need for manual capacity management.Dynamic Scaling: Serverless tasks dynamically adjust capacity based on the amount of data being replicated, ensuring optimal resource utilization and cost efficiency.On-Demand Allocation: The solution allocates only the required capacity, minimizing costs during periods of lower replication activity.Why other options are less efficient or don't meet the requirements:A. Configure the AWS DMS replication instance with a Multi-AZ deployment to provision instances across multiple Availability Zones. Multi-AZ deployments provide high availability but don't address the requirement of dynamic capacity allocation based on workload changes.C. Use Amazon EC2 Auto Scaling to scale the size of the AWS DMS replication instance up or down based on the amount of data to replicate. While EC2 Auto Scaling can provide dynamic scaling, it requires manual configuration and management of scaling policies, adding complexity and operational overhead.D. Provision AWS DMS replication capacity by using Amazon Elastic Container Service (Amazon ECS) with an AWS Fargate launch type to analyze and replicate the data while provisioning the required capacity. While ECS with Fargate can provide dynamic scaling, it introduces additional complexity and overhead compared to the simplicity of Serverless replication tasks.In summary:Option B offers the most efficient and cost-effective solution for replicating data with varying workloads. AWS DMS Serverless replication tasks provide dynamic capacity allocation, ensuring optimal resource utilization and minimizing costs.