DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals

4.7. REVIEW QUESTIONS

1. Name four key issues to be considered while planning for a data warehouse.

2. Explain the difference between the top-down and bottom-up approaches for building data warehouses. Do you have a preference? If so, why?

3. List three advantages for each of the single-vendor and multivendor solutions.

4. What is meant by a preliminary survey of requirements? List six types of information you will gather during a preliminary survey.

5. How are data warehouse projects different from OLTP system projects? Describe four such differences.

6. List and explain any four of the development phases in the life cycle of data warehouse project.

7. What do you consider to be a core set of team roles for a data warehouse project? Describe the responsibilities of three roles from your set.

8. List any three warning signs likely to be encountered in a data warehouse project. What corrective actions will you need to take to resolve the potential problems indicated by these three warning signs?

9. Name and describe any five of the success factors in a data warehouse project.

10. What is meant by "taking a practical approach" to the management of a data warehouse project? Give any two reasons why you think a practical approach is likely to succeed.