O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Knowledge Measure

  1. True or false: You can manage dynamic snapshot jobs from the Replication Monitor in Enterprise Manager.

  2. By default, who wins a conflict between a publisher and a high-priority subscriber?

  3. True or false: In a typical merge scenario, no more than one synchronization run should be required to synchronize subscriber and publisher data, regardless of the number of subscribers.

  4. Why does a dynamic snapshot provide a performance boost for dynamically filtered publications?

  5. Describe what is stored in a lineage value.

  6. What table does merge replication use to queue deleted rows?

  7. In what table does merge replication track the last sent and received generations?

  8. True or false: Merge replication is the only type of replication that can publish to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required