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. In what format does the Snapshot Agent save data from tables published as articles in a snapshot publication?

  2. True or false: Although similar to SQL Server Agent, the Snapshot Agent is installed as its own Windows service when you enable replication and does not make use of SQL Server Agent.

  3. What agent is responsible for delivering the snapshots created by the Snapshot Agent to subscribers?

  4. When a view object is included in a snapshot publication, does the Snapshot Agent write out the data returned by the view or only its schema?

  5. What system stored procedure can be used to list the MSrepl_commands table?

  6. True or false: Although a replication agent can be executed as a console application, it does not actually carry out any work when ...

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