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

7.7. REVIEW QUESTIONS

  1. What is your understanding of data warehouse architecture? Describe in one or two paragraphs.

  2. What are the three major areas in the data warehouse? Is this a logical division? If so, why do you think so? Relate the architectural components to the three major areas.

  3. Name four distinguishing characteristics of data warehouse architecture. Describe each briefly.

  4. Trace the flow of data through the data warehouse from beginning to end.

  5. For information delivery, what is the difference between top-down and bottom-up approaches to data warehouse implementation?

  6. In which architectural component does OLAP fit in? What is the function of OLAP?

  7. Define technical architecture of the data warehouse. How does it relate to the individual architectural components?

  8. List five major functions and services in the data storage area.

  9. What are the types of storage repositories in the data staging area?

  10. List four major functions and services for information delivery. Describe each briefly.

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