Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit

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. What are the elements of the Data Warehousing Framework?
2. What is the difference between remote and linked servers?
3. What are the three new kinds of join methods employed by SQL Server 7.0?
4. What role does the middle-tier server component play?
5. How does the English Query engine know how to process queries with nouns and verbs specific to your database?
6. True or false: Foreign key constraints create indexes automatically.

Answers