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 ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial