Q79 — AWS DEA-C01 Ch.1

Question 79 of 100 | ← Chapter 1

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?

• A. Use Amazon CloudWatch to monitor the DMS task. Examine the CDCIncomingChanges metric to identify delays in the CDC from the source database
• B. Verify that logical replication of the source database is configured in the postgresql.conf configuration file.
• C. Enable Amazon CloudWatch Logs for the DMS endpoint of the source database. Check for error messages.
• D. Use Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to identify delays in the CDC from the source database. ✓

Correct Answer: D. Use Amazon CloudWatch to monitor the DMS task. Examine the CDCLatencySource metric to identify delays in the CDC from the source database.

Explanation

为了确认PostgreSQL数据库是否是高延迟的来源，数据工程师需要监控DMS任务的特定指标。AmazonCloudWatch提供了监控AWS服务的能力，包括DMS任务。其中，“CDCLatencySource”指标专门用于衡量从源数据库捕获数据变更（CDC）时的延迟。通过检查这个指标，数据工程师可以确定是否源数据库导致了高延迟。因此，选项D是正确的解决方案。