DP-700 · Question #51
You have implemented synchronous mirroring for your data warehouse. You are experiencing performance issues during peak workloads. Which of the following techniques can help improve performance?
The correct answer is C. Use a faster network connection between the primary and secondary databases. Synchronous database mirroring's performance is highly dependent on the network latency and bandwidth between the primary and secondary databases. To improve performance during peak workloads, reducing the network bottleneck is crucial.
Question
Options
- AIncrease the number of dataflow activities.
- BReduce the frequency of mirroring updates.
- CUse a faster network connection between the primary and secondary databases.
- DIncrease the number of workers in the dataflow cluster
How the community answered
(35 responses)- A6% (2)
- B9% (3)
- C83% (29)
- D3% (1)
Why each option
Synchronous database mirroring's performance is highly dependent on the network latency and bandwidth between the primary and secondary databases. To improve performance during peak workloads, reducing the network bottleneck is crucial.
Increasing dataflow activities relates to ETL/ELT processing capacity, not the performance of synchronous database mirroring.
Synchronous mirroring, by definition, requires immediate mirroring of all updates, so 'reducing the frequency of mirroring updates' is not a viable option for this type of mirroring.
In synchronous mirroring, transactions on the primary database commit only after the transaction log records are hardened on the secondary database, meaning network latency and bandwidth between the two databases directly impact primary database write performance. Using a faster network connection reduces this bottleneck, allowing transactions to commit more quickly and improving overall performance during peak workloads.
Increasing the number of workers in a dataflow cluster is related to data processing capacity, not the underlying database mirroring performance.
Concept tested: Synchronous database mirroring performance factors
Source: https://learn.microsoft.com/en-us/sql/database-engine/database-mirroring/best-practices-and-recommendations-for-database-mirroring
Topics
Community Discussion
No community discussion yet for this question.