Exam DEA-C01 All QuestionsBrowse all questions from this exam
Go to Exam
Question 96

A company needs to send customer call data from its on-premises PostgreSQL database to AWS to generate near real-time insights. The solution must capture and load updates from operational data stores that run in the PostgreSQL database. The data changes continuously.

A data engineer configures an AWS Database Migration Service (AWS DMS) ongoing replication task. The task reads changes in near real time from the PostgreSQL source database transaction logs for each table. The task then sends the data to an Amazon Redshift cluster for processing.

The data engineer discovers latency issues during the change data capture (CDC) of the task. The data engineer thinks that the PostgreSQL source database is causing the high latency.

Which solution will confirm that the PostgreSQL database is the source of the high latency?

    Correct Answer: D

    To confirm that the PostgreSQL database is the source of the high latency, you should use Amazon CloudWatch to monitor the DMS task and examine the CDCLatencySource metric. This metric specifically measures the latency between the source database and the DMS task, indicating how long it takes for changes to be read from the source database's transaction logs. Identifying delays through this metric will help determine if the source database is causing the high latency.

Discussion
tgvOption: D

CDCLatencySource Metric: This metric measures the latency between the source database and the DMS task. It shows how long it takes for changes to be read from the source database's transaction logs. https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Monitoring.html#CHAP_Monitoring.Metrics

HunkyBunkyOption: D

only D makes sense

sdas1

https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Troubleshooting_Latency.html A high CDCLatencySource metric indicates that the process of capturing changes from the source is delayed. Answer is D