nerdexam
Amazon

DEA-C01 · Question #106

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…

The correct answer is D. Use Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to. 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.

Data Operations and Support

Question

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?

Options

  • AUse Amazon CloudWatch to monitor the DMS task. Examine the CDCIncomingChanges metric to
  • BVerify that logical replication of the source database is configured in the postgresql.conf
  • CEnable Amazon CloudWatch Logs for the DMS endpoint of the source database. Check for error
  • DUse Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to

How the community answered

(28 responses)
  • A
    4% (1)
  • B
    11% (3)
  • C
    4% (1)
  • D
    82% (23)

Explanation

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.

Topics

#AWS DMS#Change Data Capture#CloudWatch Metrics#Troubleshooting

Community Discussion

No community discussion yet for this question.

Full DEA-C01 Practice