9.8. REVIEW QUESTIONS

  1. Why do you think metadata is important in a data warehouse environment? Give a general explanation in one or two paragraphs.

  2. Explain how metadata is critical for data warehouse development and administration.

  3. Examine the concept that metadata is like a nerve center. Describe how the concept applies to the data warehouse environment.

  4. List and describe three major reasons why metadata is vital for end-users.

  5. Why is metadata essential for IT? List six processes in which metadata is significant for IT and explain why.

  6. Pick three processes in which metadata assists in the automation of these processes. Show how metadata plays an active role in these processes.

  7. What is meant by establishing the context of information? Briefly explain with an example how metadata establishes the context of information in a data warehouse.

  8. List four metadata types used in each of the three areas of data acquisition, data storage, and information delivery.

  9. List any ten examples of business metadata.

  10. List four major requirements that metadata must satisfy. Describe each of these four requirements.

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.