What does the Queue Reader Agent do in SQL Serve

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What does the Queue Reader Agent do in SQL Server 2005 replication?

Answer
This agent reads the subscriber logs and moves changes back to the publisher.
Explanation
This agent is used when the queued update model is chosen with transactional replication. It moves changes from the subscribers back to the publishers.

(Continued on next question...)

Other Job Interview Questions

• Which type of XML variable requires a\one and only one root element?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• Which utility is used to administer SQL Server 2005 Notification Services instances?
• Can you use a CASE statement in a WHERE clause?
• What's SQL Server
• There are two types of subscriptions in SQL Server replication. What are they?
• Where can you view the list of server-scoped DDL triggers?
• You wish to prevent anyone from using the sa account on your SQL Server 2005 instance, but still keep it available if your polocy changes. What can you do?
• Which of the following modules within SQL Server 2005 cannot be signed with a digital signature?
• Is it possible to build an index on a view
• More...