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: Of the three replication types, merge replication is the only type that allows subscribers to update replicated data.

  2. What extended stored procedure, implemented internally by SQL Server, does the Log Reader Agent call in order to retrieve changes from the transaction log for a published database?

  3. What's the default retention period for transactional replication?

  4. True or false: Although the Snapshot Agent places shared locks on table articles when it begins creating the snapshot for a transactional publication, the publication can be configured to allow changes to these objects while the snapshot is being created.

  5. What table in the distribution database is used to store replication commands the Distribution Agent ...

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