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?

Get DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial