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. What are the disadvantages of using an OLTP system to conduct analytical processing?
  2. Name the two table types that make up a dimensional schema.
  3. Why are aggregate schemas included in OLAP system designs?
  4. Are aggregate schemas always necessary in OLAP system designs?

Answers



Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net