Review

The following questions are designed 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. Your company has been experiencing contention problems. The problems occur when the sales and marketing departments run their daily reports while the order processing department is processing orders. Your company has decided to implement some form of data replication. To choose the appropriate method for making copies of the company data, which features and characteristics should you consider?
2. Your company, a large, international manufacturer with many vendors around the world, has decided to distribute data by using replication. You currently are in the planning and design phase of your replication strategy. Your goal is to receive all of the sales information from the vendors at the company headquarters on a daily basis. Because most of your vendors are remote, you are concerned about the high long-distance costs. Which replication model or models would you implement? Why?
3. What are the best ways to replicate data from an OLTP server to a data warehouse and from a data warehouse to a data mart?
4. What is the best way to replicate aggregate data?

Answer