Exam Essentials

Know how to implement and manage a linked server solution.   Be familiar with when to use and how to implement a linked server strategy.

Know how to design a replication strategy.   Understand the replication process. Be familiar with the types of replication and where each type could be applied. Understand the roles of the agents in the replication process.

Know how to design a maintenance plan to monitor health, latency, and failures.   You need to know how to use predefined alerts and design alerts. You also need to be able to apply Replication Monitor to maintain and modify your replication topology.

Know how to verify replication.   Be able to verify latency with tracer tokens. You need to know how to validate replicated data.

Know how to resolve replication conflicts.   Understand the conflict resolution policies of the various replication topologies, and know where to view and resolve conflicts.

Know how to modify agent profiles.   You need to understand agent profiles and why you might need to modify them. You also need to know how to modify the agent profiles.

Know how to tune replication configuration.   Understand how you can enhance the performance of your replication strategy at various levels of your network. You also need to know the key factors for a performance baseline.