What could be the root causes for this high target latency?
(Choose two.)
There was ongoing maintenance on the replication instance.
The source endpoint was changed by modifying the task.
Loopback changes had affected the source and target instances.
There was no primary key or index in the target database.
There were resource bottlenecks in the replication instance.
Explanations:
Ongoing maintenance on the replication instance could cause temporary disruptions, but it would not be the primary cause of slowly increasing latency during CDC replication.
Changing the source endpoint by modifying the task would result in a disruption or failure, but not a gradual increase in latency during CDC replication.
Loopback changes typically affect the replication process but would not directly cause a steadily increasing target latency in CDC replication.
A missing primary key or index in the target database can severely impact the replication performance, leading to high latency during CDC.
Resource bottlenecks in the replication instance (e.g., CPU, memory, or I/O limitations) could cause high target latency, especially during ongoing CDC replication.
I figure that the answer is:
There was no primary key or index in the target database.