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.
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)- A25% (11)
- B11% (5)
- C7% (3)
- D57% (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.
Storage utilization logs show how much storage is being used or accessed but do not directly explain delays in data committing or replicating.
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.
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.
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
Community Discussion
No community discussion yet for this question.