nerdexam
CompTIA

CV0-002 · Question #438

Asynchronous data replication for a SaaS application occurs between Regions A and B. Users in Region A are reporting that the most current data for an insurance claims application is not available to

The correct answer is D. Check the storage commit logs in both regions.. When asynchronous data replication causes stale data despite low network utilization, checking storage commit logs is the best way to identify data persistence bottlenecks.

Troubleshooting

Question

Asynchronous data replication for a SaaS application occurs between Regions A and B. Users in Region A are reporting that the most current data for an insurance claims application is not available to them until after 11:30 a.m. The cloud administrator for this SaaS provider checks the network utilization and finds that only about 10% of the network bandwidth is being used. Which of the following describes how the cloud administrator could BEST resolve this issue?

Options

  • ACheck the storage utilization logs in both regions.
  • BCheck the RAM utilization logs in both regions.
  • CCheck the CPU utilization logs in both regions.
  • DCheck the storage commit logs in both regions.

How the community answered

(44 responses)
  • A
    25% (11)
  • B
    11% (5)
  • C
    7% (3)
  • D
    57% (25)

Why each option

When asynchronous data replication causes stale data despite low network utilization, checking storage commit logs is the best way to identify data persistence bottlenecks.

ACheck the storage utilization logs in both regions.

Storage utilization logs show how much storage is being used or accessed but do not directly explain delays in data committing or replicating.

BCheck the RAM utilization logs in both regions.

RAM utilization logs provide information about memory usage, which is generally not the primary cause of asynchronous data replication delays unless there is a severe memory bottleneck.

CCheck the CPU utilization logs in both regions.

CPU utilization logs indicate processing load, but while high CPU could affect replication, it's less directly related to data freshness than the actual storage commit process.

DCheck the storage commit logs in both regions.Correct

Checking storage commit logs in both regions is the most appropriate action because these logs provide detailed information about when data changes are officially written and persisted to storage, which directly impacts data consistency and replication latency in an asynchronous setup. Delays in commits or processing commit logs could explain why data is not current.

Concept tested: Asynchronous replication troubleshooting

Source: https://learn.microsoft.com/en-us/sql/database-engine/availability-groups/windows/overview-of-always-on-availability-groups-sql-server?view=sql-server-ver16

Topics

#Data replication#Asynchronous replication#Troubleshooting#Storage commit logs

Community Discussion

No community discussion yet for this question.

Full CV0-002 Practice