Exam 70-764 topic 1 question 68 discussion

Actual exam question from Microsoft's 70-764

Question #: 68
Topic #: 1

You administer several Microsoft SQL Server 2016 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?

A. Set the Merge agent on the problem subscribers to use the slow link agent profile.
B. Create a snapshot publication, and reconfigure the problem subscribers to use the snapshot publication.
C. Change the Merge agent on the problem subscribers to run continuously.
D. Set the Remote Connection Timeout on the Publisher to 0.

Show Suggested Answer

Suggested Answer: A 🗳️
You might have different profiles for different instances of an agent. For example, a Merge Agent that connects to the Publisher and Distributor over a dialup connection could use a set of parameters that are better suited to the slower communications link by using the slow link profile.
Note: When replication is configured, a set of agent profiles is installed on the Distributor. An agent profile contains a set of parameters that are used each time an agent runs: each agent logs in to the Distributor during its startup process and queries for the parameters in its profile.
References: https://docs.microsoft.com/en-us/sql/relational-databases/replication/agents/replication-agent-profiles

by TheSwedishGuy at Jan. 24, 2020, 2 p.m.

Comments

Submit Cancel

TheSwedishGuy

5 years, 6 months ago

Basically, set the slow link mode tells the merge agent that it is using a slow connection between the servers. The merge agent is then more lenient in closing / timing out connection.

upvoted 2 times

...