Microsoft
70-457 · Question #72
You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN)…
The correct answer is A. Set the Merge agent on the problem subscribers to use the slow link agent profile. See the full explanation below for the reasoning.
Question
You administer several Microsoft SQL Server 2012 database servers. Merge replication has been configured for an application that is distributed across offices throughout a wide area network (WAN). Many of the tables involved in replication use the XML and varchar (max) data types. Occasionally, merge replication fails due to timeout errors. You need to reduce the occurrence of these timeout errors. What should you do?
Options
- ASet the Merge agent on the problem subscribers to use the slow link agent profile.
- BCreate a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
- CChange the Merge agent on the problem subscribers to run continuously.
- DSet the Remote Connection Timeout on the Publisher to 0.
How the community answered
(19 responses)- A74% (14)
- B16% (3)
- C5% (1)
- D5% (1)
Community Discussion
No community discussion yet for this question.