Review

[Previous] [Next]

The following questions are intended to reinforce key information presented in the chapter. If you are unable to answer a question, review the appropriate lesson and then try the question again. Answers to the questions can be found in Appendix A, "Questions and Answers."

1. You are trying to configure replication between two servers. Both servers appear to be set up correctly, but replication does not work. What do you think is the problem? What should you do to fix it?

Answer

2. When you set up the distribution server, what should you consider when estimating the appropriate size of the distribution database?

Answer

3. Your company has decided to use SQL Server replication. The publication server runs an intensive application and does not have the capacity to manage any replication overhead. You will have a large number of Subscribers. Some Subscribers may be offline periodically, and all Subscribers must have the ability to update data. Which model and method of replication would best address these requirements? Why?

Answer