3 4

Here are some questions to help you determine whether you have learned enough to move on to the next chapter. If you have difficulty answering these questions, review the material in this chapter before beginning the next chapter. The answers for these questions are located in the Appendix, "Questions and Answers."

  1. You have a number of users in Brazil that need to access data for the purpose of sales analysis. The data is stored in a centralized database in New York. They have been accessing the database in New York over a 56K dedicated link that is also supporting a variety of other interoffice traffic. You want to implement a replication solution between your New York office and your Brazil office. What type of replication would you implement and what additional information do you need to know?
  2. You have implemented a merge replication solution. Each Subscriber running on Windows 2000 and Windows NT 4.0 is able to initialize the subscription and replicate data successfully with the Publisher. However, your Windows Me and Windows 98 Subscribers are unable to successfully replicate with the Publisher. What is a likely source of this problem? How would you solve this problem?
  3. You are planning to implement a merge replication solution. What is the benefit of using a dedicated Distributor?
  4. You have implemented transactional replication. You have been monitoring the size of the distribution database on the Distributor and notice that its size seems to be larger than anticipated. What might be the cause of this? What Distributor setting could you modify to affect its size?

MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
Year: 2001
Pages: 126 © 2008-2017.
If you may any questions please contact us: