O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

19.7. REVIEW QUESTIONS

  1. List four major activities during data warehouse deployment. For two of these four activities, describe the key tasks.

  2. Describe briefly the user acceptance procedure. Why is this important?

  3. What are the significant considerations for the initial data load?

  4. Why is it a good practice to load the dimension tables before the fact tables?

  5. What are the two common methods of getting the desktops ready? Which method do you prefer? Why?

  6. What topics should the users be trained on initially?

  7. Give four common reasons for a pilot system.

  8. What is a proof-of-concept pilot? Under what circumstances is this type of pilot suitable?

  9. List five common provisions to be found in a good security policy.

  10. Give reasons why the data warehouse must be backed up. How is this different from an OLTP system?

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required