AWS Certified Database – Specialty — Question 216

A financial services company is using AWS Database Migration Service (AWS DMS) to migrate its databases from on-premises to AWS. A database administrator is working on replicating a database to AWS from on-premises using full load and change data capture (CDC). During the CDC replication, the database administrator observed that the target latency was high and slowly increasing.

What could be the root causes for this high target latency? (Choose two.)

Answer options

• A. There was ongoing maintenance on the replication instance.
• B. The source endpoint was changed by modifying the task.
• C. Loopback changes had affected the source and target instances.
• D. There was no primary key or index in the target database.
• E. There were resource bottlenecks in the replication instance.

Correct answer: D, E

Explanation

The correct answers are D and E. A lack of a primary key or index in the target database (D) can hinder the performance of data operations and lead to increased latency. Additionally, resource bottlenecks in the replication instance (E) can also cause high latency due to insufficient processing power or memory to handle the workload. The other options do not directly contribute to the observed latency issues.