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 is the overall purpose of OLAP Services?
  2. How is OLAP different from data warehousing?
  3. What are the possible cube storage methods?
  4. What is the difference between designing storage and processing a cube?
  5. How much programming must you do to set up cubes?
  6. What is the difference between NT Groups and OLAP Roles?
  7. What is the best way to decide on aggregations for your cube?
  8. When would you process, refresh, or incrementally update your cubes?

Answer



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