DBS-C01 practice question 32 of 35
A financial services company is using AWS Database Migration Service (AWS OMS) to migrate Its databases from on-premises to AWS. A database…
Full set: 322 questionsTarget latency is the amount of time that AWS DMS takes to apply changes from the source database to the target database1. High target latency can indicate performance issues or replication errors in the AWS DMS task. One possible cause of high target latency is the lack of a primary key or index in the target database. A primary key or index helps AWS DMS identify and apply changes to the corresponding rows in the target database. Without a primary key or index, AWS DMS has to scan the entire table to find the matching rows, which can increase the target latency and consume more CPU and memory resources2. Another possible cause of high target latency is the resource bottlenecks in the replication instance. The replication instance is the compute resource that runs the AWS DMS task and connects to the source and target endpoints. If the replication instance is under-provisioned or overloaded, it can affect the replication performance and cause high target latency. Some factors that can contribute to resource bottlenecks are insufficient network bandwidth, low disk space, high CPU utilization, or large transaction sizes3.
Keep practicing
Take the free DBS-C01 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other DBS-C01 practice questions
- Question 1A company has a hybrid environment in which a VPC connects to an on-premises network thro…
- Question 2A Database Specialist migrated an existing production MySQL database from on-premises to …
- Question 3A media company is using Amazon RDS for PostgreSQL to store user dat a. The RDS DB instan…
- Question 4A Database Specialist is working with a company to launch a new website built on Amazon A…
- Question 5A company has a database monitoring solution that uses Amazon CloudWatch for its Amazon R…
- Question 6A financial services company is developing a shared data service that supports different …
