nerdexam
Microsoft

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.

Monitor and optimize a data analytics solution

Question

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?

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)
  • A
    6% (2)
  • B
    9% (3)
  • C
    83% (29)
  • D
    3% (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.

AIncrease the number of dataflow activities.

Increasing dataflow activities relates to ETL/ELT processing capacity, not the performance of synchronous database mirroring.

BReduce the frequency of mirroring updates.

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.

CUse a faster network connection between the primary and secondary databases.Correct

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.

DIncrease the number of workers in the dataflow cluster

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

#Data Warehousing Performance#Synchronous Mirroring#Network Latency#Performance Optimization

Community Discussion

No community discussion yet for this question.

Full DP-700 Practice